Plan targetlists in EXPLAIN output

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Plan targetlists in EXPLAIN output
Дата
Msg-id 21294.1208450071@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: Plan targetlists in EXPLAIN output  (Gregory Stark <stark@enterprisedb.com>)
Re: Plan targetlists in EXPLAIN output  (Simon Riggs <simon@2ndquadrant.com>)
Re: Plan targetlists in EXPLAIN output  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-hackers
For debugging the planner work I'm about to do, I'm expecting it will be
useful to be able to get EXPLAIN to print the targetlist of each plan
node, not just the quals (conditions) as it's historically done.  My
first instinct is just to stick in the code under a debugging #ifdef,
but I wonder if anyone wants to argue for making it more easily
available?

I think it'd be a mistake to turn it on by default, because it'd add a
line for every plan node, which'd be an awful lot of bloat in output
that's hard enough to read already.  And experience has shown that
99.99% of the time people don't need the info.  Still, there's that
other 0.01%.

I'm tempted to propose redefining the currently-nearly-useless
EXPLAIN VERBOSE option as doing this.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Brendan Jurd"
Дата:
Сообщение: Multiline privileges in \z
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: get rid of psql welcome message