Postgres Pro
Downloads
Home   >   mailing lists

Re: how to get current sql execution time? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: how to get current sql execution time?
Date
Msg-id 4CB78996.4080703@gmail.com
Whole thread Raw
In response to how to get current sql execution time?  (sunpeng <bluevaley@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: Re: how to get current sql execution time?
Next
From: John R Pierce
Date:
Subject: Re: how to get current sql execution time?