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.96) (envelope-from ) id 1w0cQF-0023rj-2y for pgsql-novice@arkaria.postgresql.org; Thu, 12 Mar 2026 09:33:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0cQE-00E1d4-0Q for pgsql-novice@arkaria.postgresql.org; Thu, 12 Mar 2026 09:33:38 +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.96) (envelope-from ) id 1w0cQD-00E1cw-2r for pgsql-novice@lists.postgresql.org; Thu, 12 Mar 2026 09:33:38 +0000 Received: from mx1.alte-leipziger.de ([91.217.145.231]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w0cQB-00000001kSQ-2eMh for pgsql-novice@lists.postgresql.org; Thu, 12 Mar 2026 09:33:37 +0000 X-CSE-ConnectionGUID: 4xgTIB8ATbShPpBFEpEC2A== X-CSE-MsgGUID: dMQvP8W5RP+dt9PmzWl1rQ== From: "Subramanian,Ramachandran" To: "depesz@depesz.com" CC: "pgsql-novice@lists.postgresql.org" Subject: AW: Is it possible to turn on pg_stat_extensions at a database level Thread-Topic: Is it possible to turn on pg_stat_extensions at a database level Thread-Index: Adyx/SfUQPguEGKxTS6FByIM+aoLJf//+ouA///u1tA= Date: Thu, 12 Mar 2026 09:33:29 +0000 Message-ID: <959ecf128e514007a7558febe8b76e35@alte-leipziger.de> References: In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: SD3TfnVbAUpJC9HP7gEJMArcxrzwsv5uXPK9y3z82GsD2A3ckpvl94Oj h6H+AEzGk/EQeCwl+akdfmOLS+e0SfCVSN/usNIHQfSOYOlxKYv2aiNJz83dB+Y1GG8NWKe/Q0k XbwtzsS41Lq4E02lXQ6Btxl0D6x4S7TZVMLXtBZihLSC6hXpJl9su68CAPfG8myiLZetSf8mZMP CnTMzfOiq2rl3dzGQ1DBbGvtcMofyhqNwtCtB79PTQhuRMDCWN0tkiQsV5IzDwwVnDQpqSLbzHr prQSYUP x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--7.268700-8.000000 x-tm-snts-smtp: 06382BDF5180B02C7650E93B80D8A77826FA8D156DA8A060E0A3B110E37C3B832000:8 x-alsentwithgood: false Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-GBS-PROC: Nv3VBazK3mHkBCknlKS5+aZUyB58lh3JmXA1ROkDX9yHKeW6axVXElbWi1TFT+qq X-GBS-PROCJOB: =?utf-8?Q?PuoO136A9B0Nu+yqf2q57juuoMu6IwHoUQ3K33dnORdUZO4nbKgFwnDeUAna?= =?utf-8?Q?za6xDxzOx9kQtyjqNuWEtjCS7+lckoQ2De7pyAqFFiDu60zz9csDRz6yn9FI?= =?utf-8?Q?oZnBQsYagTmgtSBMXjhbRPveqqbyBfV/r5Sq/7wHfK9iTJBMGOg=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk WWVzLCAgSSBtaXN0eXBlZCAuDQoNClBnX3N0YXRfc3RhdGVtZW50cy4gICANCg0KICBJIG1l YW50IHRvIGFzayBpZiB0aGUgZXh0ZW5zaW9uIGNhbiBiZSBjcmVhdGVkIG9ubHkgZm9yIG9u ZSBkYXRhYmFzZSwgc28gdGhhdCB0aGUgZGV0YWlscyBmcm9tIHRoZSBvdGhlciBkYXRhYmFz ZXMgYXJlIG5vdCByZWNvcmRlZC4gDQoNCkxHDQoNClJhbQ0KDQoNCg0KDQoNCkZyZXVuZGxp Y2hlIEdyw7zDn2UNCg0KaS4gQS4gUmFtYWNoYW5kcmFuIFN1YnJhbWFuaWFuDQpaZW50cmFs YmVyZWljaCBJbmZvcm1hdGlvbnN0ZWNobm9sb2dpZQ0KDQpBbHRlIExlaXB6aWdlciBMZWJl bnN2ZXJzaWNoZXJ1bmcgYS5HLg0KDQoNCkhhbGxlc2NoZSBLcmFua2VudmVyc2ljaGVydW5n IGEuRy4NCg0KDQoNCg0KDQoNCg0KQWx0ZSBMZWlwemlnZXIgTGViZW5zdmVyc2ljaGVydW5n IGEuRy4sIEFsdGUgTGVpcHppZ2VyLVBsYXR6IDEsIDYxNDQwIE9iZXJ1cnNlbA0KVm9ycy4g ZGVzIEF1ZnNpY2h0c3JhdHM6IERyLiBXYWx0ZXIgQm90ZXJtYW5uIMK3IFZvcnN0YW5kOiBD aHJpc3RvcGggQm9obiAoVm9ycy4pLCBEci4gSsO8cmdlbiBCaWVyYmF1bSAoc3R2LiBWb3Jz LiksIEZyYW5rIEtldHRuYWtlciwgRHIuIEpvY2hlbiBLcmllZ21laWVyLCBBbGV4YW5kZXIg TWF5ZXIsIENocmlzdGlhbiBQYXBlLCBXaWx0cnVkIFBla2FyZWssIFVkbyBXaWxjc2VrDQpT aXR6IE9iZXJ1cnNlbCAoVGF1bnVzKSDCtyBSZWNodHNmb3JtIFZWYUcgwrcgQW10c2dlcmlj aHQgQmFkIEhvbWJ1cmcgdi4gZC4gSC4gSFJCIDE1ODMgwrcgVVN0Li1JZE5yLiBERSAxMTQx MDY4MTQNCg0KDQoNCg0KDQogDQpIYWxsZXNjaGUgS3JhbmtlbnZlcnNpY2hlcnVuZyBhLkcu LCAgTMO2ZmZlbHN0cmHDn2UgMzQtMzgsIDcwNTk3IFN0dXR0Z2FydA0KVm9ycy4gZGVzIEF1 ZnNpY2h0c3JhdHM6IERyLiBXYWx0ZXIgQm90ZXJtYW5uIMK3IFZvcnN0YW5kOiBDaHJpc3Rv cGggQm9obiAoVm9ycy4pLCBEci4gSsO8cmdlbiBCaWVyYmF1bSAoc3R2LiBWb3JzLiksIEZy YW5rIEtldHRuYWtlciwgRHIuIEpvY2hlbiBLcmllZ21laWVyLCBBbGV4YW5kZXIgTWF5ZXIs IENocmlzdGlhbiBQYXBlLA0KV2lsdHJ1ZCBQZWthcmVrLCBVZG8gV2lsY3Nlaw0KU2l0eiBT dHV0dGdhcnQgwrcgUmVjaHRzZm9ybSBWVmFHIMK3IEFtdHNnZXJpY2h0IFN0dXR0Z2FydCBI UkIgMjY4NiDCtyBVU3QuLUlkTnIuIERFIDE0NzgwMjI4NQ0KQmVpdHLDpGdlIHp1IHByaXZh dGVuIEtyYW5rZW4tIHVuZCBQZmxlZ2VrcmFua2VudmVyc2ljaGVydW5nZW4gdW50ZXJsaWVn ZW4gbmljaHQgZGVyIFZlcnNpY2hlcnVuZ3N0ZXVlciAowqcgNCBOci4gNSBWZXJzU3RHKSDC tyBWZXJzaWNoZXJ1bmdzbGVpc3R1bmdlbiBzb3dpZSBVbXPDpHR6ZSBhdXMgVmVyc2ljaGVy dW5nc3ZlcnRyZXRlci0vTWFrbGVydMOkdGlna2VpdGVuIHNpbmQgdW1zYXR6c3RldWVyZnJl aQ0KIA0KDQoNCg0KIA0KRGllIFBmbGljaHRhbmdhYmVuIGRlciBBTEggR3J1cHBlIGdlbcOk w58gwqcgMzVhIEdtYkhHIGJ6dy4gwqcgODAgQWt0RyBmaW5kZW4gU2llIGhpZXI6IGh0dHBz Oi8vd3d3LmFsdGUtbGVpcHppZ2VyLmRlL2ltcHJlc3N1bSANCg0KDQoNCg0KDQpfX19fX19f X19fX19fX19fX19fX19fDQoNCkFMSCBHcnVwcGUNCkFsdGUgTGVpcHppZ2VyLVBsYXR6IDEs IDYxNDQwIE9iZXJ1cnNlbA0KVGVsLjogKzQ5ICg2MTcxKSA2Ni00ODgyDQpGYXg6ICs0OSAo NjE3MSkgNjYtODAwLTQ4ODINCkUtTWFpbDogcmFtYWNoYW5kcmFuLnN1YnJhbWFuaWFuQGFs dGUtbGVpcHppZ2VyLmRlDQp3d3cuYWx0ZS1sZWlwemlnZXIuZGUNCnd3dy5oYWxsZXNjaGUu ZGUNCg0KDQoNCi0tLS0tVXJzcHLDvG5nbGljaGUgTmFjaHJpY2h0LS0tLS0NClZvbjogZGVw ZXN6QGRlcGVzei5jb20gPGRlcGVzekBkZXBlc3ouY29tPiANCkdlc2VuZGV0OiBEb25uZXJz dGFnLCAxMi4gTcOkcnogMjAyNiAxMDozMA0KQW46IFN1YnJhbWFuaWFuLFJhbWFjaGFuZHJh biBJVC1tZC1kYiA8cmFtYWNoYW5kcmFuLnN1YnJhbWFuaWFuQGFsdGUtbGVpcHppZ2VyLmRl Pg0KQ2M6IHBnc3FsLW5vdmljZUBsaXN0cy5wb3N0Z3Jlc3FsLm9yZw0KQmV0cmVmZjogUmU6 IElzIGl0IHBvc3NpYmxlIHRvIHR1cm4gb24gcGdfc3RhdF9leHRlbnNpb25zIGF0IGEgZGF0 YWJhc2UgbGV2ZWwNCg0KT24gVGh1LCBNYXIgMTIsIDIwMjYgYXQgMDg6NTQ6MDRBTSArMDAw MCwgU3VicmFtYW5pYW4sUmFtYWNoYW5kcmFuIHdyb3RlOg0KPiBJIGhhdmUgdHVybmVkIG9u IHBnX3N0YXRfZXh0ZW5zaW9uIGZvciBhbiBpbnN0YW5jZS4gVGhpcyBpbnN0YW5jZSBoYXMg bWFueSBkYXRhYmFzZXMuIEkgd2FudCB0byBjb25maW5lIHRoZSBzdGF0aXN0aWNzIHRvIG9u bHkgb25lIGRhdGFiYXNlLg0KPiBJcyBpdCBwb3NzaWJsZSB0byBkbyB0aGlzPw0KDQpEbyB5 b3UgbWVhbiBwZ19zdGF0X3N0YXRlbWVudHM/DQoNCklmIG5vIC0gc29ycnksIG5ldmVyIGhl YXJkIG9mIHBnX3N0YXRfZXh0ZW5zaW9uLg0KDQpJZiB5ZXMgLSBub3BlLiBzdGF0cyBhcmUg Z2xvYmFsLiBZb3UgY2FuIGxpbWl0IHdoYXQgeW91J3JlIGFuYWx5c2luZyBmcm9tIHN0YXRz IGJ5IGFkZGluZyBhcHByb3ByaWF0ZSB3aGVyZSBjb25kaXRpb24sIGxpa2U6DQoNClNFTEVD VA0KICAgICoNCkZST00NCiAgICBwZ19zdGF0X3N0YXRlbWVudHMgQVMgcHNzDQogICAgSk9J TiBwZ19kYXRhYmFzZSBBUyBkIE9OIHBzcy5kYmlkID0gZC5vaWQgV0hFUkUNCiAgICBkLmRh dG5hbWUgPSAncG9zdGdyZXMnOw0KDQpCZXN0IHJlZ2FyZHMsDQoNCmRlcGVzeg0KDQo=