Re: Confirming \timing output

On Aug 23, 2012, at 11:13 AM, "Gauthier, Dave" <dave.gauthier@intel.com> wrote:

> With \timing set on, I run an update statement and it reports....
>
> Time: 0.524 ms
>
> Is that really 0.524 ms?  As in 524 nanoseconds?

0.524ms = 524000ns

Perhaps you meant microseconds?

0.524ms = 524us

If all your data happens to be in RAM cache, simple queries can execute very fast!  Unless you have a reason to believe
it'swrong, I would trust it to be accurate :-) 

>
> Also, is this wallclock time or some sort of indication of how much cpu it took?
>
> Thanks for any answers !
>


\timing measures wall time.  There's a more detailed discussion of the difference between this and e.g. EXPLAIN ANALYZE
here:

http://postgresql.1045698.n5.nabble.com/What-does-timing-measure-td4289329.html