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