| From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
|---|---|
| To: | "pg-general (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | calculating time |
| Date: | 2003-04-16 12:19:28 |
| Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB04C74961@snt452.corp.bcbsm.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Howdy:
Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
I am not sure if I have asked this before, but,
how can I get the actual time in this statement:
[snip]
Nested Loop (cost=0.00..5662254656.82 rows=138 width=199)
[/snip]
The cost is supposed to be the amount of time it may take to
do a query, right? So what, exactly, is this? 500 hours?
minutes? CPU time?
How do I convert the cost time into regular human time? Putting
a date param before and after the statement won't really help me
in this situation as I need to figure out if I should even execute it
to begin with.
Thanks!
-X
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ow | 2003-04-16 12:20:17 | Re: Are we losing momentum? |
| Previous Message | Tony Grant | 2003-04-16 11:40:56 | will an honest French ISP please stand up |