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 <chriskl@familyhealth.com.au>)
Список pgsql-performance
Christopher Kings-Lynne <chriskl@familyhealth.com.au> 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 по дате отправления:

Предыдущее
От: Richard_D_Levine@raytheon.com
Дата:
Сообщение: Re: How to improve db performance with $7K?
Следующее
От: Alex Turner
Дата:
Сообщение: Re: How to improve db performance with $7K?