Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 9B696632BF8
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu,  2 Sep 2010 14:34:40 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 13014-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu,  2 Sep 2010 17:34:32 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from n3-vm0.bullet.mail.gq1.yahoo.com
	(n3-vm0.bullet.mail.gq1.yahoo.com [67.195.23.156])
	by mail.postgresql.org (Postfix) with SMTP id 085336328B7
	for <pgsql-admin@postgresql.org>; Thu,  2 Sep 2010 14:34:32 -0300 (ADT)
Received: from [98.137.27.132] by n3.bullet.mail.gq1.yahoo.com with NNFMP;
	02 Sep 2010 17:34:31 -0000
Received: from [98.137.27.222] by t4.bullet.mail.gq1.yahoo.com with NNFMP;
	02 Sep 2010 17:34:31 -0000
Received: from [127.0.0.1] by omp132.mail.gq1.yahoo.com with NNFMP;
	02 Sep 2010 17:34:31 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 759674.4035.bm@omp132.mail.gq1.yahoo.com
Received: (qmail 58463 invoked by uid 60001); 2 Sep 2010 17:34:31 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1283448871; bh=hIaQYkl2jzLuTmayR8j1YUacQezBgPwCLSJla+JRDRE=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=qQmuDLDpUBEJ2ZU2SYXKrVQOuBtS3VsrEbqpQCy7vgjoCQUyVH2DwJ1o9X9WE76BhlgVqNm8Lp0Zrow/4N6Udo2Gj4ssn87eaDAzDJkZFqKxT2ksA/FvDn50qpGwLdwaLljIbdaEJlDQtn+Yd4Ve7JCQBSx4IKzz248ECwbkQVs=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=REttBuBUNIhmRN5C104JpjbWkUtBNrCGBaf4kCz0gv200S4SPneb8sMJgmU+oieoY4b/7YdT3lHwO6kd23A8aw4VG2APXbsmuwe/IlXe7ihiNuHzjtV+CkRxrCrFbT0lgpRkvBMpTJBt4FW3xOP/943JIT7kcz6CHDBQgBZyBRw=;
Message-ID: <294404.58402.qm@web120007.mail.ne1.yahoo.com>
X-YMail-OSG: KhYZpXkVM1msrcsNruqImDKsHWSmUbehOVP.38D5iJf_JBE
	330ibQFoHpMzlIZtwliXGXTfBg2OPttFbCIims974B5G6Yc6KHMNitRmDydE
	0ZkkhOOK_DKW_J8pekhAThL.03CaZ0y72BF1Ar6fmkbApKiDQivobrelm4G_
	WEPEwkPCD9.hCcqRJE2FdsGNJGp4uvmVv3t23GIlSirI0_fs6pHJBl4LqLyn
	e_oetmKvCTYrkQfdvHQ--
Received: from [68.36.215.11] by web120007.mail.ne1.yahoo.com via HTTP;
	Thu, 02 Sep 2010 10:34:30 PDT
X-Mailer: YahooMailRC/470 YahooMailWebService/0.8.105.279950
References: <788866.21140.qm@web120020.mail.ne1.yahoo.com>
	<4C7D00330200002500034ED2@gw.wicourts.gov>
	<19320.56933.qm@web120013.mail.ne1.yahoo.com>
	<AANLkTi=6k6AbmBcqkVCKgNSiogVfQmP+iOC8FgA6+e5J@mail.gmail.com>
	<529329.89885.qm@web120007.mail.ne1.yahoo.com>
	<4C7F8F2A0200002500035037@gw.wicourts.gov>
Date: Thu, 2 Sep 2010 10:34:30 -0700 (PDT)
From: A J <s5aly@yahoo.com>
Subject: Re: Confused by 'timing' results
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>,
	Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
In-Reply-To: <4C7F8F2A0200002500035037@gw.wicourts.gov>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1149798275-1283448870=:58402"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201009/19
X-Sequence-Number: 35563

--0-1149798275-1283448870=:58402
Content-Type: text/plain; charset=us-ascii

Kevin
The problem I am trying to solve is:
measure accurately both the database server time + network time when several 
clients connect to the database from different geographic location.
All the clients hit the database simultaneously with a long script each of 
insert/update/select queries.

I don't need aggregate numbers but the 2 components of the time taken for each 
and every query to drive analysis. So need in some fashion:
Query1, DB Time, Total Time (or Network Time)
....
Query<n>, DB Time, Total Time (or Network Time)