Обсуждение: help on time calculation

От:
"S.Thanga Prakash"
Дата:

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.

От:
Christopher Kings-Lynne
Дата:

>    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