Re: ModifyTable EXPLAIN Node

"David E. Wheeler" <david@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
useit, 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