Message-ID: <4E10078E.6000101@postnewspapers.com.au>
Date: Sun, 03 Jul 2011 14:09:18 +0800
From: Craig Ringer <craig@postnewspapers.com.au>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:5.0) Gecko/20110624 Thunderbird/5.0
MIME-Version: 1.0
To: Radhya sahal <rad_cs_2006@yahoo.com>
CC: pgsql-performance group <pgsql-performance@postgresql.org>
Subject: Re: How can retrieve total query run-time with out using
 explain
References: <1309666434.43400.YahooMailClassic@web38605.mail.mud.yahoo.com>
In-Reply-To: <1309666434.43400.YahooMailClassic@web38605.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 3/07/2011 12:13 PM, Radhya sahal wrote:
> Dear all,
> How can retrieve total query run-time when i run any query with out
> using explain

EXPLAIN doesn't tell you the query runtime.

EXPLAIN ANALYZE does, but it doesn't return the query results, returning 
plan and timing information instead.

> for example when i run any query such as
> select * from tablel1;
> Total query runtime: 443 ms.

in psql, use:

\timing on

> i want a function can return "runtime: 443 ms" with out using explain
> i want this command to call it from java source code

Record the system time before you run the query using 
System.currentTimeMillis()  or System.nanoTime().

Record the system time after you run the query.

Subtract and convert the difference to a java.util.Date so you can 
format it prettily for display, or just print the difference in 
milliseconds. If you want more flexible date/time handling, see JodaTime.

This gives you the time the query took including how long it took to 
retrieve the initial resultset. If you want the time the query took to 
execute on the server, not counting fetch time, this may not be what you 
want.

I don't know how to get query execution time *not* counting resultset 
retrieval time from the client. Anyone know if it's even possible?

--
Craig Ringer