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;