[PERFORM] Is Indexed View Supported in psql 7.1.3??

hi, I like to know whether Indexed View supported in psql 7.1.3.? Is there any performance analysis tool for psql.? Please! update me for the same. regards, stp. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an

[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)

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

[PERFORM] help on time calculation

hi, how to find the time taken by an query/stored procedure? I am using psql 7.1.3 in linux 7.2 how to execute 'explain analyse' in the psql? Is it supported at 7.1.3 ? looking forward for replies.. regards, stp. ---(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