Re: Statement duration reporting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Statement duration reporting
Дата
Msg-id 8267.1139675019@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Statement duration reporting  ("Erik G. Burrows" <erik@erikburrows.com>)
Список pgsql-admin
"Erik G. Burrows" <erik@erikburrows.com> writes:
> So, my question is: What does the duration time in the serverlog
> reflect? Is it just the time the server took to execute the statement,
> or does it reflect also query receive and response transmit time?

The former.  The server has no way to measure transit times.

> Any other ideas as to why I'm seeing these odd and contradictory times?

There's a current thread in the pgsql-odbc list about similar issues
seen with ODBC.  I doubt its the same problem, because it's different
client software on a different OS, but maybe it'd be worth comparing
notes.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Ancient messages regurgitated into pgsql-admin, again
Следующее
От: lst_hoe01@kwsoft.de
Дата:
Сообщение: Re: Postgresql performance and tuning questions