From: Carlos Henrique Reimer <carlosreimer@yahoo.com.br>
To: pgsql-performance@postgresql.org
Subject: log_duration times
Date: Tue, 6 Sep 2005 17:34:12 -0300 (ART)
Message-ID: <20050906203412.32616.qmail@web53209.mail.yahoo.com> (raw)
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/
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: carlosreimer@yahoo.com.br
Subject: Re: log_duration times
In-Reply-To: <20050906203412.32616.qmail@web53209.mail.yahoo.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