Skip site navigation (1) Skip section navigation (2)

pgsql: Include the target table in EXPLAIN output for ModifyTablenodes

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 ModifyTablenodes
Date: 2011-03-01 16:37:15
Message-ID: E1PuSZX-0006Ks-Oa@gemulon.postgresql.org (view raw or flat)
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(-)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group