pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (3+ messages)  latest in thread

Message-ID: <9A53DDE1FE082F4D952FDF20AC87E21F7FD816@exchange2.t8design.com>
Permalink:  ../9A53DDE1FE082F4D952FDF20AC87E21F7FD816@exchange2.t8design.com/
Also on:    postgresql.org/message-id/9A53DDE1FE082F4D952FDF20AC87E21F7FD816@exchange2.t8design.com

 · 

reply

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