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

In response to Chris Barnes <compuguruchrisbarnes@hotmail.com>:
>
> I have the logging options set to display anything longer than a duration of 1 second, but need something to display
them.

cat?

Or are you specifically looking for something to analyze them?  Slightly
different, and I'm assuming that's what you meant.  Have a look at
pgfouine.

> > Date: Fri, 20 Nov 2009 10:02:11 -0800
> > From: pierce@hogranch.com
> > To: compuguruchrisbarnes@hotmail.com
> > CC: pgsql-general@postgresql.org
> > Subject: Re: [GENERAL] Is there a tool used to display statement times from postgres logs
> >
> > Chris Barnes wrote:
> > > Would someone have a tool that displays statement execution
> > > times/stats from the standard output from postgres logs?
> > >
> >
> > there's a logging option to put that in the logs, I thought? if so, you
> > could then display with `tail -f /path/to/postgreslog`
> >
> >
> > --
> > 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: Friends get your Flickr, Yelp, and Digg updates when they e-mail you.
> http://go.microsoft.com/?linkid=9691817

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/