Re: Is there a tool used to display statement times from postgres logs

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: Is there a tool used to display statement times from postgres logs
Дата
Msg-id EBDD4E8D-8049-4B57-9FA7-2280C9DC2141@silentmedia.com
обсуждение исходный текст
Ответ на Is there a tool used to display statement times from postgres logs  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
Список pgsql-general
Дерево обсуждения
On Nov 20, 2009, at 9:59 AM, Chris Barnes wrote:

Would someone have a tool that displays statement execution times/stats from the standard output from postgres logs?
 
I have attempted pgfouine but not had sucess with the log format.
 
Does anyone use pgfouine or have something that works for them?

We've used pgfouine to great success.... but we also log via syslog. As I recall, pgfouine has some difficulty with multi-line transactions that aren't logged via syslog.

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

Предыдущее
От: Brian Witt
Дата:
Сообщение: use log_statement to log only SELECTs?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Is there a tool used to display statement times frompostgres logs