Re: timing != log duration

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: timing != log duration
Дата
Msg-id 29855.1332339082@sss.pgh.pa.us
обсуждение исходный текст
Ответ на timing != log duration  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
Список 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 по дате отправления:

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: DBD-Pg prepared statement versus plain execution
Следующее
От: Robert Haas
Дата:
Сообщение: Re: set autovacuum=off