pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: David Fetter <david@fetter.org>
To: Rafia Sabih <rafia.pghackers@gmail.com>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Re: New EXPLAIN option: ALL
Date: Tue, 7 May 2019 18:31:29 +0200
Message-ID: <20190507163128.GL28936@fetter.org> (raw)
In-Reply-To: <CA+FpmFdpccvdmNmzjDRrX4EMrQVOw3_v1-mSXjM6+4Opf7SaEA@mail.gmail.com>
References: <20190507073046.GI28936@fetter.org>
	<CA+FpmFdpccvdmNmzjDRrX4EMrQVOw3_v1-mSXjM6+4Opf7SaEA@mail.gmail.com>

On Tue, May 07, 2019 at 11:03:23AM +0200, Rafia Sabih wrote:
> On Tue, 7 May 2019 at 09:30, David Fetter <david@fetter.org> 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 don't understand this, do you mind explaining a bit may be with an
> example on how you want it to work.

If you're tuning a query interactively, it's a lot simpler to prepend,
for example,

    EXPLAIN (ALL, FORMAT JSON)

to it than to prepend something along the lines of

    EXPLAIN(ANALYZE, VERBOSE, COSTS, BUFFERS, SETTINGS, TIMING, SUMMARY, PARTRIDGE_IN_A_PEAR_TREE, FORMAT JSON)

to it.

Best,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate





view thread (49+ messages)  latest in thread

Message-ID: <20190507163128.GL28936@fetter.org>
Permalink:  ../20190507163128.GL28936@fetter.org/
Also on:    postgresql.org/message-id/20190507163128.GL28936@fetter.org

 · 

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: david@fetter.org, rafia.pghackers@gmail.com
  Subject: Re: New EXPLAIN option: ALL
  In-Reply-To: <20190507163128.GL28936@fetter.org>

* 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