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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
