From: David Fetter <david@fetter.org>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Re: New EXPLAIN option: ALL
Date: Wed, 19 Jun 2019 16:53:41 +0200
Message-ID: <20190619145340.GB29683@fetter.org> (raw)
In-Reply-To: <03D4D016-D2C4-43F6-AB5F-5C2D472A9823@yesql.se>
References: <20190515170529.GA18938@alvherre.pgsql>
<11598.1557942806@sss.pgh.pa.us>
<20190515175806.qciblz6rhi4rzu6y@alap3.anarazel.de>
<55c4eff5-23d7-3eeb-a4a4-7d6c8753bf5d@2ndquadrant.com>
<20190618211524.GA29683@fetter.org>
<c72976c8-53cb-0038-59a2-3709edf6b2ec@2ndquadrant.com>
<03D4D016-D2C4-43F6-AB5F-5C2D472A9823@yesql.se>
On Wed, Jun 19, 2019 at 02:08:21PM +0200, Daniel Gustafsson wrote:
> > On 19 Jun 2019, at 08:15, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote:
> >
> > On 2019-06-18 23:15, David Fetter wrote:
> >> Are you proposing something along the lines of this?
> >>
> >> PROFILE [statement]; /* Shows the plan */
> >> PROFILE RUN [statement]; /* Actually executes the query */
> >
> > No, it would be
> >
> > EXPLAIN statement; /* Shows the plan */
> > PROFILE statement; /* Actually executes the query */
>
> That makes a lot of sense.
>
> cheers ./daniel
+1
Thanks for clarifying.
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
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, daniel@yesql.se, peter.eisentraut@2ndquadrant.com, andres@anarazel.de, tgl@sss.pgh.pa.us, alvherre@2ndquadrant.com, sfrost@snowman.net
Subject: Re: New EXPLAIN option: ALL
In-Reply-To: <20190619145340.GB29683@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