Thread: help on explain analyse in psql 7.1.3 (linux)
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..
> 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
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 majordomo@postgresql.org) >
Christopher Kings-Lynne <chriskl@familyhealth.com.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
-----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 greg@turnstep.com PGP Key: 0x14964AC8 200504072129 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFCVd69vJuQZxSWSsgRAvRHAJ9T1uxfWEnHSNI/+iiiHiJ2I1IGUgCggMYb tjDwzfseK3aDAKHI5Ko1S/Q= =AvKY -----END PGP SIGNATURE-----