|
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: Is there a tool used to display statement times from postgres logs > From: jd@xxxxxxxxxxxxxxxxx > To: compuguruchrisbarnes@xxxxxxxxxxx > CC: pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxx) > 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. |
