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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: thanga(at)midascomm(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: help on explain analyse in psql 7.1.3 (linux)
Date: 2005-04-07 15:43:15
Message-ID: 3144.1112888595@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Turner 2005-04-07 15:46:31 Re: How to improve db performance with $7K?
Previous Message Richard_D_Levine 2005-04-07 15:37:33 Re: How to improve db performance with $7K?