From: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
To: Amit Kapila <amit.kapila16@gmail.com>
CC: "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>,
	"pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>,
	Masahiko Sawada <sawada.mshk@gmail.com>
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/RTlA
Date: Thu, 14 Oct 2021 03:53:49 +0000
Message-ID: 
 <OS0PR01MB5716D863C8800028DA65612494B89@OS0PR01MB5716.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>
 <TY2PR01MB48902C1278A49542EDBB377FEDA89@TY2PR01MB4890.jpnprd01.prod.outlook.com>
 <CAA4eK1+NT3u-hcYzgrOn2JaEQ=V3EvRxOwvY4Vs5GxR6TgQpcA@mail.gmail.com>
 <CAD21AoCnuZu1NA+xF3ZEHikuEKKzVm-NdPM=MZFJ3KZ3jvN+uw@mail.gmail.com>
 <CAA4eK1L3dPeUNu740mu-5znsvXpx2PkRRZ=w1Msf58o=EWSnnQ@mail.gmail.com>
 <OS0PR01MB5716E503D54B23F21A9733B194AA9@OS0PR01MB5716.jpnprd01.prod.outlook.com>
 <CAA4eK1JqwpsvjhLxV8CMYQ3NrhimZ8AFhWHh0Qn1FrL=LXfY6Q@mail.gmail.com>
