jian xu <jamesxu@outlook.com> writes:
> Thanks Tom, except for setting parameters, is there any other ways to show debug information about plan generating?
Forexample, can pg show all the candidate plans it searched, and the cost of each candidate plan?
No, because rejected alternatives are not carried through to the point
of having a displayable plan. (Trying to do so would be enormously
expensive.) People have experimented with adding trace facilities
that would show some details about rejected plan alternatives, but
none of that has led to a facility that I'd care to use.
regards, tom lane