> 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