| From: | Lucas Rockwell <lr(at)socrates(dot)Berkeley(dot)EDU> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | stats for queries |
| Date: | 2002-01-29 23:51:06 |
| Message-ID: | Pine.GSO.4.40.0201291546240.8729-100000@socrates.Berkeley.EDU |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
hi all,
i am very new to this list. i have looked in the docs and have tried to
search the archives and i can not find reference to this:
how do i get psql to give me statistics about how long it took to perform
a query?
for instance, if i do:
select count(table_id) from table;
i want psql to print the time (seconds, milliseconds, or
whatever) it took postgres to get me the results.
can psql do this for me?
many thanks in advance.
-lucas
------------------------
Lucas Rockwell
lr(at)socrates(dot)berkeley(dot)edu
------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lonh SENG | 2002-01-30 01:12:32 | SQL Script |
| Previous Message | Tom Lane | 2002-01-29 22:36:15 | Re: problem with pg_restore |