we currently have logging enabled for all queries over 100ms, and keep
the last 24 hours of logs before we rotate them. I've found this tool
very helpful in diagnosing new performance problems that crop up:
http://pgfouine.projects.postgresql.org/
Bryan
On 8/8/07, Steinar H. Gunderson <sgunderson@bigfoot.com> wrote:
> On Wed, Aug 08, 2007 at 01:02:24PM -0700, smiley2211 wrote:
> > I am trying to enable capturing of the submitted code via an
> > application...how do I do this in Postgres? Performance is SLOW on my
> > server and I have autovacuum enabled as well as rebuilt indexes...whatelse
> > should be looked at?
>
> Try "log_min_duration_statement = 100" in postgresql.conf; it will show all
> statements that take more than 100ms. Set to 0 to log _all_ statements, or
> -1 to turn the logging back off.
>
> /* Steinar */
> --
> Homepage: http://www.sesse.net/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>