Fw: query total time im milliseconds

----- Forwarded Message ----
From: Radhya sahal <rad_cs_2006(at)yahoo(dot)com>
To: Samuel Gendler <sgendler(at)ideasculptor(dot)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(at)ideasculptor(dot)com>
To: Radhya sahal <rad_cs_2006(at)yahoo(dot)com>
Cc: pgsql-performance group <pgsql-performance(at)postgresql(dot)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(at)yahoo(dot)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;