Reading explain plans- row estimates/actuals on lower nodes vs nextlevel up

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Reading explain plans- row estimates/actuals on lower nodes vs nextlevel up
Дата
Msg-id CAHOFxGo1UAF45F_fdZML1QKmSjjvN_npLx52yQv7NV6Xk=COJg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Reading explain plans- row estimates/actuals on lower nodes vsnext level up
Список pgsql-performance
https://explain.depesz.com/s/Caa5

I am looking at this explain analyze output and seeing a nested loop towards the lowest levels with pretty bad estimate vs actual (2.3k vs 99k), but the things that feed that nested loop seem like the estimates are rather close (index scans with 11 estimated vs 30 actual and 3350 vs 3320)... why does the higher node have such a different estimate vs actual ratio? 


Michael Lewis  |  Software Engineer
Entrata

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Change in CTE treatment in query plans?
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: pg_stat_bgwriter