Re: Get explain output of postgresql in Tables

Greg Sabino Mullane wrote:

>>I wonder if it would help much just to change EXPLAIN to indent with
>>something other than spaces?
>
> I like that. Maybe even decrease the indenting a little more, and compress
> some of the inner whitespace (such as the 2 spaces after the operator name)

Might it be worth checking how many people (and apps) use EXPLAIN output to
drive apps? Our (web) reporting has a paging system for long reports, that
depends on getting the row/cost estimate from "EXPLAIN somequery" before
actually executing "somequery". (Yep, we have pg_autovacuum run ANALYZE a lot :-)

Anybody else out there using explain output in an automated way?

--
Engineers think that equations approximate reality.
Physicists think that reality approximates the equations.
Mathematicians never make the connection.