In-Reply-To: 
 <CAA4eK1JqwpsvjhLxV8CMYQ3NrhimZ8AFhWHh0Qn1FrL=LXfY6Q@mail.gmail.com>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?utf-8?B?eFF5eHh2cVhjR0pqd0pqY2pUa1JwZlJIWlBqKzRXRWJFWkh3TFNVdm03RFE0?=
 =?utf-8?B?ZWMvZTEzcHVkdUcwVmdBaXZFVS9jenRnbFVkc1dWSEpxdFVSdkZNMzNOU3Vl?=
 =?utf-8?B?Tk1sd005ME13QTZ2ck9kTTc0V2dUS1FJZHEzaityMTRUSXhCZ3pWVHJoS1V0?=
 =?utf-8?B?NDNSY05ialNrdFNiaWFxRXVYK0lZekMyZFo1M3RwR2F6dWI3SW9Pc3pnSGZl?=
 =?utf-8?B?R3grdlJIYUh4SXNwQ0wwRjFJNEM1NW1pWnM2eVpsZnZ0d1FBK3hDekZHZlFH?=
 =?utf-8?B?aW5KTlJmTEp5QUFJMXhaRzNVR21hdzdSMUhVazFLUjRmTzl2YTE3bjRVZnFM?=
 =?utf-8?B?c2x2RVB2VUtEOXZWRFU0TXFWZVdZUmxCWGF4aW15T052Q3dhYUp3NG5SbUZG?=
 =?utf-8?B?cnY5b0t0Q1FMYkZHejBjZ3p5TW9IK3E4YVBjQ3ZsTzlEazdFQVRDekl5T1JC?=
 =?utf-8?B?Q3VVUzVWRm1TK0xUZjNkVkpVN1J0WEpNdG9XZWNiWlFvdk15Wk9LcmRhTjdX?=
 =?utf-8?B?T2NtVnJVc2cwYTJMVTVIY25lT0lHZHlKYTFlaHNPaXRNRTNaNEJRQ2lnb2xv?=
 =?utf-8?B?cWRPY3BhTldwOU1UaStxdVg5U1pqNldlaXhrOG96KzkyVXR4MUR0WXgwdk5l?=
 =?utf-8?B?a1pDbzNpTVNrc0lBMmJmS2w4ZXd2N1I0ZUk1cmdIMEh3VVBPcm1iQ2I4L1hh?=
 =?utf-8?B?WHdhaUVSMHFBblFUdTRSbTM5YUl5NTZvazI5YjdvdDVuNmhCdkFVSVRneE1I?=
 =?utf-8?B?UUg0QjJwSG54VFB5TnYzSXBOVkdlYWk0M21OMFEwTWs0Qk9uQUlmWDJJS3pw?=
 =?utf-8?B?bkdvOWJKb0dQeSs4M29rQ3o5M29TVlBxZCtoRCtYZURHL1YyY1VHU2tmSHVL?=
 =?utf-8?B?N2ZKR3BUQ0FKUWxOakR0dDF3Zit3U2pLRVpIN2NZbHVLYWpOdTRteDZnd3FE?=
 =?utf-8?B?MFRFQVdEdG5hZzVhblNlTzQ4UkJ3K2x3bWwyRExOWDIrRS9aMUtpWnU4K0My?=
 =?utf-8?B?OXArcmZGOUN2TXZHbTFXQVJMZjZPeXZSN2NuMlhSTTNOVWVoc3d5N2RsWmUx?=
 =?utf-8?B?TmpMa3labklMQlQzb3R0bWN1NllOelNpbXR6STBuak14R3hQYTArMjNCM3Ax?=
 =?utf-8?B?S3FONDZzc3JLR01TNktjZW05ZlZhQTloUjRCQjZZUTZtaVdiZHFUcnZKQ085?=
 =?utf-8?B?MHByaHhic241b3ZwWXZkdGJvaXBsZXRPbk9yYlNQRkpwTVRna3NSdUtuNlgz?=
 =?utf-8?B?VnowbVpJM09LWjYzTXVNbnBZeEowVHpYaXhzTWxoUFFvczVMS2p0Q3hpMm9H?=
 =?utf-8?B?ZCtoazNJdjIwZ2t2OSs1UlJUS0o1K3BnTWljSGk0azRIaXFMekFpaUU3bFE5?=
 =?utf-8?B?ZU95MkFiMGRjY2JuNENYYU4wUkozT1V6ZjhHK1hoQm92U2N1Y0dLbHZFN3Na?=
 =?utf-8?B?TkZFWm5vOWUxc1V2YVM1OE1JK0IwWFZOYktqclhyL1c4NGduaVMvTlB2Ynor?=
 =?utf-8?B?NWwvaHFsMmRVeGpFWnZ5enZyVjcxakZqTzFrSnl6S2lyRzBaQytsSE45OVQy?=
 =?utf-8?B?YUVNY284VlcxZVRjUldqdnpYTFoxaEJoVDZpbHlZTjFZb2Y2YkpKN2lkQTRG?=
 =?utf-8?B?TVpTc0s0NTFpN3dvQkYreEFiRVIzNEZDL2Z6MmNVc0orTXBCYVFyVVRkK21a?=
 =?utf-8?B?Z2lhdE1PRVZQN2w2dW50dkh2WStseG5OeDMyRGdJRGpweEl0VlUxUEdnWFpD?=
 =?utf-8?Q?ZSqK9Oa1ApQo5wL5kFhrmuaA2YXNbq+xPcFgUFV?=
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: OS0PR01MB5716.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 1b57cd71-3b2c-44f3-2500-08d98ec63b11
X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Oct 2021 03:53:49.4537
 (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: 
 gClFKJ4/M01sdBIHWKYi8CWbpMtPA05Yt+bg4JoeDlgHnVp/69/uI/Ytf8zSuOw8pcr0X1otmVK47YhSwtrPkw==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS0PR01MB5586
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/OS0PR01MB5716D863C8800028DA65612494B89%40OS0PR01MB5716.jpnprd01.prod.outlook.com>
Precedence: bulk

T24gVGh1cnNkYXksIFNlcHRlbWJlciAzMCwgMjAyMSAxMjoxNSBQTSBBbWl0IEthcGlsYSA8YW1p
dC5rYXBpbGExNkBnbWFpbC5jb20+DQo+IE9uIFRodSwgU2VwIDMwLCAyMDIxIGF0IDg6MjIgQU0g
SG91LCBaaGlqaWUv5L6vIOW/l+adsCA8aG91emouZm5zdEBmdWppdHN1LmNvbT4gd3JvdGU6DQo+
ID4NCj4gPiBPbiBUdWVzLCBTZXAgMjgsIDIwMjEgNjowNSBQTSBBbWl0IEthcGlsYSA8YW1pdC5r
YXBpbGExNkBnbWFpbC5jb20+IHdyb3RlOg0KPiA+ID4NCj4gPiA+IENhbid0IHdlIGtlZXAgdGhl
IGN1cnJlbnQgYW5kIG5ldyBzdGF0cyBib3RoIGluLW1lbW9yeSBhbmQgcGVyc2lzdCBvbg0KPiA+
ID4gZGlzaz8gU28sIHRoZSBwZXJzaXN0ZW50IHN0YXRzIGRhdGEgd2lsbCBiZSB1c2VkIHRvIGZp
bGwgdGhlIGluLW1lbW9yeQ0KPiA+ID4gY291bnRlcnMgYWZ0ZXIgcmVzdGFydGluZyBvZiB3b3Jr
ZXJzLCBvdGhlcndpc2UsIHdlIHdpbGwgYWx3YXlzIHJlZmVyDQo+ID4gPiB0byBpbi1tZW1vcnkg
dmFsdWVzLg0KPiA+DQo+ID4gSSB0aGluayB0aGlzIGFwcHJvYWNoIHdvcmtzLCBidXQgSSBoYXZl
IGFub3RoZXIgY29uY2VybiBhYm91dCBpdC4NCj4gPg0KPiA+IFRoZSBjdXJyZW50IHBnX3N0YXRf
c3Vic2NyaXB0aW9uIHZpZXcgaXMgbGlzdGVkIGFzICJEeW5hbWljIFN0YXRpc3RpY3MgVmlld3Mi
DQo+IGluDQo+ID4gdGhlIGRvY3VtZW50LCB0aGUgZGF0YSBpbiBpdCBzZWVtcyBhYm91dCB0aGUg
d29ya2VyIHByb2Nlc3MsIGFuZCB0aGUgdmlldw0KPiBkYXRhDQo+ID4gc2hvd3Mgd2hhdCB0aGUg
Y3VycmVudCB3b3JrZXIgZGlkLiBCdXQgaWYgd2Uga2VlcCB0aGUgbmV3IHhhY3Qgc3RhdCBwZXJz
aXN0LA0KPiA+IHRoZW4gaXQncyBub3Qgd2hhdCB0aGUgY3VycmVudCB3b3JrZXIgZGlkLCBpdCBs
b29rcyBtb3JlIHJlbGF0ZWQgdG8gdGhlDQo+ID4gc3Vic2NyaXB0aW9uIGhpc3RvcmljIGRhdGEu
DQo+ID4NCj4gDQo+IEkgc2VlIHlvdXIgcG9pbnQuDQo+IA0KPiA+IEFkZGluZyBhIG5ldyB2aWV3
IHNlZW1zIHJlc29uYWxibGUsIGJ1dCBpdCB3aWxsIGJyaW5nIGFub3RoZXIgc3Vic2NyaXB0aW9u
DQo+ID4gcmVsYXRlZCB2aWV3IHdoaWNoIG1pZ2h0IGJlIHRvbyBtdWNoLiBPVE9ILCBJIGNhbiBz
ZWUgdGhlcmUgYXJlIGFscmVhZHkNCj4gc29tZQ0KPiA+IGRpZmZlcmVudCB2aWV3c1sxXSBpbmNs
dWRpbmcgeGFjdCBzdGF0LCBtYXliZSBhZGRpbmcgYW5vdGhlciBvbmUgaXMNCj4gYWNjZXBhdGJs
ZSA/DQo+ID4NCj4gDQo+IFRoZXNlIGFsbCB2aWV3cyBhcmUgcmVsYXRlZCB0byB1bnRyYW5zbWl0
dGVkIHRvIHRoZSBjb2xsZWN0b3IgYnV0IHdoYXQNCj4gd2UgcmVhbGx5IG5lZWQgaXMgYSB2aWV3
IHNpbWlsYXIgdG8gcGdfc3RhdF9hcmNoaXZlciBvcg0KPiBwZ19zdGF0X2Jnd3JpdGVyIHdoaWNo
IGdpdmVzIGluZm9ybWF0aW9uIGFib3V0IGJhY2tncm91bmQgd29ya2Vycy4NCj4gTm93LCB0aGUg
cHJvYmxlbSBhcyBJIHNlZSBpcyBpZiB3ZSBnbyB0aGF0IHJvdXRlIHRoZW4NCj4gcGdfc3RhdF9z
dWJzY3JpcHRpb24gd2lsbCBubyBsb25nZXIgcmVtYWluIGR5bmFtaWMgdmlldyBhbmQgb25lIG1p
Z2h0DQo+IGNvbnNpZGVyIHRoYXQgYXMgYSBjb21wYXRpYmlsaXR5IGJyZWFrLiBUaGUgb3RoZXIg
aWRlYSBJIGhhdmUgc2hhcmVkDQo+IGlzIHRoYXQgd2UgZGlzcGxheSB0aGVzZSBzdGF0cyB1bmRl
ciB0aGUgbmV3IHZpZXcgaW50cm9kdWNlZCBieQ0KPiBTYXdhZGEtU2FuJ3MgcGF0Y2ggWzFdIGFu
ZCBwcm9iYWJseSByZW5hbWUgdGhhdCB2aWV3IGFzDQo+IHBnX3N0YXRfc3Vic2NyaXB0aW9uX3dv
cmtlciB3aGVyZSBhbGwgdGhlIHN0YXRzICh4YWN0IGluZm8gYW5kIGxhc3QNCj4gZmFpbHVyZSBp
bmZvcm1hdGlvbikgYWJvdXQgZWFjaCB3b3JrZXIgd2lsbCBiZSBkaXNwbGF5ZWQuIERvIHlvdSBo
YXZlDQo+IGFueSBvcGluaW9uIG9uIHRoYXQgaWRlYSBvciBkbyB5b3Ugc2VlIGFueSBwcm9ibGVt
IHdpdGggaXQ/DQoNClBlcnNvbmFsbHksIEkgdGhpbmsgaXQgc2VlbXMgcmVhc29uYWJsZSB0byBt
ZXJnZSB0aGUgeGFjdCBzdGF0IGludG8gdGhlIHZpZXcgZnJvbQ0Kc2F3YWRhLXNhbidzIHBhdGNo
Lg0KDQpPbmUgcHJvYmxlbSBJIG5vdGljZWQgaXMgdGhhdCBwZ19zdGF0X3N1YnNjcmlwdGlvbl9l
cnJvcg0KY3VycmVudGx5IGhhdmUgYSAnY291bnQnIGNvbHVtbiB3aGljaCBzaG93IGhvdyBtYW55
IHRpbWVzIHRoZSBsYXN0IGVycm9yDQpoYXBwZW5lZC4gVGhlIHhhY3Qgc3RhdCBoZXJlIGFsc28g
aGF2ZSBhIHNpbWlsYXIgdmFsdWUgJ3hhY3RfZXJyb3InLiBJIHRoaW5rIHdlDQptaWdodCBuZWVk
IHRvIHJlbmFtZSBpdCBvciBtZXJnZSB0aGVtIGludG8gb25lIGluIHNvbWUgd2F5Lg0KDQpCZXNp
ZGVzLCBpZiB3ZSBkZWNpZGUgdG8gbWVyZ2UgeGFjdCBzdGF0IGludG8gcGdfc3RhdF9zdWJzY3Jp
cHRpb25fZXJyb3IsIHNvbWUgY29sdW1uDQpzZWVtcyBuZWVkIHRvIGJlIHJlbmFtZWQuIE1heWJl
IGxpa2U6DQplcnJvcl9tZXNzYWdlID0+IExhc3RfZXJyb3JfbWVzc2FnZSwgY29tbWFuZD0+IGxh
c3RfZXJyb3JfY29tbWFuZC4uDQoNCkJlc3QgcmVnYXJkcywNCkhvdSB6ag0K