Re: Bad Estimate for complex query with JOINS on subselects and OR in where conditions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bad Estimate for complex query with JOINS on subselects and OR in where conditions
Дата
Msg-id 9725.1565963088@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Bad Estimate for complex query with JOINS on subselects and OR in where conditions  (Peter Grman <peter.grman@gmail.com>)
Ответы Re: Bad Estimate for complex query with JOINS on subselects and OR inwhere conditions
Список pgsql-general
Peter Grman <peter.grman@gmail.com> writes:
> our ORM with tenant separation enabled is creating the following query:

Ugh.

By my count there are nine joined tables in that query, which means
you're hitting the default join_collapse_limit.  Increasing that
setting might improve matters somewhat, though it won't fix the
bad rowcount estimate per se.

            regards, tom lane



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