Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tuX2t-009Yjg-73 for pgsql-bugs@arkaria.postgresql.org; Tue, 18 Mar 2025 13:31:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tuX2r-00Em7X-HJ for pgsql-bugs@arkaria.postgresql.org; Tue, 18 Mar 2025 13:31:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tuVDv-00CefO-Me for pgsql-bugs@lists.postgresql.org; Tue, 18 Mar 2025 11:35:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tuVDt-003Uu1-0O for pgsql-bugs@lists.postgresql.org; Tue, 18 Mar 2025 11:35:06 +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=rEFbd28zfwIHtjvnlVd6D1NR1IyTV+gjNUzqrMa4+3M=; b=1YxAA/JnOFY3z6QWvP09+sBSbg T/H2L78W6qHgOFMAhiSLo3pUVSHj81llFXdgs1bLPD4967sZ/08KYcp1L/KSIGlVo+hm+QrcmKVVI 6GQUK3HNQT5+JeAIxDZzE9HbGHRnDLxCKuHTQes3Wga49wsXJABABovi7wfeWGuH6m4vjSTrJFQ4Q 5l8oemwI+80IWXqTSWUXEGcumh0ODra/+ahIxzrA9ln89ArJYQyccYMbRyTecNt5oa9KWxewGBmC6 r+K2kXrPkoo8dg5YfS8LClSQr2MKDyBrzFmc8OLwhtE/Jm9s2ZFeyJpmenUzIMynsL+iNM7WatEiW EhnszuDg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tuVDs-009CAY-Eb for pgsql-bugs@lists.postgresql.org; Tue, 18 Mar 2025 11:35: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 1tuVDr-00E5Da-8W for pgsql-bugs@lists.postgresql.org; Tue, 18 Mar 2025 11:35:02 +0000 Content-Type: multipart/mixed; boundary="===============5746966192438126714==" MIME-Version: 1.0 Subject: BUG #18854: PostgreSQL chooses a suboptimal execution plan when using a specific WHERE filter To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: yonisade83@gmail.com Reply-To: yonisade83@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 18 Mar 2025 11:34:05 +0000 Message-ID: <18854-f5bc660117569bdf@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 --===============5746966192438126714== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODg1NApMb2dnZWQgYnk6ICAgICAgICAgIFlvbmkgU2FkZQpFbWFpbCBh ZGRyZXNzOiAgICAgIHlvbmlzYWRlODNAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTYu OApPcGVyYXRpbmcgc3lzdGVtOiAgIFJEUyBMaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKUXVl cnkgaGFzIGEgc3BlY2lmaWMgV0hFUkUgZmlsdGVyIGZvciB0aW55IGxvb2t1cCB0YWJsZSAidDgi ICgxOSByb3dzKSB3aGljaApnZW5lcmF0ZXMgYW4gZXhlY3V0aW9uIHBsYW4gd2hpY2ggaGFzIHR3 byAiTmVzdGVkIExvb3AiIHN0ZXBzIGluc3RlYWQgb2YKIkhhc2ggSm9pbiIgc3RlcHMgd2hpY2gg bWFrZXMgdGhlIHF1ZXJ5IGZpbmlzaCBhZnRlciA5MCBzZWNvbmRzIChhbmQgc3Bpa2luZwp0aGUg c2VydmVyIENQVSB3aGVuIGJlaW5nIHJhbiBieSBkb3plbnMgb2Ygc2Vzc2lvbnMgc2ltdWx0YW5l b3VzbHkpIGluc3RlYWQKb2YgfjMgc2Vjb25kcyAod2hlbiBjb21tZW50aW5nIG91dCB0aGF0IHNw ZWNpZmljIFdIRVJFIGZpbHRlciBjbGF1c2UgSQptZW50aW9uZWQgYmVsb3cpOg0KDQpRdWVyeSAj MSAocnVudGltZTogfjkwIHNlY29uZHMpOjoNCg0KU0VMRUNUIGNvdW50KCopIEFTIHRvdGFsIEZS T00gKCBTRUxFQ1QgMQ0KRlJPTSB2X20NCkpPSU4gKFNFTEVDVCAqLCBnZW5lcmF0ZV9zZXJpZXMo bXYuc3RhcnRfeWVhciwgbXYuZW5kX3llYXIpIGFzIHllYXINCkZST00gbXYpIHQzDQpvbiB2X20u bV9pZCA9IHQzLm1faWQNCkxFRlQgSk9JTiB0OSBPTiB0My5tbV9pZCA9IHQ5Lm1tX2lkIGFuZCB0 My55ZWFyID0gdDkueWVhcg0KTEVGVCBKT0lOIHZfbW0gT04gdDMubW1faWQgPSB2X21tLm1tX2lk DQpMRUZUIEpPSU4gdDggT04gdl9tLmlkID0gdDgubW1fZl9pZA0KTEVGVCBKT0lOIHQ3IE9OIHQ4 LnNtX2ZfaWQgPSB0Ny5mX2lkDQpXSEVSRSB2X20uaXNfZXhpc3RzID0gdHJ1ZQ0KQU5EIHQzLmlz X2FjdGl2ZSA9IHRydWUNCkFORCB2X20ubWtfaWQgSU4gKDcpDQpBTkQgdDMueWVhciA+PSAyMDIx DQpBTkQgdDMueWVhciA8PSAyMDI0DQpBTkQgdDguc21fZl9pZCBJTiAoOCkgLS0gdGhpcyBzcGVj aWZpYyBjbGF1c2Ugc2xvd3MgZG93biB0aGUgcXVlcnkNCkdST1VQIEJZIHZfbS5tX2lkLCB2X20u bV9oLCB0My5tYWtlLCB2X20uaW1nLCBDT0FMRVNDRSh0OS5pc19uZXcsIGZhbHNlKSwKdDMueWVh cikgVDsNCg0KRXhlY3V0aW9uIHBsYW4gIzE6DQoNCk5vZGUgVHlwZQlFbnRpdHkJQ29zdAlSb3dz CVRpbWUJQ29uZGl0aW9uDQpBZ2dyZWdhdGUJW05VTExdCTQ0NTAxLjc4IC0gNDQ1MDEuNzkJMQlb TlVMTF0JW05VTExdDQpHcm91cAlbTlVMTF0JNDQ1MDEuNDggLSA0NDUwMS42OAk4CVtOVUxMXQlb TlVMTF0NCkluY3JlbWVudGFsIFNvcnQJW05VTExdCTQ0NTAxLjQ4IC0gNDQ1MDEuNjAJOAlbTlVM TF0JW05VTExdDQpOZXN0ZWQgTG9vcAlbTlVMTF0JMjkyMjQuOTIgLSA0NDUwMS4zNgk4CVtOVUxM XQlbTlVMTF0NCk5lc3RlZCBMb29wCVtOVUxMXQkyOTIyNC45MiAtIDQ0NDg2LjM4CTQJW05VTExd CVtOVUxMXQ0KTmVzdGVkIExvb3AJW05VTExdCTIwNDguMjkgLSAxMzYyOC4yNQkxCVtOVUxMXQlb TlVMTF0NCk5lc3RlZCBMb29wCVtOVUxMXQkyMDQ3Ljg3IC0gMTM2MjMuODAJMQlbTlVMTF0JW05V TExdDQpOZXN0ZWQgTG9vcAlbTlVMTF0JMTA0Ny44NyAtIDEwNjAuODkJMQlbTlVMTF0JQ09BTEVT Q0UoKChjb3VudCgqKSkgPiAwKSwKRkFMU0UpDQpJbmRleCBTY2FuCXQxCTAuMjcgLSA4LjI5CTEJ W05VTExdCShta19pZCA9IDcpDQpBZ2dyZWdhdGUJW05VTExdCTEwNDcuNjAgLSAxMDQ5LjYwCTIw MAlbTlVMTF0JW05VTExdDQpTZXEgU2Nhbgl0MgkwLjAwIC0gOTkzLjI4CTEwODY0CVtOVUxMXQlp c19hY3RpdmUNClN1YnF1ZXJ5IFNjYW4JW05VTExdCTEwMDAuMDAgLSAxMjU2Mi43MwkxNQlbTlVM TF0JIigodDMueWVhciA+PSAyMDIxKQ0KQU5EICh0My55ZWFyIDw9IDIwMjQpKSINCkdhdGhlcglb TlVMTF0JMTAwMC4wMCAtIDEyNTE2LjMzCTMwOTMJW05VTExdCVtOVUxMXQ0KUHJvamVjdFNldAlb TlVMTF0JMC4wMCAtIDExMjA3LjAzCTE4MTkwMDAJW05VTExdCVtOVUxMXQ0KSW5kZXggT25seSBT Y2FuCXQ5CTAuNDIgLSA0LjQ0CTEJW05VTExdCSIoKG1tX2lkID0gdDMubW1faWQpDQpBTkQgKFlF QVIgPSB0My55ZWFyKSkiDQpIYXNoIEpvaW4JW05VTExdCTI3MTc2LjYzIC0gMzA4NDguNDkJNzcx CVtOVUxMXQkodDQuZl9pZCA9IHQ2Lm1tX2ZfaWQpDQpVbmlxdWUJW05VTExdCTI3MTc1LjM4IC0g Mjg3MTguMTgJMTU0MjgwCVtOVUxMXQlbTlVMTF0NClNvcnQJW05VTExdCTI3MTc1LjM4IC0gMjc1 NjEuMDgJMTU0MjgwCVtOVUxMXQlbTlVMTF0NCkFwcGVuZAlbTlVMTF0JMTYuMDcgLSAzODU5LjY1 CTE1NDI4MAlbTlVMTF0JW05VTExdDQpIYXNoIEpvaW4JW05VTExdCTE2LjA3IC0gNzczLjE4CTM4 MjIwCVtOVUxMXQkodDQuZl9pZCA9IHQ3LmZfaWQpDQpIYXNoIEpvaW4JW05VTExdCTE1Ljg1IC0g MjMxNS4wNwkxMTYwNjAJW05VTExdCSh0NS50X2lkID0gdC50X2lkKQ0KSGFzaAlbTlVMTF0JMS4y NCAtIDEuMjQJMQlbTlVMTF0JW05VTExdDQpTZXEgU2Nhbgl0OAkwLjAwIC0gMS4yNAkxCVtOVUxM XQkoc21fZl9pZCA9IDgpDQpNYXRlcmlhbGl6ZQlbTlVMTF0JMC4wMCAtIDE0Ljg4CTIJW05VTExd CVtOVUxMXQ0KU2VxIFNjYW4JdDcJMC4wMCAtIDE0Ljg4CTIJW05VTExdCShmX2lkID0gOCkNCg0K DQpRdWVyeSAjMiAocnVudGltZTogfjMgc2Vjb25kcyk6DQoNClNFTEVDVCBjb3VudCgqKSBBUyB0 b3RhbCBGUk9NICggU0VMRUNUIDENCkZST00gdl9tDQpKT0lOIChTRUxFQ1QgKiwgZ2VuZXJhdGVf c2VyaWVzKG12LnN0YXJ0X3llYXIsIG12LmVuZF95ZWFyKSBhcyB5ZWFyDQpGUk9NIG12KSB0Mw0K b24gdl9tLm1faWQgPSB0My5tX2lkDQpMRUZUIEpPSU4gdDkgT04gdDMubW1faWQgPSB0OS5tbV9p ZCBhbmQgdDMueWVhciA9IHQ5LnllYXINCkxFRlQgSk9JTiB2X21tIE9OIHQzLm1tX2lkID0gdl9t bS5tbV9pZA0KTEVGVCBKT0lOIHQ4IE9OIHZfbS5pZCA9IHQ4Lm1tX2ZfaWQNCkxFRlQgSk9JTiB0 NyBPTiB0OC5zbV9mX2lkID0gdDcuZl9pZA0KV0hFUkUgdl9tLmlzX2V4aXN0cyA9IHRydWUNCkFO RCB0My5pc19hY3RpdmUgPSB0cnVlDQpBTkQgdl9tLm1rX2lkIElOICg3KQ0KQU5EIHQzLnllYXIg Pj0gMjAyMQ0KQU5EIHQzLnllYXIgPD0gMjAyNA0KR1JPVVAgQlkgdl9tLm1faWQsIHZfbS5tX2gs IHQzLm1ha2UsIHZfbS5pbWcsIENPQUxFU0NFKHQ5LmlzX25ldywgZmFsc2UpLAp0My55ZWFyKSBU Ow0KDQpFeGVjdXRpb24gcGxhbiAjMjoNCk5vZGUgVHlwZQlFbnRpdHkJQ29zdAlSb3dzCVRpbWUJ Q29uZGl0aW9uDQpBZ2dyZWdhdGUJW05VTExdCTQ0NTAxLjc4IC0gNDQ1MDEuNzkJMQlbTlVMTF0J W05VTExdDQpHcm91cAlbTlVMTF0JNDQ1MDEuNDggLSA0NDUwMS42OAk4CVtOVUxMXQlbTlVMTF0N CkluY3JlbWVudGFsIFNvcnQJW05VTExdCTQ0NTAxLjQ4IC0gNDQ1MDEuNjAJOAlbTlVMTF0JW05V TExdDQpOZXN0ZWQgTG9vcAlbTlVMTF0JMjkyMjQuOTIgLSA0NDUwMS4zNgk4CVtOVUxMXQlbTlVM TF0NCk5lc3RlZCBMb29wCVtOVUxMXQkyOTIyNC45MiAtIDQ0NDg2LjM4CTQJW05VTExdCVtOVUxM XQ0KTmVzdGVkIExvb3AJW05VTExdCTIwNDguMjkgLSAxMzYyOC4yNQkxCVtOVUxMXQlbTlVMTF0N Ck5lc3RlZCBMb29wCVtOVUxMXQkyMDQ3Ljg3IC0gMTM2MjMuODAJMQlbTlVMTF0JW05VTExdDQpO ZXN0ZWQgTG9vcAlbTlVMTF0JMTA0Ny44NyAtIDEwNjAuODkJMQlbTlVMTF0JQ09BTEVTQ0UoKChj b3VudCgqKSkgPiAwKSwKRkFMU0UpDQpJbmRleCBTY2FuCXQxCTAuMjcgLSA4LjI5CTEJW05VTExd CShta19pZCA9IDcpDQpBZ2dyZWdhdGUJW05VTExdCTEwNDcuNjAgLSAxMDQ5LjYwCTIwMAlbTlVM TF0JW05VTExdDQpTZXEgU2Nhbgl0MgkwLjAwIC0gOTkzLjI4CTEwODY0CVtOVUxMXQlpc19hY3Rp dmUNClN1YnF1ZXJ5IFNjYW4JW05VTExdCTEwMDAuMDAgLSAxMjU2Mi43MwkxNQlbTlVMTF0JIigo dDMueWVhciA+PSAyMDIxKQ0KQU5EICh0My55ZWFyIDw9IDIwMjQpKSINCkdhdGhlcglbTlVMTF0J MTAwMC4wMCAtIDEyNTE2LjMzCTMwOTMJW05VTExdCVtOVUxMXQ0KUHJvamVjdFNldAlbTlVMTF0J MC4wMCAtIDExMjA3LjAzCTE4MTkwMDAJW05VTExdCVtOVUxMXQ0KSW5kZXggT25seSBTY2FuCXQ5 CTAuNDIgLSA0LjQ0CTEJW05VTExdCSIoKG1tX2lkID0gdDMubW1faWQpDQpBTkQgKFlFQVIgPSB0 My55ZWFyKSkiDQpIYXNoIEpvaW4JW05VTExdCTI3MTc2LjYzIC0gMzA4NDguNDkJNzcxCVtOVUxM XQkodDQuZl9pZCA9IHQ2Lm1tX2ZfaWQpDQpVbmlxdWUJW05VTExdCTI3MTc1LjM4IC0gMjg3MTgu MTgJMTU0MjgwCVtOVUxMXQlbTlVMTF0NClNvcnQJW05VTExdCTI3MTc1LjM4IC0gMjc1NjEuMDgJ MTU0MjgwCVtOVUxMXQlbTlVMTF0NCkFwcGVuZAlbTlVMTF0JMTYuMDcgLSAzODU5LjY1CTE1NDI4 MAlbTlVMTF0JW05VTExdDQpIYXNoIEpvaW4JW05VTExdCTE2LjA3IC0gNzczLjE4CTM4MjIwCVtO VUxMXQkodDQuZl9pZCA9IHQ3LmZfaWQpDQpIYXNoIEpvaW4JW05VTExdCTE1Ljg1IC0gMjMxNS4w NwkxMTYwNjAJW05VTExdCSh0NS50X2lkID0gdC50X2lkKQ0KSGFzaAlbTlVMTF0JMS4yNCAtIDEu MjQJMQlbTlVMTF0JW05VTExdDQpTZXEgU2Nhbgl0OAkwLjAwIC0gMS4yNAkxCVtOVUxMXQkoc21f Zl9pZCA9IDgpDQpNYXRlcmlhbGl6ZQlbTlVMTF0JMC4wMCAtIDE0Ljg4CTIJW05VTExdCVtOVUxM XQ0KU2VxIFNjYW4JdDcJMC4wMCAtIDE0Ljg4CTIJW05VTExdCShmX2lkID0gOCkKCg== --===============5746966192438126714==--