Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In response to Chris Barnes <compuguruchrisbarnes@xxxxxxxxxxx>:
> 
> 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@xxxxxxxxxxxx
> > To: compuguruchrisbarnes@xxxxxxxxxxx
> > CC: pgsql-general@xxxxxxxxxxxxxx
> > Subject: Re:  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@xxxxxxxxxxxxxx)
> > 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/

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux