Dawid Kuroczko wrote:
>Hmm, methinks it wouldn't be a very difficult "beginner's project" in
>PostgreSQL hacking, to add "script-friendly" format for EXPLAIN
>command. I am not sure if I'll make it, but I'm willing to try...
It occured to me that it may be good to create a new datatype for
the results. The data type's default textual format could be the
same as the current output, but you could then provide functions
that operate on these structures to extract the relavent bits in a
format that your extrnal analysis tool can use.
This would require that you can do
SELECT * FROM (EXPLAIN SELECT 1);
though -- I guess that may be quite a big job!
>If I'm jumping on a too big a beast, please tell me. :)
Me thinks I may have just made it a bit more difficult, but probably
(should that be hopefully?) more generally useful.
Sam