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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
