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 1p5W9d-0005vU-E4 for pgsql-bugs@arkaria.postgresql.org; Wed, 14 Dec 2022 18:06:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p5W9b-0003ZI-Hg for pgsql-bugs@arkaria.postgresql.org; Wed, 14 Dec 2022 18:06:51 +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 1p5Vlg-0001A3-2p for pgsql-bugs@lists.postgresql.org; Wed, 14 Dec 2022 17:42:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p5Vlc-0007J5-V1 for pgsql-bugs@lists.postgresql.org; Wed, 14 Dec 2022 17:42:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=zWOLUKY+8/ooQjVBkZabOalAKcrLwO05WrJrlqj3KTk=; b=YAlSeA6VhAQPvvk5qvJpe1FtB+ a0WusdahOjTLdTXMDBBE0NoJqu4Gh0ej54E/QMVN/rtbroT6Yqt5ZfXtAjZAfYWmcDUQlo9VdJV4h FOE10a55rcOGmzZEbqdOXD6hm94UM+CtLPyf648nG2rkXcwShsXr91+XtSOdrCOWO+C5mVyK1i8F0 nt0joqDRz49r5Qr9T8Uj/o8Nnf9rR4T/3jraWKApUTkFYY0ViPws0FCvsjbL+rW3+AUrx8I6Yqdza NXQqi5soMSjh47HnagDXnOX0d6xFBmwA7J/jGISDkpJ1UCNzM0PUHLRmCOV0R06uFiLVrppGlqk4/ NHYZdDKg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p5Vlc-0002T9-D8 for pgsql-bugs@lists.postgresql.org; Wed, 14 Dec 2022 17:42:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1p5Vla-00E7Yv-Pu for pgsql-bugs@lists.postgresql.org; Wed, 14 Dec 2022 17:42:02 +0000 Content-Type: multipart/mixed; boundary="===============4563842865502941140==" MIME-Version: 1.0 Subject: BUG #17721: A completely unused CTE negatively affect Query Plan To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: nh.dev@sturdy.ai Reply-To: nh.dev@sturdy.ai, pgsql-bugs@lists.postgresql.org Date: Wed, 14 Dec 2022 17:41:37 +0000 Message-ID: <17721-a660b93948b165a7@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4563842865502941140== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzcyMQpMb2dnZWQgYnk6ICAgICAgICAgIE5hdGhhbmllbCBIYXplbHRv bgpFbWFpbCBhZGRyZXNzOiAgICAgIG5oLmRldkBzdHVyZHkuYWkKUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNS4xCk9wZXJhdGluZyBzeXN0ZW06ICAgRG9ja2VyCkRlc2NyaXB0aW9uOiAgICAgICAgCgpJ J3ZlIGJvaWxlZCBkb3duIGFuIGlzc3VlIHdlIGhhdmUgaW4gcHJvZHVjdGlvbiB0byBhIHNpbXBs ZSBxdWVyeSB0aGF0IGNhbgpkZW1vbnN0cmF0ZSBpdC4gIEkndmUgcnVuIHRoaXMgb24gMTMsMTQg YW5kIDE1IGxvY2FsbHkgaW4gYSBkb2NrZXIgY29udGFpbmVyCndpdGggdGhlIHNhbWUgcmVzdWx0 cy4gIElmIGEgQ1RFIHRoYXQgaXMgY29tcGxldGVseSB1bmV4ZWN1dGVkIGV4aXN0cyBpbiBhCnN1 YnF1ZXJ5IChvciB2aWV3IGluIG91ciBwcm9kdWN0aW9uIGNhc2UpIGl0IGFmZmVjdHMgdGhlIHF1 ZXJ5IHBsYW4gVkVSWQpuZWdhdGl2ZWx5LiAgVGhlIGZpcnN0IGV4cGxhaW4gc2hvd3MgYSBzZXF1 ZW50aWFsIHNjYW4sIHdoZXJlIHRoZSBzZWNvbmQKZXhwbGFpbiBzaG93cyBhbiBpbmRleCBzY2Fu LCBqdXN0IGJ5IHRoZSBleGlzdGVuY2Ugb2YgdGhlIChvYnZpb3VzbHkpCnVuZXhlY3V0ZWQgQ1RF Lg0KDQpJbiB0aGlzIGV4YW1wbGUsIHRoZSBwbGFucyBtaWdodCBub3QgZGlmZmVyIG11Y2ggaW4g cGVyZm9ybWFuY2UuICBIb3dldmVyLAppbiBvdXIgcHJvZHVjdGlvbiBzeXN0ZW0sIHRoZSBwYXJh bGxlbCB0byB0aGlzIGlzIFZFUlkgY29zdGx5LiAgSW4gZnJlc2gKbG9jYWwgZG9ja2VyIFBvc3Rn cmVzLCB0aGUgcmFuZG9tIHBhZ2UgY29zdCBtdXN0IGJlIHNldCB0byAxIHRvIHJlZmxlY3QgdGhp cwppc3N1ZS4gIFdpdGggb3VyIHByb2R1Y3Rpb24gZGF0YSwgdGhlIHBhZ2UgY29zdCBpcyB0aGUg ZGVmYXVsdCA0LCBhbmQKcmVmbGVjdHMgdGhlIGlzc3VlLg0KDQoNCg0KZHJvcCB0YWJsZSBpZiBl eGlzdHMgY29udiwgY29udl9hY2M7DQoNCnNlbGVjdCBzZXRzZWVkKDApOw0KDQpjcmVhdGUgdGVt cCB0YWJsZSBjb252IGFzIChzZWxlY3QgaWQsICdtZXRhJyBhcyBtZXRhIGZyb20gZ2VuZXJhdGVf c2VyaWVzCigxLCAxMDAwKSBpZCk7DQoNCmNyZWF0ZSB0ZW1wIHRhYmxlIGNvbnZfYWNjIGFzICgN CglzZWxlY3QgY29udi5pZCwgYWNjX2lkDQoJZnJvbSBjb252DQoJbGVmdCBqb2luIGxhdGVyYWwg KA0KCQlzZWxlY3QgY29udi5pZCwgZmxvb3IocmFuZG9tKCkqMTAwMCkgYXMgYWNjX2lkDQoJCWZy b20gZ2VuZXJhdGVfc2VyaWVzICgxLCA0KSBsaW1pdCBmbG9vcihyYW5kb20oKSo0KzEpOjppbnQN CgkpIGFjYyBvbiB0cnVlDQopOw0KDQoNCmNyZWF0ZSBpbmRleCBjb252X2FjY19pZF9pbmRleA0K ICAgICAgICBvbiBjb252X2FjYyhpZCk7DQoNCmFuYWx5emUgY29udjsgYW5hbHl6ZSBjb252X2Fj YzsNCg0Kc2V0IHJhbmRvbV9wYWdlX2Nvc3QgdG8gMTsNCg0KRVhQTEFJTiAoQU5BTFlaRSwgQ09T VFMsIFZFUkJPU0UsIEJVRkZFUlMsIEZPUk1BVCBKU09OKQ0Kc2VsZWN0ICogZnJvbQ0KCShzZWxl Y3QgaWQgZnJvbSBjb252IGxpbWl0IDEwKSBsaW1pdGNvbnYNCglsZWZ0IGpvaW4gKA0KCXdpdGgg c29tZWNjdGUgYXMgbWF0ZXJpYWxpemVkIChzZWxlY3QgMS8wKQ0KCQlzZWxlY3QgaWQNCgkJZnJv bQljb252X2FjYyBjYQ0KCSkgdmNhDQoJb24gdmNhLmlkID0gbGltaXRjb252LmlkOw0KDQpFWFBM QUlOIChBTkFMWVpFLCBDT1NUUywgVkVSQk9TRSwgQlVGRkVSUywgRk9STUFUIEpTT04pDQpzZWxl Y3QgKiBmcm9tDQoJKHNlbGVjdCBpZCBmcm9tIGNvbnYgbGltaXQgMTApIGxpbWl0Y29udg0KCWxl ZnQgam9pbiAoDQoJLS13aXRoIHNvbWVjY3RlIGFzIG1hdGVyaWFsaXplZCAoc2VsZWN0IDEvMCkN CgkJc2VsZWN0IGlkDQoJCWZyb20JY29udl9hY2MgY2ENCgkpIHZjYQ0KCW9uIHZjYS5pZCA9IGxp bWl0Y29udi5pZDsKCg== --===============4563842865502941140==--