Tom Lane wrote:
> Now there is a third set of desires having to do with being able to do
> simple SQL-based analysis of EXPLAIN output. That's the piece I think
> we don't have a good handle on. In particular, it's not clear whether
> a SQL-friendly output format can be the same as either of the other
> two. (I don't personally find this goal very compelling --- there is
> no natural law saying that SQL is a good tool for analyzing EXPLAIN
> output --- but I'm willing to look at it to see if it's feasible.)
>
>
>
In libxml-enabled builds at least, this could presumably be done fairly
easily via the XML functions, especially if we get XSLT processing into
the core XML functionality as I hope we can do this release. In fact,
the ability to leverage existing XML functionality to munge the output
is the thing that swings me in favor of XML as the machine readable
output format instead of JSON, since we don't have and aren't terribly
likely to get an inbuilt JSON parser. It means we wouldn't need some
external tool at all.
cheers
andrew
