Explain XML patch submitted

Started by Nonameover 17 years ago3 messages
#1Noname
raneyt@cecs.pdx.edu

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Noname (#1)
Re: Explain XML patch submitted

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. +

#3Tom Raney
raneyt@cecs.pdx.edu
In reply to: Bruce Momjian (#2)
Re: Explain XML patch submitted

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

Show quoted text

---------------------------------------------------------------------------

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