stats for queries

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
------------------------

Browse pgsql-admin by date

  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