Re: EXPLAIN omits schema? - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: EXPLAIN omits schema?
Date
Msg-id dadb94ac7ba07d56b798458bd35e2774@biglumber.com
Whole thread Raw
In response to Re: EXPLAIN omits schema?  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> And you stick them in a well-defined XML format (or another
> format if you happen to hate XML) where the client-side program can easily
> parse out whatever it needs. It's also future-proof - if you add a new
> field somewhere, the client program parser won't break.
>
> Something worth doing? Not to replace the current explain output, but as a
> second option (EXPLAIN XML whatever)?

This reminded me of a quick function I wrote up for my PGCon talk last month. 
I've posted it on the blog:

http://people.planetpostgresql.org/greg/index.php?/archives/106-Putting-EXPLAIN-results-into-a-table.html

I'd rather see tables with a convert-to-XML function than direct XML FWIW.

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200706131211
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFGcBdnvJuQZxSWSsgRA/irAJsH0ZT3wLNN4mLirsTryiK1m9gyHwCg6+9A
0MuJqGxJ9gkEIWVUeq4iXag=
=NeB/
-----END PGP SIGNATURE-----




pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: EXPLAIN omits schema?
Next
From: "Josh Tolley"
Date:
Subject: \d omits schema on inherited tables (Was: EXPLAIN omits schema?)