Postgres Pro
Downloads
Home   >   mailing lists

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

From Samuel Gendler
Subject Re: query total time im milliseconds
Date
Msg-id CAEV0TzCZVv2Ge0t6-hc3rb2H2WJye8GOmo1X1CeFMoYkQvkYhg@mail.gmail.com
Whole thread Raw
In response to query total time im milliseconds  (Radhya sahal <rad_cs_2006@yahoo.com>)
Responses Fw: query total time im milliseconds
List pgsql-performance
Tree view


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: Radhya sahal
Date:
Subject: query total time im milliseconds