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: | Raw Message | Whole Thread | 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 |