how to find the time taken by an query/stored procedure?
In psql, use \timing for an approximate time.
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 ?
Explain analyze is NOT supported in PostgreSQL 7.1. You really should upgrade your PostgreSQL to version 8.0.
Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings