"David E. Wheeler" <da...@kineticode.com> writes:
> I saw that Tom added the ModifyTable node to EXPLAIN output last week. I'd
> like to update my explanation extension to use it, but I've no idea what it
> would look like. Could someone send me an example in the XML format?
It's already there in 9.0 --- I just added the relation-name property.
But since you ask:
regression=# explain (format xml) update int8_tbl set q1 = q1+1;
QUERY PLAN
-------------------------------------------------------------
<explain xmlns="http://www.postgresql.org/2009/explain";> +
<Query> +
<Plan> +
<Node-Type>ModifyTable</Node-Type> +
<Operation>Update</Operation> +
<Relation-Name>int8_tbl</Relation-Name> +
<Alias>int8_tbl</Alias> +
<Startup-Cost>0.00</Startup-Cost> +
<Total-Cost>1.06</Total-Cost> +
<Plan-Rows>5</Plan-Rows> +
<Plan-Width>22</Plan-Width> +
<Plans> +
<Plan> +
<Node-Type>Seq Scan</Node-Type> +
<Parent-Relationship>Member</Parent-Relationship>+
<Relation-Name>int8_tbl</Relation-Name> +
<Alias>int8_tbl</Alias> +
<Startup-Cost>0.00</Startup-Cost> +
<Total-Cost>1.06</Total-Cost> +
<Plan-Rows>5</Plan-Rows> +
<Plan-Width>22</Plan-Width> +
</Plan> +
</Plans> +
</Plan> +
</Query> +
</explain>
(1 row)
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
