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 1vxr8A-00HCMO-1g for pgpool-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 18:39:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxr87-00DtfN-2k for pgpool-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 18:39:32 +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.96) (envelope-from ) id 1vxr87-00DtfF-1u for pgpool-hackers@lists.postgresql.org; Wed, 04 Mar 2026 18:39:32 +0000 Received: from mail-norwayeastazolkn190120002.outbound.protection.outlook.com ([2a01:111:f403:d20f::2] helo=OLAP279CU001.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vxr85-00000000Zvq-0r3p for pgpool-hackers@lists.postgresql.org; Wed, 04 Mar 2026 18:39:31 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=x8crxTpOBS/PHWrRwobS4eeRzfROrDIFUuWM6FT5AGaq/m9lzfuOM4hW5UBW5hpH1GD9zp7GbxUSb1RGvIOr3s/DIUxvgETtIr7/7kJ7708n6/u7Y4a3meJuWvycU7yViP5xWnl37QdPTkwTJ7yRpL/3oTpbzKc1lmvJIlZVLON+T/AODpWi7zVAbnPvxeCp+4VTrO9dE61lZ7yAUO3u+2vO4bD1mwsjrkVlP7zU/raBiJuEcT8v83hMmxZ2SMoSf1H2Rak1+CQqGDNBjdLT0SJB0SHToeLsfX7nB8Z3kvcUGAXdJ5v+JaQT/6EZLUcSGP1xY8IwBtGxAwzZ5pJoCA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=hNasGRg3J4XIH1pjqZdhHJ6+Ci1PYn3ckYUx1uJibGI=; b=Desnmo7a3h5XKNTdwwp0KUFePXbfjLNG4KIjjv8pkjiRn0DnYx+trfCWZPMRnLYcEYaAhHyuqXKikHp3CMSYYD+2y6mK4JxFR48Lzkjil95Uxqlw03S7bhz7zIMWIbQpJ3mM43CQA3IEieNiQwJ49nna65FpkYaBhTt4GA2T1leRGZPbtO1OiW3hyuE+fC7+F00pD43NSMCu05D9Sd5SyiPGC/yCFCeEKq+MC8peQI7+vHADqo/FsfaKFztdu2Jx8N8kh5TEzbgxEsDDNhNncqS9qRjxBVXEIwRXpLeKC2J25OUlEapg9Fox1Fg5NPopi1R87+nn5ODXYiUxQiov1g== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=live.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=hNasGRg3J4XIH1pjqZdhHJ6+Ci1PYn3ckYUx1uJibGI=; b=j0Yct1p/0UNBS7SmequhAgHyO8XKHbzlyFkL+VUfQrXAtFx5SxPmSv6qE0txw5uxPre7RrnDjYgve9XxiyA8lAkF5g3lftS0CTT7aUHVHaXxIl4T+ef0yEd1dCpmuSj3xDxchdROfNWdD1mvYnwUe5jlp+174e1Axujm6Q3/np+hzaE/bBGZN73f2rxONmVmuA8egYLlhUZfd0EajcIxM7I4cQyNXnGY2+FMkbylZy/IT9uLa7pMQEN79WAqtuWmPWU8emWrgH8G97y1kZEGfXDJq94yplc5pOUzOLwRyrtBbRvuZqCnDu1XXVeRTwvJOblh9zKBGCQMjRBVJ8k1fg== Received: from SV0P279MB0514.NORP279.PROD.OUTLOOK.COM (2603:10a6:f10:23::12) by SV0P279MB1429.NORP279.PROD.OUTLOOK.COM (2603:10a6:f10:39::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9678.17; Wed, 4 Mar 2026 18:39:27 +0000 Received: from SV0P279MB0514.NORP279.PROD.OUTLOOK.COM ([fe80::e7c:395d:b081:b1bf]) by SV0P279MB0514.NORP279.PROD.OUTLOOK.COM ([fe80::e7c:395d:b081:b1bf%7]) with mapi id 15.20.9678.016; Wed, 4 Mar 2026 18:39:27 +0000 From: Yishai Tamir To: "pgpool-hackers@lists.postgresql.org" Subject: [PATCH] Downgrade elog(LOG) to elog(DEBUG1) for pi->node_ids in get_pools() Thread-Topic: [PATCH] Downgrade elog(LOG) to elog(DEBUG1) for pi->node_ids in get_pools() Thread-Index: AQHcrAY3yYWregLvpk2pbHEVGpM8cg== Date: Wed, 4 Mar 2026 18:39:27 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: SV0P279MB0514:EE_|SV0P279MB1429:EE_ x-ms-office365-filtering-correlation-id: c12babe5-e87c-4af9-bbfa-08de7a1d5d67 x-microsoft-antispam: BCL:0;ARA:14566002|12121999013|39105399006|8062599012|8060799015|19110799012|15030799006|15080799012|461199028|6092099016|31061999003|20055399003|40105399003|440099028|3412199025|102099032|26115399003; x-microsoft-antispam-message-info: =?iso-8859-1?Q?xrahveccrJbIkRXKUIPpUrM8+NoOIQvac8AGE7o8D1IDYcIOeU5dP7YRN+?= =?iso-8859-1?Q?E9uojTdqbOh1stOlws6GJuLPNTdBdsOIoCl/uVazUPFbIORM5vaeldoQWY?= =?iso-8859-1?Q?u+SwOhFp+KV/Lph2SRDplhlgqG6Keqj7f2PUnpNEFiZzGd9OUQPsAcWE7i?= =?iso-8859-1?Q?/A/kD1+D2GTpC4hlD5/xtyvP862BX2LfMHCvYLQh4ZYoearSVnr8TaO/x3?= =?iso-8859-1?Q?ETm0MtTbvqKkgYwEvJ/a2N5fDMR7V1WYEWthQs5tPIDXlAbVlOAvSCP/gJ?= =?iso-8859-1?Q?fzNvwBOHKo+hcjMxXJDfv/34LoQldoMRNwSUjQSvJJdluRZNeo+DXuMonW?= =?iso-8859-1?Q?4QVnyv4bQ/m65swpf/x0wqP4z8BKrlfwtAF7VL843LUEmJ6jtF0E/Vv/Px?= =?iso-8859-1?Q?aNr52VSLthTjFxxmTjawgNXn4kaMy78kPBd6BMQ4dlW2LJzjHkuzH/ZNC0?= =?iso-8859-1?Q?lXO5MbnK8nqn5dnSBRw0f+kSHg9vJlwurGezyXb4pXzrRN9sk3xLnMwnAP?= =?iso-8859-1?Q?UhW3MMJYeoGT0HCve9yo/imlmkuF/ingjTQ4o+GEOtljkg5M++aoZ9+jre?= =?iso-8859-1?Q?Wzv38J8AI4/1VRJ1xWYaZifo5K/Tw2+tVxTM9RW3NQU8xKrdvAuzUvcqw9?= =?iso-8859-1?Q?k6u+sX7CfMks94t0ERZyTHiG7p3bQO/1uXZ144cGPE+pY8yY7pbtXh6aft?= =?iso-8859-1?Q?g+sY6AMf75K7gAvUb9oHldCRGcLO1ReetaI5jj+H8DAIjcFmMI7m+hSCSX?= =?iso-8859-1?Q?XhQZF4uvLuEsWY1ekoADs9wBLeIMnk+s45sglP95lvDnyLKPBS2peyJgtI?= =?iso-8859-1?Q?VQksYZFWu8LQONYj0Hz6kDBsLg2uYTlD2poEdyxNRKl1FfiZRpDfTpdtPh?= =?iso-8859-1?Q?BeDBUApOq18brBGLXXPbzHDug8WzIWFWsHHY8myirUuwOqQtoWIJuV5H/Y?= =?iso-8859-1?Q?YzPkRSesaa44++8OBhAwn1y8E3D/hHdYHubBgv0+6Ti4ah/DF00aEbjZxK?= =?iso-8859-1?Q?2kqdvBZmg3ol5/Xxf3tJBDfa821/0/9w6SAfnmKjrRi0/hsVjN0dIRBWg5?= =?iso-8859-1?Q?/3Zs2hUHiK25KykX+REUeKo=3D?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?R+6WB0Dgcmt+spZY/7Trpv6wAEh9s/mfNsms3DzJjnqcN6RXNn8swjmgN3?= =?iso-8859-1?Q?3hnfkwTZJXBhy6PqGM5CJLee48e9lgSYwCUIu35mEJUsMdyH9l7jjvrR/3?= =?iso-8859-1?Q?SHi7bx06romUKhmL1XtFFHCmkTIN8zHzT7OV7FcwdwK7PsNG1aZiTX9UeF?= =?iso-8859-1?Q?dTom9JTeuJq1FPKVHgLS7zHhidBb3Tbud3bAJ8lkeTUHrytbn78tZZD7Nh?= =?iso-8859-1?Q?suMKMsj9D1P93LaAsj3JW8gu+ZMLh3XudZkjO5ZARosyWIqTdB5kpa+jsm?= =?iso-8859-1?Q?NbSFLjMTLCibSZflZWsn4WQ2sBE3Aw5p99apl6i7sRzCSK0NZ2q6z5wcG+?= =?iso-8859-1?Q?/iGmduLjykwnuzTyc5znIuuR2jmxf7P5C20+u32hLvsHbLz1KdKPfjS3kY?= =?iso-8859-1?Q?TNOL+ZpwqAHy3uFma8x/g9z6o3jcaBgGUWLCKZ8iRi7yQd4SaM1Lm+BUlr?= =?iso-8859-1?Q?eV3cbgxrO0qNjU6r5w6QvrZ9ZS2iB16ocZ5+IK4bzCdXrKGS67h4tw4vIs?= =?iso-8859-1?Q?/dykbfj05uHSwd0mSfSiBeowEgU039TevcPKBXmf+65YOChp/Dxpb4umng?= =?iso-8859-1?Q?8jNl/rcEPDg56XFoIQJAXP6gsGesp8VoWc7TN9+V/7Ys3cCLXvifB+wJIu?= =?iso-8859-1?Q?oIp5FcQ8RYa5la1BgrtLL+fdhYmnuD1X3fRMF6rhXDgz0DdlMxrOlOgttY?= =?iso-8859-1?Q?aIJ90YODQ90dlZDuMjXtQNWm0q1MVv+7Nf5ErHwwTDBXeNUwwwpkhl7JRQ?= =?iso-8859-1?Q?r5HCPigf7Zkw9y3wFBGmzWCufilAL8GpeX1Eycp5mnHO8ws0cWSazZsdUK?= =?iso-8859-1?Q?qBdvd5Aob7Kc3zqldMMf78hoxXZXfzuEGYb+6ZaT2dHOJsLG9IGIPoW4S0?= =?iso-8859-1?Q?4vaSBT+C02Z4KErld1OIwmyXHVGnUMH1Sdykwzd1VAAT9LIeXDmethA4en?= =?iso-8859-1?Q?kDWrUu/ViyWRb0HfvaNcAvWcOLBp0IwlSpSrrsCA6FD4bBJ3untGSmmYkW?= =?iso-8859-1?Q?rvFx9VQoI3UI96RFVK36EDVbYiG/45ZU5kMUo8kB8opq9u4n1J9U66cQuT?= =?iso-8859-1?Q?d+qsBPbraN7yWQXb2mt84Vhv2jE/MgKKUkAPVZMHjZMod2s9SEQ/m4ERGr?= =?iso-8859-1?Q?fD3btEMJtLmRvkWc/eP8Cwcfk0jR8vCUSj65rGevN1zu6rnuuR1Lo7fTrU?= =?iso-8859-1?Q?QzS86F1j1qbXdgmfGHcHhOf5QDUQRq8R8rxgSxfLr1FOomlz28BlatHGQP?= =?iso-8859-1?Q?wRwacnQgFAfqZR7KkXyE2KZF9XYMT00khl07zC5vQbfpP2EyQXS3tzIjul?= =?iso-8859-1?Q?E8mxI0XtUE/LB7FMzl7W0HamwjVFZPhwip8qJpaynkSnz4dliD2wbG2KyY?= =?iso-8859-1?Q?omZa//HF5PDm0/Rpg+a9J/qMiPmyN2uXDSu7Pfa5EL3M1NfZ6lapc=3D?= Content-Type: multipart/mixed; boundary="_004_SV0P279MB0514A33CA35ECDDA515E7F82C37CASV0P279MB0514NORP_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-9412-4-msonline-outlook-ecede.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SV0P279MB0514.NORP279.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: c12babe5-e87c-4af9-bbfa-08de7a1d5d67 X-MS-Exchange-CrossTenant-originalarrivaltime: 04 Mar 2026 18:39:27.1773 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: SV0P279MB1429 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_004_SV0P279MB0514A33CA35ECDDA515E7F82C37CASV0P279MB0514NORP_ Content-Type: multipart/alternative; boundary="_000_SV0P279MB0514A33CA35ECDDA515E7F82C37CASV0P279MB0514NORP_" --_000_SV0P279MB0514A33CA35ECDDA515E7F82C37CASV0P279MB0514NORP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, The attached patch downgrades an elog(LOG) to elog(DEBUG1) in get_pools() (src/utils/pool_process_reporting.c). The elog statement was added in commit 706ca859c as part of the pgpool_adm_pcp_proc_info feature. It prints pi->node_ids bitmap values at LOG level for every connection on every backend whenever pool status is queried. In containerized deployments where a metrics exporter (pgpool2_exporter) continuously polls "show pool_pools", this produces thousands of log lines per minute. We confirmed the fix eliminates the spam on our staging cluster under real production-like traffic. Since the message is purely diagnostic, DEBUG1 is the appropriate level. GitHub issue: https://github.com/pgpool/pgpool2/issues/153 Regards, Yishai Tamir --_000_SV0P279MB0514A33CA35ECDDA515E7F82C37CASV0P279MB0514NORP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,

  The attached patch downgrades an elog(LOG) to elog(DEBUG1) in get_po= ols()
  (src/utils/pool_process_reporting.c).

  The elog statement was added in commit 706ca859c as part of the
  pgpool_adm_pcp_proc_info feature. It prints pi->node_ids bitmap v= alues
  at LOG level for every connection on every backend whenever pool sta= tus
  is queried.

  In containerized deployments where a metrics exporter (pgpool2_expor= ter)
  continuously polls "show pool_pools", this produces thousa= nds of log
  lines per minute. We confirmed the fix eliminates the spam on our
  staging cluster under real production-like traffic.

  Since the message is purely diagnostic, DEBUG1 is the appropriate le= vel.

  GitHub issue: https://github.com/pgpool/pgpool2/issues/153

  Regards,
  Yishai Tamir
--_000_SV0P279MB0514A33CA35ECDDA515E7F82C37CASV0P279MB0514NORP_-- --_004_SV0P279MB0514A33CA35ECDDA515E7F82C37CASV0P279MB0514NORP_ Content-Type: application/octet-stream; name="0001-Downgrade-elog-LOG-to-elog-DEBUG1-for-pi-node_ids-in.patch" Content-Description: 0001-Downgrade-elog-LOG-to-elog-DEBUG1-for-pi-node_ids-in.patch Content-Disposition: attachment; filename="0001-Downgrade-elog-LOG-to-elog-DEBUG1-for-pi-node_ids-in.patch"; size=1320; creation-date="Wed, 04 Mar 2026 18:36:24 GMT"; modification-date="Wed, 04 Mar 2026 18:39:22 GMT" Content-Transfer-Encoding: base64 RnJvbSAyOWQ0YjE4ODY3NGVkN2IzMjhlNGYxZDI5ODU3YWJlMzdhYzFmZTk3IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBZaXNoYWkgVGFtaXIgPHlpc2hhaUB0YWlsb3JicmFuZHMuY29t PgpEYXRlOiBXZWQsIDQgTWFyIDIwMjYgMjA6Mjc6MjEgKzAyMDAKU3ViamVjdDogW1BBVENIXSBE b3duZ3JhZGUgZWxvZyhMT0cpIHRvIGVsb2coREVCVUcxKSBmb3IgcGktPm5vZGVfaWRzIGluCiBn ZXRfcG9vbHMoKQoKVGhlIGVsb2cgc3RhdGVtZW50IGFkZGVkIGluIGNvbW1pdCA3MDZjYTg1OWMg cHJpbnRzIHBpLT5ub2RlX2lkcwpiaXRtYXAgdmFsdWVzIGF0IExPRyBsZXZlbCBmb3IgZXZlcnkg Y29ubmVjdGlvbi9iYWNrZW5kIGNvbWJpbmF0aW9uCndoZW5ldmVyIHBvb2wgc3RhdHVzIGlzIHF1 ZXJpZWQuIEluIGRlcGxveW1lbnRzIHdpdGggbWV0cmljcyBleHBvcnRlcnMKdGhhdCBwb2xsICJz aG93IHBvb2xfcG9vbHMiIGNvbnRpbnVvdXNseSwgdGhpcyBwcm9kdWNlcyB0aG91c2FuZHMgb2YK bG9nIGxpbmVzIHBlciBtaW51dGUuIFNpbmNlIHRoZSBtZXNzYWdlIGlzIHB1cmVseSBkaWFnbm9z dGljLCBpdApzaG91bGQgYmUgYXQgREVCVUcxIGxldmVsLgoKUmVwb3J0ZWQgaW46IGh0dHBzOi8v Z2l0aHViLmNvbS9wZ3Bvb2wvcGdwb29sMi9pc3N1ZXMvMTUzCi0tLQogc3JjL3V0aWxzL3Bvb2xf cHJvY2Vzc19yZXBvcnRpbmcuYyB8IDIgKy0KIDEgZmlsZSBjaGFuZ2VkLCAxIGluc2VydGlvbigr KSwgMSBkZWxldGlvbigtKQoKZGlmZiAtLWdpdCBhL3NyYy91dGlscy9wb29sX3Byb2Nlc3NfcmVw b3J0aW5nLmMgYi9zcmMvdXRpbHMvcG9vbF9wcm9jZXNzX3JlcG9ydGluZy5jCmluZGV4IDM5MDg3 YmM0Ny4uMjU2YzNlOTc3IDEwMDY0NAotLS0gYS9zcmMvdXRpbHMvcG9vbF9wcm9jZXNzX3JlcG9y dGluZy5jCisrKyBiL3NyYy91dGlscy9wb29sX3Byb2Nlc3NfcmVwb3J0aW5nLmMKQEAgLTE3MDMs NyArMTcwMyw3IEBAIGdldF9wb29scyhpbnQgKm5yb3dzKQogCQkJCWlmIChpc19waV9zZXQocGkt Pm5vZGVfaWRzLCBiYWNrZW5kX2lkKSkKIAkJCQl7CiAJCQkJCVN0ck5DcHkocG9vbHNbbGluZXNd LnN0YXRlbWVudCwgcGktPnN0YXRlbWVudCwgTUFYU1RNVExFTik7Ci0JCQkJCWVsb2coTE9HLCAi cGktPm5vZGVfaWRzWzBdOiVsZCBwaS0+bm9kZV9pZHNbMV06JWxkIiwKKwkJCQkJZWxvZyhERUJV RzEsICJwaS0+bm9kZV9pZHNbMF06JWxkIHBpLT5ub2RlX2lkc1sxXTolbGQiLAogCQkJCQkJIHBp LT5ub2RlX2lkc1swXSwgcGktPm5vZGVfaWRzWzFdKTsKIAkJCQl9CiAJCQkJbGluZXMrKzsKLS0g CjIuNTAuMQoK --_004_SV0P279MB0514A33CA35ECDDA515E7F82C37CASV0P279MB0514NORP_--