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

From Tom Lane
Subject Re: EXPLAIN omits schema?
Date
Msg-id 9635.1181744222@sss.pgh.pa.us
Whole thread Raw
In response to EXPLAIN omits schema?  (Dave Page <dpage@postgresql.org>)
Responses Re: EXPLAIN omits schema?  (Dave Page <dpage@postgresql.org>)
Re: EXPLAIN omits schema?  (Andrew Dunstan <andrew@dunslane.net>)
Re: EXPLAIN omits schema?  (Lukas Kahwe Smith <smith@pooteeweet.org>)
Re: EXPLAIN omits schema?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: EXPLAIN omits schema?  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Dave Page <dpage@postgresql.org> writes:
> Looking to fix this, a comment in src/backend/commands/explain.c
> indicates that this is intentional:

Quite.

> Anyone know why?

As already noted, it'd usually be clutter in lines that are too long
already.  Also, conditionally adding a schema name isn't very good
because it makes life even more complicated for programs that are
parsing EXPLAIN output (yes, there are some).

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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Tom Lane's presentation on SERIALIZABLE etc?
Next
From: Magnus Hagander
Date:
Subject: Re: EXPLAIN omits schema?