Thread: stats for queries

stats for queries

From
Lucas Rockwell
Date:
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@socrates.berkeley.edu
------------------------