From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
Cc: | pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: ModifyTable EXPLAIN Node |
Date: | 2011-03-08 00:41:10 |
Message-ID: | 18885.1299544870@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"David E. Wheeler" <david(at)kineticode(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David E. Wheeler | 2011-03-08 00:44:37 | Re: ModifyTable EXPLAIN Node |
Previous Message | Jaime Casanova | 2011-03-08 00:20:27 | Re: pgsql: Basic Recovery Control functions for use in Hot Standby. Pause, |