Re: help on explain analyse - Mailing list pgsql-performance

From John A Meinel
Subject Re: help on explain analyse
Date
Msg-id 425A03CF.8000604@arbash-meinel.com
Whole thread Raw
In response to help on explain analyse  ("S.Thanga Prakash" <thanga@midascomm.com>)
List pgsql-performance
S.Thanga Prakash wrote:

>hi,
>
>    I am using psql 7.1.3
>
>I didn't find option analyse in explain command..
>
>how to get time taken by SQL procedure/query?
>
>regards,
>stp..
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>
I don't believe it was added until 7.2. It is highly recommended that
you upgrade. Performance and stability have both been improved
tremendously between 7.1 and 8.0.

John
=:->


Attachment

pgsql-performance by date:

Previous
From: "anon permutation"
Date:
Subject: 8.0.1 much slower than 7.4.2?
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Is Indexed View Supported in psql 7.1.3??