Re: Get explain output of postgresql in Tables

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.