Le vendredi 22 juillet 2005 à 15:44 +0100, Sam Mason a écrit :
> 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.
Denys (in CC) wrote an XML output for EXPLAIN to be used by any
program in a easy way. In that way, he replaced the current output
of explain. So, I'm working in a patch that extends EXPLAIN and
give the chance to get the output as text (as usual) or xml.
So, you'd be able to run EXPLAIN ANALYZE XML to get the output
in XML, that could be parsed by whatever script/program.
I hope to get a patch in the next days, according to my spare
time.
Regards,
--
Germán Poó Caamaño
http://www.ubiobio.cl/~gpoo/