Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id B164BB5DE0F
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 10 Jul 2011 15:13:11 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 53253-01-5
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 10 Jul 2011 18:13:05 +0000 (UTC)
Received: from mx1.hub.org (mx1.hub.org [200.46.208.106])
	by mail.postgresql.org (Postfix) with ESMTP id B7A0AB5DE4E
	for <pgsql-performance@postgresql.org>;
	Sun, 10 Jul 2011 15:08:38 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from nm15-vm0.bullet.mail.ne1.yahoo.com
	(nm15-vm0.bullet.mail.ne1.yahoo.com [98.138.91.70])
	by mx1.hub.org (Postfix) with SMTP id E87AF27FB891
	for <pgsql-performance@postgresql.org>;
	Sun, 10 Jul 2011 15:08:37 -0300 (ADT)
Received: from [98.138.90.49] by nm15.bullet.mail.ne1.yahoo.com with NNFMP;
	10 Jul 2011 13:08:02 -0000
Received: from [98.138.88.238] by tm2.bullet.mail.ne1.yahoo.com with NNFMP;
	10 Jul 2011 13:08:02 -0000
Received: from [127.0.0.1] by omp1038.mail.ne1.yahoo.com with NNFMP;
	10 Jul 2011 13:08:02 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 541060.15931.bm@omp1038.mail.ne1.yahoo.com
Received: (qmail 68527 invoked by uid 60001); 10 Jul 2011 13:08:02 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1310303282; bh=PM6md75m6XThodszNTm5WQ+gG+RcqWvOUKyYoiZaXu0=;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type;
	b=ApTZPDeWPfhuMU6/bMOtukyANYj2GFSn/utC3sb1z9sWNIZME+MF1HG7xucIb0fOpvCSsDnIsTIfxroGS5cHMzFbON5JWX+DuwuMcikKc0AxXBmHHI5HhAAM71dGQEkByORjgjY1B63vUmsHMK2cn58dHeZUBrCgUf3hx7o72ao=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type;
	b=X4cljsB1K9StLEdNp0BpbAYMtoxZNup4kSggr6fXRdenZj48wzQ4XfnVM/8POMMZB/ESZSvOUVSxmmrlGOmn90Pms9F6YrC/UzFoZu2VzEKCI4uiLzIdTZ/fQKvXl97f+R9wj0C4qQN/no5El6Gi8oitdEydAy35ItfYeRoKk7k=;
X-YMail-OSG: KtrV3jQVM1l9Y4uz8r0HsbxoFpWFMiBiK7mrZ7WEuTzoUpu
	CWBT8g3evQ1u2la1ns2800lL80AWgqbaDDeLWyx6oQNF4r6j8vwVOgdxXy.F
	9V_kRrs6uaxB9wcHF7V_tEtulVDQiseUDE3nmPBOnAJESug02hO3xlIB5CnJ
	LQrtuyIQb5h3fLvguHMnxlpGr3tR.kB2QxI_a1lKpxiPf9s.xLIjOwlCI2WR
	PAlIt8qj8FF16F5HCjdUA.l8ZJdjieKJiCNYuXB16vkAqkWCLY8jEBTHpbgJ
	tWJ39JsfY06A3P_9DbhChTtPGvuDRol4si9wxq3drS1i8Z_OVa4.uFO_nFNl
	MXeyGnCVTdSWO3t7sI9vtXO6Z1iQo1.SHvmd_YQ6gn6UFTJgAA19qLLS7R2C
	NhETjXPmJKTDOIwE-
Received: from [41.34.141.141] by web38607.mail.mud.yahoo.com via HTTP;
	Sun, 10 Jul 2011 06:08:01 PDT
X-Mailer: YahooMailRC/572 YahooMailWebService/0.8.112.307740
Message-ID: <1310303281.47662.YahooMailRC@web38607.mail.mud.yahoo.com>
Date: Sun, 10 Jul 2011 06:08:01 -0700 (PDT)
From: Radhya sahal <rad_cs_2006@yahoo.com>
Subject: query total time im milliseconds
To: pgsql-performance group <pgsql-performance@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-254469466-1310303281=:47662"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.798 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.1, FREEMAIL_FROM=0.001,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201107/85
X-Sequence-Number: 44297

--0-254469466-1310303281=:47662
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

=A0=0A=0A=A0Dear all ,=0Acould any one help me?=0Awhen i use pgadmin to exc=
eute a query it shows the total time for query ..=0Asuch as =0A(select * fo=
rm table_name.........)query total time is for example 100 ms=0Ai want to k=
now the command that can retetive the query total time in=A0millisecond =0A=
=0Aif i connect with postgresql from java using JDBC =0Ai need the query to=
tal time necessary to use it in my project =0Ai don't want run explian,expl=
ain gives estimated i want real total time for the=A0 =0Aquery =0A=0Athank'=
s
--0-254469466-1310303281=:47662
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:arial, helvetica, sans-serif;font-size:1=
4pt"><DIV>&nbsp;<BR></DIV>=0A<DIV style=3D"FONT-FAMILY: arial, helvetica, s=
ans-serif; FONT-SIZE: 14pt">=0A<DIV style=3D"FONT-FAMILY: times new roman, =
new york, times, serif; FONT-SIZE: 12pt">=0A<DIV style=3D"FONT-FAMILY: aria=
l, helvetica, sans-serif; FONT-SIZE: 14pt">=0A<DIV style=3D"FONT-FAMILY: ar=
ial, helvetica, sans-serif; FONT-SIZE: 14pt">=0A<DIV style=3D"FONT-FAMILY: =
times new roman, new york, times, serif; FONT-SIZE: 12pt">=0A<DIV style=3D"=
FONT-FAMILY: arial, helvetica, sans-serif; COLOR: #2d2d2d; FONT-SIZE: 14pt"=
>=0A<DIV><FONT color=3D#000000>&nbsp;</FONT>Dear all ,</DIV>=0A<DIV>could a=
ny one help me?</DIV>=0A<DIV>when i use pgadmin to exceute a query it shows=
 the total time for query ..</DIV>=0A<DIV>such as </DIV>=0A<DIV>(select * f=
orm table_name.........)query total time is for example 100 ms</DIV>=0A<DIV=
>i want to know the command that can retetive the query total time in&nbsp;=
millisecond </DIV>=0A<DIV>if i connect with postgresql from java using JDBC=
 </DIV>=0A<DIV>i need the query total time necessary to use it in my projec=
t </DIV>=0A<DIV>i don't want run explian,explain gives estimated i want rea=
l total time for the&nbsp; query </DIV>=0A<DIV>thank's</DIV></DIV></DIV></D=
IV></DIV></DIV></DIV></div></body></html>
--0-254469466-1310303281=:47662--