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 [EMAIL PROTECTED])

Reply via email to