From: "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
To: 'Amit Kapila' <amit.kapila16@gmail.com>
CC: Masahiko Sawada <sawada.mshk@gmail.com>,
	"pgsql-hackers@lists.postgresql.org" <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+6DXgAAsU7aA
Date: Tue, 28 Sep 2021 01:55:39 +0000
Message-ID: 
 <TY2PR01MB48902C1278A49542EDBB377FEDA89@TY2PR01MB4890.jpnprd01.prod.outlook.com>
References: 
 <OSBPR01MB48887CA8F40C8D984A6DC00CED199@OSBPR01MB4888.jpnprd01.prod.outlook.com>
 <CAD21AoAixHnpjG-TtnSejJ2Dv1VsrzGr3oVPSRFhYjz3Z8_XZA@mail.gmail.com>
 <OSBPR01MB4888D9048D3D7E7C3D035D54EDEF9@OSBPR01MB4888.jpnprd01.prod.outlook.com>
 <CAD21AoCbj6YBNmdG9gAXf=dPE+bdY95ENwkh4q5wPL0q=qMzVw@mail.gmail.com>
 <CAA4eK1+tOV-+ssGjj1zq+nAL8a9LfPsxbtyupZGvZ0U7nV0A7g@mail.gmail.com>
 <CAD21AoAO0004L1kv9+uArrhT7d=vFj=2ZUKFbUfpZnHJku-37g@mail.gmail.com>
 <CAA4eK1+CfMrJeA8TR__uFMQVZk50L+OGUEW-8h5G0hD_erfaSw@mail.gmail.com>
 <CAD21AoDtn1bY4CYkBDXMgxpyBQZTAh45HMTXfAjQ3nY_G_=7Mg@mail.gmail.com>
 <CAA4eK1KNqNnWq=wep5OALjqRRKbqp3pRjnqBJi2CPfMYJMUjrQ@mail.gmail.com>
 <CAD21AoA6X7UtbewgRVetcwh2tuAp=umR5n_bE69ZBj3mN6R31Q@mail.gmail.com>
 <CAA4eK1KMT8biciVqTBoZ9gYV-Gf297JFeNhJaxZNmFrZL8m2jA@mail.gmail.com>
 <TY2PR01MB48905729E8CB81805CCF64C0EDCE9@TY2PR01MB4890.jpnprd01.prod.outlook.com>
 <TY2PR01MB489065DB7B8066936087C5E4EDD59@TY2PR01MB4890.jpnprd01.prod.outlook.com>
 <OSBPR01MB4888507DD52192F0CDF9A49DEDDA9@OSBPR01MB4888.jpnprd01.prod.outlook.com>
 <TY2PR01MB489042618A073A2FC7BF62C0EDA29@TY2PR01MB4890.jpnprd01.prod.outlook.com>
 <CAA4eK1JEVoTJNMu94vVdUoak-uefo9V=XJ5bQQ+o47uawDFftg@mail.gmail.com>
In-Reply-To: 
 <CAA4eK1JEVoTJNMu94vVdUoak-uefo9V=XJ5bQQ+o47uawDFftg@mail.gmail.com>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
msip_labels: 
 =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?=
 =?utf-8?B?NTBfRW5hYmxlZD10cnVlOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJh?=
 =?utf-8?B?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjEtMDktMjhUMDE6NTU6?=
 =?utf-8?B?MzdaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?=
 =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?=
 =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?=
 =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?=
 =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?=
 =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?=
 =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD01ZDE2ZWZiMi1mYzVmLTQwNzgt?=
 =?utf-8?B?OWU2Yi1kNjYzNGE3ZGE2NDM7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?=
 =?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: c7860156-0720-40cf-d416-08d98223126d
x-ms-traffictypediagnostic: TYAPR01MB3712:
x-microsoft-antispam-prvs: 
 <TYAPR01MB371201682C59AD53BE6E47F1EDA89@TYAPR01MB3712.jpnprd01.prod.outlook.com>
