After trying to get pgfouine to work with stderr, I tried syslog. This seems to work fine.
Produces nice html format reports. Graphing is also available.
This link gives set up details for setup for pgfouine.
http://www.thelazysysadmin.net/2009/08/pgfouine-automatic-report-setup-with-postgresql-logrotate/ > Subject: Re: [GENERAL] Is there a tool used to display statement times from postgres logs
> From: jd@commandprompt.com
> To: compuguruchrisbarnes@hotmail.com
> CC: pgsql-general@postgresql.org
> Date: Fri, 20 Nov 2009 10:53:00 -0800
>
> On Fri, 2009-11-20 at 12:59 -0500, 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?
> >
> > Chris
>
> All the time. Perhaps you could explain your actual problem?
>
> >
> >
> > ______________________________________________________________________
> > Windows Live: Make it easier for your friends to see what you’re up to
> > on Facebook.
>
>
> --
> PostgreSQL.org Major Contributor
> Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
> Consulting, Training, Support, Custom Development, Engineering
> If the world pushes look it in the eye and GRR. Then push back harder. - Salamander
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
Windows Live: Keep your friends up to date
with what you do online.
