| From: | Francisco Reyes <lists(at)natserv(dot)com> |
|---|---|
| To: | Greg Sabino Mullane <greg(at)turnstep(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Timing a query |
| Date: | 2001-11-27 15:44:58 |
| Message-ID: | 20011127104225.U95906-100000@zoraida.natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wheeler | 2001-11-27 16:13:29 | Re: DBD::Pg BYTEA Character Escaping |
| Previous Message | Francisco Reyes | 2001-11-27 15:38:07 | Re: Optimize for insertions? |