Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id B9CABB5DBBE for ; Sun, 10 Jul 2011 15:26:19 -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 67316-02 for ; Sun, 10 Jul 2011 18:26:13 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm8.bullet.mail.bf1.yahoo.com (nm8.bullet.mail.bf1.yahoo.com [98.139.212.167]) by mail.postgresql.org (Postfix) with SMTP id 3E0CDB5D803 for ; Sun, 10 Jul 2011 15:26:12 -0300 (ADT) Received: from [98.139.212.149] by nm8.bullet.mail.bf1.yahoo.com with NNFMP; 10 Jul 2011 18:26:12 -0000 Received: from [98.139.212.232] by tm6.bullet.mail.bf1.yahoo.com with NNFMP; 10 Jul 2011 18:26:12 -0000 Received: from [127.0.0.1] by omp1041.mail.bf1.yahoo.com with NNFMP; 10 Jul 2011 18:26:12 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 330438.24977.bm@omp1041.mail.bf1.yahoo.com Received: (qmail 32389 invoked by uid 60001); 10 Jul 2011 18:26:11 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1310322371; bh=WlbqRUzgrPiwqYkHz7tdBtEYNiaC65EbRfs9jU42xiQ=; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=2+wj2wTpVaR5p3riQRMYuzBRmfHuKP85dCx49Tpa0/7LiDrncoMmqDARstcUe03iOlB3Fp4DPrc7mYV+kqZ63HMsRXoGJhzcdrJFeuvKSCbykacfWSb0O94VuSwW/l3XIr2NDAA02Lj8UyRfzyfeaC9SuS+zwWC66DjqtuDrbgQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=zntje3WmS35nmk6b8Ae5v96s98aEloSqnkGdUWmPA5ecG1eyXbqz4VMjLIVo1sy54PkBaa5//TB+/NcpV+Rmq9p3K5aZzcO4RQiFP+mivu77XuHB+kcLsGqE5ij6brjRfeZsLyX+01pfVHZRgGq12bSkOzFOos3lPHnMgrgWg8s=; X-YMail-OSG: GxNr0FkVM1lhmgD6TrwvwaC_HtlOBCez_7IO8.gK0vF2gv6 LM5sjUY.2TQa2qZFwAL6raD.YogyCHfMteTX3_Z_DiHSCO0Yj77cJr7UJP9R J_pZf96OMlJr368J4zMNzChaadN8YAos5o1UlYiKwiA2PwI8YJFMOuyPchsj W_TqlHEDVEnP2RkRFnz8_xGZSFlmLXg.YH6dVKRAx.p1eUILwHwr82By.x7x NPkp5igf9U4zI00hpESkEGkEO6YtCu2caPXAtln.Pvnh9ZQ6CizNtwVwGjAX KW9MwWSj4euQHXyXkv8EOyOzf7JA._TvDxYqigK78eY_rjFk0sL_QixBDgoF fkxiFF81WQ6M5cgQzf692rCsMRqiVT3sLeNpEXXWJ_A6OplPHLuwrv8OoyGh nHDz.TNNzsTVKwA-- Received: from [41.34.141.141] by web38604.mail.mud.yahoo.com via HTTP; Sun, 10 Jul 2011 11:26:11 PDT X-Mailer: YahooMailRC/572 YahooMailWebService/0.8.112.307740 References: <1310298105.48876.YahooMailRC@web38605.mail.mud.yahoo.com> Message-ID: <1310322371.24647.YahooMailRC@web38604.mail.mud.yahoo.com> Date: Sun, 10 Jul 2011 11:26:11 -0700 (PDT) From: Radhya sahal Subject: Fw: query total time im milliseconds To: pgsql-performance group In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1285827097-1310322371=:24647" 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/86 X-Sequence-Number: 44298 --0-1285827097-1310322371=:24647 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable =0A=0A=0A=0A----- Forwarded Message ----=0AFrom: Radhya sahal =0ATo: Samuel Gendler =0ASent: Sun, Ju= ly 10, 2011 11:25:46 AM=0ASubject: Re: [PERFORM] query total time im millis= econds=0A=0A=0AThank's=0A=0Along startTime =3D System.currentTimeMillis();= =0A//execute query=0Along executionTime =3D System.currentTimeMillis() - st= artTime; =0A=0Athis executionTime is=A0not an=A0actual time for query ,=0Ai= t includes time for access to postgresql server=0A=A0using JDBC=0A=0A=0A=0A= ________________________________=0AFrom: Samuel Gendler =0ATo: Radhya sahal =0ACc: pgsql-performance= group =0ASent: Sun, July 10, 2011 10:51:= 52 AM=0ASubject: Re: [PERFORM] query total time im milliseconds=0A=0A=0A=0A= =0AOn Sun, Jul 10, 2011 at 4:41 AM, Radhya sahal wr= ote:=0A=0ADear all ,=0A>could any one help me?=0A>when i use pgadmin to exc= eute 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 t= o know the command that can retentive the query total time =0A>in=A0millise= cond =0A>=0A>if i connect with postgresql from java using JDBC =0A>i need t= he query total time necessaryto use it in my project =0A>i don't want run e= xplian just query =0A>thank's=0A=0A=0Along startTime =3D System.currentTime= Millis();=0A//execute query=0Along executionTime =3D System.currentTimeMill= is() - startTime;=A0=0A --0-1285827097-1310322371=:24647 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

=0A

=0A
----- F= orwarded Message ----
From:<= /B> Radhya sahal <rad_cs_2006@yahoo.com>
To: Samuel Gendler <sgendler@ideasculptor.com>=
Sent: Sun, July 10, 201= 1 11:25:46 AM
Subject: R= e: [PERFORM] query total time im milliseconds

=0A
=0A
Tha= nk's
=0A

=0A
long startTime =3D System.currentTimeMi= llis();
=0A
//execute query
=0A
long executionTime =3D Sy= stem.currentTimeMillis() - startTime;
=0A

this executionTime = is not an actual time for query ,
=0A
it includes time f= or access to postgresql server
=0A
 using JDBC
=0A

=0A=
=0A
=0AFrom: Samuel Gendler <sgendler@ideasculpt= or.com>
To: Radhya sa= hal <rad_cs_2006@yahoo.com>
C= c: pgsql-performance group <pgsql-performance@postgresql.org&= gt;
Sent: Sun, July 10, = 2011 10:51:52 AM
Subject: Re: [PERFORM] query total time im milliseconds



=0A<= DIV class=3Dgmail_quote>On Sun, Jul 10, 2011 at 4:41 AM, Radhya sahal <rad_cs_2006@yahoo.com<= /A>> wrote:
=0A
=0A=0A
=0A
Dear all ,
=0A
could any one help me?<= /DIV>=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 need the query total time necessaryto use it in my project
=0A
= i don't want run explian just query
=0A
thank's
=
=0A

=0A

=0A
long startTime =3D= System.currentTimeMillis();
=0A
//execute query
=0A
long= executionTime =3D System.currentTimeMillis() - startTime; 

--0-1285827097-1310322371=:24647--