How can retrieve total query run-time with out using explain

From: Radhya sahal <rad_cs_2006(at)yahoo(dot)com>
To: pgsql-performance group <pgsql-performance(at)postgresql(dot)org>
Subject: How can retrieve total query run-time with out using explain
Date: 2011-07-03 04:13:54
Message-ID: 1309666434.43400.YahooMailClassic@web38605.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dear all,
How can retrieve total query run-time  when i run any query with out using explain
for example when i run any query  such  as
select * from  tablel1;
Total query runtime: 443 ms.
 i want a function can return "runtime: 443 ms" with out using explain
i want this command to call it from java source code
can any one help me??? .

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2011-07-03 06:09:18 Re: How can retrieve total query run-time with out using explain
Previous Message Dave Page 2011-07-02 08:20:33 Re: Infinite Cache