Re: Is there a tool used to display statement times from postgres logs - Mailing list pgsql-general

From Ben Chobot
Subject Re: Is there a tool used to display statement times from postgres logs
Date
Msg-id EBDD4E8D-8049-4B57-9FA7-2280C9DC2141@silentmedia.com
Whole thread Raw
In response to Is there a tool used to display statement times from postgres logs  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
List 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 by date:

Previous
From: Brian Witt
Date:
Subject: use log_statement to log only SELECTs?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Is there a tool used to display statement times frompostgres logs