Re: timing != log duration - Mailing list pgsql-performance

From Tom Lane
Subject Re: timing != log duration
Date
Msg-id 29855.1332339082@sss.pgh.pa.us
Whole thread Raw
In response to timing != log duration  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
List pgsql-performance
Rafael Martinez <r.m.guerrero@usit.uio.no> writes:
> 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?

Network transmission delays, perhaps?  psql reports the elapsed time
seen at the client, which is necessarily going to be somewhat more than
the time taken by the server.

            regards, tom lane

pgsql-performance by date:

Previous
From: Andy Colson
Date:
Subject: Re: DBD-Pg prepared statement versus plain execution
Next
From: Robert Haas
Date:
Subject: Re: set autovacuum=off