Re: query total time im milliseconds

[Samuel Gendler <sgendler@xxxxxxxxxxxxxxxx>]

On Sun, Jul 10, 2011 at 4:41 AM, Radhya sahal <rad_cs_2006@xxxxxxxxx> 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;