Re: How to get the used time when operate a select query? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to get the used time when operate a select query?
Date
Msg-id 26150.1025192683@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to get the used time when operate a select query?  (nconway@klamath.dyndns.org (Neil Conway))
List pgsql-general
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



pgsql-general by date:

Previous
From: mordicus
Date:
Subject: Re: pg_dump / consistent snapshot / backup
Next
From: Gregory Seidman
Date:
Subject: Re: script to keep views "correct"?