Re: Rationalizing EXPLAIN VERBOSE output

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > How about?
> 
> >     EXPLAIN select * from pg_class;
> >     EXPLAIN VERBOSE select * from pg_class;
> >     EXPLAIN VERBOSE 1 select * from pg_class;
> >     EXPLAIN VERBOSE 5 select * from pg_class;
> 
> Seems kinda ugly.  But maybe same idea with repeated VERBOSE,
> a la some Unix commands ("more -v's get you more detail"):
> 
>     EXPLAIN [ANALYZE] [VERBOSE] [ VERBOSE ... ] statement;
> 
> I'd sugggest
> 
> EXPLAIN select * from pg_class;
> 
>     Default output: same as now
> 
> EXPLAIN VERBOSE select * from pg_class;
> 
>     Add prettyprinted qual clauses
> 
> EXPLAIN VERBOSE VERBOSE select * from pg_class;
> 
>     Add full plan-tree dump
> 
> and there's room for expansion if we need it.

I was never a fan of the -v -v more-verbose options, and I don't see any
case where we use such behavior in our code.  We do use detail levels
for debug, and that is fairly common.

How about:

> >     EXPLAIN select * from pg_class;
> >     EXPLAIN VERBOSE select * from pg_class;
> >     EXPLAIN LEVEL 1 select * from pg_class;
> >     EXPLAIN LEVEL 5 select * from pg_class;

Here I use LEVEL to tell how much detail you want.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026