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