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
