In 7.3, you can use \timing to see query duration, or SET log_duration
TO 'on';SET client_min_messages TO 'log'.
---------------------------------------------------------------------------
Andy Kriger wrote:
> Is it possible to find out how long a query takes in the psql command-line
> tool? For example, when I exectute a query I want to see 28ms or whatever
> before the query results. If not in the command-line tool, is there a way to
> log this info? (I have query logging turned on, but that just shows the
> query being executed). I need this info to compare against making calls
> through JDBC and through an object-layer on top of JDBC.
>
> thx
> andy
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073