Re: [PERFORM] Slow query: Postgres chooses nested loop over hash join, whery by hash join is much faster, wrong number of rows estimated

On Thu, Jun 11, 2015 at 7:18 PM, Sasa Vilic wrote: > Hi, > > I have a query that takes ridiculously long to complete (over 500ms) but if > I disable nested loop it does it really fast (24.5ms) > > Here are links for > * first request (everything enabled): http://explain.depesz.com/s/Q1M > * second

[PERFORM] Slow query: Postgres chooses nested loop over hash join, whery by hash join is much faster, wrong number of rows estimated

Hi, I have a query that takes ridiculously long to complete (over 500ms) but if I disable nested loop it does it really fast (24.5ms) Here are links for * first request (everything enabled): http://explain.depesz.com/s/Q1M * second request (nested loop disabled): http://explain.depesz.com/s/9Z