stats for queries - Mailing list pgsql-admin

From Lucas Rockwell
Subject stats for queries
Date
Msg-id Pine.GSO.4.40.0201291546240.8729-100000@socrates.Berkeley.EDU
Whole thread Raw
List 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@socrates.berkeley.edu
------------------------


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem with pg_restore
Next
From: "lonh SENG"
Date:
Subject: SQL Script