[PERFORM] help on time calculation

2005-04-07 Thread 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. ---(end of broadcast)--- TIP

Re: [PERFORM] help on time calculation

2005-04-07 Thread 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