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 1n7MOx-0002eC-FN for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Jan 2022 19:01:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n7MOw-0007EN-BH for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Jan 2022 19:01:46 +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 1n7MOv-0007EE-Tf for pgsql-hackers@lists.postgresql.org; Tue, 11 Jan 2022 19:01:46 +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 1n7MOt-0006ME-FP for pgsql-hackers@postgresql.org; Tue, 11 Jan 2022 19:01:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1641927704; x=1673463704; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=u0mtlSCIoDSF6MupANnVWEK9hjCM0uIcVc6vyjd21tE=; b=o3xUUYdeUMBAr4VHizTLCNo4GVOsj7LaFh9b0NJec5mBSqVRnB07HVrQ KzBsSB4On8F4i7khZ0rm+xClMPxFyv3EGYPtJQ07To4Xo8FRjJfoKVXgH 96I75o2R5EoGBSbwTlkpWS+oJj/+ebXDR1CvYR8fEboY46O7GNpBRSBkA E=; X-IronPort-AV: E=Sophos;i="5.88,279,1635206400"; d="scan'208";a="54584921" 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-vlan2.amazon.com (HELO email-inbound-relay-iad-1e-98691110.us-east-1.amazon.com) ([10.25.36.210]) by smtp-border-fw-80007.pdx80.corp.amazon.com with ESMTP; 11 Jan 2022 19:01:40 +0000 Received: from EX13MTAUWB001.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan3.iad.amazon.com [10.40.163.38]) by email-inbound-relay-iad-1e-98691110.us-east-1.amazon.com (Postfix) with ESMTPS id 57EA581163; Tue, 11 Jan 2022 19:01:38 +0000 (UTC) Received: from EX13D13UWB002.ant.amazon.com (10.43.161.21) by EX13MTAUWB001.ant.amazon.com (10.43.161.207) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Tue, 11 Jan 2022 19:01:37 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D13UWB002.ant.amazon.com (10.43.161.21) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Tue, 11 Jan 2022 19:01:37 +0000 Received: from EX13D03UWC004.ant.amazon.com ([10.43.162.49]) by EX13D03UWC004.ant.amazon.com ([10.43.162.49]) with mapi id 15.00.1497.026; Tue, 11 Jan 2022 19:01:37 +0000 From: "Bossart, Nathan" To: "Imseih (AWS), Sami" , Justin Pryzby CC: Masahiko Sawada , Peter Geoghegan , "pgsql-hackers@postgresql.org" Thread-Index: AQHX5uocuLg5vK9yXkugZYU7JVvUD6wzrQ+AgAgmSICABBF2gIAG6AwAgAKncACAAHdDgIAB+R4AgApC9gCAAH6XgIAFpgqAgACO0YCAAQxNAA== Date: Tue, 11 Jan 2022 19:01:37 +0000 Message-ID: References: <5478DFCD-2333-401A-B2F0-0D186AB09228@amazon.com> <7874FB21-FAA5-49BD-8386-2866552656C7@amazon.com> <7F1C93C1-C50E-497A-86C5-B637EA4D9F79@amazon.com> <04D9F80C-1A7C-4C23-9156-6799D974DC72@amazon.com> <20211229175121.GP24477@telsasoft.com> <39E8ED08-56E6-4466-93BF-3FD3D51EE52C@amazon.com> <5883EFA0-1AFF-46C3-A8A7-0DA63640482F@amazon.com> <6D2C60C2-C09E-4117-A6B8-DCA7A0F5B182@amazon.com> <22C9CB0C-9576-47AF-8A6E-F9573F73CD4E@amazon.com> In-Reply-To: <22C9CB0C-9576-47AF-8A6E-F9573F73CD4E@amazon.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.162.228] 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 T24gMS8xMC8yMiwgNTowMSBQTSwgIkltc2VpaCAoQVdTKSwgU2FtaSIgPHNpbXNlaWhAYW1hem9u LmNvbT4gd3JvdGU6DQo+IEkgaGF2ZSBhdHRhY2hlZCB0aGUgM3JkIHJldmlzaW9uIG9mIHRoZSBw YXRjaCB3aGljaCBhbHNvIGluY2x1ZGVzIHRoZSBkb2N1bWVudGF0aW9uIGNoYW5nZXMuIEFsc28g YXR0YWNoZWQgaXMgYSByZW5kZXJlZCBodG1sIG9mIHRoZSBkb2NzIGZvciByZXZpZXcuDQo+DQo+ ICJtYXhfaW5kZXhfdmFjdXVtX2N5Y2xlX3RpbWUiIGhhcyBiZWVuIHJlbW92ZWQuDQo+ICJpbmRl eF9yb3dzX3ZhY3V1bWVkIiByZW5hbWVkIHRvICJpbmRleF90dXBsZXNfcmVtb3ZlZCIuICJ0dXBs ZXMiIGlzIGEgbW9yZSBjb25zaXN0ZW50IHdpdGggdGhlIHRlcm1pbm9sb2d5IHVzZWQuDQo+ICJ2 YWN1dW1fY3ljbGVfb3JkaW5hbF9wb3NpdGlvbiIgcmVuYW1lZCB0byAiaW5kZXhfb3JkaW5hbF9w b3NpdGlvbiIuDQoNClRoYW5rcyBmb3IgdGhlIG5ldyB2ZXJzaW9uIG9mIHRoZSBwYXRjaCENCg0K bml0cGljazogSSBnZXQgb25lIHdoaXRlc3BhY2UgZXJyb3Igd2hlbiBhcHBseWluZyB0aGUgcGF0 Y2guDQoNCiAgICAgICAgQXBwbHlpbmc6IEV4cG9zZSBwcm9ncmVzcyBmb3IgdGhlICJ2YWN1dW1p bmcgaW5kZXhlcyIgcGhhc2Ugb2YgYSBWQUNVVU0gb3BlcmF0aW9uLg0KICAgICAgICAuZ2l0L3Jl YmFzZS1hcHBseS9wYXRjaDo0NDogdGFiIGluIGluZGVudC4NCiAgICAgICAgICAgV2hlbmV2ZXIg PHhyZWYgbGlua2VuZD0iZ3VjLXZhY3V1bS1mYWlsc2FmZS1hZ2UiLz4gaXMgdHJpZ2dlcmVkLCBp bmRleA0KICAgICAgICB3YXJuaW5nOiAxIGxpbmUgYWRkcyB3aGl0ZXNwYWNlIGVycm9ycy4NCg0K KyAgICAgPHJvdz4NCisgICAgICA8ZW50cnkgcm9sZT0iY2F0YWxvZ190YWJsZV9lbnRyeSI+PHBh cmEgcm9sZT0iY29sdW1uX2RlZmluaXRpb24iPg0KKyAgICAgICA8c3RydWN0ZmllbGQ+bnVtX2lu ZGV4ZXNfdG9fdmFjdXVtPC9zdHJ1Y3RmaWVsZD4gPHR5cGU+YmlnaW50PC90eXBlPg0KKyAgICAg IDwvcGFyYT4NCisgICAgICA8cGFyYT4NCisgICAgICAgVGhlIG51bWJlciBvZiBpbmRleGVzIHRo YXQgd2lsbCBiZSB2YWN1dW1lZC4gT25seSBpbmRleGVzIHdpdGgNCisgICAgICAgPGxpdGVyYWw+ cGdfaW5kZXguaW5kaXNyZWFkeTwvbGl0ZXJhbD4gc2V0IHRvICJ0cnVlIiB3aWxsIGJlIHZhY3V1 bWVkLg0KKyAgICAgICBXaGVuZXZlciA8eHJlZiBsaW5rZW5kPSJndWMtdmFjdXVtLWZhaWxzYWZl LWFnZSIvPiBpcyB0cmlnZ2VyZWQsIGluZGV4DQorICAgICAgIHZhY3V1bWluZyB3aWxsIGJlIGJ5 cGFzc2VkLg0KKyAgICAgIDwvcGFyYT48L2VudHJ5Pg0KKyAgICAgPC9yb3c+DQorICAgIDwvdGJv ZHk+DQorICAgPC90Z3JvdXA+DQorICA8L3RhYmxlPg0KDQpXZSBtYXkgd2FudCB0byBhdm9pZCBl eGhhdXN0aXZlbHkgbGlzdGluZyB0aGUgY2FzZXMgd2hlbiB0aGlzIHZhbHVlDQp3aWxsIGJlIHpl cm8uICBJIHdvdWxkIHN1Z2dlc3Qgc2F5aW5nLCAiV2hlbiBpbmRleCBjbGVhbnVwIGlzIHNraXBw ZWQsDQp0aGlzIHZhbHVlIHdpbGwgYmUgemVybyIgaW5zdGVhZC4NCg0KKyAgICAgPHJvdz4NCisg ICAgICA8ZW50cnkgcm9sZT0iY2F0YWxvZ190YWJsZV9lbnRyeSI+PHBhcmEgcm9sZT0iY29sdW1u X2RlZmluaXRpb24iPg0KKyAgICAgICA8c3RydWN0ZmllbGQ+cmVsaWQ8L3N0cnVjdGZpZWxkPiA8 dHlwZT5vaWQ8L3R5cGU+DQorICAgICAgPC9wYXJhPg0KKyAgICAgIDxwYXJhPg0KKyAgICAgICBP SUQgb2YgdGhlIHRhYmxlIGJlaW5nIHZhY3V1bWVkLg0KKyAgICAgIDwvcGFyYT48L2VudHJ5Pg0K KyAgICAgPC9yb3c+DQoNCkRvIHdlIG5lZWQgdG8gaW5jbHVkZSB0aGlzIGZpZWxkPyAgSSB3b3Vs ZCBleHBlY3QgaW5kZXhyZWxpZCB0byBnbw0KaGVyZS4NCg0KKyAgICAgPHJvdz4NCisgICAgICA8 ZW50cnkgcm9sZT0iY2F0YWxvZ190YWJsZV9lbnRyeSI+PHBhcmEgcm9sZT0iY29sdW1uX2RlZmlu aXRpb24iPg0KKyAgICAgICA8c3RydWN0ZmllbGQ+bGVhZGVyX3BpZDwvc3RydWN0ZmllbGQ+IDx0 eXBlPmJpZ2ludDwvdHlwZT4NCisgICAgICA8L3BhcmE+DQorICAgICAgPHBhcmE+DQorICAgICAg IFByb2Nlc3MgSUQgb2YgdGhlIHBhcmFsbGVsIGdyb3VwIGxlYWRlci4gVGhpcyBmaWVsZCBpcyA8 bGl0ZXJhbD5OVUxMPC9saXRlcmFsPg0KKyAgICAgICBpZiB0aGlzIHByb2Nlc3MgaXMgYSBwYXJh bGxlbCBncm91cCBsZWFkZXIgb3IgdGhlDQorICAgICAgIDxsaXRlcmFsPnZhY3V1bWluZyBpbmRl eGVzPC9saXRlcmFsPiBwaGFzZSBpcyBub3QgcGVyZm9ybWVkIGluIHBhcmFsbGVsLg0KKyAgICAg IDwvcGFyYT48L2VudHJ5Pg0KKyAgICAgPC9yb3c+DQoNCkFyZSB0aGVyZSBjYXNlcyB3aGVyZSB0 aGUgcGFyYWxsZWwgZ3JvdXAgbGVhZGVyIHdpbGwgaGF2ZSBhbiBlbnRyeSBpbg0KdGhpcyB2aWV3 IHdoZW4gcGFyYWxsZWxpc20gaXMgZW5hYmxlZD8NCg0KKyAgICAgPHJvdz4NCisgICAgICA8ZW50 cnkgcm9sZT0iY2F0YWxvZ190YWJsZV9lbnRyeSI+PHBhcmEgcm9sZT0iY29sdW1uX2RlZmluaXRp b24iPg0KKyAgICAgICA8c3RydWN0ZmllbGQ+aW5kZXhfb3JkaW5hbF9wb3NpdGlvbjwvc3RydWN0 ZmllbGQ+IDx0eXBlPmJpZ2ludDwvdHlwZT4NCisgICAgICA8L3BhcmE+DQorICAgICAgPHBhcmE+ DQorICAgICAgIFRoZSBvcmRlciBpbiB3aGljaCB0aGUgaW5kZXggaXMgYmVpbmcgdmFjdXVtZWQu IEluZGV4ZXMgYXJlIHZhY3V1bWVkIGJ5IE9JRCBpbiBhc2NlbmRpbmcgb3JkZXIuDQorICAgICAg PC9wYXJhPjwvZW50cnk+DQorICAgICA8L3Jvdz4NCg0KU2hvdWxkIHdlIGluY2x1ZGUgdGhlIGJp dCBhYm91dCB0aGUgT0lEIG9yZGVyaW5nPyAgSSBzdXBwb3NlIHRoYXQgaXMNCnVubGlrZWx5IHRv IGNoYW5nZSBpbiB0aGUgbmVhciBmdXR1cmUsIGJ1dCBJIGRvbid0IGtub3cgaWYgaXQgaXMNCnJl bGV2YW50IGluZm9ybWF0aW9uLiAgQWxzbywgZG8gd2UgbmVlZCB0byBpbmNsdWRlIHRoZSAiaW5k ZXhfIg0KcHJlZml4PyAgVGhpcyB2aWV3IGlzIHNwZWNpZmljIGZvciBpbmRleGVzLiAgKEkgaGF2 ZSB0aGUgc2FtZSBxdWVzdGlvbg0KZm9yIGluZGV4X3R1cGxlc19yZW1vdmVkLikNCg0KU2hvdWxk IHRoaXMgbmV3IHRhYmxlIGdvIGFmdGVyIHRoZSAiVkFDVVVNIHBoYXNlcyIgdGFibGU/ICBJdCBt aWdodA0KbWFrZSBzZW5zZSB0byBrZWVwIHRoZSBwaGFzZXMgdGFibGUgY2xvc2VyIHRvIHdoZXJl IGl0IGlzIHJlZmVyZW5jZWQuDQoNCisgICAgLyogQWR2ZXJ0aXNlIHRoZSBudW1iZXIgb2YgaW5k ZXhlcyB0byB2YWN1dW0gaWYgd2UgYXJlIG5vdCBpbiBmYWlsc2FmZSBtb2RlICovDQorICAgIGlm ICghbGF6eV9jaGVja193cmFwYXJvdW5kX2ZhaWxzYWZlKHZhY3JlbCkpDQorICAgICAgICBwZ3N0 YXRfcHJvZ3Jlc3NfdXBkYXRlX3BhcmFtKFBST0dSRVNTX1ZBQ1VVTV9UT1RBTF9JTkRFWF9WQUNV VU0sIHZhY3JlbC0+bmluZGV4ZXMpOw0KDQpTaG91bGRuJ3QgdGhpcyBiZSAwIHdoZW4gSU5ERVhf Q0xFQU5VUCBpcyBvZmYsIHRvbz8NCg0KKyNkZWZpbmUgUFJPR1JFU1NfVkFDVVVNX0NVUlJFTlRf SU5EUkVMSUQgICAgICAgICA3DQorI2RlZmluZSBQUk9HUkVTU19WQUNVVU1fTEVBREVSX1BJRCAg ICAgICAgICAgICAgIDgNCisjZGVmaW5lIFBST0dSRVNTX1ZBQ1VVTV9JTkRFWF9PUkRJTkFMICAg ICAgICAgICAgOQ0KKyNkZWZpbmUgUFJPR1JFU1NfVkFDVVVNX1RPVEFMX0lOREVYX1ZBQ1VVTSAg ICAgICAxMA0KKyNkZWZpbmUgUFJPR1JFU1NfVkFDVVVNX0RFQURfVFVQTEVTX1ZBQ1VVTUVEICAg ICAxMQ0KDQpuaXRwaWNrOiBJIHdvdWxkIHN1Z2dlc3QgdGhlIGZvbGxvd2luZyBuYW1lcyB0byBt YXRjaCB0aGUgZXhpc3RpbmcNCnN0eWxlOg0KDQogICAgICAgIFBST0dSRVNTX1ZBQ1VVTV9OVU1f SU5ERVhFU19UT19WQUNVVU0NCiAgICAgICAgUFJPR1JFU1NfVkFDVVVNX0lOREVYX0xFQURFUl9Q SUQNCiAgICAgICAgUFJPR1JFU1NfVkFDVVVNX0lOREVYX0lOREVYUkVMSUQNCiAgICAgICAgUFJP R1JFU1NfVkFDVVVNX0lOREVYX09SRElOQUxfUE9TSVRJT04NCiAgICAgICAgUFJPR1JFU1NfVkFD VVVNX0lOREVYX1RVUExFU19SRU1PVkVEDQoNCk5hdGhhbg0KDQo=