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

From: Tom Lane
Subject: Re: help on explain analyse in psql 7.1.3 (linux)
Date: ,
Msg-id: 3144.1112888595@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: help on explain analyse in psql 7.1.3 (linux)  (Christopher Kings-Lynne)
List: pgsql-performance

Tree view

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 by date:

From: "Jim C. Nasby"
Date:
Subject: Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
From: Tom Lane
Date:
Subject: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)