On Wed, Mar 21, 2012 at 13:42, Rafael Martinez <r.m.guerrero@usit.uio.no> wrote:
> I am wondering why the time reported by \timing in psql is not the same
> as the time reported by duration in the log file when log_duration or
> log_min_duration_statement are on?
psql's \timing measures time on the client -- which includes the
network communication time (time to send the query to the server, and
receive back the results)
log_min_duration_statement measures time on the server, so it doesn't
know how long network transmission takes.
Regards,
Marti