Re: Query optimization advice for beginners

Subject: Re: Query optimization advice for beginners Am 27.01.20 um 14:15 schrieb Kemal Ortanca: > > https://explain.depesz.com/s/G4vq > > the estimates and the real values are very different, seems like problems with autoanalyze. which version? Andreas -- 2ndQuadrant - The Postgr

Query optimization advice for beginners

) > 0 group by 1,2,3 --,bid.pallet_item_quantity having coalesce(s.is_pick, false) and round((coalesce(sum(sb.quantity), 0) / GREATEST(MAX(bid.pallet_item_quantity), 1)::float)::numeric, 2) <= 0.15 https://explain.depesz.com/s/G4vq Yours truly, Kemal Ortanca