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 1s7Acp-0045Zf-O5 for pgsql-bugs@arkaria.postgresql.org; Wed, 15 May 2024 09:08:41 +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 1s7Acp-00CgtF-Dd for pgsql-bugs@arkaria.postgresql.org; Wed, 15 May 2024 09:08:39 +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 1s72W4-005ECT-TO for pgsql-bugs@lists.postgresql.org; Wed, 15 May 2024 00:29:08 +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.94.2) (envelope-from ) id 1s72W2-000FJG-22 for pgsql-bugs@lists.postgresql.org; Wed, 15 May 2024 00:29: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=LVzwZG1qBLeldop1C1QqoHl2bRc6BzugpxknfodSUm4=; b=AkjofI0IO9RG2xruF7Zyt7sU68 lC70OjaA6Gni+DoqjXkQDVexR8eu9PApU2GgJ/Fc02XQLgIJgAlNGfWYDxZCcJfy3n13BMcCYp15g Mr4Fb7C65SqkHK2aFZh329Ul48Uk1rM1ZqSjXrdwmuw6E72uRvHhhNf2BS4u1rhY+4FcrFmLCT5cY 2bRsP5odibBrWbs7bCRbNvXLPK1WQ8elYfBtCIB4IIpcgw5u837DKAC1ncintrJREXUVxYBYcMOiD ml1440MrrGx6Q6Tw0L0h/jH5fS9MWykdaycPhedHeBZ50TslSGRiN0HdadG4ESXaUCirGbUwWVUER YScKeR8w==; 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 1s72W1-000k7q-ET for pgsql-bugs@lists.postgresql.org; Wed, 15 May 2024 00:29:05 +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 1s72Vz-001AxR-1R for pgsql-bugs@lists.postgresql.org; Wed, 15 May 2024 00:29:03 +0000 Content-Type: multipart/mixed; boundary="===============9021195463969216969==" MIME-Version: 1.0 Subject: BUG #18466: Wrong row estimate for nested loop To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 4wuyan@gmail.com Reply-To: 4wuyan@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 15 May 2024 00:28:28 +0000 Message-ID: <18466-1d296028273322e2@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 --===============9021195463969216969== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQ2NgpMb2dnZWQgYnk6ICAgICAgICAgIFlhbiBXdQpFbWFpbCBhZGRy ZXNzOiAgICAgIDR3dXlhbkBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNi4zCk9wZXJh dGluZyBzeXN0ZW06ICAgRGViaWFuIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIZWxsbyBl dmVyeW9uZSwgSSBub3RpY2UgdGhlIHJvdyBlc3RpbWF0ZSBmb3IgYSBuZXN0ZWQgbG9vcCBpcyB3 cm9uZyBpZiBhCmN0ZSBpcyBpbnZvbHZlZC4NCg0KIyMgSG93IHRvIHJlcHJvZHVjZQ0KDQpZb3Ug Y2FuIHJlcHJvZHVjZSBpdCBpbiBhIGRvY2tlciBjb250YWluZXIuIEkgb3JpZ2luYWxseSBzYXcg aXQgb24gQVdTCkF1cm9yYS4NCmBgYGJhc2gNCmRvY2tlciBydW4gLS1uYW1lIHRlc3QtcG9zdGdy ZXMgLWUgUE9TVEdSRVNfUEFTU1dPUkQ9bXlzZWNyZXRwYXNzd29yZCAtZCAtcAo1NDMyOjU0MzIg cG9zdGdyZXM6MTYuMw0KYGBgDQoNClNpbXBsZSB0YWJsZSBzZXR1cA0KYGBgc3FsDQpjcmVhdGUg dGFibGUgdDEoYSBpbnQpOw0KY3JlYXRlIHRhYmxlIHQyKGIgaW50KTsNCmNyZWF0ZSBpbmRleCBt eV9pbmRleCBvbiB0MSB1c2luZyBidHJlZSAoYSk7DQppbnNlcnQgaW50byB0MSBzZWxlY3QgZ2Vu ZXJhdGVfc2VyaWVzKDEsIDEwMDAwMCkgZnJvbSBnZW5lcmF0ZV9zZXJpZXMoMSwKMyk7DQppbnNl cnQgaW50byB0MiBzZWxlY3QgZ2VuZXJhdGVfc2VyaWVzKDEsIDEwMCkgZnJvbSBnZW5lcmF0ZV9z ZXJpZXMoMSwgMTApOw0KYW5hbHl6ZSB0MTsNCmFuYWx5emUgdDI7DQoNCi8qIE9wdGlvbmFsbHkg bWFrZSBzdXJlIG5lc3RlZCBsb29wIGlzIHVzZWQgLyoNCi0tIHNldCBlbmFibGVfbWVyZ2Vqb2lu ID0gb2ZmOw0KLS0gc2V0IGVuYWJsZV9oYXNoam9pbiA9IG9mZjsNCmBgYA0KDQpUaGUgcm93IGVz dGltYXRlIGZvciB0aGUgZm9sbG93aW5nIHBsYW4gaXMgd3Jvbmc6IDI5ODAgLyAyMDAgaXMgbm90 IGNsb3NlIHRvCjMuDQpgYGANCnBvc3RncmVzPSMgZXhwbGFpbiB3aXRoIG15X2N0ZSBhcyBtYXRl cmlhbGl6ZWQgKHNlbGVjdCBiIGZyb20gdDIpIHNlbGVjdCAqCmZyb20gdDEgd2hlcmUgdDEuYSBp biAoc2VsZWN0IGIgZnJvbSBteV9jdGUpOw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIFFVRVJZIFBMQU4NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBOZXN0ZWQgTG9vcCAgKGNv c3Q9MzcuOTIuLjI2NzQuNzcgcm93cz0yOTgwIHdpZHRoPTQpDQogICBDVEUgbXlfY3RlDQogICAg IC0+ICBTZXEgU2NhbiBvbiB0MiAgKGNvc3Q9MC4wMC4uMTUuMDAgcm93cz0xMDAwIHdpZHRoPTQp DQogICAtPiAgSGFzaEFnZ3JlZ2F0ZSAgKGNvc3Q9MjIuNTAuLjI0LjUwIHJvd3M9MjAwIHdpZHRo PTQpDQogICAgICAgICBHcm91cCBLZXk6IG15X2N0ZS5iDQogICAgICAgICAtPiAgQ1RFIFNjYW4g b24gbXlfY3RlICAoY29zdD0wLjAwLi4yMC4wMCByb3dzPTEwMDAgd2lkdGg9NCkNCiAgIC0+ICBJ bmRleCBPbmx5IFNjYW4gdXNpbmcgbXlfaW5kZXggb24gdDEgIChjb3N0PTAuNDIuLjEzLjE1IHJv d3M9Mwp3aWR0aD00KQ0KICAgICAgICAgSW5kZXggQ29uZDogKGEgPSBteV9jdGUuYikNCig4IHJv d3MpDQpgYGANCg0KIyMgRXhwZWN0ZWQgb3V0cHV0DQoNCkEgc2ltcGxlIGBkaXN0aW5jdGAgd2ls bCBnaXZlIHRoZSBzYW1lIHBsYW4sIGJ1dCB3aXRoIHRoZSBjb3JyZWN0IHJvdwplc3RpbWF0ZToN CmBgYA0KcG9zdGdyZXM9IyBleHBsYWluIHdpdGggbXlfY3RlIGFzIG1hdGVyaWFsaXplZCAoc2Vs ZWN0IGIgZnJvbSB0Mikgc2VsZWN0ICoKZnJvbSB0MSB3aGVyZSB0MS5hIGluIChzZWxlY3QgZGlz dGluY3QgYiBmcm9tIG15X2N0ZSk7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg UVVFUlkgUExBTg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIE5lc3RlZCBMb29wICAoY29zdD0z Ny45Mi4uMjY3NC43NyByb3dzPTU5NiB3aWR0aD00KQ0KICAgQ1RFIG15X2N0ZQ0KICAgICAtPiAg U2VxIFNjYW4gb24gdDIgIChjb3N0PTAuMDAuLjE1LjAwIHJvd3M9MTAwMCB3aWR0aD00KQ0KICAg LT4gIEhhc2hBZ2dyZWdhdGUgIChjb3N0PTIyLjUwLi4yNC41MCByb3dzPTIwMCB3aWR0aD00KQ0K ICAgICAgICAgR3JvdXAgS2V5OiBteV9jdGUuYg0KICAgICAgICAgLT4gIENURSBTY2FuIG9uIG15 X2N0ZSAgKGNvc3Q9MC4wMC4uMjAuMDAgcm93cz0xMDAwIHdpZHRoPTQpDQogICAtPiAgSW5kZXgg T25seSBTY2FuIHVzaW5nIG15X2luZGV4IG9uIHQxICAoY29zdD0wLjQyLi4xMy4xNSByb3dzPTMK d2lkdGg9NCkNCiAgICAgICAgIEluZGV4IENvbmQ6IChhID0gbXlfY3RlLmIpDQooOCByb3dzKQ0K YGBgDQoNClRoaXMgaXMgbXkgZXhwZWN0ZWQgb3V0cHV0OiA1OTYgLyAyMDAgaXMgYXBwcm94aW1h dGVseSAzLg0KDQpJZiB5b3UgY29tcGFyZSB0aGUgdHdvIHBsYW5zLCB5b3UgY2FuIHNlZSB0aGV5 IGFyZSBleGFjdGx5IHRoZSBzYW1lIHBsYW4Kd2l0aCB0aGUgc2FtZSBjb3N0IGVzdGltYXRlIHRv by4gVGhlIG9ubHkgZGlmZmVyZW5jZSBpcyBgcm93cz0yOTgwYCBhbmQKYHJvd3M9NTk2YCBmb3Ig dGhlIE5lc3RlZCBMb29wIG5vZGUuIEl0IHNlZW1zIGByb3dzPTEwMDBgIGluc3RlYWQgb2YKYHJv d3M9MjAwYCBpcyB1c2VkIGZvciB0aGUgSGFzaEFnZ3JlZ2F0ZSBub2RlIGluIHRoZSB3cm9uZyBv dXRwdXQuDQoNClRoaXMgcXVlcnkgaXMgc2ltcGxlIGFuZCB0cml2aWFsLiBCdXQgaXQncyBmb3Ig ZGVtbyBwdXJwb3NlIG9ubHkuIFRoZSBxdWVyeQptYXkgYmUgYSBwYXJ0IG9mIGEgYmlnZ2VyIHF1 ZXJ5LCBhbmQgdGhlIHdyb25nIHJvdyBlc3RpbWF0ZSBjYW4gbGVhZCB0byBhCmJhZCBleGVjdXRp b24gcGxhbiBmb3IgdGhlIGJpZyBxdWVyeS4NCg0KIyMgUG9zdGdyZXMgdmVyc2lvbg0KDQoxNi4z DQoNCiMjIFBsYXRmb3JtIGluZm9ybWF0aW9uDQoNCkxhdGVzdCBwb3N0Z3JlcyBkb2NrZXIgaW1h Z2UsIHdoaWNoIGlzIGJhc2VkIG9uIERlYmlhbiBMaW51eC4gT3JpZ2luYWxseQpmb3VuZCB0aGUg aXNzdWUgb24gQVdTIEF1cm9yYS4KCg== --===============9021195463969216969==--