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
Re: Plan targetlists in EXPLAIN output Re: Plan targetlists in EXPLAIN output |
Список | 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 по дате отправления: