Re: how to get current sql execution time?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: sunpeng <bluevaley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to get current sql execution time?
Date: 2010-10-14 22:55:47
Message-ID: 4CB78A73.4080003@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message sunpeng 2010-10-14 23:34:10 how to write an optimized sql with two same subsql?
Previous Message Adrian Klaver 2010-10-14 22:52:06 Re: how to get current sql execution time?