Postgres Pro
Downloads
Home   >   mailing lists

Re: help on explain analyse in psql 7.1.3 (linux) - Mailing list pgsql-performance

From Tom Lane
Subject Re: help on explain analyse in psql 7.1.3 (linux)
Date
Msg-id 3144.1112888595@sss.pgh.pa.us
Whole thread Raw
In response to Re: help on explain analyse in psql 7.1.3 (linux)  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: How to improve db performance with $7K?
Next
From: Alex Turner
Date:
Subject: Re: How to improve db performance with $7K?