From: A J <s5aly@yahoo.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org
Subject: Re: Confused by 'timing' results
Date: Tue, 31 Aug 2010 12:01:36 -0700 (PDT)
Message-ID: <19320.56933.qm@web120013.mail.ne1.yahoo.com> (raw)
In-Reply-To: <4C7D00330200002500034ED2@gw.wicourts.gov>
References: <788866.21140.qm@web120020.mail.ne1.yahoo.com>
<4C7D00330200002500034ED2@gw.wicourts.gov>
OK, thanks Kevin. So to measure just the time take by database server, I guess I
need to set the log_min_duration_statement and log_statement parameters in
postgresql.conf
log_min_duration_statement output should stay constant for all the different
clients across different geographic locations.
________________________________
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org; A J <s5aly@yahoo.com>
Sent: Tue, August 31, 2010 2:14:27 PM
Subject: Re: [ADMIN] Confused by 'timing' results
A J <s5aly@yahoo.com> wrote:
> time echo '\timing \\select * from table1 where id = 123;' | psql
> In the above query. the 'timing' will time the database time and
> the 'time' command at the very start will time the complete time
> for the query including network time.
No, the 'timing' will say how long it took to send the query from
psql to the server and get the complete response back from the
server. The 'time' command will also include the time to start
psql, establish the connection to the database, read from the pipe,
and close the connection to the database.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: s5aly@yahoo.com, Kevin.Grittner@wicourts.gov
Subject: Re: Confused by 'timing' results
In-Reply-To: <19320.56933.qm@web120013.mail.ne1.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