query total time im milliseconds

From: Radhya sahal <rad_cs_2006(at)yahoo(dot)com>
To: pgsql-performance group <pgsql-performance(at)postgresql(dot)org>
Subject: query total time im milliseconds
Date: 2011-07-10 16:44:30
Message-ID: 1310316270.63536.YahooMailRC@web38606.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

 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 retetive the query total time in millisecond

if i connect with postgresql from java using JDBC
i need the query total time necessary to use it in my project
i don't want run explian,explain gives estimated i want real total time for the 
query

thank's

Browse pgsql-performance by date

  From Date Subject
Next Message Samuel Gendler 2011-07-10 17:51:52 Re: query total time im milliseconds
Previous Message Tom Lane 2011-07-10 16:42:55 Re: INSERT query times