Re: how do i find out how long a query took?

Darren Ferguson wrote:
> select version();
> version
> -------------------------------------------------------------
> PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
> (1 row)
>
>
> \timing does not work gives following
>
> oss=> \timing
> Showing only tuples.
> \t: extra argument 'iming' ignored
>
> Any ideas ??? or was it just 7.2.2??

Oops, that is a 7.3 new feature. There isn't a way in 7.2.X. Perhaps
you can set your psql prompt to the current time but I can't figure out
how to do that either.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073