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 1fffqw-0005eQ-OF for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jul 2018 06:22:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fffqu-0005iA-W0 for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jul 2018 06:22:20 +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 1fffqt-0005hx-3W for pgsql-hackers@lists.postgresql.org; Wed, 18 Jul 2018 06:22:20 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fffql-0006Lz-8w for pgsql-hackers@postgresql.org; Wed, 18 Jul 2018 06:22:15 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id BC1C0218AF; Wed, 18 Jul 2018 02:22:07 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 18 Jul 2018 02:22:07 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=DJ6iH3Eb3Iyg9Tn2Kmx4R4K+UjbZRDz62PxjEN2fi2o=; b=L+HFS/eL xJDrJGBIyBkhT9g9wjYSqd+C6nJvlGibv6j+FomLIsLE8EhuERk3ORuTh5Pxj8EZ XG/Tkzc54vYxQTY4vvSNvO09BE5FkCEe9MYRJZfGn1Np12BW97SuCRZ57mjkbtN+ qTIp/sXHmJKi7uQptQzcWKX2c63PrK5kk9zzTtgzN758CBOEjvCSxu2i/JxB+Vc4 sqfcZPHg+dJhpuO8XkeoVGiIp0tf3In0We0EozzkPqVgs/Q6bYS8u9J6gLkoHsoU ixQ/sJeoRYqaCgBfgH/ifkcg+JgQtm2GkLKWeUmA6aIxSNTnHZuK3iYvav5A2OJt rYX3Q8cIy4IS/w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=DJ6iH3Eb3Iyg9Tn2Kmx4R4K+UjbZR Dz62PxjEN2fi2o=; b=gkDGO/+vToI4cX0EpK850Ev0pdQ8u2hxZpJf0Oaxwy/EX C5Pf4knt41oBAA2xZZnCEXqkI79fqFS/MEz4un8SZ8pjmuH+/DeBQ88JWhxoqhcR iohA2WVjuJfz5NziNcSZnw3Z14ej2rfn+EQkN90/iNXLBdba6Rx7jMFGOQOMNg+C /OtKxC3y+HGiS04JGVraAZpmaFTQ4ij+de3DXItCb88rFHIL+RY0vYt5664IWTd3 pksTOk95paE1jGZlxj//KIcBZ+fNmzFzeGUEiDTZtqMW1Y2N79nqhowNYN3B6oNO f7fYhGrNL79JqSSgRcbkQlttFWwpl4+7YegCAKEZA== X-ME-Proxy: X-ME-Sender: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 4DEA910269; Wed, 18 Jul 2018 02:22:05 -0400 (EDT) Date: Wed, 18 Jul 2018 15:22:02 +0900 From: Michael Paquier To: Masahiko Sawada Cc: PostgreSQL-development , Robert Haas , Ashutosh Bapat Subject: Re: print_path is missing GatherMerge and CustomScan support Message-ID: <20180718062202.GC8565@paquier.xyz> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="/aVve/J9H4Wl5yVO" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --/aVve/J9H4Wl5yVO Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jul 18, 2018 at 02:35:23PM +0900, Masahiko Sawada wrote: > Hi, >=20 > While debugging planner I realized that print_path() function is not > aware of both GatherMerge path and CustomScan path. Attached small > patch fixes it. Good catch. Those should be backpatched. While I am looking at this stuff, I have noticed that pathnode.c/reparameterize_path_by_child uses T_MergeAppend and not T_MergeAppendPath. --- a/src/backend/optimizer/util/pathnode.c +++ b/src/backend/optimizer/util/pathnode.c @@ -3817,7 +3817,7 @@ do { \ } break; - case T_MergeAppend: + case T_MergeAppendPath: { MergeAppendPath *mapath This is new as of f49842d1 in v11. Robert, Ashutosh, am I missing something? -- Michael --/aVve/J9H4Wl5yVO Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAltO3IoACgkQnvQgOdby QH1a2BAAgJmtO/HrbKnGwcq+pjznryrkqVUNtLO5VOdT7XTZkUOFv6RVK6n0CM/W cUubUCSPgYvJZKx6YK1ePEZGBEu70AdmDIthpMwOOciW2SZ0Asn7G76z7DvZ2bmb ejAqQrDFOWJ8TN32lDn1m4CLnBeyk/V2tPCc9dv0l3aV3y9jSXGXc5gX/EqH4XbI bjm6JAOChnx3hLUHT8mteVMeswd7QV7bYvhG7/p3LCAX24btJi7AtPk8n9kbyXvA i5hQWsbHSJ4XIM871rTnzvHeAioB1D9Ufym3OCwswHyzoQebyW8ClStOURk7DlTf 9g62k7KC8zUYxbgo+oN066pOsmycS2o+OWnLy0/y2QjKIDPp3Wh7KhDekiky9nka ilRqRzeoYYx1S7+MOGZoU7TmjR26Ua9R/49TA9kHV4leO69m3cdyG8jMsE01BjXg MdcjET89Hy2ukvsqp1VPJCOg8cnRc69Amyx/uhhcXhOHIJh/UX10Ba/+GOrmytPj V+qaxXf7DdFKRy6RoUXQxRQqTtbLf1ZV7dcnMxynbT8S6t+t5E6NKf2EtBincxQC Ag/Uc7v8xbfDiBhri8zZWkbfTOLQQMAiEZCm/f/8+2wy6tZpwvKb//boPcHtUekk qYWVxK+4rVPfFq8FaGg66YFDaCuUcmrO+sA4almRdneFfwfkDJA= =M3Fk -----END PGP SIGNATURE----- --/aVve/J9H4Wl5yVO--