Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id BF87BB5DE02 for ; Sun, 10 Jul 2011 15:13:09 -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 53524-02 for ; Sun, 10 Jul 2011 18:13:03 +0000 (UTC) Received: from mx1.hub.org (mx1.hub.org [200.46.208.106]) by mail.postgresql.org (Postfix) with ESMTP id 22D57B5D803 for ; Sun, 10 Jul 2011 15:08:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm22-vm0.bullet.mail.ac4.yahoo.com (nm22-vm0.bullet.mail.ac4.yahoo.com [98.139.53.218]) by mx1.hub.org (Postfix) with SMTP id C080F27FBD13 for ; Sun, 10 Jul 2011 15:08:05 -0300 (ADT) Received: from [98.139.52.188] by nm22.bullet.mail.ac4.yahoo.com with NNFMP; 10 Jul 2011 13:07:14 -0000 Received: from [98.139.52.160] by tm1.bullet.mail.ac4.yahoo.com with NNFMP; 10 Jul 2011 13:07:14 -0000 Received: from [127.0.0.1] by omp1043.mail.ac4.yahoo.com with NNFMP; 10 Jul 2011 13:07:14 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 75692.42641.bm@omp1043.mail.ac4.yahoo.com Received: (qmail 71773 invoked by uid 60001); 10 Jul 2011 13:07:13 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1310303233; bh=20xy8AaY0h3bfUtR2Oy/OuakA+gzErGE+jiqblu3iIU=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type; b=m3uPoAJwoDkk/sQbxjxGgbr+CKg/W5xz4UR8sRrolL/k2eobD4ataIjD00ImEgzgfaIUMa4uifTUUG6OhUDFAe44hR+yPZqnNj4z2IaWTkJK2Azjv8CCEtqLzS8qM7hwZ57q1b7ac3S99742t2/6d02jCT8Wh4rRy1Y31yXE69w= 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=t9eJ9dN6GYtHOR9nHcKbEmDqsKGhUvhEI3SfXc0pUq+xIkvcn2AWTaB2+NNYobYEJ7YPzznQaRtvFYcpoqgLlirg+UTSERNyClwBpRkyo8iGRjrXOfkUcgY98dnNYsKc+dFa3CwOYtPw/7uZBL88RpQxVz8juLDAV2ovLNOPu24=; X-YMail-OSG: tdn4DPQVM1k2i7L5o6DWh9NDbgGyOfNCMXSkykUs9.SnJB1 SNTvJTUTpjLik9N8Yv56j8GyY_RllY7auFpO8N6NaiZNDU2iI64M9gmpvTuB kjwLWOMB3w.AYDu.PXo9rSMHjcziJjCbxrz3H6DHru86VoB1dwMLm8EosQIk pugizEiprhg91ByBCrNdYoIikNsq6fwRnIw94jK.TBQd_ksy3LRNFRHSvpaX I.fLCEzH5AnpDmksC84wR38JGYqmuSpcIViVQ3BtIpp9s0KpwflUUotUE0TD OVmwCVZmYYIonFcA34a4sB7Zre87kVGwfmTxgHQ12cpTSC9ICSRybPDFyXxs lGFMOaVjq3ok9VbDkpLuvt4teD0pk529LnQHrbIROB2mlph3OG_RNYYUE10. .n6SFMMspKLJ1ng-- Received: from [41.34.141.141] by web38606.mail.mud.yahoo.com via HTTP; Sun, 10 Jul 2011 06:07:13 PDT X-Mailer: YahooMailRC/572 YahooMailWebService/0.8.112.307740 Message-ID: <1310303233.63581.YahooMailRC@web38606.mail.mud.yahoo.com> Date: Sun, 10 Jul 2011 06:07:13 -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-845077509-1310303233=:63581" 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/84 X-Sequence-Number: 44296 --0-845077509-1310303233=:63581 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 thim for the=A0 query =0A=0Athank's --0-845077509-1310303233=:63581 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

=0A
=0A
=0A
=0A
 Dear all ,
=0A
could any one help me?
= =0A
when i use pgadmin to exceute a query it shows the total time for q= uery ..
=0A
such as
=0A
(select * form table_name.......= ..)query total time is for example 100 ms
=0A
i want to know the c= ommand that can retetive the query total time in millisecond
=0A=
if i connect with postgresql from java using JDBC
=0A
i need= the query total time necessary to use it in my project
=0A
i don= 't want run explian,explain gives estimated i want real thim for the  = query
=0A
thank's
--0-845077509-1310303233=:63581--