Christopher Kings-Lynne <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to