Re: timing queries?

In 7.3 psql, just issue (at the psql prompt):

\timing

All queries subsequent to the command will have timing info.

\timing

again to toggle it off.

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(at)postgresql(dot)org
>
>

--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero(at)sonalysts(dot)com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************