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 1oxsCE-0006YE-Sp for pgsql-bugs@arkaria.postgresql.org; Wed, 23 Nov 2022 16:01:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oxsCD-0004Ek-Kt for pgsql-bugs@arkaria.postgresql.org; Wed, 23 Nov 2022 16:01:57 +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 1oxr1s-0002Pn-26 for pgsql-bugs@lists.postgresql.org; Wed, 23 Nov 2022 14:47:12 +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 1oxr1l-0005mz-AD for pgsql-bugs@lists.postgresql.org; Wed, 23 Nov 2022 14:47:10 +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=lmLj/Ph63YCpASDf/jqPIABif5WDSodgpXSm+anx11E=; b=Y63Hz/r5znrcTdxZFS04XnBC1/ KeLxjrIPcWNkyjoyXe2jQF+XlhuJo9htEUMqD3Q2HW9M9AlYkM3LMhTG7gy1b5X+Qj5Tlyy/Y4RGS qTRb1Fn+Kw97kl7h1eFlxjKe8AiK8k2OK24pSk+oeRlWPujfMgQGZBfqj3mP2jV8BJwi/FfWERCXZ WmelQrq4gGpFtFeeScb8adUMx4CwSy0IV1obQ+8svC1EbWFjg4rKL/cVHFds0gPb3KPI9zrc3Uixg LTnOyCR3qByZasycho6hLYEAgT2hyZ/AtEe0wq0HDckDYESteuu5NyZkeMAJjjSKK0aO96OXPygjQ bcmihozQ==; 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 1oxr1k-0004JJ-9x for pgsql-bugs@lists.postgresql.org; Wed, 23 Nov 2022 14:47: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 1oxr1i-001fXY-8g for pgsql-bugs@lists.postgresql.org; Wed, 23 Nov 2022 14:47:02 +0000 Content-Type: multipart/mixed; boundary="===============6694277850832559656==" MIME-Version: 1.0 Subject: BUG #17693: Slow performance: Much slower queries on pg_stat_all_tables since 13.4 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: aless.jeant@gmail.com Reply-To: aless.jeant@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 23 Nov 2022 14:46:47 +0000 Message-ID: <17693-8d263aff1ffe112f@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 --===============6694277850832559656== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzY5MwpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXNzYW5kcm8gSmVhbnRl dXIKRW1haWwgYWRkcmVzczogICAgICBhbGVzcy5qZWFudEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxMy43Ck9wZXJhdGluZyBzeXN0ZW06ICAgUkRTCkRlc2NyaXB0aW9uOiAgICAgICAg CgpXZSBkaWQgYSBwb2ludCB1cGdyYWRlIHRocm91Z2ggUkRTJ3MgbWFuYWdlZCBzZXJ2aWNlIHdo aWNoIHdlbnQgZnJvbSAxMy40IHRvCjEzLjcuICgxMy45IGlzIHVuYXZhaWxhYmxlIGFuZCB3ZSBo YXZlIHlldCB0byB1cGdyYWRlIHRvIDEzLjggLSBob3dldmVyIEkKY291bGRuJ3QgZmluZCBhbnkg ZG9jdW1lbnRhdGlvbiBvciBpc3N1ZSBoaXN0b3J5IHJlcG9ydGluZyBzaW1pbGFyIHN5bXB0b21z CmluIHRoZSBwYXN0IHllYXIgb2YgZGlzY3Vzc2lvbnMgaGVyZSkNCg0KVGhpcyBjcmVhdGVkIGEg d2VpcmQgYnVnIHdoaWNoIGlzIGNhdXNpbmcgYSBsb3Qgb2Ygc3RyYWluIG9uIG91ciBzeXN0ZW1z LApiZWNhdXNlIHdlIGN1cnJlbnRseSBydW4gYSBsb3Qgb2YgcXVlcmllcyBvdmVyIHRoZSBwZ19z dGF0X2FsbF90YWJsZXMsIGluCm9yZGVyIHRvIGNob29zZSBjYW5kaWRhdGUgdGFibGVzIG1vc3Qg YXBwcm9wcmlhdGUgdG8gdmFjdXVtIHByZWVtcHRpdmVseSBpbgphIHByb2R1Y3Rpb24gc3lzdGVt ICh3ZSBoYXZlIGEgbG90IG9mIGFjdGl2ZSB0YWJsZXMsIG9yZGVyIG9mIG1hZ25pdHVkZSAxMDBr CnRhYmxlcykNCg0KQmVmb3JlIHRoaXMsIHF1ZXJpZXMgd291bGQgdGFrZSA8PDEgc2Vjb25kLCBu b3cgdGhleSdyZSBhbHdheXMgfjUgc2Vjb25kcywKcmVnYXJkbGVzcyBvZiB3aGF0IHdlIGFyZSBm aWx0ZXJpbmcgb24uDQpFWFBMQUlOIEFOQUxZWkUgcmVwb3J0cyBhbiBvZGQgZml4ZWQgY29zdCAo dGhhdCdzIG5vdCBleHBlY3RlZCBieSBFWFBMQUlOJ3MKcXVlcnkgcGxhbikgb2Ygcm91Z2hseSA1 IHNlY29uZHMgYXQgdGhlIGxhc3QgbGF5ZXIgb2YgdGhlIHF1ZXJ5IG9uIHRoaXMKdmlldywgR3Jv dXBBZ2dyZWdhdGUuDQpTaW1pbGFybHksIHdoZW4gcnVubmluZyB0aGUgc2FtZSBxdWVyeSB0aHJv dWdoIHRoZSBlcXVpdmFsZW50IGZ1bmN0aW9ucwoocGdfc3RhdF9nZXRfbW9kX3NpbmNlX2FuYWx5 emUsIHBnX3N0YXRfZ2V0X2RlYWRfdHVwbGVzLApwZ19zdGF0X2dldF9saXZlX3R1cGxlcykgd2Ug YWx3YXlzIHJ1biBpbnRvIHRoaXMgb2JzY3VyZSBodWdlIGZpeGVkIGNvc3QuDQpXaGF0IGlzIGl0 LCBhbmQgaG93IGNhbiB3ZSBvcHRpb25hbGx5IGdldCByaWQgb2YgaXQsIHByZXN1bWFibHkgZ29p bmcgYmFjawp0byB0aGUgcHJldmlvdXMgcGVyZm9ybWFuY2UgY2hhcmFjdGVyaXN0aWNzPw0KDQpl eGFtcGxlIHdpdGhvdXQgYSBmaWx0ZXIsIGxpbWl0IDE6DQpgYGBFWFBMQUlOIEFOQUxZWkUgU0VM RUNUIG5fbW9kX3NpbmNlX2FuYWx5emUsIG5fbGl2ZV90dXAsIG5fZGVhZF90dXAgRlJPTQpwZ19z dGF0X2FsbF90YWJsZXMgbGltaXQgMTsNCkxpbWl0IChjb3N0PTIuODAuLjQuMTUgcm93cz0xIHdp ZHRoPTI0KSAoYWN0dWFsIHRpbWU9NTkxMi4xMjEuLjU5MTIuMTI1CnJvd3M9MSBsb29wcz0xKQ0K IC0+IFN1YnF1ZXJ5IFNjYW4gb24gcGdfc3RhdF9hbGxfdGFibGVzIChjb3N0PTIuODAuLjE1MTUw MDIuMjQgcm93cz0xMTE5ODM0CndpZHRoPTI0KSAoYWN0dWFsIHRpbWU9NTkxMi4xMjAuLjU5MTIu MTI0IHJvd3M9MSBsb29wcz0xKQ0KIC0+IEdyb3VwQWdncmVnYXRlIChjb3N0PTIuODAuLjE1MDM4 MDMuOTAgcm93cz0xMTE5ODM0IHdpZHRoPTI5MikgKGFjdHVhbAp0aW1lPTU5MTIuMTE4Li41OTEy LjEyMSByb3dzPTEgbG9vcHM9MSkNCiBHcm91cCBLZXk6IGMub2lkLCBuLm5zcG5hbWUsIGMucmVs bmFtZQ0KIC0+IEluY3JlbWVudGFsIFNvcnQgKGNvc3Q9Mi44MC4uMTQ3NTgwOC4wNSByb3dzPTEx MTk4MzQgd2lkdGg9MTMyKSAoYWN0dWFsCnRpbWU9MC4xMjIuLjAuMTI0IHJvd3M9MyBsb29wcz0x KQ0KIFNvcnQgS2V5OiBjLm9pZCwgbi5uc3BuYW1lLCBjLnJlbG5hbWUNCiBQcmVzb3J0ZWQgS2V5 OiBjLm9pZA0KIEZ1bGwtc29ydCBHcm91cHM6IDEgU29ydCBNZXRob2Q6IHF1aWNrc29ydCBBdmVy YWdlIE1lbW9yeTogMzNrQiBQZWFrCk1lbW9yeTogMzNrQg0KIC0+IE5lc3RlZCBMb29wIExlZnQg Sm9pbiAoY29zdD0xLjUyLi4xNDI1NDE1LjUyIHJvd3M9MTExOTgzNCB3aWR0aD0xMzIpCihhY3R1 YWwgdGltZT0wLjAyMS4uMC4xMDYgcm93cz0zNCBsb29wcz0xKQ0KIC0+IE1lcmdlIExlZnQgSm9p biAoY29zdD0xLjExLi45NDAzMjQuODIgcm93cz0xMTE5ODM0IHdpZHRoPTcyKSAoYWN0dWFsCnRp bWU9MC4wMTYuLjAuMDQ0IHJvd3M9MzQgbG9vcHM9MSkNCiBNZXJnZSBDb25kOiAoYy5vaWQgPSBp LmluZHJlbGlkKQ0KIC0+IEluZGV4IFNjYW4gdXNpbmcgcGdfY2xhc3Nfb2lkX2luZGV4IG9uIHBn X2NsYXNzIGMgKGNvc3Q9MC41Ni4uNzAwNDE5LjQ1CnJvd3M9MTExOTgzNCB3aWR0aD03MikgKGFj dHVhbCB0aW1lPTAuMDA5Li4wLjAyNSByb3dzPTE5IGxvb3BzPTEpDQogRmlsdGVyOiAocmVsa2lu ZCA9IEFOWSAoJ3tyLHQsbX0nOjpcImNoYXJcIltdKSkNCiBSb3dzIFJlbW92ZWQgYnkgRmlsdGVy OiAxNA0KIC0+IEluZGV4IE9ubHkgU2NhbiB1c2luZyBwZ19pbmRleF9pbmRyZWxpZF9pbmRleCBv biBwZ19pbmRleCBpCihjb3N0PTAuNTUuLjIyNzE0MC45NiByb3dzPTE2NTkwNTMgd2lkdGg9NCkg KGFjdHVhbCB0aW1lPTAuMDA2Li4wLjAxMApyb3dzPTM0IGxvb3BzPTEpDQogSGVhcCBGZXRjaGVz OiAwDQogLT4gSW5kZXggU2NhbiB1c2luZyBwZ19uYW1lc3BhY2Vfb2lkX2luZGV4IG9uIHBnX25h bWVzcGFjZSBuCihjb3N0PTAuNDEuLjAuNDMgcm93cz0xIHdpZHRoPTY4KSAoYWN0dWFsIHRpbWU9 MC4wMDEuLjAuMDAxIHJvd3M9MQpsb29wcz0zNCkNCiBJbmRleCBDb25kOiAob2lkID0gYy5yZWxu YW1lc3BhY2UpDQpQbGFubmluZyBUaW1lOiAxLjAyNCBtcw0KRXhlY3V0aW9uIFRpbWU6IDU5MTIu MjM5IG1zDQpgYGANCih3aXRoIE9JRCB1bmlxdWUga2V5IGZpbHRlciwgdGhlIG9ubHkgZGlmZmVy ZW5jZSBpcyBpbiB0aGUgR3JvdXBBZ2dyZWdhdGUKcGxhbiwgd2hlcmUgKGNvc3Q9MjUuNzIuLjI1 LjgzIHJvd3M9NCB3aWR0aD0yOTIpKQ0KDQpUaGFuayB5b3UgaW4gYWR2YW5jZSwNCkJlc3QsCgo= --===============6694277850832559656==--