Re: EXPLAIN omits schema?

From: Lukas Kahwe Smith <smith(at)pooteeweet(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: EXPLAIN omits schema?
Date: 2007-06-13 15:19:29
Message-ID: 46700B01.6020908@pooteeweet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-06-13 15:43:06 Re: EXPLAIN omits schema?
Previous Message Joshua D. Drake 2007-06-13 15:07:44 Re: [HACKERS] Avoiding legal email signatures