On Wed, Mar 21, 2012 at 13:42, Rafael Martinez <r.m.guerr...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
