| From: | "Dan Langille" <dan(at)langille(dot)org> |
|---|---|
| To: | Lucas Rockwell <lr(at)socrates(dot)Berkeley(dot)EDU> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: something similar to explain |
| Date: | 2002-03-04 16:34:43 |
| Message-ID: | 200203041634.g24GYjk77968@lists.unixathome.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-03-04 17:28:35 | Re: [GENERAL] Which trigger execute which function? |
| Previous Message | Stephan Szabo | 2002-03-04 16:26:17 | Re: Which trigger execute which function? |