Re: Change in CTE treatment in query plans?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



David Conlin <dc345@xxxxxxxxxx> 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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux