Re: Timing a query - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Timing a query
Date
Msg-id 20011127104225.U95906-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Timing a query  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-general
On Tue, 27 Nov 2001, Greg Sabino Mullane wrote:
> If you have a recent version of Postgresql, you can do an
> EXPLAIN ANALYZE before the actual query:


How recent? 7.2 beta?
I tried it on 7.1.3 and didn't have it.

> Alteratively, I wrote a small patch for psql that tells
> you how long every query you run takes.


This seems to be such a commonly needed task. Shouldn't this be
incorporated into psql?

Could you include the output of "EXPLAIN ANALYZE" I would like to see what
it gives.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Troublesome handling of dropped connection
Next
From: Francisco Reyes
Date:
Subject: Re: Optimize for insertions?