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 1nMht9-0003Tn-EB for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Feb 2022 03:00:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nMht8-0000MB-2l for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Feb 2022 03:00:22 +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 1nMht6-0000LB-Ty for pgsql-hackers@lists.postgresql.org; Wed, 23 Feb 2022 03:00:21 +0000 Received: from esa4.fujitsucc.c3s2.iphmx.com ([68.232.151.214]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nMht2-0004YU-2h for pgsql-hackers@postgresql.org; Wed, 23 Feb 2022 03:00:18 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1645585216; x=1677121216; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=nRMrp/H0DsdU2QbsfGq5u9EUGG+/FzzrVHqE/y61e44=; b=fskaNr1loRlFY0Nx+QqYUVj5DroeNbo2D+mcGDEaS+Nxx/J4gt20aiBn Z5xh3xn/nICqre8Q1Dtdf2s4pxeTNPHwiIDwtNMuPmsQd6+wbXt/8mpn+ piQWc0VggRRwEy3Md6eSM+oQqaLGe7ZcYt6wpKoYhpA9ZNUQOnJ5a/b45 e3PdR+cYsceyDX6YZReBgTvsaujj4fhGW53lvbHnYfvnOgMMBv1Ca0or/ KOBh7BaLEcX/PkaSv7b5WUKczeTtuG8Wm6jvnglsEhRPfoTLeSEWlDR/I 7By3TOeRy3dI/O9GIRMVyM3Y7ET3EOoaQB6H1DTqRl/UTlg7kGG+GdnCo w==; X-IronPort-AV: E=McAfee;i="6200,9189,10266"; a="58178563" X-IronPort-AV: E=Sophos;i="5.88,390,1635174000"; d="scan'208";a="58178563" Received: from mail-tycjpn01lp2170.outbound.protection.outlook.com (HELO JPN01-TYC-obe.outbound.protection.outlook.com) ([104.47.23.170]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 23 Feb 2022 12:00:12 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=LOMoILO4dwTkfpJF65IE37WKJ2vndi+naSRQvqe1z1ifG1Z0iGPrFA2qs1m+HJLx9q8cPHukS+/keaY0YWluE3TcRmWU45AU32xFM/DawUq0QZTDn/A5vrb31Ogrsx72p3tPUZsFu3FQr7xGHuU1SLl6YnVD1XnhhlTXc4LPEN8Ge0Dd5692Xg5ryDFQ8zyhKVtnAyllV9QRCMhBhpbnGCHeCfthVtLZmB1Yig968APeNFyR95KbUigibAzUxXWTKEg52jE9HBKIJaPz9PczXuHFKCvlT63gmhzCZeYazhlCNHOka4kpfdJREJF+t509KFyxs34Rk32iOJNsyLdsZA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; 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=nRMrp/H0DsdU2QbsfGq5u9EUGG+/FzzrVHqE/y61e44=; b=KELPItlWDIS7zlcGFbHyf6BMmD3rWXwlwxF2ZpgCHuNtwpcFA7oGunbbT9QtmUciL9t3J8Ts2fbyiXqbRNHmL1SZm6ROIu3uDzYBm5v6WPYbBIjrb3RnenfryvR5/V7otJzo6nHsZJOZsFXbvWqVLwOqLiP9+L0O2MrhqvcVDBSXODnPBihWSym0fbCy4KZDAaVSaN4izooglpdi4Lj4Jf+dADNXOkmUkFQTSb8cl1FsaInMsM8TKDTMH99iZocs+Ygv25U9bEvCZCDJNGd+ju+CX2OI0yHDpQjp2zt36wCAXwT8xkNr+VGUpIkWPf6gtUIHcQhkH0Vz2kW1vEQu2A== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.onmicrosoft.com; s=selector2-fujitsu-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=nRMrp/H0DsdU2QbsfGq5u9EUGG+/FzzrVHqE/y61e44=; b=CNtfBXTYNIOam90YleZV7pIcU8ILXlMxczb8DGbkMN57PRCqzzA2fzUed/yDG7f1XQpvFj4+gpfzKy+uNKUaotLYnql+AXbkdtxtqQnKqIDhOwi5upo50FnXLbBdQj2SSfNn/Ajw0uJH5AUzqjBGThBkhSXf6JAHVViCoblbDzQ= Received: from TYCPR01MB6128.jpnprd01.prod.outlook.com (2603:1096:400:61::7) by OSBPR01MB4549.jpnprd01.prod.outlook.com (2603:1096:604:76::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4995.16; Wed, 23 Feb 2022 03:00:09 +0000 Received: from TYCPR01MB6128.jpnprd01.prod.outlook.com ([fe80::d4f:4d0b:a8be:1571]) by TYCPR01MB6128.jpnprd01.prod.outlook.com ([fe80::d4f:4d0b:a8be:1571%5]) with mapi id 15.20.4995.027; Wed, 23 Feb 2022 03:00:09 +0000 From: "tanghy.fnst@fujitsu.com" To: Masahiko Sawada , Amit Kapila CC: Andres Freund , "David G. Johnston" , pgsql-hackers Subject: RE: Design of pg_stat_subscription_workers vs pgstats Thread-Topic: Design of pg_stat_subscription_workers vs pgstats Thread-Index: AQHYEbU6wJ+bs5G1WkKOVpOHDlrhVaxzmY2AgALFYgCAAGqdgIAAiTuAgACiIgCABk5WAIABXWkAgAAR4gCAAC2ZAIAAC4gAgAFfMwCAE8TegIAA8RqAgAAukgCAAu+DAIAAyxWAgAEefoCAACgpgIACWgUAgAAbaoCAABpxgIAACscAgAAZZ4CAAVaggIABY9rw Date: Wed, 23 Feb 2022 03:00:08 +0000 Message-ID: References: <20220215182641.2cejma6tcgeoqyw2@alap3.anarazel.de> <20220218203255.d3evl6qi2n6gxy6b@alap3.anarazel.de> <20220219160203.y5w2ktc2utthn7pe@alap3.anarazel.de> <20220221053453.lo6fzmji23ennvgj@alap3.anarazel.de> <20220221074806.nyhdberpuwbcbudp@alap3.anarazel.de> In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: af3a0eea-3a85-43bd-95dd-08d9f6789a06 x-ms-traffictypediagnostic: OSBPR01MB4549:EE_ x-microsoft-antispam-prvs: x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: D8+TdFv9HWKjgsZ3Oguk9UMQ3LdmSZX0FLOxCmuKc4FtkzVwkR1Sf78LF2xDWz5O3MWwDGmaffrvXpnpgqUWqq5m0HV5LfPfkVIC8zQBAyeepGgJRY4fGlM2Hq++fJMDdw695ZuZITkfIgN5ECNVUW4C74+SyTRCxozwS6e2k/6iXrSSdowL05N1Nn6jVdsevE12tsEbwXhI/vtSp5a2bAornFBwo1+OmtPIFG4JXqauKyA0aEcFeQQk8f9siP2MLRX9r7eHM1hgYU7gnf35IExjwl86gxoLoIvDCgmD8YF4QpeSJ9mf1DOTCKLnWrcld3pmpXvKmy5NaiaKJxzlUvC6KqP6GCtbl9g9XpFaR/fGUGQF1yq+HiQJm5y2bT9onpn/a9Wzc9DTQskGytnTW6vzXvYiXVV+CXjk7h0Gm7jCtF6ZdaYH4SdULNT3TzoUf4uboTcOcaoGyVWByvIEvLPMoD0H9QKotYlbFonfRugiPPb6RrjImD754R8AvutrBjH8kW3HGAFYEfqUXCZqn8CA7u+fg/luuBn80bVKhQOYYpHbzd/vErfsAMmajQLiWsuXELjsJgUYVXPi9nOqA6DY/bmA5aApXwuLGfoivomkGOfWspXtYuJzu17cY8mjPuRPbtmqm1j/tJraleJZtHzedcw5myEyhrbmxsgv5YbwBvMXPhpsAGSs7Uvka9O3rKCvcub71UFep3kGJX17Ew== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYCPR01MB6128.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230001)(4636009)(366004)(8936002)(7696005)(55016003)(76116006)(52536014)(6506007)(122000001)(53546011)(508600001)(33656002)(86362001)(186003)(8676002)(71200400001)(5660300002)(66556008)(66476007)(66446008)(64756008)(66946007)(4326008)(38070700005)(26005)(82960400001)(38100700002)(54906003)(85182001)(83380400001)(9686003)(316002)(2906002)(110136005);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?SVlaRmRsOTFsTXJRbHoxUFZUcFZlM29zNlM0TjVPeVovVEtKRGxjNXJURDc0?= =?utf-8?B?U05lRndqWFBsUHUxUEZrR1BuNTFYZ0NESG41MkpvQzdXYUlkSFBiRWVhdDBZ?= =?utf-8?B?UDBwajJXcUZoTG1sd1hOdzMrWlZNdGJYNkNpdkFDNklVN2g2b0lZOEkydmhh?= =?utf-8?B?UDdicm9mbS9rSUxyOGpRd2ZpbGxRZUNQWEdSVzJlbkppQkRXNEovY2JLNjNH?= =?utf-8?B?MW9RK25tdXg5Y1ZRZ1pQYjRobjA0UldNbjFXdmVLZEVxMTdmSlphUk9xZ2RS?= =?utf-8?B?bWdFZ0hweG1jaU8wZC96aVE5blBGeGh3T203Tk5uU0lpT3BwMVlHR090KzNO?= =?utf-8?B?dTlHNXNDWmdIdjRmWEYwTUVheFJFU2NKMERkRUxRQmRKbjM3WlB5TVlrZHl6?= =?utf-8?B?N3FUS0xpVlNTN2MrZnNSeks3VnlhVzBZSnZscXJUK0VENGV5NFFLaTluTEhB?= =?utf-8?B?QUFwR3hWaTB2S1dObXhMWVlQS3VQQWdxa0FJaDF1RkE4YldIK3dtdGN6U214?= =?utf-8?B?Z2VNT0htY1I4ajlydTAyNTVjQkQ2ZEx6OGZtZ0Q1US9uKzg3dXFKamlPQzQz?= =?utf-8?B?dGJpOWNITVRycUJOZGhoOGtnWVNidXZHLzVRVzArdWZvQlV1dkIycXZKMjR2?= =?utf-8?B?NmVYWkZYUUhpbUFzNUJhSlJDYXhoWS9FaCthRGZNekhUZVk2VHI3TDVhdVlp?= =?utf-8?B?YXJoMHFTQi8xUHlaRXc3UmMySDVDQml5b1NDZ2xyY0RjeFczVXU1WGw5TzBw?= =?utf-8?B?V2N4Tk1Yb0lLVjBDU3dtWjA0d2tvalBTeXpLbU4ySGFGVFNpenhiOWFrMG9O?= =?utf-8?B?ZDRJNG5DeS9LWWFxeVFGME5aajRFYnVHN0F3aTZqMjlYS3czSUM3YndEVEFH?= =?utf-8?B?eXhUTVhrSzRrWE9DbExhZ1BSbEFHWlBVeXcwMElwa3BKbnExUFNpdDl0RWdu?= =?utf-8?B?a01ma1VlMUhIS0RlRnVmd1c4MDdFb2p5a2UzS0hmQmttSFVpSDFCckk2OU81?= =?utf-8?B?MVIzbDNEaHFEK3JOUXY2Q2xlNWFCUnJQL214R2dCR3YwNmFzRjBHTFVqZnlv?= =?utf-8?B?SGxTQmowSS9PWml3dCtXQldYM0RQYXIxWWZkcElERis5SnFyQlk2clJ2SnM0?= =?utf-8?B?TVY5bjNxRGJoeURzOXZBUGt3cC9rdldFZ1UvTDRUVnJIVEFLWUNYNXJQaXVq?= =?utf-8?B?OUZxWm10OVIxZDNGa0xlVGVQYzV0WEI3VkFCd0t2a3crOExxZ2tvaXZYOWVJ?= =?utf-8?B?Rlc0TFNqRS9sK2tSbWVEa0UvNmFzbjlzaWlLZnZodlcvVmhPY2xRRGhLWWQ5?= =?utf-8?B?Q2V5blJjRG9GRm1CZEpLaUpqMGxRenFZTkhOamtDUnZZWXVlN3NzSlJtUXV0?= =?utf-8?B?UVRqSEpWVEZvdkxVNHF1SEVFcUpDMHJRN1N0Rmd3Q0dBaDJoZmtlUWd1U1pp?= =?utf-8?B?aXhacWZmd1o0MTJSbTdrNkQ0NFU4cDhTVGhRTzVSYzRWcVVjTGgyV2FudGVF?= =?utf-8?B?blVpS0g4UTUrNzFITXpUNENXc0dBdHgwaDFmS3A0VDJZMVJMNGdpL2pkRGV3?= =?utf-8?B?ZnJSaDR0akpCOXUzM05oNGo1ME5vcTdqR0VuNGdDWmlMNkx5ZlpTQllKblF4?= =?utf-8?B?NjcwSlg5Q3dIWkh0aTQwWmN5WkNxRlVQSkF0R2loSHpQY3F4Q2JuYlZKUGRC?= =?utf-8?B?ZTdsMTVGRlhRUVdySitPZFhaQzFsa2dXM0w2R2RXay8zenE4U0NNVEVoVXJE?= =?utf-8?B?b0Z1cWRreEdHOUY0YkI4WTlKNGYzYi9NWDdPbEtpVnA0bmlDTmFKaHVualFM?= =?utf-8?B?aXNBeFJROGJYdyt0WmU3eUJXMWh5K0JRb0pLWHFhYUhvWSt2bEJTYzdtTEt3?= =?utf-8?B?aFhzNCttcG96RnNPWGN0UmRWcDRSb1VCSzBseFVSOFJBT3FLN2tYZkxoOGEr?= =?utf-8?B?OUZtZlFkR2ZYZkhqYldpOFJ1Ujd0U1lkLzdLSTVsQjBXUXdING9nZ1oxR08x?= =?utf-8?B?R2JPcC9BTG8xWlp5UnBkM2RER1pGVFRMei8zbGMxaG9JRUs0dFlOMU1BREcy?= =?utf-8?B?T0VlcUFGQ1JNa3YveXJrY1VoaFlNMXdYby9FN2ZhR3YxMkFObWVVOS9ZNkZm?= =?utf-8?B?ZktJbDJvZTg4ZkJmT0ZEMzRKQmM4bnZCMDNtczluTG9Bc3dzSW1qQU1CZ0Jx?= =?utf-8?Q?gyKP2wKaBymWbjOtDe5h1H0=3D?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYCPR01MB6128.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: af3a0eea-3a85-43bd-95dd-08d9f6789a06 X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Feb 2022 03:00:08.9173 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: Dqy62T60AdwLnFZ3cLqxkTnvuN8+nbdPD3AfKrLEt+zYoItbM8IuBpLnWnN7BYhPxzcWpV8iAdsHJqZCIueFFw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSBPR01MB4549 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVHVlLCBGZWIgMjIsIDIwMjIgMTo0NSBQTSBNYXNhaGlrbyBTYXdhZGEgPHNhd2FkYS5tc2hr QGdtYWlsLmNvbT4gd3JvdGU6DQo+IA0KPiBJJ3ZlIGF0dGFjaGVkIGEgcGF0Y2ggdGhhdCBjaGFu Z2VzIHBnX3N0YXRfc3Vic2NyaXB0aW9uX3dvcmtlcnMgdmlldy4NCj4gSXQgcmVtb3ZlcyBub24t Y3VtdWxhdGl2ZSB2YWx1ZXMgc3VjaCBhcyBlcnJvciBkZXRhaWxzIHN1Y2ggYXMNCj4gZXJyb3It WElEIGFuZCB0aGUgZXJyb3IgbWVzc2FnZSBmcm9tIHRoZSB2aWV3LCBhbmQgY29uc2VxdWVudGx5 IHRoZQ0KPiB2aWV3IG5vdyBoYXMgb25seSBjdW11bGF0aXZlIHN0YXRpc3RpY3MgY291bnRlcnM6 IGFwcGx5X2Vycm9yX2NvdW50DQo+IGFuZCBzeW5jX2Vycm9yX2NvdW50LiBTaW5jZSB0aGUgbmV3 IHZpZXcgbmFtZSBpcyB1bmRlciBkaXNjdXNzaW9uIEkNCj4gdGVtcG9yYXJpbHkgY2hvc2UgcGdf c3RhdF9zdWJzY3JpcHRpb25fYWN0aXZpdHkuDQo+IA0KDQpUaGFua3MgZm9yIHlvdXIgcGF0Y2gu DQoNCkZldyBjb21tZW50czoNCg0KMS4NCisgICAgICAgPHN0cnVjdGZpZWxkPmFwcGx5X2Vycm9y X2NvdW50PC9zdHJ1Y3RmaWVsZD4gPHR5cGU+dWludDg8L3R5cGU+DQouLi4NCisgICAgICAgPHN0 cnVjdGZpZWxkPnN5bmNfZXJyb3JfY291bnQ8L3N0cnVjdGZpZWxkPiA8dHlwZT51aW50ODwvdHlw ZT4NCg0KSXQgc2VlbXMgdGhhdCBQb3N0Z3JlcyBoYXMgbm8gZGF0YSB0eXBlIG5hbWVkIHVpbnQ4 LCBzaG91bGQgd2UgY2hhbmdlIGl0IHRvDQpiaWdpbnQ/DQoNCjIuDQorIyBXYWl0IGZvciB0aGUg dGFibGUgc3luYyBlcnJvciB0byBiZSByZXBvcnRlZC4NCiskbm9kZV9zdWJzY3JpYmVyLT5wb2xs X3F1ZXJ5X3VudGlsKA0KKwkncG9zdGdyZXMnLA0KKwlxcVsNCitTRUxFQ1QgYXBwbHlfZXJyb3Jf Y291bnQgPSAwIEFORCBzeW5jX2Vycm9yX2NvdW50ID4gMA0KK0ZST00gcGdfc3RhdF9zdWJzY3Jp cHRpb25fYWN0aXZpdHkNCitXSEVSRSBzdWJuYW1lID0gJ3RhcF9zdWInDQorXSkgb3IgZGllICJU aW1lZCBvdXQgd2hpbGUgd2FpdGluZyBmb3IgdGFibGUgc3luYyBlcnJvciI7DQoNCldlIHdhbnQg dG8gY2hlY2sgdGFibGUgc3luYyBlcnJvciBoZXJlLCBidXQgZG8gd2UgbmVlZCB0byBjaGVjaw0K ImFwcGx5X2Vycm9yX2NvdW50ID0gMCI/IEkgYW0gbm90IHN1cmUgaWYgaXQgaXMgcG9zc2libGUg dGhhdCB0aGUgYXBwbHkgd29ya2VyIGhhcw0KYW4gdW5leHBlY3RlZCBlcnJvciwgd2hpY2ggd291 bGQgY2F1c2UgdGhpcyB0ZXN0IHRvIGZhaWwuDQoNClJlZ2FyZHMsDQpUYW5nDQo=