Re: EXPLAIN omits schema? - Mailing list pgsql-hackers

From Lukas Kahwe Smith
Subject Re: EXPLAIN omits schema?
Date
Msg-id 46700B01.6020908@pooteeweet.org
Whole thread Raw
In response to Re: EXPLAIN omits schema?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

> I agree with the idea of having an option to get EXPLAIN's output in
> an entirely different, more machine-readable format.  Not wedded to
> XML, but I fear that a pure relational structure might be too strict ---
> there's a lot of variability in the entries already.  XML also could
> deal naturally with nesting, whereas we'd have to jump through hoops
> to represent the plan tree structure in relational form.

Which was my point regarding needing WITH RECURSIVE to make this truely 
useful.

XML output is nice, but only as an addition imho. Then again it would 
indeed be quite useful for external development tools.

regards,
Lukas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Tom Lane's presentation on SERIALIZABLE etc?
Next
From: Aidan Van Dyk
Date:
Subject: Re: EXPLAIN omits schema?