Re: Change in CTE treatment in query plans?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Change in CTE treatment in query plans?
Дата
Msg-id 19441.1571303072@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Change in CTE treatment in query plans?  (David Conlin <dc345@cantab.net>)
Ответы Re: Change in CTE treatment in query plans?
Список pgsql-performance
David Conlin <dc345@cantab.net> writes:
> Does anyone know if there's been a change in the way values for CTEs are 
> displayed in query plans?

Offhand I don't recall any such changes, nor does a cursory look
through explain.c find anything promising.

If you're concerned with a multiply-referenced CTE, one possibility
for funny results is that the blame for its execution cost could be
spread across the multiple call sites.  The same can happen with
initplans/subplans.  But I'm just guessing; you didn't show any
concrete examples so it's hard to be definite.

            regards, tom lane



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

Предыдущее
От: dangal
Дата:
Сообщение: Re: pg_stat_bgwriter
Следующее
От: Michael Lewis
Дата:
Сообщение: Reading explain plans- row estimates/actuals on lower nodes vs nextlevel up