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: j...@commandprompt.com > To: compuguruchrisbar...@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. http://go.microsoft.com/?linkid=9691815
