From: Josh Cole <Josh.Cole@t8design.com>
To: pgsql-performance@postgresql.org
Subject: pgfouine - commit details?
Date: Tue, 6 May 2008 16:10:47 -0500
Message-ID: <9A53DDE1FE082F4D952FDF20AC87E21F7FD816@exchange2.t8design.com> (raw)
We are using pgfouine to try and optimize our database at this time. Is
there a way to have pgfouine show examples or breakout commits?
Queries that took up the most time
Rank Total duration Times executed Av. duration (s)
Query
1 26m54s 222,305 0.01
COMMIT;
Perhaps we need to tweak what is being logged by postgresql?
log_destination = 'syslog'
logging_collector = on
log_directory = 'pg_log'
log_truncate_on_rotation = on
log_rotation_age = 1d
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
client_min_messages = notice
log_min_messages = notice
log_error_verbosity = default
log_min_error_statement = notice
log_min_duration_statement = 2
#silent_mode = off
debug_print_parse = off
debug_print_rewritten = off
debug_print_plan = off
debug_pretty_print = off
log_checkpoints = off
log_connections = off
log_disconnections = off
log_duration = off
log_hostname = off
#log_line_prefix = ''
log_lock_waits = on
log_statement = 'none'
#log_temp_files = -1
#log_timezone = unknown
#track_activities = on
#track_counts = on
#update_process_title = on
#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off
Regards,
Josh
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: Josh.Cole@t8design.com
Subject: Re: pgfouine - commit details?
In-Reply-To: <9A53DDE1FE082F4D952FDF20AC87E21F7FD816@exchange2.t8design.com>
References: <9A53DDE1FE082F4D952FDF20AC87E21F7FD816@exchange2.t8design.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox