hi,
how to find the time taken by an query/stored procedure?
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 ?
looking forward for replies..
regards,
stp.
> 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