Re: timing != log duration

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: timing != log duration
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C207A2B547@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на timing != log duration  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
Список pgsql-performance
Rafael Martinez 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?. I can not find any information
about
> this in the documentation.

\timing measures the time on the client, while the log contains the
duration
on the server side.  The client time includes the overhead for
transferring
data to and from the server.

Yours,
Laurenz Albe

В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: set autovacuum=off
Следующее
От: "Gnanakumar"
Дата:
Сообщение: Write workload is causing severe slowdown in Production