pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Vik Fearing <vik.fearing@2ndquadrant.com>
To: David Fetter <david@fetter.org>
To: PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Re: New EXPLAIN option: ALL
Date: Wed, 8 May 2019 23:22:10 +0200
Message-ID: <eff3ba2d-b92c-60ad-3456-a0902f5d18f7@2ndquadrant.com> (raw)
In-Reply-To: <20190507073046.GI28936@fetter.org>
References: <20190507073046.GI28936@fetter.org>

On 07/05/2019 09:30, David Fetter wrote:
> Folks,
> 
> It can get a little tedious turning on (or off) all the boolean
> options to EXPLAIN, so please find attached a shortcut.

I would rather have a set of gucs such as default_explain_buffers,
default_explain_summary, and default_explain_format.

Of course if you default BUFFERS to on(*) and don't do ANALYZE, that
should not result in an error.

(*) Defaulting BUFFERS to on is something I want regardless of anything
else we do.
-- 
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support





view thread (49+ messages)  latest in thread

Message-ID: <eff3ba2d-b92c-60ad-3456-a0902f5d18f7@2ndquadrant.com>
Permalink:  ../eff3ba2d-b92c-60ad-3456-a0902f5d18f7@2ndquadrant.com/
Also on:    postgresql.org/message-id/eff3ba2d-b92c-60ad-3456-a0902f5d18f7@2ndquadrant.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: vik.fearing@2ndquadrant.com, david@fetter.org
  Subject: Re: New EXPLAIN option: ALL
  In-Reply-To: <eff3ba2d-b92c-60ad-3456-a0902f5d18f7@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox