[ADMIN] min duration logging

[AA]

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_destination = 'csvlog'
logging_collector = on
log_directory = '/usr/local/pgb/pg_log'
log_rotation_size = 100MB
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
#silent_mode = off
#client_min_messages = debug1
#log_min_messages = warning
#log_min_error_statement = error
log_min_duration_statement = 450
#debug_print_parse = off
#debug_print_rewritten = off
#debug_print_plan = off
#debug_pretty_print = on
#log_checkpoints = off
#log_connections = off
#log_disconnections = off
log_duration = on
#log_error_verbosity = default
#log_hostname = off
#log_line_prefix = ''
#log_lock_waits = off
#log_statement = 'all'
#log_temp_files = -1
#log_timezone = unknown

[Steve Crawford]

Post by AA
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?

Post by AA
#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