Re: Rationalizing EXPLAIN VERBOSE output - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Rationalizing EXPLAIN VERBOSE output
Date
Msg-id 200203110519.g2B5J4S27235@candle.pha.pa.us
Whole thread Raw
In response to Re: Rationalizing EXPLAIN VERBOSE output  (Thomas Lockhart <thomas@fourpalms.org>)
List pgsql-hackers
Thomas Lockhart wrote:
> ...
> > > >     EXPLAIN VERBOSE select * from pg_class;
> > > >     EXPLAIN LEVEL 1 select * from pg_class;
> > > >     EXPLAIN LEVEL 5 select * from pg_class;
> 
> How about leaving off "LEVEL" and just allow a numeric argument after
> VERBOSE? It does not give shift/reduce troubles. And I'm not sure that
> "level" makes it clearer (level of what?). So it would be
> 
>   EXPLAIN VERBOSE select ...
>   EXPLAIN VERBOSE 5 select ...

Yes, this was my initial proposal but Tom didn't like it.  Seemed very
clear to me.  Tom wants EXPLAIN VERBOSE VERBOSE.

--  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
 


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Rationalizing EXPLAIN VERBOSE output
Next
From: Gavin Sherry
Date:
Subject: Re: Rationalizing EXPLAIN VERBOSE output