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 setti

[PERFORM] help on explain analyse

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

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 nee

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

Christopher Kings-Lynne <[EMAIL PROTECTED]> 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'

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... > > Y

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

[PERFORM] 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.. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate s