Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hdbyA-0002ZU-4M for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Jun 2019 14:53:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hdby6-0005Q3-Th for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Jun 2019 14:53:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hdby6-0005Pw-Hl for pgsql-hackers@lists.postgresql.org; Wed, 19 Jun 2019 14:53:46 +0000 Received: from xvm-110-146.dc2.ghst.net ([46.226.110.146] helo=fetter.org) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hdby3-00045j-Jw for pgsql-hackers@postgresql.org; Wed, 19 Jun 2019 14:53:44 +0000 Received: by fetter.org (Postfix, from userid 1001) id BF50E40903; Wed, 19 Jun 2019 16:53:41 +0200 (CEST) Date: Wed, 19 Jun 2019 16:53:41 +0200 From: David Fetter To: Daniel Gustafsson Cc: Peter Eisentraut , Andres Freund , Tom Lane , Alvaro Herrera , Stephen Frost , PostgreSQL Development Subject: Re: New EXPLAIN option: ALL Message-ID: <20190619145340.GB29683@fetter.org> 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> <03D4D016-D2C4-43F6-AB5F-5C2D472A9823@yesql.se> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <03D4D016-D2C4-43F6-AB5F-5C2D472A9823@yesql.se> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, Jun 19, 2019 at 02:08:21PM +0200, Daniel Gustafsson wrote: > > On 19 Jun 2019, at 08:15, Peter Eisentraut 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 http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate