help on explain analyse in psql 7.1.3 (linux)

От: S.Thanga Prakash
Тема: help on explain analyse in psql 7.1.3 (linux)
Дата: ,
Msg-id: 1148.192.168.13.108.1112858466.squirrel@192.168.13.108
(см: обсуждение, исходный текст)
Ответы: Re: help on explain analyse in psql 7.1.3 (linux)  (Christopher Kings-Lynne)
Список: pgsql-performance

Скрыть дерево обсуждения

help on explain analyse in psql 7.1.3 (linux)  ("S.Thanga Prakash", )
 Re: help on explain analyse in psql 7.1.3 (linux)  (Christopher Kings-Lynne, )
  Re: help on explain analyse in psql 7.1.3 (linux)  ("S.Thanga Prakash", )
  Re: help on explain analyse in psql 7.1.3 (linux)  (Tom Lane, )
  Re: help on explain analyse in psql 7.1.3 (linux)  ("Greg Sabino Mullane", )

hi,

        I am using psql 7.1.3

I didn't find option analyse in explain command..

how to get time taken by SQL procedure/query?

regards,
stp..


В списке 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)