something similar to explain

From: Lucas Rockwell <lr(at)socrates(dot)Berkeley(dot)EDU>
To: pgsql-admin(at)postgresql(dot)org
Subject: something similar to explain
Date: 2002-03-04 15:28:09
Message-ID: Pine.GSO.4.40.0203040713110.24352-100000@socrates.Berkeley.EDU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi,

i am running some tests and i would like to see how long it takes to run a
query. "explain" gives me query plan info, but i want to actually run the
query and then find out how long it took.

is there a way with psql to get the time it takes to perform a query?

thanks.

-lucas

------------------------
Lucas Rockwell
UAS Systems Group
510.642.6465
lr(at)socrates(dot)berkeley(dot)edu
------------------------

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-03-04 15:51:02 Re: [GENERAL] Which trigger execute which function?
Previous Message Tom Lane 2002-03-04 15:13:30 Re: Indexes and outer join?