Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kg8mE-0001j4-0x for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Nov 2020 15:56:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kg8mD-0000Kk-0N for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Nov 2020 15:56:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kg8mC-0000He-Pe for pgsql-hackers@lists.postgresql.org; Fri, 20 Nov 2020 15:56:44 +0000 Received: from forward4-smtp.messagingengine.com ([66.111.4.238]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kg8m9-0008P9-Um for pgsql-hackers@postgresql.org; Fri, 20 Nov 2020 15:56:43 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailforward.nyi.internal (Postfix) with ESMTP id 244DE1940E6A; Fri, 20 Nov 2020 10:56:41 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Fri, 20 Nov 2020 10:56:41 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=s+/ZGKEJZZG/N3YMz8cDf7KRXtMgbwMVpQ9NPoeGl uw=; b=NSGagSRU/MrbBJs6Kcu4Lds5rZCbxSoy1tY7GzXaE3mlaR1iOku1NGDEn JwtNtZHWpeA5AzwJz8Q7EJBBQRbxMxC+WZjWTyCeaDTRfSbDGLN13Ru2nAvAVm8j MWbteOLAicm65aAqMWn92rqgbmCApV89yvokBvaX27zLdld1YFGoIB+jzuedpOgS 6DlI2lJgXAQlTmYsQ6GUxfY/NOFV2npaaddw+hyTFXI7hM3bDaHx+G2eJTbL5jcx Bur8dllEOjbci2Ww+APLJhUtaTTF3xhXlSPgkoaLKJPPDg4XHVy2XUKKhIfJiq9z buaGJNC4WU67evqeCRx0psnZXeoHQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrudegtddgkedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtjeertddtfeehnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvghnth gvrhhprhhishgvuggsrdgtohhmqeenucggtffrrghtthgvrhhnpeehvdfhjeelieeuvedt veeigfffffeiudevteeugeetgeejgedtueetkeevudefgeenucffohhmrghinhepphhosh htghhrvghsqhhlrdhorhhgnecukfhppeekjedrudejjedrjeehrdelgeenucevlhhushht vghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrrdgvihhsvg hnthhrrghuthesvghnthgvrhhprhhishgvuggsrdgtohhm X-ME-Proxy: Received: from april.pezone.net (p57b14b5e.dip0.t-ipconnect.de [87.177.75.94]) by mail.messagingengine.com (Postfix) with ESMTPA id 18B1E3064AB2; Fri, 20 Nov 2020 10:56:38 -0500 (EST) Subject: Re: jit and explain nontext To: Justin Pryzby , David Rowley References: <20201014193859.GS9241@telsasoft.com> <3643530.1602724513@sss.pgh.pa.us> <20201015014326.GU9241@telsasoft.com> <20201017192134.GD9241@telsasoft.com> Cc: Tom Lane , pgsql-hackers@postgresql.org, Andres Freund From: Peter Eisentraut Organization: EnterpriseDB Message-ID: Date: Fri, 20 Nov 2020 16:56:38 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <20201017192134.GD9241@telsasoft.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-10-17 21:21, Justin Pryzby wrote: > Added at:https://commitfest.postgresql.org/30/2766/ > > diff --git a/src/backend/commands/explain.c b/src/backend/commands/explain.c > index 41317f1837..7345971507 100644 > --- a/src/backend/commands/explain.c > +++ b/src/backend/commands/explain.c > @@ -839,7 +839,8 @@ ExplainPrintJIT(ExplainState *es, int jit_flags, JitInstrumentation *ji) > instr_time total_time; > > /* don't print information if no JITing happened */ > - if (!ji || ji->created_functions == 0) > + if (!ji || (ji->created_functions == 0 && > + es->format == EXPLAIN_FORMAT_TEXT)) > return; > > /* calculate total time */ Can you show an output example of where this patch makes a difference? Just from reading the description, I would expect some kind of additional JIT-related output from something like EXPLAIN (FORMAT YAML) SELECT 1; but I don't see anything.