Thread: how to get current sql execution time?

\timing

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

On Thu, Oct 14, 2010 at 3:47 PM, sunpeng <bluevaley@gmail.com> wrote:
> when I use the psql to send a sql, how to get current sql execution time?
>

At the psql prompt:

# \timing
Timing is on.

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

http://www.postgresql.org/docs/9.0/interactive/app-psql.html

"\timing [ on | off ]

     Without parameter, toggles a display of how long each SQL statement
takes, in milliseconds. With parameter, sets same. "

--
Adrian Klaver
adrian.klaver@gmail.com

  On 10/14/10 3:47 PM, sunpeng wrote:
> when I use the psql to send a sql, how to get current sql execution time?

\timing [{on|off}]

either toggles or sets on and off.   when timing is on, it displays
query 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/