Re: Timing a query

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Timing a query
Дата
Msg-id 20011127104225.U95906-100000@zoraida.natserv.net
обсуждение исходный текст
Ответ на Re: Timing a query  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Troublesome handling of dropped connection
Следующее
От: Francisco Reyes
Дата:
Сообщение: Re: Optimize for insertions?