Re: how to troubleshoot a wrong query plan - Mailing list pgsql-admin

jian xu <jamesxu@outlook.com> writes:
> Sorry, we figured out that the PostgreSQL.conf has the nestloop disabled….that’s why It picked merge join by default
> But it might be still very helpful if there is a way to show how the plan is generated , or some debug information
aboutthe plan generating, for example in this case, if we can debug the plan and see nestloop is disable, it will be
easyfor us figure out the problem. 

In supported releases of PG, there's the EXPLAIN (SETTINGS) option, which
will print the values of any non-default settings that affect planning.
Of course, you have to remember to use that, but it does respond to
your point.

            regards, tom lane