From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Greg Stark <gsstark(at)mit(dot)edu> |
Subject: | Re: machine-readable explain output |
Date: | 2009-06-17 14:27:25 |
Message-ID: | 200906171727.25815.peter_e@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tuesday 16 June 2009 16:22:27 Robert Haas wrote:
> 1. It didn't seem very wise to go with the approach of trying to do
> EVERYTHING with attributes. If I did that, then I'd either get really
> long lines that were not easily readable, or I'd have to write some
> kind of complicated line wrapping code (which didn't seem to make a
> lot of sense for a machine-readable format). The current format isn't
> the most beautiful thing I've ever seen, but you don't need a parser
> to make sense of it, just a bit of patience.
There are obviously a lot of ways to go about defining an XML format, but here
is another one of them:
A plan is a tree of plan nodes. Each node has some information attached to
it, such as row counts and costs.
If you consider an XML document to be a tree of element nodes, then this falls
into place naturally. Each plan is an element, and all the other information
are attributes.
With this, visual explain would be completely trivial.
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2009-06-17 14:30:43 | Re: machine-readable explain output |
Previous Message | Tom Lane | 2009-06-17 14:15:04 | Re: GRANT ON ALL IN schema |