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

From Bruce Momjian
Subject Re: Rationalizing EXPLAIN VERBOSE output
Date
Msg-id 200203111426.g2BEQUD00271@candle.pha.pa.us
Whole thread Raw
In response to Rationalizing EXPLAIN VERBOSE output  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Rationalizing EXPLAIN VERBOSE output  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Thomas Lockhart wrote:
> > >> I'm not partial to the duplicated keyword. Really.
> > Okay, okay, I concede.  "EXPLAIN VERBOSE n stmt" it is.
> 
> Another possibility is to implement
> 
>   SET VERBOSITY = n;
> 
> Why not do that and not bother extending/polluting the EXPLAIN syntax?

Unless you have another use for VERBOSITY, it seems like a waste.   I
don't see a value in moving control away from the EXPLAIN command
itself.  I realize it would be used as a default for all EXPLAIN
commands, but the level is just a single-digit number.

--  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: "Luis Alberto Amigo Navarro"
Date:
Subject: need help on tuning tpch
Next
From: Thomas Lockhart
Date:
Subject: Re: Rationalizing EXPLAIN VERBOSE output