On 4 Mar 2002 at 7:28, Lucas Rockwell wrote:
> i am running some tests and i would like to see how long it takes to run a
> query. "explain" gives me query plan info, but i want to actually run the
> query and then find out how long it took.
>
> is there a way with psql to get the time it takes to perform a query?
I was told about this last night: With 7.2, explain analyze
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-
explain.html
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples