Tom Lane wrote:
Greg Stark <st...@enterprisedb.com> writes:
...
I suppose if we had explain-to-a-table then we could run explain and
then run an sql query to verify the specific properties we were
looking for.
A similar thing could be done with xml if we had powerful enough xml
predicates but we have a lot more sql skills in-house than xml.
Yeah, I suspect the only really good answers involve the ability to
apply programmable checks to the EXPLAIN output. A SQL-based solution
shouldn't need any external moving parts, whereas analyzing XML output
presumably would.
If only an explain-to-a-table would be one of the available options
and not the only option that would be great. The big O only has this
option and it totally sux if you want to explain a query on a production
environment where you can't just create tables here and there.
Tino
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
