pgsql: Include the target table in EXPLAIN output for ModifyTable nodes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Include the target table in EXPLAIN output for ModifyTable nodes
Date: 2011-03-01 16:37:15
Message-ID: E1PuSZX-0006Ks-Oa@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Include the target table in EXPLAIN output for ModifyTable nodes.

Per discussion, this seems important for plans involving writable CTEs,
since there can now be more than one ModifyTable node in the plan.

To retain the same formatting as for target tables of scan nodes, we
show only one target table, which will be the parent table in case of
an UPDATE or DELETE on an inheritance tree. Individual child tables
can be determined by inspecting the child plan trees if needed.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/97c4ee94adf15f7a0a39cbb5549159e2aa0679d1

Modified Files
--------------
src/backend/commands/explain.c | 37 ++++++++++++++++++++++++++++++++++---
1 files changed, 34 insertions(+), 3 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2011-03-01 16:46:17 pgsql: Dump the COLLATABLE attribute in CREATE TYPE
Previous Message Robert Haas 2011-03-01 16:34:30 pgsql: Avoid excessive Hot Standby feedback messages.