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 1svXrV-00Fqf0-7V for pgsql-bugs@arkaria.postgresql.org; Tue, 01 Oct 2024 08:04:02 +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 1svXrU-00CmTz-Bs for pgsql-bugs@arkaria.postgresql.org; Tue, 01 Oct 2024 08:04:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1svXc8-00CWjI-AI for pgsql-bugs@lists.postgresql.org; Tue, 01 Oct 2024 07:48:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1svXc4-001yf8-Hf for pgsql-bugs@lists.postgresql.org; Tue, 01 Oct 2024 07:48: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=do5CnVXXFfJR3jtlZfTTgaPdnsDoh5rkrR8ZpPol7Ws=; b=RD3axHn6aj8opUa2qMGLXo01u5 YJN3kWocHdOCtOKFQPaqmUUY0kDcNAZ0EMRmDzFXhzGvm0FpUZRX9v1o+W8epqw/CspDok9E/PS3N 1Tg8iml7ril6pnV9EHfgSI7a+pQg0zRuXmAkkNG2CgqIKbCsaI8kHiWiaCVYteZwvr24jTbOR/SOh gqseoKvi9tCYnN4cNgGkPiIX76kMd7jCS3PhUnGxvjZ1cuO2T4PnT5cp4Ul8iE8I4eNEGH3AaExbt lYxCgH1IkaW3AKE97al1TPQOO6XZCHEtB9iKSPV5seIemjmIDoWwZlGjJxDQV3wsWLmq4cglLpaEs lqusDiXA==; 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 1svXc4-006341-7r for pgsql-bugs@lists.postgresql.org; Tue, 01 Oct 2024 07:48: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 1svXc2-00Ar9x-Vc for pgsql-bugs@lists.postgresql.org; Tue, 01 Oct 2024 07:48:02 +0000 Content-Type: multipart/mixed; boundary="===============1822746641340067143==" MIME-Version: 1.0 Subject: BUG #18643: EXPLAIN estimated rows mismatch To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mingwei.tc@gmail.com Reply-To: mingwei.tc@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 01 Oct 2024 07:47:34 +0000 Message-ID: <18643-8d455145acd8243e@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 --===============1822746641340067143== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODY0MwpMb2dnZWQgYnk6ICAgICAgICAgIG1pbmcgd2VpIHRhbgpFbWFp bCBhZGRyZXNzOiAgICAgIG1pbmd3ZWkudGNAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTIuMjAKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gMTIuMjAtMS5wZ2RnMTIwKzEgKERvY2tl cikKRGVzY3JpcHRpb246ICAgICAgICAKCkdpdmVuIHByZWRpY2F0ZSBBIGFuZCBCLCBpdCBpcyBl eHBlY3RlZCB0aGF0IHNpemUgKFNFTEVDVCBYIHdoZXJlIEEpICA8PQpzaXplIChTRUxFQ1QgWCBX SEVSRSBBIG9yIEIpICANCg0KSG93ZXZlciwgYEVYUExBSU4gU0VMRUNUIHQyLmMwIEZST00gdDIg V0hFUkUgdDIuYzAgSU4gKHQyLmMwKWAgcmV0dXJucwpyb3dzPTI1MzcNCiAgICAgICAgICAgICAg ICAgICAgICBRVUVSWSBQTEFODQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0NCiBTZXEgU2NhbiBvbiB0MiAgKGNvc3Q9MC4wMC4uMzUuNTAgcm93 cz0yNTM3IHdpZHRoPTQpDQogICBGaWx0ZXI6IChjMCBJUyBOT1QgTlVMTCkNCg0KDQpXaGlsZSwg YEVYUExBSU4gU0VMRUNUIHQyLmMwIEZST00gdDIgV0hFUkUgKHQyLmMwIElOICh0Mi5jMCkpIE9S ICh0Mi5jMCA+CjQpYCByZXR1cm5zIHJvd3M9ODU4DQogICAgICAgICAgICAgICAgICAgICBRVUVS WSBQTEFODQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLQ0KIFNlcSBTY2FuIG9uIHQyICAoY29zdD0wLjAwLi40OC4yNSByb3dzPTg1OCB3aWR0aD00 KQ0KICAgRmlsdGVyOiAoKGMwID0gYzApIE9SIChjMCA+IDQpKQ0KDQoNClJ1bm5pbmcgb24gZG9j a2VyIGltYWdlIHBvc3RncmVzOjEyDQoNClRlc3QgY2FzZXM6DQoNCkRST1AgREFUQUJBU0UgSUYg RVhJU1RTIGRhdGFiYXNlNDsNCkNSRUFURSBEQVRBQkFTRSBkYXRhYmFzZTQgV0lUSCBFTkNPRElO RyAnVVRGOCcgVEVNUExBVEUgdGVtcGxhdGUwOw0KXGMgZGF0YWJhc2U0Ow0KQ1JFQVRFIFRBQkxF IHQyKGMwIGludCk7DQpJTlNFUlQgSU5UTyB0MihjMCkgVkFMVUVTKDEpOw0KSU5TRVJUIElOVE8g dDIoYzApIFZBTFVFUygyKTsNCkVYUExBSU4gU0VMRUNUIHQyLmMwIEZST00gdDIgV0hFUkUgdDIu YzAgSU4gKHQyLmMwKTsNCkVYUExBSU4gU0VMRUNUIHQyLmMwIEZST00gdDIgV0hFUkUgKHQyLmMw IElOICh0Mi5jMCkpIE9SICh0Mi5jMCA+IDQpOw0KDQoNCg0KRFJPUCBEQVRBQkFTRSBJRiBFWElT VFMgZGF0YWJhc2U0Ow0KQ1JFQVRFIERBVEFCQVNFIGRhdGFiYXNlNCBXSVRIIEVOQ09ESU5HICdV VEY4JyBURU1QTEFURSB0ZW1wbGF0ZTA7DQpcYyBkYXRhYmFzZTQ7DQpDUkVBVEUgVEFCTEUgdDIo YzAgaW50KTsNCklOU0VSVCBJTlRPIHQyKGMwKSBWQUxVRVMoMSk7DQpJTlNFUlQgSU5UTyB0Mihj MCkgVkFMVUVTKDIpOw0KRVhQTEFJTiBTRUxFQ1QgdDIuYzAgRlJPTSB0MiBXSEVSRSAodDIuYzAp PSh0Mi5jMCk7DQpFWFBMQUlOIFNFTEVDVCB0Mi5jMCBGUk9NIHQyIFdIRVJFICgodDIuYzApPSh0 Mi5jMCkgT1IgKHQyLmMwID4gNCk7Cgo= --===============1822746641340067143==--