Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g21Pd-00024l-KV for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Sep 2018 21:50:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g21PZ-0006Wu-Sd for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Sep 2018 21:50:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g21PZ-0006Wm-Lx for pgsql-hackers@lists.postgresql.org; Mon, 17 Sep 2018 21:50:29 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g21PV-0003on-Ke; Mon, 17 Sep 2018 21:50:29 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w8HLoFjM027813; Mon, 17 Sep 2018 17:50:15 -0400 From: Tom Lane To: Amit Khandekar cc: Andres Freund , Andreas Joseph Krogh , Robert Haas , Alvaro Herrera , "Jonathan S. Katz" , PostgreSQL Hackers Subject: Re: Query is over 2x slower with jit=on In-reply-to: References: <20180822161241.je6nghzjsktbb57b@alap3.anarazel.de> <20180822165155.tjbib4pewnbiyy4x@alap3.anarazel.de> <20180910160909.qf3h3ttztvbyyuds@alap3.anarazel.de> Comments: In-reply-to Amit Khandekar message dated "Fri, 14 Sep 2018 16:48:24 +0530" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <27811.1537221015.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Mon, 17 Sep 2018 17:50:15 -0400 Message-ID: <27812.1537221015@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Amit Khandekar writes: > On 11 September 2018 at 14:50, Amit Khandekar w= rote: >> On 10 September 2018 at 21:39, Andres Freund wrote= : >>> On 2018-09-10 15:42:55 +0530, Amit Khandekar wrote: >>>> I think we better show per-worker jit info also. Just to throw a contrarian opinion into this: I find the current EXPLAIN output for JIT to be insanely verbose already. regards, tom lane