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

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com>
Cc: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is there a tool used to display statement times from postgres logs
Date: 2009-11-21 01:44:59
Message-ID: EBDD4E8D-8049-4B57-9FA7-2280C9DC2141@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alan Gruskoff 2009-11-21 03:04:38 Re: Books, the lulu.com scam
Previous Message Brian Witt 2009-11-21 01:16:21 use log_statement to log only SELECTs?