Re: Planner ignoring to use INDEX SCAN

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Planner ignoring to use INDEX SCAN
Дата
Msg-id 87d4t94d4z.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: Planner ignoring to use INDEX SCAN  (Ashish Karalkar <ashish_postgre@yahoo.co.in>)
Список pgsql-general
"Ashish Karalkar" <ashish_postgre@yahoo.co.in> writes:

> Thanks Richard for your replay,
>
> Richard Huxton <dev@archonet.com> wrote:
>>
> Actually, this is the output from EXPLAIN not EXPLAIN ANALYSE. It
> doesn't show what actually happened, just what the planner thought was
> going to happen.
>
> Its from EXPLAIN ANALYSE

No, it's not. Not unless you've removed all the added info explain analyse
adds to the explain output.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's PostGIS support!

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: rewrite pl/pgsql functions to c - remote job
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: rewrite pl/pgsql functions to c - remote job