Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 4BE9FB5DBC6 for ; Sun, 10 Jul 2011 13:41:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 23590-02 for ; Sun, 10 Jul 2011 16:41:51 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm8-vm0.bullet.mail.bf1.yahoo.com (nm8-vm0.bullet.mail.bf1.yahoo.com [98.139.213.95]) by mail.postgresql.org (Postfix) with SMTP id CA8C4B5DBBE for ; Sun, 10 Jul 2011 13:41:50 -0300 (ADT) Received: from [98.139.212.153] by nm8.bullet.mail.bf1.yahoo.com with NNFMP; 10 Jul 2011 11:41:46 -0000 Received: from [98.139.212.239] by tm10.bullet.mail.bf1.yahoo.com with NNFMP; 10 Jul 2011 11:41:46 -0000 Received: from [127.0.0.1] by omp1048.mail.bf1.yahoo.com with NNFMP; 10 Jul 2011 11:41:46 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 89061.52568.bm@omp1048.mail.bf1.yahoo.com Received: (qmail 55331 invoked by uid 60001); 10 Jul 2011 11:41:45 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1310298105; bh=FO+MaE5w3iInDqivGWd4+2B4vt4FTP7VN2DM7FEbpPQ=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type; b=Edx/o/mW+8aSXprsISbPL9wvC7oKZbe+p0mvY5we/hcRoj+dqXuJYntXdo9ZuuHWyzW3q8H1TthbEx4dAnw+kAg8s5ylnloXQWjr/+knSfbHMg4Zpp/0oO/uhs14be2LltpVydcdqwvOX2BO7251YJLKJ5iERY9HJbdhLuYPa64= 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=Q3i/P/F8jSavbV7hhnhB1Pnr25no7d0DewJXM/0X3q8Sx3kr0xzYz+PrZZJultLS9Uvqi2I+GPVT8cMAtcm452MXI/EQVZ/68w8PV+HJxnYsXe65Fiv7TUen/gHrEnemnBKiBtLl31NsWxCNdeuUbb0LNHjS0IARfGYiT80n68o=; X-YMail-OSG: EGnRovMVM1mPmBNXfmEBAADIlOFSd5fYc2H2Hm31Rea9Tvw vi_yaF3uSKY2AerZS1RNyiOr56Oe8b75cYxYa6IWVkAMgm8epEgLbfVOTBsU oPoAsOiKAsGkhbFBo4tLADhKgCVF6JaoGPdpMz357fVtwac3t6T9SdhBcxKy _J0QiH.TPZL5K0c4Exn.X7Fh8L3.PLNuXGi_VmE3S6PVOIx3mA1c2A.9FzWY 0rMpBAZNBNBT1IzOVmyenxxPpxNiPfRal.9fFCr3zuvW1NhVscrbD.X8bhZo fGqcDQIQnRycOQAtNsrFfTBeeR.ti2i4wRFpE5raTWIHM5xRcZJNq6RqxPLJ VGUklo8YBem94sF88fdn.Xuurry5qoMX7wWcUqOkC7abACjIATmPZ1_H5FD7 Wwz1K.6TuovYMh_8- Received: from [41.34.141.141] by web38605.mail.mud.yahoo.com via HTTP; Sun, 10 Jul 2011 04:41:45 PDT X-Mailer: YahooMailRC/572 YahooMailWebService/0.8.112.307740 Message-ID: <1310298105.48876.YahooMailRC@web38605.mail.mud.yahoo.com> Date: Sun, 10 Jul 2011 04:41:45 -0700 (PDT) From: Radhya sahal Subject: query total time im milliseconds To: pgsql-performance group MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1229999834-1310298105=:48876" 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/80 X-Sequence-Number: 44292 --0-1229999834-1310298105=:48876 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Dear all ,=0Acould any one help me?=0Awhen i use pgadmin to exceute a query= it shows the total time for query ..=0Asuch as =0A(select * form table_nam= e.........)query total time is for example 100 ms=0Ai want to know the comm= and that can retentive the query total time =0Ain=A0millisecond =0A=0Aif i = connect with postgresql from java using JDBC =0Ai need the query total time= necessaryto use it in my project =0Ai don't want run explian just query = =0Athank's --0-1229999834-1310298105=:48876 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Dear all ,
=0A
could any one help me?=0A
when i use pgadmin to exceute a query it shows the total time for= query ..
=0A
such as
=0A
(select * form table_name.....= ....)query total time is for example 100 ms
=0A
i want to know the= command that can retentive the query total time in millisecond
= =0A
if i connect with postgresql from java using JDBC
=0A
i n= eed the query total time necessaryto use it in my project
=0A
i d= on't want run explian just query
=0A
thank's
--0-1229999834-1310298105=:48876--