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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match