From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: smiley2211 <smiley2211@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to ENABLE SQL capturing???
Date: Wed, 8 Aug 2007 22:36:12 +0200
Message-ID: <20070808203612.GA26143@uio.no> (raw)
In-Reply-To: <12060736.post@talk.nabble.com>
References: <12060736.post@talk.nabble.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sgunderson@bigfoot.com, smiley2211@yahoo.com
Subject: Re: How to ENABLE SQL capturing???
In-Reply-To: <20070808203612.GA26143@uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox