jian xu <jamesxu@xxxxxxxxxxx> 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 about the plan generating, for example in this case, if we can debug the plan and see nestloop is disable, it will be easy for 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
