Re: [PERFORM] help on explain analyse
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 =:- signature.asc Description: OpenPGP digital signature
Re: [PERFORM] help on explain analyse in psql 7.1.3 (linux)
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... Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PERFORM] help on explain analyse in psql 7.1.3 (linux)
hi, thanks for immediate response.. regards, stp.. On Thu, 7 Apr 2005, Christopher Kings-Lynne wrote: 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... Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [PERFORM] help on explain analyse in psql 7.1.3 (linux)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Christopher Kings-Lynne wrote: Explain analyze was added in 7.2 - you really need to upgrade... You can use \timing in psql to get an approximation... Actually, \timing was not added until 7.2 either! So, the original poster really, really needs to upgrade... :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200504072129 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCVd69vJuQZxSWSsgRAvRHAJ9T1uxfWEnHSNI/+iiiHiJ2I1IGUgCggMYb tjDwzfseK3aDAKHI5Ko1S/Q= =AvKY -END PGP SIGNATURE- ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster