Re: Printing query durations

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Printing query durations
Дата
Msg-id 1143552753.3839.346.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Printing query durations  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
On Tue, 2006-03-28 at 07:12 -0500, Dave Cramer wrote:

> What happens if I turn log_duration on ? Doesn't it prepend the
> duration to every log ?

No.

If you use log_statement the statement is logged before execution,
whereas the duration is known only at the end, so two log records are
produced.

log_min_duration_statement logs both at the end so is better suited to
performance analysis.

Best Regards, Simon Riggs



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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Printing query durations
Следующее
От: jao@geophile.com
Дата:
Сообщение: Array support in 8.1 JDBC driver