X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id DFD22D8625
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue,  6 Sep 2005 17:34:14 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 78342-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue,  6 Sep 2005 20:34:11 +0000 (GMT)
Received: from web53209.mail.yahoo.com (web53209.mail.yahoo.com
	[206.190.49.79])
	by svr1.postgresql.org (Postfix) with SMTP id 628EBD85C8
	for <pgsql-performance@postgresql.org>;
	Tue,  6 Sep 2005 17:34:11 -0300 (ADT)
Received: (qmail 32618 invoked by uid 60001); 6 Sep 2005 20:34:12 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=jQOw8+5Uyu/seSVnRbZ51fJ9q53Bt9HGdt347NbQqCvz8nHrmCygfLrcA5W6AUm9kSW3OR+YEhA6/jJWmBNW17KnnNNTubM0iQSg70byaoSdRDRTAuxIXR0l7fadRr9lMYZzGC09+DaHuKI0yYCHAVvb5pTdvp6bi/XBsWcosTU=
	;
Message-ID: <20050906203412.32616.qmail@web53209.mail.yahoo.com>
Received: from [200.193.41.11] by web53209.mail.yahoo.com via HTTP;
	Tue, 06 Sep 2005 17:34:12 ART
Date: Tue, 6 Sep 2005 17:34:12 -0300 (ART)
From: Carlos Henrique Reimer <carlosreimer@yahoo.com.br>
Subject: log_duration times 
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-496221878-1126038852=:31073"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.647 required=5 tests=[AWL=-0.231,
	DNS_FROM_RFC_ABUSE=0.374, HTML_20_30=0.504, HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200509/101
X-Sequence-Number: 14409

--0-496221878-1126038852=:31073
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi,
 
We want to discover how to improve the performance of an application and with that intention I turned on log_duration, log_statement=all and the time stamp escape character (%t) of log_line_prefix. 
 
Subtracting the time stamp of the last SQL statement from the first one I disovered that the whole application takes about 10 seconds to run. Almost the same time we have at the client workstation.
 
Adding all the log_duration times I found almost 3 seconds (30% of the total time). 
 
So, I realized that to improve performance it will be better to discover who is spending the 7 remaining seconds than making changes in database structure or SQL syntax.
 
How could I discover who is using the 7 remaining seconds? Network? ODBC? Application?
 
Thanks in advance!
 
Reimer
 
 

__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger 
http://br.download.yahoo.com/messenger/ 
--0-496221878-1126038852=:31073
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>Hi,</DIV>
<DIV>&nbsp;</DIV>
<DIV>We want to discover how to improve the performance of&nbsp;an application and with that intention I turned on log_duration, log_statement=all&nbsp;and the time stamp escape character (%t) of log_line_prefix. </DIV>
<DIV>&nbsp;</DIV>
<DIV>Subtracting the time stamp of the last SQL statement from the first one I disovered that the whole application takes about 10 seconds to run. Almost the same time we have at the client workstation.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Adding all the log_duration times I found almost 3 seconds (30% of the total time). </DIV>
<DIV>&nbsp;</DIV>
<DIV>So, I realized that to improve performance it will be better to discover who is spending the 7 remaining seconds than making changes in database structure or SQL syntax.</DIV>
<DIV>&nbsp;</DIV>
<DIV>How could I discover who is using&nbsp;the 7 remaining seconds? Network? ODBC? Application?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks in advance!</DIV>
<DIV>&nbsp;</DIV>
<DIV>Reimer</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV><p>__________________________________________________<br>Converse com seus amigos em tempo real com o Yahoo! Messenger <br>http://br.download.yahoo.com/messenger/ 
--0-496221878-1126038852=:31073--