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't got \timing either ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq