Re: EXPLAIN omits schema?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: EXPLAIN omits schema?
Дата
Msg-id 9635.1181744222@sss.pgh.pa.us
обсуждение исходный текст
Ответ на EXPLAIN omits schema?  (Dave Page <dpage@postgresql.org>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Tom Lane's presentation on SERIALIZABLE etc?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: EXPLAIN omits schema?