On Mar 7, 2011, at 4:41 PM, Tom Lane wrote: > "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> +
Oh, just new values for the Node-Type and Operation elements. That's okay, then. I thought it was a new <ModifyTable> element. Great, nothing for me to change. And thanks for sending this to me, much appreciated. Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers