pgfouine - commit details?

From: "Josh Cole" <Josh(dot)Cole(at)t8design(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: pgfouine - commit details?
Date: 2008-05-06 21:10:47
Message-ID: 9A53DDE1FE082F4D952FDF20AC87E21F7FD816@exchange2.t8design.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dennis Muhlestein 2008-05-06 21:39:02 Re: Possible Redundancy/Performance Solution
Previous Message Craig James 2008-05-06 20:43:54 Re: RAID 10 Benchmark with different I/O schedulers