Re: Planner choosing nested loop in place of Hashjoin

On Tue, Mar 7, 2023 at 7:14 AM Praneel Devisetty wrote: > Hi, > > I have a query which is taking roughly 10mins to complete and the query > planner is choosing a nested loop. > > query and query plan with analyze,verbose,buffers > qsEn | explain.depesz.com

Re: Planner choosing nested loop in place of Hashjoin

Hi Praneel, It is hard to propose a solution without seeing the actual query and knowing details of the tables. If I were you, I would try to increase statistics target for the columns used in joins. Default value is 100. You need to analyze those tables again after updating the statistics targets

Planner choosing nested loop in place of Hashjoin

Hi, I have a query which is taking roughly 10mins to complete and the query planner is choosing a nested loop. query and query plan with analyze,verbose,buffers qsEn | explain.depesz.com Disabling the nested loop on session is allowing the query planner t