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 13:08:01
Message-ID: 1310303281.47662.YahooMailRC@web38607.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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Anish Kejariwal 2011-07-10 15:33:59 Re: issue with query optimizer when joining two partitioned tables
Previous Message Radhya sahal 2011-07-10 13:07:13 query total time im milliseconds