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 1mkPj7-0004Vf-LY for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Nov 2021 11:55:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mkPj6-0005bm-Gy for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Nov 2021 11:55:44 +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 1mkPj6-0005bc-6f for pgsql-hackers@lists.postgresql.org; Tue, 09 Nov 2021 11:55:44 +0000 Received: from esa18.fujitsucc.c3s2.iphmx.com ([216.71.158.38]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mkPj2-0007Cd-77 for pgsql-hackers@lists.postgresql.org; Tue, 09 Nov 2021 11:55:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1636458940; x=1667994940; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=1Suut5Qf8xbscsmkLhtBUl/PgUf8a43iNXEqUhXInrM=; b=Gm5oFkU2lOy9j0gwhTUbcUra3Kur1BM71vBQXH0rtsy9UteYAWUIm/9l Jpc+eEjCP2Fo5tOS/tebHWN9VjAcE2wMFWhOPAW6TorZBnR7I9UcZwpFY dscRPZXemDw3diwni9axJRhtG9N0difiE369Jelde1Xaa+uo8YDA6Xezm uHxjenB3ea76GdCvuVi5qcp8EjRzLtCGu2ZnBD3fQj/V4qcAOG702Zygk PLu9qoWPw3VaXEDhYx8FN12kjNRzpPN6Ufk/icDlqq0y+2ao+J4hU3lKQ eCWhJbIlmZlcw5NfaLLE1KbHr3QVLavXoToHdHD2xQIrQpFE4ktpSiYrM Q==; X-IronPort-AV: E=McAfee;i="6200,9189,10162"; a="43974582" X-IronPort-AV: E=Sophos;i="5.87,220,1631545200"; d="scan'208";a="43974582" Received: from mail-os2jpn01lp2050.outbound.protection.outlook.com (HELO JPN01-OS2-obe.outbound.protection.outlook.com) ([104.47.92.50]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 09 Nov 2021 20:55:36 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=IJVG89BcjYuFxjPt0PtYs6ioXM+HnYpvjPJKu+RVeWWnYjxODA0z75oICADf119397jYryjKsLe38F9Jo3kcflG0L42mthlsMXXni1cHZKnb/BZrFj0MXCoPxbjCIK+2YZly0T0by5MXWbOh+a4CtSUP+P+FNgoX5M+eRO1qI/SbmVSjezkGUizi9sIQxrP3Yg5/jzuYJx7UyC1X0E/t9H5nTUPWNw8xPkfFp0utC+/XucShNTvI+1i2ilJVl1Vkn/SeeKwNb1ewqGvi4kqzcOuJnEGDwwORWxgfxQpozztWzyqbk2YPrbl6onmatcCHsmRPskI2x1S3yhfaVlW2xw== 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=1Suut5Qf8xbscsmkLhtBUl/PgUf8a43iNXEqUhXInrM=; b=NUGt+iKHVrv+t178HAJ3wKdWQ0Tou5sgf0lnYZ2a3t6y6UAp8IsyqNvQqQ69yZTRhg5eW4bn7o2HMSjtH0quLiGvmDswbTRezTjX1PTtWREBdnnES64aIjMUV/hdrOjMrPUvCJtczp5F47x5U+GNMb948ETq8GyMWb8VH2fA+Nwx/HvMBxiRvpADmMmL7YxnMatm64MxGHQ6+H7zNTZfS90yKlRkChkBwDgNvyijPfWoW3XQssStt3sSuODbG7ndzf60zU/Mf8N8zXjxXwC/8S3CWaQN2WkcwpP3WZGyS4Mzj7Dr3+F04GG39RjK5dybygae6Yx9ENVQ/mZHzvHptQ== 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=1Suut5Qf8xbscsmkLhtBUl/PgUf8a43iNXEqUhXInrM=; b=d/yX2zkmKZM99CUQ3reCj0ibQPsxZ3+YWECVBHMEFpsNQkFuYe7mBuPPsCFe5CwqyQgJQRi5so9xh+EZ6KT+37CHpw2pEZ4pIqpngq0RGey9zqxXfoOXKZWPwonpBhRMdPqrXZ9cSxqqEPVIw8whi6VjD9VgC93WLtqrh+aTIuQ= Received: from TYCPR01MB8373.jpnprd01.prod.outlook.com (2603:1096:400:15f::9) by TYCPR01MB8803.jpnprd01.prod.outlook.com (2603:1096:400:188::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4669.11; Tue, 9 Nov 2021 11:55:33 +0000 Received: from TYCPR01MB8373.jpnprd01.prod.outlook.com ([fe80::adb3:be1d:5bb2:45f5]) by TYCPR01MB8373.jpnprd01.prod.outlook.com ([fe80::adb3:be1d:5bb2:45f5%7]) with mapi id 15.20.4669.016; Tue, 9 Nov 2021 11:55:33 +0000 From: "osumi.takamichi@fujitsu.com" To: 'Greg Nancarrow' CC: Masahiko Sawada , Amit Kapila , "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/RTlAANYpygAAhIjngAF7IiwAAMcV0oAAfP65gABBZ2kgAL69AQAAEaPLYAAAwHZQ Date: Tue, 9 Nov 2021 11:55:33 +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?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjEtMTEtMDlUMTE6MzU6?= =?utf-8?B?MjJaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?= =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?= =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?= =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?= =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?= =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD04MTI5N2FkNS03ZjcwLTRkM2Et?= =?utf-8?B?YmEyOC01ZjczOTg0MGFjNTY7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?= =?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: 3fa24ff7-1d64-4b41-3062-08d9a377d5bf x-ms-traffictypediagnostic: TYCPR01MB8803: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:6430; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 7PhmQyyl40Ho+MfW6FYW59K5VClMh34IO6CrA/qcERzXIk54gy+TCiirEVYCXMGErvb30ZNFu0XMP/lK0r0nAkdPZOcrWwgwqtYCQ4GOowrDCOivGMCDdCgvl8SaZapMCzNKRvXwQFNfwImo1ZkXsVFewebCND0SELrbqqVVUxpMzYgWIH4U/F/Y3sUWNcWn77AqzEVh9yyCkjl5gtKPIpXCh16Ru3g/4yN/B5jFrszAOOa4Hzd18FLMRdUh0tY72PN9VydG7SF9nZJW1kfsO4Ro3EGs2woPGh4HksmNvSYonqW4X2SxmjOFPP/vkRAljJg0oKZYyoLooUPGIhquqHCxfrnfltwEYUeT/lLSBsjRvVF1uCcspI+FLYHOX9kwY9/3P7nMVyt+MOYNWFl2v4Dlsr1IZLuqvYKYgZnifUKidHvu3QPF3g2d8nEBJNIUae/zXV52YvUGWL7b9V4WztCg5KyIyDLzqsPRuLyPIx+EnFSNkC63KjFMzZSouKyXhhvonmqRP88PJwbzc252L2AI0Jg0FfPjmgz9nHYDKTfR6zX/hUnLzDw/h//fCb6UoGLDhJrJqh0T45c10L2p11+Y0wtosZS79tXHSq3q2rpdtR0Emt0o99SHKJG6LTIzhv8sYBE0RBnFPL72wiqD+KCgHUg+bk92OxRbraZB3XAsct/olLq+x1IoDf1UyHAg9H+SnT9esJWg8YOP1jP8EC7IhZwmOPt3iglpwBUxCpYqEsWV/sSP7bNFq/lmMfOEqzJVQ7kEPPJLp2lm3MoCNIzixsR+ih/whDt75ZMoWYk= 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)(186003)(2906002)(54906003)(4326008)(508600001)(6916009)(5660300002)(66946007)(82960400001)(66556008)(66446008)(316002)(966005)(76116006)(85182001)(4744005)(33656002)(66476007)(8676002)(6506007)(2940100002)(53546011)(83380400001)(86362001)(64756008)(9686003)(26005)(71200400001)(38100700002)(7696005)(52536014)(122000001)(8936002)(55016002)(38070700005);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?cHBrV2k2eFVFS2pibDk5eVY2WkFyN0RQcW84Z3NUcUlORWJHb1hVcGY3UEoy?= =?utf-8?B?dVArZXZWdnlCSWZrMmU1ODZ5YS9KQlljODUvWGZ5QzN4dTJJV1h2ODNKSkdJ?= =?utf-8?B?SmVNTktVRGFpQkFodW5DN25NQUdCYkRDK2c0L0FyUUdDTS8wdGlPZGV2bGE3?= =?utf-8?B?YjQ5M213MDY5eUJwZDd4NUFDUkxobHZnS1JnVStFWHRCZmQ3cXRaZS93TTdG?= =?utf-8?B?cENGelhCNFVUa1BTUDRmSjZqNDg1UU1ibFhwMHE2eHhLYnRoT2VRZFd0bXpP?= =?utf-8?B?cEwySHIzSWFoa2JtK2JmUmxTT2luMW5uaHI2b3JmL3liNVV3R054dld0Sitw?= =?utf-8?B?bktLRitFZGhMSEFzbTF6NWRPNElYQjNjRW02SzVLNG9RNFY5c3FvUFlDbCtr?= =?utf-8?B?M2J5RWF0QllXOWQvZ1VkUmx1REtTQkNPQ1JXUXRJL2xWbHFrUy9IVitxK1Fi?= =?utf-8?B?R3daM2FBY2U4Q2hOVVhoMzJWdEJGR1kwT1RSZEU4aTFlTkNoeW1QSW44bTJL?= =?utf-8?B?anRncW5scnN4bS96emhVY2dqN2JzbHI5dUEwbmJhSzhUd0VqdHRoK1AxNTVP?= =?utf-8?B?b1IyZklPUUFWN2NURVNYS3FOb01BZkh0NzlqRjlyamtXdE1aeEpFVEc3NThT?= =?utf-8?B?cTh3dDFCdUNPeHZ6anltbzdCdDE4TzBtNjZnMjl0dnJNa1ZSdzdack1QUVl2?= =?utf-8?B?anIzWUUxQTY5cnBvbTRweHE2OXdnemRiMGJ3WmJRc29QZDZ6Ykt4aTJ6M280?= =?utf-8?B?ejhhRlVMdkxjL2plMU1NQkQ1QkQ4ci9RWGtqYmhYNW15UW44MnZLQVpObUsx?= =?utf-8?B?WThVK2M5eTVTSHQwenJUeU5GVTBzMGN3aVFxeVRuYmlLaU01Mkd3R1ZzREt3?= =?utf-8?B?ZlR6VGhPbERqai9BZUszbC9lRThuZm9abVVEbTRFaExHTHRqMlBWTE1QcjhH?= =?utf-8?B?ZUNNOEJ5N3hBZndXTldtaEU1UEMrWUEyelJKRjk1Y29TN2xsK1UzRXRYZ1d0?= =?utf-8?B?ZTJLUjlUenRVa0w3OFREdlQxak5Ed1diWFRhYkZxR2VCakJKNTlLaXdISllN?= =?utf-8?B?Sm82LytYbXpDT2lQSjN1cjE4TUVyNHJmZlYxSlhFUmgveEQ4bkVBVXZrYUNW?= =?utf-8?B?bVJUSFdJL290SnBMU2R0SHZiVUhzUHRoWU5FVHRxQTFKeExsWXZkeUphQ1dU?= =?utf-8?B?VmRVZDBWSXozSEN2K2RjbXZRdGh4WUs3c3R6OTRId1E2a242SE1PUGRuNkVE?= =?utf-8?B?ZzJkOWZyYzJORWphVXdTYTFOOWdKQlNwaVZ6dnIrMUVPNy9FZysxUk5lWUta?= =?utf-8?B?Z3k3MTJGYVhKRE9mcGdqMzlYN2VzRGNYeXJoeUZwMitWSFpMeGlTb2tvajlU?= =?utf-8?B?NEVmc3c0NkVuaWhrcHZkak5DMFA1YWFWaTVubVNtWVQwSHNhNXJaK3o4eFha?= =?utf-8?B?blk1Z3MzVndSNU54Q1BvYXRiM0RCRkdoN0VvMEtzVW0zUE9LdmNaM210SzZh?= =?utf-8?B?U1A0NGhIV1FqdTc3MzlZV0ZEQzJYc2xvbHludTEvdEFEWlBzSTRsTVlpbGI2?= =?utf-8?B?allFaDk1NUdRNk5XUVJoL0JaNTMyVnRFclk5YmpNK0FNaFZ2UTBkWGVHZ2pQ?= =?utf-8?B?b1pZR0VZM1ZMMlZvZXBrSDhIcjZZbVFKY0lWcFE5NjRDaGk0MExxcGg2QlN6?= =?utf-8?B?Kys2TmxCNlc1VnhVcFN5TlJyQ0dGWXZqdExISHI3cnNNbEFoM1Z6V1FiQUZJ?= =?utf-8?B?QUJwN0h1U3NnWTg2TGVaWjJ2UlhuSnVFU2dQR0F0SDREZnhGOEI3U04xem9F?= =?utf-8?B?MVNxOU9ub09TekNncHpFVHd5K0I2N3ViRkpEVjZpTTlSQUdvUkVoUTJkT1lS?= =?utf-8?B?SVNiNVdESnZQWVhwYWE2RHZWeVRYRkJmZU55WmlmdHZUcFRneFNMcE9uWlFu?= =?utf-8?B?bE5iNDZYWnRla29rb3NUdVJMSWt6NDdVb1ZZbmRTNkN3VUJSZCtiNkI0NGNk?= =?utf-8?B?RFplZzdoVEt5WG9iSTdyOXlkZHNFL25wV0V0VzBhMG9QK1Z5RXpyNWUyVGk5?= =?utf-8?B?Sjdkay9IQkcrMitONytId0lRRkxPeExaQ2F4aHJ3K1ZXWExxbGY0TFZ1ZDgx?= =?utf-8?B?ZmdodHlsRlNZZmJKc0JzSGd5TUVzZkJTUlIxSEVqVkdZMXA4ZU5mZDdqbEUr?= =?utf-8?B?Z0p2OG5rVUlONlR1eXRuWGgrL2dQTVdNRmZZMGNLaWhrejdGSzVIUTNnTGNZ?= =?utf-8?B?UlBibHhuK0N6cGR0eERqUHphSVNBPT0=?= 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: 3fa24ff7-1d64-4b41-3062-08d9a377d5bf X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Nov 2021 11:55:33.0844 (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: TKjmdCsJAlioDSy3FyaYI5s6sULdVwlLKkQ75SGxGKFm3O1BFqK7Yx0PsmVw1PkXvgI0MtFD9IPlXkzpAYV3b5XBMlmBU4mmtXWRWhnn+50= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYCPR01MB8803 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVHVlc2RheSwgTm92ZW1iZXIgOSwgMjAyMSA4OjM1IFBNIEkgd3JvdGU6DQo+IFllcy4gSSd2 ZSByZWJhc2VkIGFuZCB1cGRhdGVkIHRoZSBwYXRjaCwgcGF5aW5nIGF0dGVudGlvbiB0byB0aGlz IHBvaW50Lg0KPiBBdHRhY2hlZCB0aGUgdXBkYXRlZCB2ZXJzaW9uLg0KRm9yZ290IHRvIG5vdGUg b25lIHRoaW5nLg0KVGhpcyBpcyBiYXNlZCBvbiB0aGUgc2tpcCB4aWQgdjIwIHNoYXJlZCBpbiBb MV0NCg0KWzFdIC0gaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9DQUQyMUFv QVQ0Mm1oY3FlQjFqUGZSTDElMkJFVUhiWms4TU1ZX2ZCZ3N5WnZKZUtOcEclMkJ3JTQwbWFpbC5n bWFpbC5jb20NCg0KQmVzdCBSZWdhcmRzLA0KCVRha2FtaWNoaSBPc3VtaQ0KDQo=