x-ms-oob-tlc-oobclassifiers: OLM:8882;
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: 
 mvsEovl3D074ol+vMgylIFPkMOHADSuYwIn6iYoa2pZXSdTIYHcSua6rzzJ3VNx9F+bNnYqVDbfJHAOvJaVyqUxq0XoG0XsvKI2cW0qgdlXQIzlOBbYIPqkXndiY4b5Ht/5qil1gT5sMtZp1DfaMNVJynDxGHoerG/xZh5V5MjkZMTksBZuyYU6z//q/ihfTbuqSaW95fn65rego7MJVe4zqAT0/eM+c1hdDiYlil7HKOnoN/YrwMBcLdZzx3bi4oFmlQ6y6JyyCePMtMK0VfdYNSbo64Sg+MBSC8GlD0WSvuWH9obd1zoeTRRF+E9naWiUPrYdU63kzd3dJBYlSnIkuTsTVB0GrZFVeebI6b9wUWHdcLIxysdEB9ghAqwNJkgwVngYsrsVJI1PY5UD3BH0vUv74n/u/xWpw4Nr27cAW9tLVlH3ehNfYCOu74mTvLBKSCzYytQL5ybX/wu01NFfFBPR4dTVjv0oRVJt7TkAqs9V77RnFJ0yqJOlQvOYT8l2zWgh4F8cOq2y27Ggj6zQn76y0CPppfiqbrAtxjKTfc5n4l6ALo2faLJ+OiGa8tPvzAo4hT0rUoXHGXZKzfLpkLcu6Ztq2a6wKYkXZ3+eMplCGa1BfTPV0+qqXg/L54YZo65bmE/sgIOAkYEFKeP4tSxfsR85xoR6jHWupArA4BvNFfJqBfkv3I/kkp0z8lLSFsaXthxVAJ6Qs6aTOMw==
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TY2PR01MB4890.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(38070700005)(2906002)(52536014)(8676002)(33656002)(6506007)(53546011)(6916009)(5660300002)(26005)(7696005)(186003)(8936002)(66946007)(66476007)(66446008)(64756008)(66556008)(71200400001)(83380400001)(316002)(86362001)(4326008)(76116006)(38100700002)(85182001)(508600001)(54906003)(9686003)(55016002)(122000001);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?utf-8?B?THNRRDBSRE1JU0wvTkdUenA4QlRIRFBlTUp6TENNK09DODdlNFRrdXVrTStR?=
 =?utf-8?B?Nm5yblBrOW1ncFRJZVNETGhWd3NmT1J1UGY3NFVKZ2NSZVpTNTF5c2doUHZ2?=
 =?utf-8?B?L2ZZNyt4ODlGV1ROU2NsU2Zoc1BtRUFWRmN2a3J4L29QR0NLeXhBUGtvb29h?=
 =?utf-8?B?TzhWc2JaNWd1MlhPNDhGMGZJbEIxVWhiUXVuWkFRV0VLckZNOThGQzFSUWM2?=
 =?utf-8?B?WUJHNXp2eWNYeGNOeHFkbWZ5MjFWZzlhck95dHJZNXUvVUNSbWMxTFZPdVlS?=
 =?utf-8?B?SGp3UzYyOGE4UGwrNktqNXFHNUVkOW9NS2JLc3NEUFRZelZUTkxZejYwZlZW?=
 =?utf-8?B?RjJSSzFOdW5JWkxTRmQ1eE5nL2NJRGVwVG1iQ3Y5QlAyR0EvRkhPQXRwQmRT?=
 =?utf-8?B?VmhhRGFRMWF4VWRzRmtGeEhpWHJybWVCckxwNmNtS1BGU2NqQlh0ektZT0hB?=
 =?utf-8?B?YysyVTdkbTJKNnFlVnY4UFl6WHFYbExhSmRxNDZFOUJ6SWY3SGlyT0cxbXd1?=
 =?utf-8?B?aklGY3FYd2hqZWtEWXBldEhQL2F6WG5Ua0FLYlVHNGhsQnRqQjlTUytiMW54?=
 =?utf-8?B?M3R4SzZOQ3hGak5HUmF2WDZZK3BwTjFiclZVanhxYXB2R0syTTlZYmZST2lR?=
 =?utf-8?B?bURVTCs2R3BwL2Z0aFFzZUhVM2dHeXdXWFI4WkoyT0dDM0Q5dW51aVNzb28w?=
 =?utf-8?B?Y1Y2LzBuUm9JTjZBaUNxQ0hvU0xPd3ZGbml2bkNtRGRiWkxrM210UTFyQmtl?=
 =?utf-8?B?SlJpT3FxaXNUd0JHM3FFeGhNVmI3a0FHWnl3b3NBNFBVMWxEZEN4OFBrT2Za?=
 =?utf-8?B?ZklnZW9mcnBGQW9mZEkvSmZzNFE1T2RtRGdFOXVVVFNocnZFTGhEdkpuTUpZ?=
 =?utf-8?B?T1hjS0l6Wkh2ck5aTWRMc1lhb0JQWVh6WDFFUkR0QU9ZZkVRU0tXSnNIMXRV?=
 =?utf-8?B?OXdkVVFrVkhOanY2Qzc0R2xRM1JkUGxCRnU0UHB4ZXdpQ25DbEFGN0ZZTERX?=
 =?utf-8?B?QnZkMUFDaUhJTzFkZWlYU3hoZGQwR0FPbTVleFByNE1DYmlLTG5UZG5yNmFa?=
 =?utf-8?B?Rnk4YTRueTIxdmpnOWtkUmc5eGhEcWdpVlVHL3VHQzJ1QitnNmF6UUtsQm5K?=
 =?utf-8?B?R2RUN1BiTHhoOEM0aXF4ZGFudm5DWk5vb3k4WmRDbmNaTkVFN25rZFhxZ0Jq?=
 =?utf-8?B?aDF6OVIrWTJSS2t6QUFHZ1Z2VjFBeEpZNU9rUXNTOFFKMVRCSXBleUNZMkVG?=
 =?utf-8?B?YktMNVB6MXdZa3FGaXVrc1BzNHd6TVliS2NoR05ISG1HRHJoOG9sTEtkMUdY?=
 =?utf-8?B?ZURieDY2NWlDb0JuallNS2ZZTlUzRnI1VjJCWWpHSlhOUGJYeEc2eWZ5WS9H?=
 =?utf-8?B?TENVNmJ2cGdrWnpFeUErK3BZMjFZUEl0N3IxRmp5VGxFcERhS0pqK2RVeGJI?=
 =?utf-8?B?cUExbm5McnlvWlNYd3QyVFRFTU4rRUFhM1BGUncxbC9kZy9JcGhycFRtUVl6?=
 =?utf-8?B?NzhpRGltSEhJdDJQMU9xZ3B2b1BmSUdDejl6RGtMWXJ1VnovM2YyVnIwZThQ?=
 =?utf-8?B?aVYzOXZHeDZ6YjRjM1V0VlRrK05xcCtLL2srbHBkYzRrdWsxQjc2OCtXajNV?=
 =?utf-8?B?aTdFOG44QVBGcmF4SXhLaVUrSW1DSFlNVXVvMmR2MWxDbndVejBiYUQ4L1pY?=
 =?utf-8?B?MEdCRy9nUFVxNFViMXk4QWJMSzFjK1FmL2p0a0VaalpFMFJUeXdUT0F5RHlt?=
 =?utf-8?Q?kUmhIyxhdH/eB5e6DeJVqFyhcd329RJvt56Sex8?=
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: TY2PR01MB4890.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 c7860156-0720-40cf-d416-08d98223126d
X-MS-Exchange-CrossTenant-originalarrivaltime: 28 Sep 2021 01:55:39.2920
 (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: 
 CNekfZSI89jqkzF2pjiwctURbEVNOMTqp97c5iH1q0MZBnAy5qUIrb5U5kcx5AGPSAp5ggFwl0RxFw+LPtW/9AoQCrgOMYv0ONht/DcbZhs=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYAPR01MB3712
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/TY2PR01MB48902C1278A49542EDBB377FEDA89%40TY2PR01MB4890.jpnprd01.prod.outlook.com>
Precedence: bulk

T24gTW9uZGF5LCBTZXB0ZW1iZXIgMjcsIDIwMjEgMTo0MiBQTSBBbWl0IEthcGlsYSA8YW1pdC5r
YXBpbGExNkBnbWFpbC5jb20+IHdyb3RlOg0KPiBPbiBXZWQsIFNlcCAyMiwgMjAyMSBhdCAxMDox
MCBBTSBvc3VtaS50YWthbWljaGlAZnVqaXRzdS5jb20NCj4gPG9zdW1pLnRha2FtaWNoaUBmdWpp
dHN1LmNvbT4gd3JvdGU6DQo+ID4NCj4gPiBKdXN0IGNvbmR1Y3RlZCBzb21lIGNvc21ldGljIGNo
YW5nZXMNCj4gPiBhbmQgcmViYXNlZCBteSBwYXRjaCwgdXNpbmcgdjE0IHBhdGNoLXNldCBpbiBb
MV0uDQo+ID4NCj4gDQo+IElJVUMsIHRoaXMgcHJvcG9zYWwgd2lsbCBhbGxvdyBuZXcgeGFjdCBz
dGF0cyBmb3Igc3Vic2NyaXB0aW9ucyB2aWENCj4gcGdfc3RhdF9zdWJzY3JpcHRpb24uIE9uZSB0
aGluZyB0aGF0IGlzIG5vdCBjbGVhciB0byBtZSBpbiB0aGlzIHBhdGNoIGlzIHRoYXQgd2h5DQo+
IHlvdSBjaG9vc2UgYSBkaWZmZXJlbnQgd2F5IHRvIHN0b3JlIHRoZXNlIHN0YXRzIHRoYW4gdGhl
IGV4aXN0aW5nIHN0YXRzIGluIHRoYXQNCj4gdmlldz8gQUZBSUNTLCB0aGUgb3RoZXIgZXhpc3Rp
bmcgc3RhdHMgYXJlIHN0b3JlZCBpbi1tZW1vcnkgaW4NCj4gTG9naWNhbFJlcFdvcmtlciB3aGVy
ZWFzIHRoZXNlIG5ldyBzdGF0cyBhcmUgc3RvcmVkL2ZldGNoZWQgdmlhIHN0YXRzDQo+IGNvbGxl
Y3RvciBtZWFucyB0aGVzZSB3aWxsIHBlcnNpc3QuIElzbid0IGl0IGJldHRlciB0byBiZSBjb25z
aXN0ZW50IGhlcmU/IEkgYW0gbm90DQo+IHN1cmUgd2hpY2ggaXMgYSBtb3JlIGFwcHJvcHJpYXRl
IHdheSB0byBzdG9yZSB0aGVzZSBzdGF0cyBhbmQgSSB3b3VsZCBsaWtlIHRvDQo+IGhlYXIgeW91
ciBhbmQgb3RoZXIncyB0aG91Z2h0cyBvbiB0aGF0IG1hdHRlciBidXQgaXQgYXBwZWFycyBhIGJp
dCBhd2t3YXJkIHRvDQo+IG1lIHRoYXQgc29tZSBvZiB0aGUgc3RhdHMgaW4gdGhlIHNhbWUgdmll
dyBhcmUgcGVyc2lzdGVudCBhbmQgb3RoZXJzIGFyZQ0KPiBpbi1tZW1vcnkuDQpZZWFoLCBleGlz
dGluZyBzdGF0cyB2YWx1ZXMgb2YgcGdfc3RhdF9zdWJzY3JpcHRpb24gYXJlIGluLW1lbW9yeS4N
CkkgdGhvdWdodCB4YWN0IHN0YXRzIHNob3VsZCBzdXJ2aXZlIG92ZXIgdGhlIHJlc3RhcnQsDQp0
byBzdW1tYXJpemUgYW5kIHNob3cgYWxsIGFjY3VtdWxhdGl2ZSB0cmFuc2FjdGlvbiB2YWx1ZXMN
Cm9uIG9uZSBzdWJzY3JpcHRpb24gZm9yIHVzZXIuIEJ1dCwgeW91ciBwb2ludGluZyBvdXQgaXMg
cmVhc29uYWJsZSwNCm1peGluZyB0d28gdHlwZXMgY2FuIGJlIGF3a3dhcmQgYW5kIGxhY2sgb2Yg
Y29uc2lzdGVuY3kuDQoNClRoZW4sIGlmLCB3ZSBwcm9jZWVkIGluIHRoaXMgZGlyZWN0aW9uLA0K
dGhlIHBsYWNlIHRvIGltcGxlbWVudCB0aG9zZSBzdGF0cw0Kd291bGQgYmUgb24gdGhlIExvZ2lj
YWxSZXBXb3JrZXIgc3RydWN0LCBpbnN0ZWFkID8NCg0KT24gb25lIGhhbmQsIHdoYXQgY29uZnVz
ZXMgbWUgaXMgdGhhdA0KaW4gYW5vdGhlciB0aHJlYWQgb2YgZmVhdHVyZSB0byBza2lwIHhpZCwN
Ckkgd29uZGVyZWQgaWYgU2F3YWRhLXNhbiBoYXMgc3RhcnRlZCB0byB0YWtlDQp0aG9zZSB4YWN0
IHN0YXRzIGludG8gYWNjb3VudCAocHJvYmFibHkgaW4gaGlzIHBhdGNoLXNldCksDQpiZWNhdXNl
IHRoZSBzdGF0cyB2YWx1ZXMgdGhpcyB0aHJlYWQgaXMgdGFraW5nIGNhcmUgb2YgYXJlIGxpc3Rl
ZCB1cCBpbiB0aGUgdGhyZWFkLg0KSWYgdGhhdCdzIHRydWUsIGl0cyB0aHJlYWQgYW5kIHRoaXMg
dGhyZWFkIGFyZSBnZXR0aW5nIHJlYWxseSBjbG9zZS4NClNvLCBJSVVDLCB3ZSBoYXZlIHRvIGRp
c2N1c3MgdGhpcyBwb2ludCBhcyB3ZWxsLg0KDQpCZXN0IFJlZ2FyZHMsDQoJVGFrYW1pY2hpIE9z
dW1pDQoNCg==