Обсуждение: pgfouine - commit details?

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