Re: min duration logging

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;"

Cheers,
Steve