| From: | Esteban Gutierrez Abarzua <esgutier(at)sauce(dot)chillan(dot)ubiobio(dot)cl> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | explain command |
| Date: | 2001-09-25 00:09:51 |
| Message-ID: | Pine.LNX.4.21.0109242002150.12770-100000@sauce.chillan.ubiobio.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
hi.
I still go on looking for query time.
I get a question!
explain is a command that estimate cost of query time ok, but I don't
know how is the time.
for example:
mybase=> explain select * from tabla1;
NOTICE: QUERY PLAN:
Seq Scan on tabla1 (cost=0.00..1.06 rows=6 width=4)
EXPLAIN
the cost query time is 1.06? 1.06......seconds or milliseconds
thanks friends!
bye
Esteban Gutierrez Abarzua Chillan- Chile
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jimi Thompson | 2001-09-25 03:43:35 | Re: getting some tech skills? |
| Previous Message | Colin 't Hart | 2001-09-24 20:51:14 | Re: [HACKERS] not on .hackers |