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 1mniem-0007nl-Os for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Nov 2021 14:44:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mniel-0004so-NI for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Nov 2021 14:44:55 +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 1mniel-0004sf-AA for pgsql-hackers@lists.postgresql.org; Thu, 18 Nov 2021 14:44:55 +0000 Received: from esa10.fujitsucc.c3s2.iphmx.com ([68.232.159.247]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mniei-0006mk-76 for pgsql-hackers@lists.postgresql.org; Thu, 18 Nov 2021 14:44:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1637246692; x=1668782692; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=PT8tIvPkS+GuxvdqXtEtNvlk4ldU8TTnbju4R55p0SQ=; b=wbZJ+/dktwmuoT0nzk1oHnO9SP35YrQ/k+hC8e2spX8Z1zUR9h447cVE 07xt+QANBqM7lUJ46j0l8PaJiiN5JwLW9YNdY/HqMxjF4F4wvN/s1/B0k 4CYBXkuWy90uI0eXP9UeuM6+1aXUDbTcfY3Ylw4NHWEg1AJ8RnfJxc43b tUcmyEIxD6NVsNmI41W9aH3N/Zb5ZLoTgb+47D6FIGLPY1ydRlclj6FLj H6wZMY0p+omxXlyp1cV0E8RAERGzQQs3PiY2bGNdhd5kmgUhgc7F5e749 EFT+5IsqUgXFqQaFmhG0CHUdev+KrQZTetwj8Oop+ZTWYGvoMXjJMZ+mT g==; X-IronPort-AV: E=McAfee;i="6200,9189,10171"; a="44070166" X-IronPort-AV: E=Sophos;i="5.87,245,1631545200"; d="scan'208";a="44070166" Received: from mail-os0jpn01lp2110.outbound.protection.outlook.com (HELO JPN01-OS0-obe.outbound.protection.outlook.com) ([104.47.23.110]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 18 Nov 2021 23:44:48 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=WbV1p9Ir+fRdBtAjOHFCDSJjJHpk8qEMh/7R1satLUkMbwsKxpS485CTW+8cQtHba22MdIdguK2U3oo/m0XEhddj1XaDdPuaI94eHMwylsvuiZYXjI2u1ZnTm8YPXpvNbXwlbLc7APXxuvqK8hHcAtoLcpA3Gwj4cDFU7Dy7ywEDn3O9b+14GFRP2V7xQJ1DOolxZtMushTKsHXxJeCvQWgG6F+IFTG/B+aK4FbFLEOlRDzzihH9mXRl078oc2qkWE4fgA9vVbOi9jy+PzggtYsqRTExy5qu3ODsUPJ355YGNvAfDHiIyFtLk1LgkpXcg4zx/vVf8iBI84nZsW2J6g== 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=PT8tIvPkS+GuxvdqXtEtNvlk4ldU8TTnbju4R55p0SQ=; b=UwmkKKAvQJHvPfftu4vBicdX5jxNIu6GfDZNYJX5jojyJzUPKcK1b4g74u5zLCl1bIjtA4/OuKimHUk5Hwrhf1aSbxQe0AglLmBTV+JX2VruZBD8fIzWh5iCe1LgN0MLDjHT5CPEeAVxBr0iEmv2xwjI1tDRiTOIFe1A6ST27mPjuNF/S9L9gA0eIy9J9tpeCkHKCB7GH5hwbqi+asNXXzmMrMQXoIPPrUTZQqs42AugbzpyK3uRR4gzjaby2f/TQhzm+FfrG0ooE5AvsN2B1IGqUutJ8y9AnzBC1B+sHoX+Hpi/0pl9exCFE4LWD8fnWJMxAnWJywF8FxF4/MClVA== 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=PT8tIvPkS+GuxvdqXtEtNvlk4ldU8TTnbju4R55p0SQ=; b=BT00aWYQy1kR+F76tIP/pvg4RKQQRxVtTWd2GdXZRtb17pwtsZ/zM0Ny4AVKVkO+69kTK8VLE+mrDzLApSXICpvWbGv18MyBq+CNfnhhqPxN++GcbEg6TKLsAZtDynfj0ogxD3j8aaPV7mz91FFLObsTbP3D5Zfnnp1rMse/2xQ= Received: from TYCPR01MB8373.jpnprd01.prod.outlook.com (2603:1096:400:15f::9) by TYCPR01MB7775.jpnprd01.prod.outlook.com (2603:1096:400:180::5) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4669.10; Thu, 18 Nov 2021 14:44:45 +0000 Received: from TYCPR01MB8373.jpnprd01.prod.outlook.com ([fe80::adb3:be1d:5bb2:45f5]) by TYCPR01MB8373.jpnprd01.prod.outlook.com ([fe80::adb3:be1d:5bb2:45f5%8]) with mapi id 15.20.4713.021; Thu, 18 Nov 2021 14:44:45 +0000 From: "osumi.takamichi@fujitsu.com" To: 'Amit Kapila' CC: Masahiko Sawada , vignesh C , Greg Nancarrow , "houzj.fnst@fujitsu.com" , "pgsql-hackers@lists.postgresql.org" Subject: RE: Failed transaction statistics to measure the logical replication progress Thread-Topic: Failed transaction statistics to measure the logical replication progress Thread-Index: AddzxbV4E8towJomTkm1trqmHwIwlgQVlICAANF/lUAAA/6ZgAAn+wOAAAWfTgAAB8XmAAAgvB4AAAU0KgAAB+7hgAAMXNsABZwy4NABa8QD4ADxViZAAZV2mrAA+6DXgAAsU7aAAAZiVQAAAnmZAAAIXu+AAFRfhZAAA/2jgAK/RTlAANYpygAAhIjngAF7IiwAAMcV0oAAfP65gABBZ2kgAL69AQAAEaPLYAAvgi4AADeqboAAwid+sAAFx08QADMCznAAHvUqAAAB2xAAABJwrQAAAVGmgAAc7XGAABenJqA= Date: Thu, 18 Nov 2021 14:44:45 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfRW5hYmxlZD10cnVlOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJh?= =?utf-8?B?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjEtMTEtMThUMTQ6NDQ6?= =?utf-8?B?NDRaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?= =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?= =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?= =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?= =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?= =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD0yMDZjOWYzNS0wNTMzLTQyZTMt?= =?utf-8?B?YTk1NC02NmZkNjBmMjEwY2U7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?= =?utf-8?B?MmFjLWFiNGQtM2IwZjRmZWNlMDUwX0NvbnRlbnRCaXRzPTA=?= authentication-results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 2d07140a-428e-4d7b-95d9-08d9aaa1f6c2 x-ms-traffictypediagnostic: TYCPR01MB7775: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:7691; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: ySP14Vwyc8KK5oUV431z8VgfyiIMnnLKmfKELECn4zTkV4qDXvsdJrgK3P38k9a1/CUKjgDJFh3qNWV+T5qUo2m/bOo7ldH2HCVBJTu05xooChZhvgYfF/lGpF+d0Xc5+vuVn4Tch/Qf52B5ZfmEOYRoGubmKcAME5HRXKJCQY6LSb2mnlZgx7Gf0jSOHGUa4Jv268boLKxSL9DYHlBBhwGfJPmCT6R8xvW5gt9ki4aroEawjI/L++aPJV04PM1sFJfr5pm+OX+lFc8ZqWT7xllU90YX7agn3LXTF0KBf0JjWrIq0hdE+FF8PBp8BIt1NxmPoLyYbetQ2cIruVGT82U+fyXry+WIAe2jNiz5+6CEQUJeF3mTTB7iJVUPB4Qunfl9xCkjpnoSqSQizAiKnB6CzFSIauq5wAwTpz9JYXauxvKcahrJTiG0l53tMxJmkVlgChRTbX45k6HavAWOHIyiaeqLjwN/V6FmdlC3Vgbu6AcbBgVx4sUW+7GfD5IQ8byCRXX8QRIwKeFqvkehEyZGsvQQ/yg2uLQkQUMQcCEnfTnB/e+t9k8i2bjogi1I4caH8CZo3Hu4PaKef3tdCO7u03UheYsT5t07AHekwmmGN+CZ2plBp8dO6Nd6gPtUzBBLELnpN/cOi3jYOZw0nCJOesrmBFjsrR9NkgR73NlgCXvK5KhF48x/dYZRuSN+9jvOtqaEmy6PFkk7Nor+eh4DoPBxyJi6zFOS6rKSvQoinOxR8haF3E6nCsdBlyxcTDTo0gf/a225btFmLuWJlHlZQstSAS+6ca0eFz0vMvk= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYCPR01MB8373.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(4744005)(38070700005)(8676002)(2906002)(7696005)(82960400001)(26005)(33656002)(508600001)(52536014)(86362001)(966005)(55016002)(71200400001)(45080400002)(64756008)(6506007)(8936002)(38100700002)(9686003)(66476007)(66446008)(6916009)(54906003)(5660300002)(186003)(83380400001)(76116006)(4326008)(316002)(53546011)(85182001)(66946007)(122000001)(66556008);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?M25yeDhlMCtlYzFjeFozNDg3Uzd4cE11MGJZVlNwNkEyZmptcWMvd3EyZlNR?= =?utf-8?B?QmpiZjFzTjZMd2trSlZYaWdrak9ubU5iZlFzK3ZXeXlycFN5S2N2Sy9aUStX?= =?utf-8?B?MEdkcVJZNTdaWUNoZFFiVXk5bDRUYTJCem83ME80czJqYW5YUHFYUTVSRCs1?= =?utf-8?B?U3NIRVBITUJYNC9GSTJSTDRpVUF5OHBHQXUvREtZSm55dWl4YkdIZ2FuR21q?= =?utf-8?B?WlFtTUJKUzVaYXh1VlF6aGo3cmIyWUpzWDZ5RzBRV3JmYVBJdzdvZ29nQk1j?= =?utf-8?B?SzZRa2R3WDBrSnc2bG85VU9BRXMyeG1VVDdsV0tUUnMvajdnc0FnWWxWRmMy?= =?utf-8?B?dmVCSzAralhHcmR1Mklqamd3Ykc2Wm5uamMxd1pISkZNa01kcjJQL3JESk1h?= =?utf-8?B?enJSUGFsbWxkMzlPVWFYeis2cTYrMmovam01SnBFRjRQWVZBUXFPNm1valNx?= =?utf-8?B?cXNGMlJIRDUyNyt2RmRSYzBoK3IrWnZpeDZORjhtbEdCdnNMN2w0dVdSRFdH?= =?utf-8?B?NFlzQVZQNVV2elZINm1ZeWZuUEJWb20vaEdrVTc0dVc2YllZVENyR3RaN2JP?= =?utf-8?B?OGR2dzBuRE41bGUyVElJR3k0T0YvV2xrbHY1NDU2ZC8yWjUyYTFTWkFSOUVv?= =?utf-8?B?TjN2andoc3FjWDF1eWdrQiswSFhXNHhITndtaWdBNXk4dGpCTkhsaEdqY0tj?= =?utf-8?B?WFhXajU2cGF0Ni9FRUgzUW1obmZzaEpVUHh6Nk5DTGRNS1p5T1BNbFlGT2U0?= =?utf-8?B?T1I5SHpoRnMxS0V0UDBXNDhCZmNNRDUzNnZGZUpVZ3A1YkxXLzlvN3Npbmhh?= =?utf-8?B?RU03K2dCeG0rMmxFNFRFOXA5Wk9tVURMUHRadjRDNGsxYzc3c0FxUi8xZDNE?= =?utf-8?B?dzI4QmZRT3R1WkFldlEyUTVMTmV6L0xLTmhyeTlxbHpOU0lqUnFVQzlITUxI?= =?utf-8?B?TGREeTI4b0FwbU04YlVCNWU4NTdVeGdhRTVtVDZJYUtRM0VhUTEyRmFNR1VE?= =?utf-8?B?MFdvdVhJemRIR09ZZWpYWTZYdDRMZlc4b0V3aEdQaDFLTENEUGx1d1A2ZHhw?= =?utf-8?B?MStEcXEzYlBxZzJKS2lZRVRXdjFHNFppRlpnZS9FZ3hWTWhWU3g3c1MwYUov?= =?utf-8?B?bEZhaXlBbUR2UjJUM201UGJLcDZkb3B2WW9KYU1IOU8rcHEvaGVDc1BzTHkw?= =?utf-8?B?cVdOQlNtaEJWdGZaTldrNW5OeGluNlRsYkRzVjlCejZxQW5NRVBkUExYcDZ1?= =?utf-8?B?ckE5eHJOWnIybGNBQzFzcmloQlVyekJEOUlFMkFsbzdGY1ZWTHpwV1FkTDNX?= =?utf-8?B?WExjT0lyakZwczNSVDVUZkU1OWI0MEl1Q25VTURnOW5IbGRwWnkwQUErQWsy?= =?utf-8?B?TGNTWG5hd0MxM3c5Nk5uZUM5NFdKcjNUSHdUdlNvQXhKZGpOQXA2eXl4ZHQx?= =?utf-8?B?bEd4b0dZWjlUUGlLcmZqRkFZZms5SzNDWU1qcTA1TElzK3VpM3YyKzE1VlE2?= =?utf-8?B?MEFvK3VxSlc4M0M2RU42R0M2RGRMVTdTRVhnUVVyS0xzMmhESTlUSWkwbHFi?= =?utf-8?B?cDd2R09yTGk4aGhlSThUc3ZlQ1FiWndxMFB6SUszeHlFa2hMaWlxRkQxVlFJ?= =?utf-8?B?K2h6U2E2N0NGcldyK0h4WWp0d2tvUXd0ZGhvUGdCUGQ2bzJXTytHcytPZHU4?= =?utf-8?B?enhodjZ6UC8zK0g0T1pjZDczejl0Smo1MWtMQWRKQitsZytUV0pINjJNY1dL?= =?utf-8?B?ZDFtUW5pQkxLNE1CNTI5RGs4ZmRDZ3VnVjBHRzAwMmR6Sy9waFFnL1RMeHZS?= =?utf-8?B?NkxpQ3BsQVFsS0R3RGNkc1dsQkNmWm1uQXhYejgrMWlpb2REODFyWFl3YkZW?= =?utf-8?B?SGFxekZnYUZRMytETjBkcDFPYzhmcnFBYnZPajdZaXVPdnZYN25OZWNMdDg0?= =?utf-8?B?UGRTSlpJa3A4NXFHOTNuL2JSWE1BVHpqUzY4WXd3bU84QVJzTThCcVkvTWpz?= =?utf-8?B?bytsVy9vSlFZZHJISFVrbW9nTDFjUU1hOHl5bXdMNGVkdm5rUjR4dk1SYkRE?= =?utf-8?B?aGpmaFdLNFJNbmNTbkwzaGN4WjVKWVN3MitBdS9xQ3VSZllZTXd0dkczVFc1?= =?utf-8?B?ajFxekdaR29vNmE1eHA3ZDZHcmFwTTc4SUsxdFlLS1JneDEzd0lEWTA5NGI1?= =?utf-8?B?YnhVb3UxV0E2cTQvaG4xMUE0SXM0NUZPZXZlZ01sOGc1QkE1clVoNXQ5U1RY?= =?utf-8?B?VXFGYTYvRUZjM1BkdTBzalA3QnhnPT0=?= 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: TYCPR01MB8373.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 2d07140a-428e-4d7b-95d9-08d9aaa1f6c2 X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Nov 2021 14:44:45.5024 (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: y81Jw4b1ODh8/f2ERaFvxLnyA4RLF15GvahcPsQGJBRQH73FIraDCBcN4rFfnqmCCVnGtaQpfH4soQ/fG5X7nmKvTtCLjyXRdFqkHYPUatA= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYCPR01MB7775 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVGh1cnNkYXksIE5vdmVtYmVyIDE4LCAyMDIxIDEyOjI2IFBNIEFtaXQgS2FwaWxhIDxhbWl0 LmthcGlsYTE2QGdtYWlsLmNvbT4gd3JvdGU6DQo+IEJUVywgSSB0aGluayB0aGUgd2F5IHlvdSBh cmUgY29tcHV0aW5nIGVycm9yX2NvdW50IGluDQo+IHBnc3RhdF9yZWN2X3N1Yndvcmtlcl9lcnJv cigpIGRvZXNuJ3Qgc2VlbSBjb3JyZWN0IHRvIG1lIGJlY2F1c2UgaXQgd2lsbA0KPiBhY2N1bXVs YXRlIHRoZSBjb3VudGVyL2J5dGVzIGZvciB0aGUgc2FtZSBlcnJvciBhZ2FpbiBhbmQgYWdhaW4u DQo+IFlvdSBtaWdodCB3YW50IHRvIHVwZGF0ZSB0aGVzZSBjb3VudGVycyBhZnRlciB3ZSBoYXZl IGNoZWNrZWQgdGhhdCB0aGUNCj4gcmVjZWl2ZWQgZXJyb3IgaXMgbm90IHRoZSBzYW1lIGFzIHRo ZSBwcmV2aW91cyBvbmUuDQpUaGFuayB5b3UgZm9yIHlvdXIgY29tbWVudHMgIQ0KVGhpcyBpcyBh ZGRyZXNzZWQgYnkgdjEzIHBhdGNoc2V0IFsxXQ0KDQoNClsxXSAtIGh0dHBzOi8vd3d3LnBvc3Rn cmVzcWwub3JnL21lc3NhZ2UtaWQvVFlDUFIwMU1CODM3MzUzM0E1QzI0QkREQTUxNkRBN0UxRUQ5 QjklNDBUWUNQUjAxTUI4MzczLmpwbnByZDAxLnByb2Qub3V0bG9vay5jb20NCg0KQmVzdCBSZWdh cmRzLA0KCVRha2FtaWNoaSBPc3VtaQ0KDQo=