Postgres Pro
Downloads
Home   >   mailing lists

Fw: query total time im milliseconds - Mailing list pgsql-performance

From Radhya sahal
Subject Fw: query total time im milliseconds
Date
Msg-id 1310322371.24647.YahooMailRC@web38604.mail.mud.yahoo.com
Whole thread Raw
In response to Re: query total time im milliseconds  (Samuel Gendler <sgendler@ideasculptor.com>)
Responses Re: Fw: query total time im milliseconds
List pgsql-performance
Tree view


----- Forwarded Message ----
From: Radhya sahal <rad_cs_2006@yahoo.com>
To: Samuel Gendler <sgendler@ideasculptor.com>
Sent: Sun, July 10, 2011 11:25:46 AM
Subject: Re: [PERFORM] query total time im milliseconds

Thank's

long startTime = System.currentTimeMillis();
//execute query
long executionTime = System.currentTimeMillis() - startTime;

this executionTime is not an actual time for query ,
it includes time for access to postgresql server
 using JDBC

From: Samuel Gendler <sgendler@ideasculptor.com>
To: Radhya sahal <rad_cs_2006@yahoo.com>
Cc: pgsql-performance group <pgsql-performance@postgresql.org>
Sent: Sun, July 10, 2011 10:51:52 AM
Subject: Re: [PERFORM] query total time im milliseconds



On Sun, Jul 10, 2011 at 4:41 AM, Radhya sahal <rad_cs_2006@yahoo.com> wrote:
Dear all ,
could any one help me?
when i use pgadmin to exceute a query it shows the total time for query ..
such as
(select * form table_name.........)query total time is for example 100 ms
i want to know the command that can retentive the query total time in millisecond
if i connect with postgresql from java using JDBC
i need the query total time necessaryto use it in my project
i don't want run explian just query
thank's


long startTime = System.currentTimeMillis();
//execute query
long executionTime = System.currentTimeMillis() - startTime; 

pgsql-performance by date:

Previous
From: Radhya sahal
Date:
Subject: query total time im milliseconds
Next
From: lars
Date:
Subject: Re: UPDATEDs slowing SELECTs in a fully cached database