From: | AA <araskoktas(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | min duration logging |
Date: | 2011-10-11 18:23:40 |
Message-ID: | CAC44bgq-74gpZHRY=tNQrHVdeXD_r7ut7L_gXcakA1i_VC2mgw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2011-10-11 19:52:35 | Re: min duration logging |
Previous Message | gabriel12345 | 2011-10-11 17:39:38 | Contents of WAL files |