Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 98DBE2E0091 for ; Tue, 6 May 2008 18:23:08 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 02839-02-2 for ; Tue, 6 May 2008 18:22:59 -0300 (ADT) X-Greylist: delayed 00:12:11.902405 by SQLgrey-1.7.5 Received: from exchange2.t8design.com (exchange.t8design.com [147.202.23.70]) by developer.postgresql.org (Postfix) with SMTP id 6B1902E008C for ; Tue, 6 May 2008 18:23:03 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C8AFBD.A80B6A3A" Subject: pgfouine - commit details? X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Tue, 6 May 2008 16:10:47 -0500 Message-ID: <9A53DDE1FE082F4D952FDF20AC87E21F7FD816@exchange2.t8design.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: pgfouine - commit details? Thread-Index: AcivvWiXBwEfjLMWQb+8+j9DAmELgA== From: "Josh Cole" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200805/109 X-Sequence-Number: 30077 This is a multi-part message in MIME format. ------_=_NextPart_001_01C8AFBD.A80B6A3A Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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?=20 =20 Queries that took up the most time Rank Total duration Times executed Av. duration (s) Query 1 26m54s 222,305 0.01 COMMIT; =20 Perhaps we need to tweak what is being logged by postgresql? =20 log_destination =3D 'syslog' =20 logging_collector =3D on =20 log_directory =3D 'pg_log' =20 log_truncate_on_rotation =3D on =20 log_rotation_age =3D 1d =20 =20 syslog_facility =3D 'LOCAL0' syslog_ident =3D 'postgres' =20 client_min_messages =3D notice =20 log_min_messages =3D notice =20 log_error_verbosity =3D default =20 log_min_error_statement =3D notice =20 log_min_duration_statement =3D 2 =20 #silent_mode =3D off =20 =20 debug_print_parse =3D off debug_print_rewritten =3D off debug_print_plan =3D off debug_pretty_print =3D off log_checkpoints =3D off log_connections =3D off log_disconnections =3D off log_duration =3D off log_hostname =3D off #log_line_prefix =3D '' =20 log_lock_waits =3D on =20 log_statement =3D 'none' =20 #log_temp_files =3D -1 =20 #log_timezone =3D unknown =20 =20 #track_activities =3D on #track_counts =3D on #update_process_title =3D on =20 #log_parser_stats =3D off #log_planner_stats =3D off #log_executor_stats =3D off #log_statement_stats =3D off =20 Regards, Josh ------_=_NextPart_001_01C8AFBD.A80B6A3A Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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             &= nbsp;           &n= bsp;    COMMIT;

 

Perhaps we need to tweak what is being logged by = postgresql?

 

log_destination =3D 'syslog'           = ;  

logging_collector =3D on            = ;     

log_directory =3D 'pg_log'           = ;    

log_truncate_on_rotation =3D on           =

log_rotation_age =3D = 1d            = ;      

 

syslog_facility =3D = 'LOCAL0'

syslog_ident =3D = 'postgres'

 

client_min_messages =3D notice            =

log_min_messages =3D notice           &= nbsp;  

log_error_verbosity =3D default           =

log_min_error_statement =3D notice        =

log_min_duration_statement =3D 2          =

#silent_mode =3D off           &nbs= p;         

 

debug_print_parse =3D = off

debug_print_rewritten =3D = off

debug_print_plan =3D off

debug_pretty_print =3D = off

log_checkpoints =3D off

log_connections =3D off

log_disconnections =3D = off

log_duration =3D off

log_hostname =3D off

#log_line_prefix =3D ''            = ;      

log_lock_waits =3D on            = ;        

log_statement =3D 'none'           &= nbsp;     

#log_temp_files =3D -1            = ;       

#log_timezone =3D unknown           =      

 

#track_activities =3D on

#track_counts =3D on

#update_process_title =3D = on

 

#log_parser_stats =3D = off

#log_planner_stats =3D = off

#log_executor_stats =3D = off

#log_statement_stats =3D = off

 

Regards,

Josh

------_=_NextPart_001_01C8AFBD.A80B6A3A--