Обсуждение: min duration logging

Поиск
Список
Период
Сортировка

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 

Re: min duration logging

От
Steve Crawford
Дата:
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