Thread: Explain XML patch submitted
I just posted a patch addressing the TODO item: "Allow EXPLAIN output to be more easily processed by scripts, perhaps XML" This is a modified patch originally submitted by Germán Poó Caamaño last year. I added the DTD and some other tweaks. I did *not* delve much into the ecpg code, other than mildly modifying prepoc.y by adding the XML and DTD defines. I'm sure more work is required there. And, I did not include "Init Plan" and "Sub Plan" in the XML output, which did not fit into the XML in a graceful way. But, that can also be revisited. Regards, Tom Raney
Bruce Momjian wrote: > Where are we on this patch? > I think I submitted the patch before its time. The project opened a big can of worms with the XML output. I'd like to rework it with some of the comments I received. The work there was some prep-work for the planner visualizer I've been working on. I haven't had time to revisit this initial work. -Tom Raney > --------------------------------------------------------------------------- > > raneyt@cecs.pdx.edu wrote: > >> I just posted a patch addressing the TODO item: >> >> "Allow EXPLAIN output to be more easily processed by scripts, perhaps XML" >> >> This is a modified patch originally submitted by Germ?n Po? Caama?o >> last year. I added the DTD and some other tweaks. >> >> I did *not* delve much into the ecpg code, other than mildly modifying >> prepoc.y by adding the XML and DTD defines. I'm sure more work is >> required there. >> >> And, I did not include "Init Plan" and "Sub Plan" in the XML output, >> which did not fit into the XML in a graceful way. But, that can also >> be revisited. >> >> Regards, >> >> Tom Raney >> >> -- >> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-hackers >> > >
Where are we on this patch? --------------------------------------------------------------------------- raneyt@cecs.pdx.edu wrote: > I just posted a patch addressing the TODO item: > > "Allow EXPLAIN output to be more easily processed by scripts, perhaps XML" > > This is a modified patch originally submitted by Germ?n Po? Caama?o > last year. I added the DTD and some other tweaks. > > I did *not* delve much into the ecpg code, other than mildly modifying > prepoc.y by adding the XML and DTD defines. I'm sure more work is > required there. > > And, I did not include "Init Plan" and "Sub Plan" in the XML output, > which did not fit into the XML in a graceful way. But, that can also > be revisited. > > Regards, > > Tom Raney > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +