Thread: How to get the used time when operate a select query?
How can I get the time which a select query use? thank you!
$B2+=ULP wrote: > How can I get the time which a select query use? > thank you! > > If you are using version 7.2 or later, try the command EXPLAIN ANALYZE <any query> This will perform the query (even if it is a DELETE FROM <table>!) and show the actual time. /Oskar Ps. You should check what your mail client puts in the from field of you mail. It is quite unreadable... -- /----------------------------------------------------------------------\ | Oskar Berggren beo@sgs.o.se | | Network and Software Engineer SGS Datanätgrupp | | Gothenburg, Sweden | \----------------------------------------------------------------------/
Re: How to get the used time when operate a select query?
From
nconway@klamath.dyndns.org (Neil Conway)
Date:
On Thu, Jun 27, 2002 at 12:01:09PM +0200, Oskar Berggren wrote:
> $B2+=ULP wrote:
> >How can I get the time which a select query use?
> >thank you!
>
> If you are using version 7.2 or later, try the command
>
> EXPLAIN ANALYZE <any query>
>
> This will perform the query (even if it is a DELETE FROM <table>!)
> and show the actual time.
BTW in 7.3, you'll be able to do "\timing" inside psql to enable
client-side timing. i.e.
nconway=# \timing
Timing is on.
nconway=# select 1;
?column?
----------
1
(1 row)
Total time: 0.001s
nconway=#
Cheers,
Neil
--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC
nconway@klamath.dyndns.org (Neil Conway) writes:
> BTW in 7.3, you'll be able to do "\timing" inside psql to enable
> client-side timing. i.e.
> nconway=# select 1;
> ?column?
> ----------
> 1
> (1 row)
> Total time: 0.001s
Why is the precision of the display restricted to milliseconds?
Clock readings are usually good to a few microseconds on modern
machines.
I'd suggest showing the result in the same format used by EXPLAIN
ANALYZE, which is milliseconds with a fractional part.
regards, tom lane