help on time calculation

От: S.Thanga Prakash
Тема: help on time calculation
Дата: ,
Msg-id: 1168.
(см: обсуждение, исходный текст)
Ответы: Re: help on time calculation  (Christopher Kings-Lynne)
Список: 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 по дате сообщения:

От: Harald Fuchs
Сообщение: Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?)
От: Bruno Wolff III
Сообщение: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)