[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: timing != log duration



Rafael Martinez <r.m.guerrero@xxxxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Home]     [Yosemite]

Powered by Linux