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