help on time calculation

From: S.Thanga Prakash
Subject: help on time calculation
Date: ,
Msg-id: 1168.
(view: Whole thread, Raw)
Responses: Re: help on time calculation  (Christopher Kings-Lynne)
List: pgsql-performance


   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..

pgsql-performance by date:

From: Harald Fuchs
Subject: Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?)
From: Bruno Wolff III
Subject: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)