Re: how to get current sql execution time?

From: Adrian Klaver <adrian(dot)klaver(at)gmail(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:52:06
Message-ID: 4CB78996.4080703@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-10-14 22:55:47 Re: how to get current sql execution time?
Previous Message bricklen 2010-10-14 22:51:54 Re: how to get current sql execution time?