Jim C. Nasby wrote:
On Wed, Apr 12, 2006 at 04:53:20PM +0200, Thomas Hallgren wrote:<NestedLoop cost="1.06..40.43" rows="5" width="244"> <JoinFilter publicTenk1Unique2="int4_tbl.f1"> <HashAggregate cost="1.06..1.11" rows="5" width="4"/> </JoinFilter> </NestedLoop>Well, the downside is that such a format means explain output is now twice as long. But I'd love to see something like that as an option. I'd also still like to see an SQL-parseable version as well, since I think there's applications for that.
On the plus side, a complex xml document is an easy read in a browser (IE or Firefox, either way). Hard to picture the representation in relational tables, though ... did you have some specific idea for what to do with a plan in SQL,
once it was parsed? -- Engineers think that equations approximate reality. Physicists think that reality approximates the equations. Mathematicians never make the connection. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
