On 10/11/2011 11:23 AM, AA wrote:
> hey all
> trying to find non optimized queries and want to use this logging
> feature, however postgresql seems to write every query to log.
> my conf is as follows...
> log_min_duration_statement = 450
What durations are showing in the log? Are lots/all of the queries you
run longer than 450ms?
> #log_statement = 'all'
I don't know what the config looked like beforehand but did you reload
PostgreSQL after changing it? You can check the current running settings
with "show all;"
In response to
pgsql-admin by date
|Next:||From: gabriel12345||Date: 2011-10-11 20:15:36|
|Subject: Re: Contents of WAL files|
|Previous:||From: AA||Date: 2011-10-11 18:23:40|
|Subject: min duration logging|