Re: EXPLAIN WITH

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> This isn't terribly compelling in this example, of course, but
> it gets a lot more important when you've got a dozen of 'em.

Exactly.

> >From the perspective of the backend this is a simple and cheap change.

Awesome.

> I think the objection that is most likely to be raised is that it would
> confuse or break programs that analyze EXPLAIN output in any degree of
> detail. Of course such programs are going to need some work for 8.4
> already.

I definitely feel that it would be best to make this change now, when
we're introducing CTE as a type that anything doing EXPLAIN would need
to deal with at some level anyway than to add it later (eg: 8.5). I'm
definitely a +1 on this.

Thanks!

Stephen