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

In response to Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)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(at)hogranch(dot)com
> > To: compuguruchrisbarnes(at)hotmail(dot)com
> > CC: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)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/