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 1pIsXS-0005gh-VR for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Jan 2023 14:38:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pIsXR-0007bW-4f for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Jan 2023 14:38:41 +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 1pIsXQ-0007bN-O3 for pgsql-hackers@lists.postgresql.org; Fri, 20 Jan 2023 14:38:40 +0000 Received: from smtp-fw-80007.amazon.com ([99.78.197.218]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pIsXO-0002jq-8v for pgsql-hackers@postgresql.org; Fri, 20 Jan 2023 14:38:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1674225519; x=1705761519; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=soBg+TwYvUl8PlhWi3nuJJVALgPLKCGCFVTbcyZdYmU=; b=hRbJSVj5HcUoxC4sRNSBgGwH3Ib/3Ah59hGUTC14txl/y8UGjrFX7cEf jBmLx+P8o7hP1XEdeQCmT4YfO4nfFkFcuB19ZyLbY6FAC9KnkFxE67NKM 71YBAzgsseg5inORMMyxcE/uEqY6axccJtNfzQ3SfwLuIRUH33qDhG7OT A=; X-IronPort-AV: E=Sophos;i="5.97,232,1669075200"; d="scan'208";a="173245717" Subject: Re: Add index scan progress to pg_stat_progress_vacuum Thread-Topic: Add index scan progress to pg_stat_progress_vacuum Received: from pdx4-co-svc-p1-lb2-vlan3.amazon.com (HELO email-inbound-relay-pdx-2a-m6i4x-44b6fc51.us-west-2.amazon.com) ([10.25.36.214]) by smtp-border-fw-80007.pdx80.corp.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 20 Jan 2023 14:38:36 +0000 Received: from EX13MTAUWC001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-pdx-2a-m6i4x-44b6fc51.us-west-2.amazon.com (Postfix) with ESMTPS id 8E67BA3717; Fri, 20 Jan 2023 14:38:34 +0000 (UTC) Received: from EX19D003UWC004.ant.amazon.com (10.13.138.150) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1497.45; Fri, 20 Jan 2023 14:38:34 +0000 Received: from EX19D013UWA001.ant.amazon.com (10.13.138.253) by EX19D003UWC004.ant.amazon.com (10.13.138.150) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1118.7; Fri, 20 Jan 2023 14:38:33 +0000 Received: from EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964]) by EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964%5]) with mapi id 15.02.1118.020; Fri, 20 Jan 2023 14:38:33 +0000 From: "Imseih (AWS), Sami" To: Masahiko Sawada CC: Andres Freund , "Drouvot, Bertrand" , vignesh C , "Nathan Bossart" , Robert Haas , "Bossart, Nathan" , Peter Geoghegan , Justin Pryzby , "pgsql-hackers@postgresql.org" Thread-Index: AQHZA4UjiGMtZ7l1bk+swoIiaI4jE65gO6uAgAqyogCAAcWAAP//1SQAgBpsPYCAA2YugIACX5aA////NwCAAYLDgIAAO8SAgAE67gCAANixAIAAtUEAgADKN4CABRmogIADi7YAgAyQ/4CAAAv5AA== Date: Fri, 20 Jan 2023 14:38:33 +0000 Message-ID: <08FEC8D2-B5BA-4E0F-80EB-5428E7C980EC@amazon.com> References: <20221230183955.GB437226@nathanxps13> <3D992C93-AA5D-4719-8712-6ECD3D864966@amazon.com> <7A191516-3D65-4819-BF19-E116B53E783C@amazon.com> <977c555e-5d10-526f-ada0-b58d12267075@gmail.com> <2397CA8A-DAD7-46C7-AF69-97365DA47AF8@amazon.com> <84DF5E2A-3AB5-4744-92B3-DA63F9C4B3AE@amazon.com> <39C09108-1A6A-4105-9E16-5F0F68503658@amazon.com> <20230110015247.yspx3hkz2sk6p6u3@awork3.anarazel.de> <72CD33F6-C2B5-45E4-A78F-85EC923DCF0F@amazon.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.106.178.27] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiAgICBOdW1iZXIgb2YgaW5kZXhlcyB0aGF0IHdpbGwgYmUgdmFjdXVtZWQgb3IgY2xlYW5lZCB1 cC4gVGhpcyBjb3VudGVyIG9ubHkNCj4gICAgYWR2YW5jZXMgd2hlbiB0aGUgcGhhc2UgaXMgdmFj dXVtaW5nIGluZGV4ZXMgb3IgY2xlYW5pbmcgdXAgaW5kZXhlcy4NCg0KSSBhZ3JlZSwgdGhpcyBy ZWFkcyBiZXR0ZXIuDQoNCiAgICAtLS0NCiAgICAtICAgICAgICAvKiBSZXBvcnQgdGhhdCB3ZSBh cmUgbm93IHZhY3V1bWluZyBpbmRleGVzICovDQogICAgLSAgICAgICAgcGdzdGF0X3Byb2dyZXNz X3VwZGF0ZV9wYXJhbShQUk9HUkVTU19WQUNVVU1fUEhBU0UsDQogICAgLQ0KICAgIFBST0dSRVNT X1ZBQ1VVTV9QSEFTRV9WQUNVVU1fSU5ERVgpOw0KICAgICsgICAgICAgIC8qDQogICAgKyAgICAg ICAgICogUmVwb3J0IHRoYXQgd2UgYXJlIG5vdyB2YWN1dW1pbmcgaW5kZXhlcw0KICAgICsgICAg ICAgICAqIGFuZCB0aGUgbnVtYmVyIG9mIGluZGV4ZXMgdG8gdmFjdXVtLg0KICAgICsgICAgICAg ICAqLw0KICAgICsgICAgICAgIHByb2dyZXNzX3N0YXJ0X3ZhbFswXSA9IFBST0dSRVNTX1ZBQ1VV TV9QSEFTRV9WQUNVVU1fSU5ERVg7DQogICAgKyAgICAgICAgcHJvZ3Jlc3Nfc3RhcnRfdmFsWzFd ID0gdmFjcmVsLT5uaW5kZXhlczsNCiAgICArICAgICAgICBwZ3N0YXRfcHJvZ3Jlc3NfdXBkYXRl X211bHRpX3BhcmFtKDIsIHByb2dyZXNzX3N0YXJ0X2luZGV4LA0KICAgIHByb2dyZXNzX3N0YXJ0 X3ZhbCk7DQoNCj4gICAgQWNjb3JkaW5nIHRvIG91ciBjb2RlIHN0eWxlIGd1aWRlbGluZVsxXSwg d2UgbGltaXQgbGluZSBsZW5ndGhzIHNvDQo+ICAgIHRoYXQgdGhlIGNvZGUgaXMgcmVhZGFibGUg aW4gYW4gODAtY29sdW1uIHdpbmRvdy4gU29tZSBjb21tZW50cw0KID4gICB1cGRhdGVkIGluIHRo aXMgcGF0Y2ggc2VlbSB0b28gc2hvcnQuDQoNCkkgd2lsbCBjb3JyZWN0IHRoaXMuDQoNCj4gICAg SSB0aGluayBpdCdzIGJldHRlciB0byBkZWZpbmUgInZvaWQgKmFyZyIuDQoNCkFncmVlDQoNCj4g ICAgLS0tDQo+ICAgICsgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8qDQo+ICAgICsg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAqIEEgTGVhZGVyIHByb2Nlc3MgdGhhdCBy ZWNlaXZlcyB0aGlzIG1lc3NhZ2UNCj4gICAgKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICogbXVzdCBiZSByZWFkeSB0byB1cGRhdGUgcHJvZ3Jlc3MuDQo+ICAgICsgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAqLw0KPiAgICArICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBBc3NlcnQocGN4dC0+cGFyYWxsZWxfcHJvZ3Jlc3NfY2FsbGJhY2spOw0KPiAgICAr ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBBc3NlcnQocGN4dC0+cGFyYWxsZWxfcHJv Z3Jlc3NfY2FsbGJhY2tfYXJnKTsNCj4gICAgKw0KPiAgICArICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAvKiBSZXBvcnQgcHJvZ3Jlc3MgKi8NCj4gICAgKw0KPiAgICBwY3h0LT5wYXJh bGxlbF9wcm9ncmVzc19jYWxsYmFjayhwY3h0LT5wYXJhbGxlbF9wcm9ncmVzc19jYWxsYmFja19h cmcpOw0KDQo+ICAgIEkgdGhpbmsgdGhlIHBhcmFsbGVsIHF1ZXJ5IGluZnJhIHNob3VsZCBub3Qg cmVxdWlyZQ0KPiAgICBwYXJhbGxlbF9wcm9ncmVzc19jYWxsYmFja19hcmcgdG8gYWx3YXlzIGJl IHNldC4gSSB0aGluayBpdCBjYW4gYmUNCj4gICAgTlVMTC4NCg0KVGhpcyBhc3NlcnRpb24gaXMg aW5zaWRlIHRoZSBuZXcgJ1AnIG1lc3NhZ2UgdHlwZSBoYW5kbGluZy4NCklmIGEgbGVhZGVyIGlz IGNvbnN1bWluZyB0aGlzIG1lc3NhZ2UsIHRoZXkgbXVzdCBoYXZlIGENCnByb2dyZXNzIGNhbGxi YWNrIHNldC4gUmlnaHQgbm93IHdlIG9ubHkgc2V0IHRoZSBjYWxsYmFjaw0KaW4gdGhlIHBhcmFs bGVsIHZhY3V1bSBjYXNlIG9ubHksIHNvIG5vdCBhbGwgbGVhZGVycyB3aWxsIGJlIHByZXBhcmVk DQp0byBoYW5kbGUgdGhpcyBjYXNlLiANCg0KV291bGQgeW91IGFncmVlIHRoaXMgaXMgbmVlZGVk IGZvciBzYWZldHk/DQoNCiAgICAgICAgY2FzZSAnUCc6ICAgICAgICAgICAgICAgLyogUGFyYWxs ZWwgcHJvZ3Jlc3MgcmVwb3J0aW5nICovDQogICAgICAgICAgICB7DQogICAgICAgICAgICAgICAg LyoNCiAgICAgICAgICAgICAgICAgKiBBIExlYWRlciBwcm9jZXNzIHRoYXQgcmVjZWl2ZXMgdGhp cyBtZXNzYWdlDQogICAgICAgICAgICAgICAgICogbXVzdCBiZSByZWFkeSB0byB1cGRhdGUgcHJv Z3Jlc3MuDQogICAgICAgICAgICAgICAgICovDQogICAgICAgICAgICAgICAgQXNzZXJ0KHBjeHQt PnBhcmFsbGVsX3Byb2dyZXNzX2NhbGxiYWNrKTsNCiAgICAgICAgICAgICAgICBBc3NlcnQocGN4 dC0+cGFyYWxsZWxfcHJvZ3Jlc3NfY2FsbGJhY2tfYXJnKTsNCg0KICAgIC0tLQ0KPiAgICArdm9p ZA0KPiAgICArcGFyYWxsZWxfdmFjdXVtX3VwZGF0ZV9wcm9ncmVzcyh2b2lkICphcmcpDQo+ICAg ICt7DQo+ICAgICsgICAgICAgIFBhcmFsbGVsVmFjdXVtU3RhdGUgKnB2cyA9IChQYXJhbGxlbFZh Y3V1bVN0YXRlICopYXJnOw0KPiAgICArDQo+ICAgICsgICAgICAgIEFzc2VydCghSXNQYXJhbGxl bFdvcmtlcigpKTsNCj4gICAgKw0KPiAgICArICAgICAgICBpZiAocHZzKQ0KPiAgICArICAgICAg ICAgICAgICAgIHBnc3RhdF9wcm9ncmVzc191cGRhdGVfcGFyYW0oUFJPR1JFU1NfVkFDVVVNX0lO REVYX0NPTVBMRVRFRCwNCj4gICAgKw0KPiAgICAgICBwZ19hdG9taWNfYWRkX2ZldGNoX3UzMigm KHB2cy0+c2hhcmVkLT5uaW5kZXhlc19jb21wbGV0ZWQpLCAxKSk7DQo+ICAgICt9DQoNCj4gICAg U2luY2UgcGFyYWxsZWwgdmFjdXVtIGFsd2F5cyBzZXRzIHRoZSBhcmcsIEkgdGhpbmsgd2UgZG9u J3QgbmVlZCB0byBjaGVjayBpdC4NCg0KVGhlIGFyZyBpcyBvbmx5IHNldCBkdXJpbmcgcGFyYWxs ZWwgdmFjdXVtLiBEdXJpbmcgbm9uLXBhcmFsbGVsIHZhY3V1bSwNCkl0J3MgTlVMTC4gVGhpcyBj aGVjayBjYW4gYmUgcmVtb3ZlZCwgYnV0IEkgcmVhbGl6ZSBub3cgdGhhdCB3ZSBkbyBuZWVkIA0K YW4gQXNzZXJ0KHB2cykuIERvIHlvdSBhZ3JlZT8NCg0KLS0NCg0KUmVnYXJkcywNCg0KU2FtaSBJ bXNlaWgNCkFtYXpvbiBXZWIgU2VydmljZXMgKEFXUykNCg0KDQo=