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 1v6OQP-003pOZ-PB for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Oct 2025 07:17:26 +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 1v6OQM-008Hss-3Y for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Oct 2025 07:17:23 +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 1v6EMv-003NPj-Jh for pgsql-bugs@lists.postgresql.org; Tue, 07 Oct 2025 20:33:10 +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 1v6EMs-000YHc-24 for pgsql-bugs@lists.postgresql.org; Tue, 07 Oct 2025 20:33:09 +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=11JSpa4c9SkBEsK5cCR97730f05WWm42tyLhXdeWtqI=; b=eLIMBVZkE8NlDzW5hXwroD+bcD pmP8bDsY/bJVyjt6YINmMLLL47lnCXQ/hcNUsLsRFOSut2AHx5NP2XHUc1mmCh81IEERJRApiaAsy w++tizyfxRHHlztAyyiURqSlBPtm2f4hqt9DhvVnI3o1XXxlcBytWkfggXSFYM4He+q6vGlZq2oXg 1FxwmJsXr3r67lH56XjyUFk2pON5I+UTG6G3otlehJz1zF6pedTaL3IJQsvnQMnFVY2IUyWXPtEyx qustVvEhHOotEZQ+YhiYjRhPFqhSrO1WPOsV0tCOcIJzWG0736PNmBYZ2v1KIjwGnWdQ5rJaFD10U ePXICIsg==; 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 1v6EMr-001ZiW-Du for pgsql-bugs@lists.postgresql.org; Tue, 07 Oct 2025 20:33:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v6EMp-005B8g-0O for pgsql-bugs@lists.postgresql.org; Tue, 07 Oct 2025 20:33:03 +0000 Content-Type: multipart/mixed; boundary="===============3088415639394987741==" MIME-Version: 1.0 Subject: BUG #19076: Generic query plan is extremely slow To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: premal.patel@veeva.com Reply-To: premal.patel@veeva.com, pgsql-bugs@lists.postgresql.org Date: Tue, 07 Oct 2025 20:32:40 +0000 Message-ID: <19076-4d897c04a44a9627@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 --===============3088415639394987741== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA3NgpMb2dnZWQgYnk6ICAgICAgICAgIFByZW1hbCBQYXRlbApFbWFp bCBhZGRyZXNzOiAgICAgIHByZW1hbC5wYXRlbEB2ZWV2YS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNy42Ck9wZXJhdGluZyBzeXN0ZW06ICAgbWFjT1MgMTUuNi4xIChvYnNlcnZlZCBvbiBvdGhl ciBMaW51eCBiYXNlZCBPUykKRGVzY3JpcHRpb246ICAgICAgICAKCkkgaGF2ZSBhbiBhcHBsaWNh dGlvbiB3aGljaCB1c2VzIGEgZGF0YWJhc2UgZHJpdmVyIHRoYXQgY3JlYXRlcyBwcmVwYXJlZApz dGF0ZW1lbnRzLiBJIGFtIG5vdGljaW5nIHRoYXQgZm9yIHNvbWUgcXVlcmllcywgdGhlIGZpcnN0 IDUgZXhlY3V0aW9ucwphZnRlciB0aGUgZGF0YWJhc2UgY29ubmVjdGlvbiBpcyBjcmVhdGVkIGFy ZSBwZXJmb3JtYW50LiBBZnRlciB0aGlzLCB0aGUKcHJlcGFyZWQgc3RhdGVtZW50IHVzZXMgdGhl IGdlbmVyaWMgcXVlcnkgcGxhbiBhbmQgaXMgaW5jcmVkaWJseSBzbG93LiBUaGlzCmlzIGV2ZW4g aWYgSSBkbyBub3QgY2hhbmdlIHRoZSBwYXJhbWV0ZXJzIGFuZCBzaW1wbGUgcmUtcnVuIHRoZSBz YW1lIHF1ZXJ5CnNldmVyYWwgdGltZXMgd2l0aCB0aGUgc2FtZSBhcmd1bWVudHMuIEkgaGF2ZSB0 cmllZCByZS1ydW5uaW5nIEFOQUxZWkUgb24KdGhlIHRhYmxlcyBhbmQgc2V0dGluZyBTVEFUSVNU SUNTIHRvIDEwMDAgb24gdGhlIHJvd3MgaW4gcXVlc3Rpb24gd2l0aCBubwpsdWNrLiBIZXJlIGlz IHdoYXQgbXkgcXVlcnkgbG9va3MgbGlrZToKClNFTEVDVCBhY2NvdW50c19jb250YWN0cy5hY2Nv dW50X2lkLCBjb3VudChjb250YWN0cy5pZCkgQVMgY291bnQKICAgIEZST00gYWNjb3VudHNfY29u dGFjdHMgSk9JTiBjb250YWN0cyBPTiBjb250YWN0cy5pZCA9CmFjY291bnRzX2NvbnRhY3RzLmNv bnRhY3RfaWQKICAgIFdIRVJFIGFjY291bnRzX2NvbnRhY3RzLmFjY291bnRfaWQgSU4gKC4uLikg QU5EIGNvbnRhY3RzLnRlbmFudF9pZCA9CiQxOjpVVUlEIEFORCBjb250YWN0cy5zdGF0dXMgPSAk Mjo6VkFSQ0hBUgpHUk9VUCBCWSBhY2NvdW50c19jb250YWN0cy5hY2NvdW50X2lkCgpIZXJlIGlz IHRoZSBFWFBMQUlOIG91dHB1dCBmcm9tIHRoZSBmaXJzdCA1IGV4ZWN1dGlvbnMgdXNpbmcgdGhl IGN1c3RvbQpxdWVyeSBwbGFuOgoKRmluYWxpemUgSGFzaEFnZ3JlZ2F0ZSAgKGNvc3Q9NDcwMzQu NTIuLjQ3MTMxLjI0IHJvd3M9OTY3MiB3aWR0aD0yNCkgKGFjdHVhbAp0aW1lPTEwMy4xNzMuLjEw My44MjIgcm93cz0xMDAwIGxvb3BzPTEpCiAgICAgIEdyb3VwIEtleTogYWNjb3VudHNfY29udGFj dHMuYWNjb3VudF9pZAogICAgICBCYXRjaGVzOiAxICBNZW1vcnkgVXNhZ2U6IDQ2NWtCCiAgICAg IC0+ICBHYXRoZXIgIChjb3N0PTQ0OTA2LjY4Li40NjkzNy44MCByb3dzPTE5MzQ0IHdpZHRoPTI0 KSAoYWN0dWFsCnRpbWU9MTAyLjgwMS4uMTAzLjUwNiByb3dzPTIzMjYgbG9vcHM9MSkKICAgICAg ICAgICAgV29ya2VycyBQbGFubmVkOiAyCiAgICAgICAgICAgIFdvcmtlcnMgTGF1bmNoZWQ6IDIK ICAgICAgICAgICAgLT4gIFBhcnRpYWwgSGFzaEFnZ3JlZ2F0ZSAgKGNvc3Q9NDM5MDYuNjguLjQ0 MDAzLjQwIHJvd3M9OTY3Mgp3aWR0aD0yNCkgKGFjdHVhbCB0aW1lPTkzLjY4Mi4uOTMuNzU3IHJv d3M9Nzc1IGxvb3BzPTMpCiAgICAgICAgICAgICAgICAgIEdyb3VwIEtleTogYWNjb3VudHNfY29u dGFjdHMuYWNjb3VudF9pZAogICAgICAgICAgICAgICAgICBCYXRjaGVzOiAxICBNZW1vcnkgVXNh Z2U6IDQ2NWtCCiAgICAgICAgICAgICAgICAgIFdvcmtlciAwOiAgQmF0Y2hlczogMSAgTWVtb3J5 IFVzYWdlOiA0NjVrQgogICAgICAgICAgICAgICAgICBXb3JrZXIgMTogIEJhdGNoZXM6IDEgIE1l bW9yeSBVc2FnZTogNDY1a0IKICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggSm9pbiAgKGNvc3Q9 NjA2Ni43OS4uNDM4MTkuMjYgcm93cz0xNzQ4NAp3aWR0aD0zMikgKGFjdHVhbCB0aW1lPTEyLjkw Mi4uOTIuNjc0IHJvd3M9MTE1MDkgbG9vcHM9MykKICAgICAgICAgICAgICAgICAgICAgICAgSGFz aCBDb25kOiAoY29udGFjdHMuaWQgPQphY2NvdW50c19jb250YWN0cy5jb250YWN0X2lkKQogICAg ICAgICAgICAgICAgICAgICAgICAtPiAgUGFyYWxsZWwgU2VxIFNjYW4gb24gY29udGFjdHMKKGNv c3Q9MC4wMC4uMzYxNzcuNTAgcm93cz0zNzMzNjYgd2lkdGg9MTYpIChhY3R1YWwgdGltZT0wLjQz NS4uNTUuMDIzCnJvd3M9Mjg4MTIyIGxvb3BzPTMpCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIEZpbHRlcjogKCh0ZW5hbnRfaWQgPQonMDE5OTcyOWMtM2YxZS03MTJmLThiNzEtZjY1NDVh OTZiMjI1Jzo6dXVpZCkgQU5EICgoc3RhdHVzKTo6dGV4dCA9CidBQ1RJVkUnOjp0ZXh0KSkKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjogMTYyNTE4 CiAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBIYXNoICAoY29zdD01Mjc1LjQ2Li41Mjc1LjQ2 IHJvd3M9NjMzMDcKd2lkdGg9MzIpIChhY3R1YWwgdGltZT0xMi4wNTMuLjEyLjA1NCByb3dzPTM3 MjgyIGxvb3BzPTMpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEJ1Y2tldHM6IDY1NTM2 ICBCYXRjaGVzOiAxICBNZW1vcnkgVXNhZ2U6CjI4NDNrQgogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAtPiAgSW5kZXggT25seSBTY2FuIHVzaW5nCnVxX2FjY291bnRzX2NvbnRhY3RzX2Fj Y291bnRfaWRfY29udGFjdF9pZCBvbiBhY2NvdW50c19jb250YWN0cwooY29zdD0wLjQyLi41Mjc1 LjQ2IHJvd3M9NjMzMDcgd2lkdGg9MzIpIChhY3R1YWwgdGltZT0wLjMzNS4uNS4yMjAKcm93cz0z NzI4MiBsb29wcz0zKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBD b25kOiAoYWNjb3VudF9pZCA9IEFOWSAoLi4uCgpIZXJlIGlzIHRoZSBFWFBMQUlOIG91dHB1dCBm cm9tIGV4ZWN1dGlvbnMgNisgdXNpbmcgdGhlIGdlbmVyaWMgcXVlcnkgcGxhbjoKR3JvdXBBZ2dy ZWdhdGUgIChjb3N0PTU4MjEuMjEuLjU4MjEuNTYgcm93cz0yMCB3aWR0aD0yNCkgKGFjdHVhbAp0 aW1lPTcxNzguMzI4Li43MTc5LjkzNCByb3dzPTEwMDAgbG9vcHM9MSkKICAgICAgR3JvdXAgS2V5 OiBhY2NvdW50c19jb250YWN0cy5hY2NvdW50X2lkCiAgICAgIC0+ICBTb3J0ICAoY29zdD01ODIx LjIxLi41ODIxLjI2IHJvd3M9MjAgd2lkdGg9MzIpIChhY3R1YWwKdGltZT03MTc4LjMxNC4uNzE3 OC45NDMgcm93cz0zNDUyNiBsb29wcz0xKQogICAgICAgICAgICBTb3J0IEtleTogYWNjb3VudHNf Y29udGFjdHMuYWNjb3VudF9pZAogICAgICAgICAgICBTb3J0IE1ldGhvZDogcXVpY2tzb3J0ICBN ZW1vcnk6IDI5ODRrQgogICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTEwLjI2Li41 ODIwLjc3IHJvd3M9MjAgd2lkdGg9MzIpIChhY3R1YWwKdGltZT0zNC4xODcuLjcxNzQuOTM3IHJv d3M9MzQ1MjYgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgLT4gIEJpdG1hcCBIZWFwIFNjYW4g b24gY29udGFjdHMgIChjb3N0PTkuODMuLjI0OTAuMDkKcm93cz0zNTQgd2lkdGg9MTYpIChhY3R1 YWwgdGltZT0zNC4wNzEuLjE5My4yMTYgcm93cz04NjQzNjUgbG9vcHM9MSkKICAgICAgICAgICAg ICAgICAgICAgICAgUmVjaGVjayBDb25kOiAodGVuYW50X2lkID0gJDEpCiAgICAgICAgICAgICAg ICAgICAgICAgIEZpbHRlcjogKChzdGF0dXMpOjp0ZXh0ID0gKCQyKTo6dGV4dCkKICAgICAgICAg ICAgICAgICAgICAgICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjogMTAyNTE5CiAgICAgICAgICAg ICAgICAgICAgICAgIEhlYXAgQmxvY2tzOiBleGFjdD0yNjg1OAogICAgICAgICAgICAgICAgICAg ICAgICAtPiAgQml0bWFwIEluZGV4IFNjYW4gb24gaXhfY29udGFjdHNfdGVuYW50X2lkCihjb3N0 PTAuMDAuLjkuNzQgcm93cz03MDkgd2lkdGg9MCkgKGFjdHVhbCB0aW1lPTMyLjExNC4uMzIuMTE0 IHJvd3M9OTY2ODg0Cmxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4 IENvbmQ6ICh0ZW5hbnRfaWQgPSAkMSkKICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4g dXNpbmcgaXhfYWNjb3VudHNfY29udGFjdHNfY29udGFjdF9pZCBvbgphY2NvdW50c19jb250YWN0 cyAgKGNvc3Q9MC40Mi4uOS40MCByb3dzPTEgd2lkdGg9MzIpIChhY3R1YWwKdGltZT0wLjAwOC4u MC4wMDggcm93cz0wIGxvb3BzPTg2NDM2NSkKICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXgg Q29uZDogKGNvbnRhY3RfaWQgPSBjb250YWN0cy5pZCkKICAgICAgICAgICAgICAgICAgICAgICAg RmlsdGVyOiAoYWNjb3VudF9pZCA9IEFOWSAoQVJSQVlbLi4uXSkpCiAgICAgICAgICAgICAgICAg ICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDEKCihwbGVhc2Ugbm90ZSBJIG9taXR0ZWQg dGhlIGFjY291bnRfaWRzIGxpc3QsIGJ1dCBpdCBpcyBvZiBsZW5ndGggMTAwMCBpbgpib3RoIGNh c2VzKQoKSSBoYXZlIHNlZW4gb3RoZXJzIHJlcG9ydCB0aGUgc2FtZSBpc3N1ZSwgYXMgc2VlbiBp biB0aGlzIGZvcnVtOgpodHRwczovL2RiYS5zdGFja2V4Y2hhbmdlLmNvbS9xdWVzdGlvbnMvMjg5 MTMwL3Bvc3RncmVzcWwtY2hhbmdlcy1zYW1lLXF1ZXJ5LXBsYW4tYXQtcnVudGltZQoK --===============3088415639394987741==--