Postgres Pro
Downloads
Home   >   mailing lists

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

From John R Pierce
Subject Re: how to get current sql execution time?
Date
Msg-id 4CB78A73.4080003@hogranch.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/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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: how to get current sql execution time?
Next
From: sunpeng
Date:
Subject: how to write an optimized sql with two same subsql?