> 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