Thread: help on explain analyse

help on explain analyse

From
"S.Thanga Prakash"
Date:
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..


Re: help on explain analyse

From
John A Meinel
Date:
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