Re: help on explain analyse in psql 7.1.3 (linux)

От: Tom Lane
Тема: Re: help on explain analyse in psql 7.1.3 (linux)
Дата: ,
Msg-id: 3144.1112888595@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: help on explain analyse in psql 7.1.3 (linux)  (Christopher Kings-Lynne)
Список: pgsql-performance

Скрыть дерево обсуждения

help on explain analyse in psql 7.1.3 (linux)  ("S.Thanga Prakash", )
 Re: help on explain analyse in psql 7.1.3 (linux)  (Christopher Kings-Lynne, )
  Re: help on explain analyse in psql 7.1.3 (linux)  ("S.Thanga Prakash", )
  Re: help on explain analyse in psql 7.1.3 (linux)  (Tom Lane, )
  Re: help on explain analyse in psql 7.1.3 (linux)  ("Greg Sabino Mullane", )

Christopher Kings-Lynne <> writes:
>> I didn't find option analyse in explain command..
>>
>> how to get time taken by SQL procedure/query?

> Explain analyze was added in 7.2 - you really need to upgrade...

> You can use \timing in psql to get an approximation...

7.1 psql hasn't got \timing either ...

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: "Jim C. Nasby"
Дата:
Сообщение: Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
От: Tom Lane
Дата:
Сообщение: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)