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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
