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

2011-02-28 Thread Tom Lane
David Fetter 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 > partition

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 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

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 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 pretty inad

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

2011-02-28 Thread Tom Lane
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 pretty inadequate to me as I play around with data-modifying statement