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 11:41:45
Message-ID: 1310298105.48876.YahooMailRC@web38605.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 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Radhya sahal 2011-07-10 13:07:13 query total time im milliseconds
Previous Message Gael Le Mignot 2011-07-10 10:06:38 Re: Memory usage of auto-vacuum