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

[Ben Chobot <bench@xxxxxxxxxxxxxxx>]

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.