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.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to