On 12/29/21 5:07 AM, Chris Cleveland wrote:
> I'm developing a new index access method. Sometimes the planner uses it
> and sometimes it doesn't. I'm trying to debug the process to understand
> why the index does or doesn't get picked up.
>
> Is there a way to dump all of the query plans that the planner
> considered, along with information on why they were rejected? EXPLAIN
> only gives info on the plan that was actually selected.
You can enable OPTIMIZER_DEBUG option. Also the gdbpg code [1] makes our
work much easier, sometimes.
[1] https://github.com/tvondra/gdbpg
--
regards,
Andrey Lepikhov
Postgres Professional