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@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