Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 6D1BBB5DBC6
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 10 Jul 2011 13:44:38 -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 53662-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 10 Jul 2011 16:44:32 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from nm30.bullet.mail.ac4.yahoo.com (nm30.bullet.mail.ac4.yahoo.com
	[98.139.52.227])
	by mail.postgresql.org (Postfix) with SMTP id D8996B5DBC8
	for <pgsql-performance@postgresql.org>;
	Sun, 10 Jul 2011 13:44:31 -0300 (ADT)
Received: from [98.139.52.196] by nm30.bullet.mail.ac4.yahoo.com with NNFMP;
	10 Jul 2011 16:44:31 -0000
Received: from [98.139.52.167] by tm9.bullet.mail.ac4.yahoo.com with NNFMP;
	10 Jul 2011 16:44:31 -0000
Received: from [127.0.0.1] by omp1050.mail.ac4.yahoo.com with NNFMP;
	10 Jul 2011 16:44:31 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 273778.22004.bm@omp1050.mail.ac4.yahoo.com
Received: (qmail 78097 invoked by uid 60001); 10 Jul 2011 16:44:30 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1310316270; bh=ISMQr3A7B/bI37xCB9l2IDquraaLTStP3x/Koq6Vp2o=;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type;
	b=F9MlI34Qd6BCRh6Z9RknPjHwCvVlA0GHhaeU2HpsJrOjUAq631MAEeqX3N9JKkXAp1uxwB2lCpWsPLoj/hM8IZhe0YN/4ugnu/LEDtnQHxSw49H5G6xj15YpjgNvfze/HN/1pqo/P7sjuVxeveMBPNn3ZdbyZ+zhAoqOjM0YixU=
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=vfE9s4tIs/DwU4MFIhTA+e+KcVquE9FfAITUUcRIYZozvfnFKcIegbgUc8eccB2h4Dlmv+/TdKAvuHiGvKOoTyFZ943lj10pV9LDYOaH+hCMaXBWAPyh/6VOu95yi7UsuAt/mum4DJxcgKPqIPNzPa+mF7sPOWY0995FAyAzSd4=;
X-YMail-OSG: GC6So2gVM1nyp5M7i03p1c4BSSJ3YwS0I3vUSB3HEDlzUS3
	Bcp9suwbt2rNXLGRmPEQ5eL5ftCFBmR28mjXlzS93lSbBd_y_.WDpTVtrurC
	E4XMGEtmlCI4zSnAmr46htWVuqhQS7g5QrThO9sblYqdlRSFNaf0MdYsoRhY
	_WGjiE7Qij4y8C9ut2JBGl9klSm.Xh.WiHqsEVbNDGqZCHdDXJKXZsVtDMtq
	gF8NzfeqOVIutymkiPr0FKNGTxm9DVdj1JbkK2oQD2F321PaO.dQjcKzw7y4
	R9ya0KDnxng32qEhDNUGXtepYW0h2krvCj1qAnpW0N6Mh3QN7uRIB81i53cV
	hCcwEKS4.96gL34mPI7WKKjzr1OaoHHA0tbERsagUGUvZRYPr0C5TLu7VEew
	n7dgw_tc8VLGwdg--
Received: from [41.34.141.141] by web38606.mail.mud.yahoo.com via HTTP;
	Sun, 10 Jul 2011 09:44:30 PDT
X-Mailer: YahooMailRC/572 YahooMailWebService/0.8.112.307740
Message-ID: <1310316270.63536.YahooMailRC@web38606.mail.mud.yahoo.com>
Date: Sun, 10 Jul 2011 09:44:30 -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-1720294257-1310316270=:63536"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.808 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, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201107/82
X-Sequence-Number: 44294

--0-1720294257-1310316270=:63536
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

=0A=0A=A0Dear all ,=0Acould any one help me?=0Awhen i use pgadmin to exceut=
e a query it shows the total time for query ..=0Asuch as =0A(select * form =
table_name.........)query total time is for example 100 ms=0Ai want to know=
 the command that can retetive the query total time in=A0millisecond =0A=0A=
if i connect with postgresql from java using JDBC =0Ai need the query total=
 time necessary to use it in my project =0Ai don't want run explian,explain=
 gives estimated i want real total time for the=A0 =0Aquery =0A=0Athank's
--0-1720294257-1310316270=:63536
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;</DIV>=0A<DIV style=3D"FONT-FAMILY: arial, 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, h=
elvetica, sans-serif; FONT-SIZE: 14pt">=0A<DIV style=3D"FONT-FAMILY: arial,=
 helvetica, sans-serif; FONT-SIZE: 14pt">=0A<DIV style=3D"FONT-FAMILY: time=
s new roman, new york, times, serif; FONT-SIZE: 12pt">=0A<DIV style=3D"FONT=
-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 14pt">=0A<DIV style=3D"FO=
NT-FAMILY: arial, 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; FON=
T-SIZE: 14pt">=0A<DIV><FONT color=3D#000000>&nbsp;</FONT>Dear all ,</DIV>=
=0A<DIV>could any 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 * form table_name.........)query total time is for example 100 =
ms</DIV>=0A<DIV>i want to know the command that can retetive the query tota=
l 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 project </DIV>=0A<DIV>i don't want run explian,explain gives estim=
ated i want real total time for the&nbsp; query </DIV>=0A<DIV>thank's</DIV>=
</DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></div></body></html>
--0-1720294257-1310316270=:63536--