Re: how to get current sql execution time?

On 15/10/2010 6:47 AM, sunpeng wrote:
> when I use the psql to send a sql, how to get current sql execution time?

In addition to \timing as others have mentioned, you can use:

EXPLAIN ANALYZE [your-sql-here];

to get the server to tell you how it executed your SQL. If you do this,
the server won't return the query results, it'll instead return query
plan and timing data. Because of that, EXPLAIN ANALYZE doesn't include
the time it takes to transfer the results to the client, only the time
the server took to execute the query and how it executed it.

--
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/