Re: [HACKERS] EXPLAIN doesn't show sufficient info for wCTE cases

2011-02-28 Thread Robert Haas
On Mon, Feb 28, 2011 at 11:39 AM, Tom Lane t...@sss.pgh.pa.us wrote: EXPLAIN currently shows ModifyTable nodes as just Insert, Update, or Delete, without any indication of the target table.  This was more or less good enough when there could only be one such node per query, but it's looking

Re: [HACKERS] EXPLAIN doesn't show sufficient info for wCTE cases

2011-02-28 Thread David Fetter
On Mon, Feb 28, 2011 at 11:44:06AM -0500, Robert Haas wrote: On Mon, Feb 28, 2011 at 11:39 AM, Tom Lane t...@sss.pgh.pa.us wrote: EXPLAIN currently shows ModifyTable nodes as just Insert, Update, or Delete, without any indication of the target table.  This was more or less good enough when

Re: [HACKERS] EXPLAIN doesn't show sufficient info for wCTE cases

2011-02-28 Thread Tom Lane
David Fetter da...@fetter.org writes: On Mon, Feb 28, 2011 at 11:44:06AM -0500, Robert Haas wrote: I think it's good to include the table name, for sure. I *think* I agree that it isn't necessary to include the child names. Would this affect the use case of breaking up a too-long table into