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 1m8j7S-0004gE-MP for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Jul 2021 12:57:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m8j7P-0000sb-VS for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Jul 2021 12:57:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m8j7P-0000sR-8c for pgsql-hackers@lists.postgresql.org; Wed, 28 Jul 2021 12:57:03 +0000 Received: from esa15.fujitsucc.c3s2.iphmx.com ([68.232.156.107]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m8j7M-0008G2-5J for pgsql-hackers@lists.postgresql.org; Wed, 28 Jul 2021 12:57:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1627477020; x=1659013020; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=HQzeR+BuMXT8++05FNUQqgKZuGYdsIQn1KcpXtOHCMQ=; b=qirROUlJ79HubSQHHdVCqU0nLvCs0NodZ0zOC/idnO4CztmIOSjXHRio eOjIza9Brx6AV5KEojOnrolSloK4MvVcKZjCu5gxMqG3jxDqBaqyQ1O2l No9sDMzX8bP4Rv4tKDILr9z5fGj931HkBIv2hGnGHsrtjxk08KXfsW5Ml BwGPT+GCKUqtyqjMAEK2d7TrvQYYHiUut59zalMzzLhPnFXgYjWS/Ukvd dEJY24J58buzqU/IzK3v91AcK00wtAaKiJ/Dv8zeCLUGZatwoOVZgyFcG RUEEbZz77pOEJPihuEoU2eUapsD3c7cy5l9UfwifGmMkZKQZ4Kh3HI9gq A==; X-IronPort-AV: E=McAfee;i="6200,9189,10058"; a="35633998" X-IronPort-AV: E=Sophos;i="5.84,276,1620658800"; d="scan'208";a="35633998" Received: from mail-os2jpn01lp2052.outbound.protection.outlook.com (HELO JPN01-OS2-obe.outbound.protection.outlook.com) ([104.47.92.52]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 28 Jul 2021 21:56:55 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=EwdXIa7zRyq1cnF7r/awF3Jw1OnRUJKv29iSpRA3aRP8x56mX9wdjGkT13f/om/yQoTPyMWLme3Jx4dsWPhxDZQ/GasZMBODrl/t5YZUNzvP13qVejGMJfjvX3w/OwlI3Kj9vu9Z5EeDFpYjfVTa3VROBssuLqH439wya0ZCwKu3+lhGhavvzhavvv3rbW9OX66Gk+ZUIJpSoVZVDU7jQQKvU9jTF2oHp1PcuIpBGM8hEBoGpJGkEJKhq++uwtWIYvrlag2V2zMWUEeYchAdTOdSanZanH4/NSVx0kpPvJlSA2iiBY93mZ5UBzoeN7Dj9CwKoXiPMPsqbHQUf9OHmw== 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-SenderADCheck; bh=HQzeR+BuMXT8++05FNUQqgKZuGYdsIQn1KcpXtOHCMQ=; b=AccC2RSRVGj2XHh5YNtu0Dowt/WrmIxzLnQiLgVW+s2mcR2mI4jJLfpPAIEo69Uydmkjc03kueW3QPl9AgNrpfDRTdXyfKpFMukF3m1qnx3mpD7d7jIfwjQoupZ5E+4k0vDtaNWMDUV3PFVn+m6mksRh4C2rZxi0aL1lABAu3Z7uwzmaE37mrBjXnJHGQGph8iFaMgloAwh1n0P4BIR3chVLAU+iwZaTzPDrsjrHdopcIwe234l+vtcySU/CvdjQNfsM7IAXXHwooQys8pyKMDN8oKM3K1gt+AQXjOnUw1TroKPCBbZrBm/dkxRqxkCOsVW5R27HsF50Nn7LsGh6gg== 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=HQzeR+BuMXT8++05FNUQqgKZuGYdsIQn1KcpXtOHCMQ=; b=RH7NrCQZ5X/SlIFzkBJTP87GSx/JqFS/6mNME9LP/G/gnvotJCYbCDbVJVbmvefHRbCYkQrz69kZ+Q7WtahzCyLNYQ1+Zn44F75z1aQsEw9Cfv0g2RzZd+5Vsy7p19NrLX9eEapcHebgpk9SjdE0LolPV+TuWR2x7ZVQglIe5eM= Received: from OSBPR01MB4888.jpnprd01.prod.outlook.com (2603:1096:604:79::23) by OSYPR01MB5381.jpnprd01.prod.outlook.com (2603:1096:604:87::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4352.28; Wed, 28 Jul 2021 12:56:52 +0000 Received: from OSBPR01MB4888.jpnprd01.prod.outlook.com ([fe80::786c:f68d:8895:6750]) by OSBPR01MB4888.jpnprd01.prod.outlook.com ([fe80::786c:f68d:8895:6750%6]) with mapi id 15.20.4352.032; Wed, 28 Jul 2021 12:56:52 +0000 From: "osumi.takamichi@fujitsu.com" To: 'Ajin Cherian' CC: "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: AddzxbV4E8towJomTkm1trqmHwIwlgO7zMwAAD6lzwA= Date: Wed, 28 Jul 2021 12:56:52 +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?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjEtMDctMjhUMTI6NTY6?= =?utf-8?B?NTFaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?= =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?= =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?= =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?= =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?= =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD03N2FkZWE2MS05MWQ1LTQyZDgt?= =?utf-8?B?OGNjYy0wMDNkNjc4ODc1YTI7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?= =?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: b74c9741-8146-4dad-15ac-08d951c72be1 x-ms-traffictypediagnostic: OSYPR01MB5381: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:10000; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: lhqwqPbYQsILC3lZQiGgLNnS80PUhhq+caMSnc2KKc17u4b9gCA+ITrptp/faxAOb2VwBaxGWULYJJrP1J6XxKTYXGqY1N+kB6W5RBmltdeBwniGnf5g/dcTJaN60xrQ6Z7Uiuwl/wYTacrst3JtuLLhJxGciEqWSW6bvSoH/6BzmhKUBqxKQju3GahGZtouQONu79Byxzv3O6g3QbYqwajgA1JFKt80LFz2PyT8v9z2a0fgfms5HtTWjFC1kJ/CmykaB/3Ot/+F3DUJe8QTl8694opUGbZG5F98BV0KR8MmfeaJzw+Oun7tu755Mt76kPnAHl2Puuho6PRmwOE5e98r1ur900+d2gqilf3/+QFFDkYguK67/EX+qu98TEFexbYZPp8tiXRFB8Ld5jJykQUv2MxyQ1IU+ZfQSJX0UKOwipzXfiOhhUKPDD0M0HMy1ljKapWb4sE/xUZcE7Rx8LEqSb0Gp5QBrKvFGK+qUlSqqwvPQpvGI9KDKP41+FcgvTmEe41GMBdVJ7sdzWs3cyXj+87Ru+itGNXm5q6fXBXBwKJZh2wj3bBRmNi9wt+6SNyg+uUWFBmN50RINPPmtJkxMIo77Wh7gQ71WZLXWLKKeucpJYHE4O+V4o2bkhcdXTGbj58k/Pws+TMrP756gIKfpZCxsgm1H//66vFdHoLCB7J0yGnP8DbxB3IgTgi4NkOhBzAR5bIzhe5nIUlCtA== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OSBPR01MB4888.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(39850400004)(346002)(366004)(136003)(396003)(376002)(76116006)(66476007)(8676002)(9686003)(66446008)(66946007)(6506007)(85182001)(53546011)(186003)(38070700005)(5660300002)(316002)(8936002)(26005)(86362001)(4326008)(83380400001)(7696005)(52536014)(122000001)(38100700002)(478600001)(2906002)(55016002)(64756008)(6916009)(66556008)(71200400001)(33656002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?QkxNM0xCNGZCQ09hSmNKdGw2ZlAxVkVtalJZUU1hbzRlazRZVFhmbnIzcWNr?= =?utf-8?B?L05XRWlpN0lGOGlYK0dpbFkwcXdrL2N3ZHZYaEFvcVQrRnRZcXJ5TEdqZk94?= =?utf-8?B?NzVwZlpVTGlxY05YM2tsRzdXQVpnL3pvUHZJeDdWcmFiZlBPeW9qbEc1SzJC?= =?utf-8?B?TGZKRmUrd2JaQ01RaUY1QWtvVmZnMVdZNjJzUEh0SzJqRmI1U0liL3ZaNXNL?= =?utf-8?B?UEtsSkd5Ry9GbnlMOVcxRW5xa2ZManlwdnRHbm9pU212RmpxcXdYZFh5YWZ0?= =?utf-8?B?M1VTcitUUlQ2UTZSZ2tZUnYyZWh5dmdGSzF1N2JvT0NHdVhQRCsxcm1zcUVp?= =?utf-8?B?L3ZOMFJpSU51TTIrK0N3L252QVNTZTAxN0ZPazFYTHdWQ1JCTnByK1MxeUdj?= =?utf-8?B?am1vYVNzRmJNbEh6M1dKL0U3L0V5bGlZK1NEZk0zMXc0RzNYUjY0WG5ZNys3?= =?utf-8?B?aUc4eHdzOVdTb0JldTlVMUtuS2RsWkRhTlV6ZWhsL2UrbGNuamhQUFlMbDAz?= =?utf-8?B?NVRlOVpCVHBIVXorMWRiWU5JMTBaSnYrUzFpb21aSGxyT0Jsby9tazZoQzFU?= =?utf-8?B?UG1UMGluWnRIWTl5OENkN2NCTTBZQkVLOWsyRHh5MkFSNlpMLzl5Z2VqUlRE?= =?utf-8?B?L0hhZC9qdHh0TVQxbUE2TUdTY3pBajBCeUFMZ1lsQkROWFZBRURid3VyN2Vy?= =?utf-8?B?bksvVkNqZ3NvWGF1RFEyb3dHTEc4VkFqUGFvUTk2YjNHalpVcWNERHIwVGE0?= =?utf-8?B?NXlIa1p1WGVZZllRSjRrekEzVVZWcC9sYXZ0VUxqU2ZJbmJ1Ti9TSE81M3dt?= =?utf-8?B?YjF4SFYreTRLTzVPM203Z0EzMy9LSWwvaGpKQUxVVTE2Y2ZzTEU1SkkrREZR?= =?utf-8?B?ckxBTWF2MEh4NENPRGFZYzR0VzUwUHIybUVmcVpTRjZ6NmpYSFpTSko0S2Vw?= =?utf-8?B?SzNHZXAxdnVzRjFkMkx0aHVzQWVBbzBzN2o5a2JpcStQK0hwcCsrYW1OU3FZ?= =?utf-8?B?MUk0SGlvaDB6M013NXBGT0JLcjI4akY5dG1oZzVDcmtwbFR6QmpjRXhDb1hl?= =?utf-8?B?aFVEWkEyR0hWN1NsQTRRV295S29hRzlBZ29BQzhrbS9RNDJtdXdYKzZDSmJo?= =?utf-8?B?amZsWmt0Mk9sZlV1eTVPZW5GY3RoK0UvUlNaeTdRWDd5TTd6YkVWcG5XNEMw?= =?utf-8?B?Y2pwV3YxWmhvTHRYVDBhY0I1Tmc1MHQrWFU5bzFMa2ZHZHF3SjNGbHdZVU9M?= =?utf-8?B?ZGtrTUY3WDE2RXU1N2tqZ0htamNSZi9SK0h6RW1SYnIxUzBORmgyVmxBenlw?= =?utf-8?B?bjBvQnhuTGdsaDBhemJOeW92VUdRaTVZMHE4QnY4Y294Mm1QeElvNWtham9j?= =?utf-8?B?ekh2TnBiTDNueHlieTBEQjRxUndpQllCRS9NZ2paRDhDTlcrZDRGVXM5ZUEx?= =?utf-8?B?U2djMkx6UXNlRFVQNEhGY3I2b3lIUEVUa0pRQkNTZWFHa3pkaDBKQmp5N1hq?= =?utf-8?B?WGJMTmR0WUIya2R1Y09UZnJZellKSVdTMFBvVm5Ed2JpVlNFOGc1UUZ1QlBH?= =?utf-8?B?Y2FHN3Y0dmpKZUNGTG4xU0g4eE5WeTlTVGVJRzl4L29NUmdjRjlaZDNCcmFB?= =?utf-8?B?eU9pczE5UmZpOWRmN2F2RU5PNGFndWFlczBQWXlqNGlrcDd0VWtldzRiRksv?= =?utf-8?B?M2R0UGZsRDhzSWFzMXVPZU1qSkVhZTBDWC9pbUdHbHlMc3RSSk1aRVZubTJq?= =?utf-8?Q?W70tpN62zaXYIIFSJQ=3D?= x-ms-exchange-transport-forked: True 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: OSBPR01MB4888.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: b74c9741-8146-4dad-15ac-08d951c72be1 X-MS-Exchange-CrossTenant-originalarrivaltime: 28 Jul 2021 12:56:52.5699 (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: 5x36BZfdWTjh50nXABMfJG9OMvfycb+2w+U4ht13zRpm/+7HhrW2QRamq54449ol0NeU9DxEtbhqTo1U7E7WuENDVOJsXDTQhYU/cQJBCAA= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSYPR01MB5381 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVHVlc2RheSwgSnVseSAyNywgMjAyMSAzOjU5IFBNIEFqaW4gQ2hlcmlhbiA8aXRzYWppbkBn bWFpbC5jb20+IHdyb3RlOg0KPiBPbiBUaHUsIEp1bCA4LCAyMDIxIGF0IDQ6NTUgUE0gb3N1bWku dGFrYW1pY2hpQGZ1aml0c3UuY29tDQo+IDxvc3VtaS50YWthbWljaGlAZnVqaXRzdS5jb20+IHdy b3RlOg0KPiANCj4gPiBBdHRhY2hlZCBmaWxlIGlzIHRoZSBQT0MgcGF0Y2ggZm9yIHRoaXMuDQo+ ID4gQ3VycmVudCBkZXNpZ24gaXMgdG8gc2F2ZSBmYWlsZWQgc3RhdHMgZGF0YSBpbiB0aGUgUmVw bGljYXRpb25TbG90IHN0cnVjdC4NCj4gPiBUaGlzIGlzIGJlY2F1c2UgYWZ0ZXIgdGhlIGVycm9y LCBJJ20gbm90IGFibGUgdG8gYWNjZXNzIHRoZSBSZW9yZGVyQnVmZmVyDQo+IG9iamVjdC4NCj4g PiBUaHVzLCBJIGNob3NlIHRoZSBvYmplY3Qgd2hlcmUgSSBjYW4gaW50ZXJhY3Qgd2l0aCBhdCB0 aGUNCj4gUmVwbGljYXRpb25TbG90UmVsZWFzZSB0aW1pbmcuDQo+IA0KPiBJIHRoaW5rIHRoaXMg aXMgYSBnb29kIGlkZWEgdG8gY2FwdHVyZSB0aGUgZmFpbGVkIHJlcGxpY2F0aW9uIHN0YXRzLg0K PiBCdXQgSSdtIHdvbmRlcmluZyBob3cgeW91IGFyZSBkZWNpZGluZyBpZiB0aGUgcmVwbGljYXRp b24gZmFpbGVkIG9yIG5vdD8gTm90IGFsbA0KPiBjYXNlcyBvZiBSZXBsaWNhdGlvblNMb3RSZWxl YXNlIGFyZSBkdWUgdG8gYSBmYWlsdXJlLiBJdCBjb3VsZCBhbHNvIGJlIGR1ZSB0byBhDQo+IHBs YW5uZWQgZHJvcHBpbmcgb2Ygc3Vic2NyaXB0aW9uIG9yIGRpc2FibGUgb2Ygc3Vic2NyaXB0aW9u LiBJIGhhdmUgbm90IHRlc3RlZA0KPiB0aGlzIGJ1dCB3b24ndCB0aGUgZmFpbGVkIHN0YXRzIGJl IHVwZGF0ZWQgaW4gdGhpcyBjYXNlIGFzIHdlbGw/IElzIHRoYXQgY29ycmVjdD8NClllcywgd2hh dCB5b3Ugc2FpZCBpcyB0cnVlLiBDdXJyZW50bHksIHdoZW4gSSBydW4gRFJPUCBTVUJTQ1JJUFRJ T04gb3INCkFMVEVSIFNVQlNDUklQVElPTiBESVNBQkxFLCBmYWlsZWQgc3RhdHMgdmFsdWVzIGFy ZSBhZGRlZA0KdG8gcGdfc3RhdF9yZXBsaWNhdGlvbl9zbG90cyB1bmludGVudGlvbmFsbHksIGlm IHRoZXkgaGF2ZSBzb21lIGxlZnQgdmFsdWVzLg0KVGhpcyBpcyBiZWNhdXNlIGFsbCB0aG9zZSBj b21tYW5kcywgbGlrZSB0aGUgc3Vic2NyaWJlciBhcHBseSBmYWlsdXJlDQpieSBkdXBsaWNhdGlv biBlcnJvciwgaGF2ZSB0aGUgcHVibGlzaGVyIGdldCAnWCcgbWVzc2FnZSBhdCBQcm9jZXNzUmVw bGllc0lmQW55KCkNCmFuZCBnbyBpbnRvIHRoZSBwYXRoIHRvIGNhbGwgUmVwbGljYXRpb25TbG90 UmVsZWFzZSgpLg0KDQpBbHNvLCBvdGhlciBvcHBvcnR1bml0aWVzIGxpa2Ugc2VydmVyIHN0b3Ag Y2FsbCB0aGUgc2FtZSBpbiB0aGUgZW5kLA0Kd2hpY2ggbGVhZHMgdG8gYSBzaXR1YXRpb24gdGhh dCBhZnRlciB0aGUgc2VydmVyIHJlc3RhcnQsDQp0aGUgdmFsdWUgb2YgZmFpbGVkIHN0YXRzIGNh dGNoIHVwIHdpdGggdGhlIChzdWNjZXNzZnVsKSBleGlzdGluZyBzdGF0cyB2YWx1ZXMuDQpBY2Nv cmRpbmdseSwgSSBuZWVkIHRvIGNoYW5nZSB0aGUgcGF0Y2ggdG8gYWRqdXN0IHRob3NlIHNpdHVh dGlvbnMuDQpUaGFuayB5b3UuDQoNCg0KQmVzdCBSZWdhcmRzLA0KCVRha2FtaWNoaSBPc3VtaQ0K DQo=