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(at)rogers(dot)com>
PGP Key ID: DB3C29FC