Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A9074B5DBC8 for ; Sun, 3 Jul 2011 01:14:02 -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 33654-10 for ; Sun, 3 Jul 2011 04:13:56 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm7.bullet.mail.ac4.yahoo.com (nm7.bullet.mail.ac4.yahoo.com [98.139.52.204]) by mail.postgresql.org (Postfix) with SMTP id 3F515B5D80A for ; Sun, 3 Jul 2011 01:13:56 -0300 (ADT) Received: from [98.139.52.192] by nm7.bullet.mail.ac4.yahoo.com with NNFMP; 03 Jul 2011 04:13:55 -0000 Received: from [98.139.52.155] by tm5.bullet.mail.ac4.yahoo.com with NNFMP; 03 Jul 2011 04:13:55 -0000 Received: from [127.0.0.1] by omp1038.mail.ac4.yahoo.com with NNFMP; 03 Jul 2011 04:13:55 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 325102.13697.bm@omp1038.mail.ac4.yahoo.com Received: (qmail 18860 invoked by uid 60001); 3 Jul 2011 04:13:54 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1309666434; bh=RkIXjxM2iQ88dVRR/TflCnNWK8wHTr7worj1ovwAT3s=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type; b=rcBZ+kRd/sJi/8rAU7tKEiPPNqaLhXALrOATqVZ9fg8O+Ds//bdTBo3BP7EAlvZYv3DgIEw0CHl2Q7MqUJMQzIdZOwWHrcU+ZnBtiAg8xlRLuDktpH8JcX36zbAF6RQqbK90rx7/mt7uCMl/YTcHV7Dg46TkqNB/o0LUjFRBm74= 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=e2NTsCvIJOVqTDUcGww7PLWuoIGSV57cT2wQqcmIf6dqM8jRORioHEg2owc+bC438h/geKcC3JjmJikUL7Gn5KtbpnC9vahUbKSCXQfKfs/SQipNIbSlKCbo8nDyb5gx+/vC75QvcQAeOvCxCRMX/3B8A72R59t5UySPn32HOew=; X-YMail-OSG: OdNzukcVM1mfCm36ZfFCgeoAzO83ImjGpqrSkkJWBHCS1ie JNYzyfpqAt3e7vAmh4jGSFbOwNX9M_bOxxYl.3tehdlOdKnDY2EyMQ1YsDxW gtoqXtGJRDEc7BdzjJn3aeC5lsJJdfDmx21OF0HSNqMhiuxA1m7tkOJl8DLx JQYAMB_MKL0a0zDHmRSFRdUCtRx2Ix7.rAFcqhcVNhm35PbH3kLjRWQdKXFO QIGWIZXkycZuJWYEPX5hzs.8zzBqwNSRG2BWM_zFP.0L4_5qbrz56cG0liwj 5rKdtLYYEABO46hUXOZ8q4ze2i1QUYNKa1tXRHYg2kiEdagca5bk08PqUf1U H1uKl3_6aPdJvqzhVgOUcCDEpLjaiOjTo1lUtf8a9a_VxilBkl1r0u1fdp6F nW7LSjDmbP9YVYg-- Received: from [41.237.150.213] by web38605.mail.mud.yahoo.com via HTTP; Sat, 02 Jul 2011 21:13:54 PDT X-Mailer: YahooMailClassic/14.0.3 YahooMailWebService/0.8.112.307740 Message-ID: <1309666434.43400.YahooMailClassic@web38605.mail.mud.yahoo.com> Date: Sat, 2 Jul 2011 21:13:54 -0700 (PDT) From: Radhya sahal Subject: How can retrieve total query run-time with out using explain To: pgsql-performance group MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1539226291-1309666434=:43400" 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/8 X-Sequence-Number: 44220 --0-1539226291-1309666434=:43400 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Dear all,=20 How can retrieve total query run-time=A0 when i run any query with out usin= g explain=20 for example when i run any query=A0 such=A0 as select * from=A0 tablel1; Total query runtime: 443 ms. =A0i want a function can return "runtime: 443 ms" with out using explain=20 i want this command to call it from java source code can any one help me??? . --0-1539226291-1309666434=:43400 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Dear all,
How can retrieve total query ru= n-time  when i run any query with out using explain
for example wh= en i run any query  such  as
select * from  tablel1;
T= otal query runtime: 443 ms.
 i want a function can return "runtime:= 443 ms" with out using explain
i want this command to call it from jav= a source code
can any one help me??? .
--0-1539226291-1309666434=:43400--