min duration logging

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

Responses

Browse pgsql-admin by date

  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