How can I show more potential query plans, other than the default one?

Поиск
Список
Период
Сортировка
От Yangyang
Тема How can I show more potential query plans, other than the default one?
Дата
Msg-id CAN3Hncy1X9Zm4gJjGPc4ApYQe0Qs_pjZe=vw0V_J=rMa-cLF1g@mail.gmail.com
обсуждение исходный текст
Ответы Re: How can I show more potential query plans, other than the default one?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi,
I want to see more query plans, other than the default one for a query
and compare their cost. Based on this, I can change the cost model and
see how that can affect the cost model?
I enabled the debug information in postgresql.conf. But it looks like
the output is still for the best plan only. Is there any way to see
them, before I go to the code and implement sth myself?
Thanks very much.
-Yangyang

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

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: How to truncate? integers
Следующее
От: "Kai Otto"
Дата:
Сообщение: UTF8 problem