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 1n5ZZt-0002jl-2c for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Jan 2022 20:41:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n5ZZr-0008Pu-TK for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Jan 2022 20:41:39 +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 1n5ZZr-0008Pl-G3 for pgsql-hackers@lists.postgresql.org; Thu, 06 Jan 2022 20:41:39 +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 1n5ZZo-0007Mx-6R for pgsql-hackers@postgresql.org; Thu, 06 Jan 2022 20:41:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1641501696; x=1673037696; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=+YF0ZsGickVv+VdaDUwiM7Ia9GJmf/vnASoVpjHWG6Q=; b=UDfbskoK++W4hm8E9U+jzZpAWPxt7Z9iRcVluAr6zjbCPx2A3iNopwNW EBCZrdz8haT/2QFkngpBx+7gSjaCwz1vs8esmRHJnO0AQu0gvbFmJfZFA j5gwHTNU21IkD8Hl6ig3a4PbKW2IzM1GboSFnxHWbh2vS7oVjc+MdCrC9 o=; X-IronPort-AV: E=Sophos;i="5.88,267,1635206400"; d="scan'208";a="53277803" 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-1d-10222bbc.us-east-1.amazon.com) ([10.25.36.210]) by smtp-border-fw-80007.pdx80.corp.amazon.com with ESMTP; 06 Jan 2022 20:41:33 +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-1d-10222bbc.us-east-1.amazon.com (Postfix) with ESMTPS id 463B11A004B; Thu, 6 Jan 2022 20:41:32 +0000 (UTC) Received: from EX13D13UWB002.ant.amazon.com (10.43.161.21) by EX13MTAUWB001.ant.amazon.com (10.43.161.249) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Thu, 6 Jan 2022 20:41:32 +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; Thu, 6 Jan 2022 20:41:31 +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; Thu, 6 Jan 2022 20:41:31 +0000 From: "Bossart, Nathan" To: "Imseih (AWS), Sami" , Justin Pryzby CC: Masahiko Sawada , Peter Geoghegan , "pgsql-hackers@postgresql.org" Thread-Index: AQHX5uocuLg5vK9yXkugZYU7JVvUD6wzrQ+AgAgmSICABBF2gIAG6AwAgAKncACAAHdDgIAB+R4AgApC9gA= Date: Thu, 6 Jan 2022 20:41:30 +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> In-Reply-To: <39E8ED08-56E6-4466-93BF-3FD3D51EE52C@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.160.37] Content-Type: text/plain; charset="utf-8" Content-ID: <089224C67695FA4796BB8112CFF19B26@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTIvMjkvMjEsIDg6NDQgQU0sICJJbXNlaWggKEFXUyksIFNhbWkiIDxzaW1zZWloQGFtYXpv bi5jb20+IHdyb3RlOg0KPiBJbiAicGdfc3RhdF9wcm9ncmVzc192YWN1dW0iLCBpbnRyb2R1Y2Ug MiBjb2x1bW5zOg0KPg0KPiAqIHRvdGFsX2luZGV4X3ZhY3V1bSA6IFRoaXMgaXMgdGhlICMgb2Yg aW5kZXhlcyB0aGF0IHdpbGwgYmUgdmFjdXVtZWQuIEtlZXAgaW4gbWluZCB0aGF0IGlmIGZhaWxz YWZlIG1vZGUga2lja3MgaW4gbWlkLWZsaWdodCB0byB0aGUgdmFjdXVtLCBQb3N0Z3JlcyBtYXkg Y2hvb3NlIHRvIGZvcmdvIGluZGV4IHNjYW5zLiBUaGlzIHZhbHVlIHdpbGwgYmUgYWRqdXN0ZWQg YWNjb3JkaW5nbHkuDQo+ICogbWF4X2luZGV4X3ZhY3V1bV9jeWNsZV90aW1lIDogVGhlIHRvdGFs IGVsYXBzZWQgdGltZSBmb3IgYSBpbmRleCB2YWN1dW0gY3ljbGUgaXMgY2FsY3VsYXRlZCBhbmQg dGhpcyB2YWx1ZSB3aWxsIGJlIHVwZGF0ZWQgdG8gcmVmbGVjdCB0aGUgbG9uZ2VzdCB2YWN1dW0g Y3ljbGUuIFVudGlsIHRoZSBmaXJzdCBjeWNsZSBjb21wbGV0ZXMsIHRoaXMgdmFsdWUgd2lsbCBi ZSAwLiBUaGUgcHVycG9zZSBvZiB0aGlzIGNvbHVtbiBpcyB0byBnaXZlIHRoZSB1c2VyIGFuIGlk ZWEgb2YgaG93IGxvbmcgYW4gaW5kZXggdmFjdXVtIGN5Y2xlIHRha2VzIHRvIGNvbXBsZXRlLg0K DQpJIHRoaW5rIHRoYXQgdG90YWxfaW5kZXhfdmFjdXVtIGlzIGEgZ29vZCB0aGluZyB0byBoYXZl LiAgSSB3b3VsZA0KZXhwZWN0IHRoaXMgdG8gdXN1YWxseSBqdXN0IGJlIHRoZSBudW1iZXIgb2Yg aW5kZXhlcyBvbiB0aGUgdGFibGUsIGJ1dA0KYXMgeW91IHBvaW50ZWQgb3V0LCB0aGlzIGNhbiBi ZSBkaWZmZXJlbnQgd2hlbiB3ZSBhcmUgc2tpcHBpbmcNCmluZGV4ZXMuICBNeSBvbmx5IGNvbmNl cm4gd2l0aCB0aGlzIG5ldyBjb2x1bW4gaXMgdGhlIHBvdGVudGlhbCBmb3INCmNvbmZ1c2lvbiB3 aGVuIGNvbXBhcmVkIHdpdGggdGhlIGluZGV4X3ZhY3V1bV9jb3VudCB2YWx1ZS4NCmluZGV4X3Zh Y3V1bV9jb3VudCBpbmRpY2F0ZXMgdGhlIG51bWJlciBvZiB2YWN1dW0gY3ljbGVzIGNvbXBsZXRl ZCwNCmJ1dCB0b3RhbF9pbmRleF92YWN1dW0gaW5kaWNhdGVzIHRoZSBudW1iZXIgb2YgaW5kZXhl cyB0aGF0IHdpbGwgYmUNCnZhY3V1bWVkLiAgSG93ZXZlciwgdGhlIG5hbWVzIHNvdW5kIGxpa2Ug dGhleSBjb3VsZCByZWZlciB0byB0aGUgc2FtZQ0KdGhpbmcgdG8gbWUuICBQZXJoYXBzIHdlIHNo b3VsZCByZW5hbWUgaW5kZXhfdmFjdXVtX2NvdW50IHRvDQppbmRleF92YWN1dW1fY3ljbGVzL2lu ZGV4X3ZhY3V1bV9jeWNsZV9jb3VudCwgYW5kIHRoZSBuZXcgY29sdW1uDQpzaG91bGQgYmUgc29t ZXRoaW5nIGxpa2UgbnVtX2luZGV4ZXNfdG9fdmFjdXVtIG9yIGluZGV4X3ZhY3V1bV90b3RhbC4N Cg0KSSBkb24ndCB0aGluayB3ZSBuZWVkIHRoZSBtYXhfaW5kZXhfdmFjdXVtX2N5Y2xlX3RpbWUg Y29sdW1uLiAgV2hpbGUNCnRoZSBpZGVhIGlzIHRvIGdpdmUgdXNlcnMgYSByb3VnaCBlc3RpbWF0 ZSBmb3IgaG93IGxvbmcgYW4gaW5kZXggY3ljbGUNCndpbGwgdGFrZSwgSSBkb24ndCB0aGluayBp dCB3aWxsIGhlbHAgZ2VuZXJhdGUgYW55IG1lYW5pbmdmdWwNCmVzdGltYXRlcyBmb3IgaG93IG11 Y2ggbG9uZ2VyIHRoZSB2YWN1dW0gb3BlcmF0aW9uIHdpbGwgdGFrZS4gIElJVUMgd2UNCndvbid0 IGhhdmUgYW55IGlkZWEgaG93IG1hbnkgdG90YWwgaW5kZXggdmFjdXVtIGN5Y2xlcyB3aWxsIGJl IG5lZWRlZC4NCkV2ZW4gaWYgd2UgZGlkLCB0aGUgY3VycmVudCBjeWNsZSBjb3VsZCB0YWtlIG11 Y2ggbW9yZSBvciBtdWNoIGxlc3MNCnRpbWUuICBBbHNvLCBub25lIG9mIHRoZSBvdGhlciBwcm9n cmVzcyB2aWV3cyBzZWVtIHRvIHByb3ZpZGUgYW55DQp0aW1pbmcgaW5mb3JtYXRpb24sIHdoaWNo IEkgc3VzcGVjdCBpcyBieSBkZXNpZ24gdG8gYXZvaWQgaW5hY2N1cmF0ZQ0KZXN0aW1hdGVzLg0K DQo+IEludHJvZHVjZSBhIG5ldyB2aWV3IGNhbGxlZCAicGdfc3RhdF9wcm9ncmVzc192YWN1dW1f aW5kZXgiLiBUaGlzIHZpZXcgd2lsbCB0cmFjayB0aGUgcHJvZ3Jlc3Mgb2YgYSB3b3JrZXIgKCBv ciBsZWFkZXIgUElEICkgd2hpbGUgaXQncyB2YWN1dW1pbmcgYW4gaW5kZXguIEl0IHdpbGwgZXhw b3NlIHNvbWUga2V5IGNvbHVtbnM6DQo+DQo+ICogcGlkOiBUaGUgUElEIG9mIHRoZSB3b3JrZXIg cHJvY2Vzcw0KPg0KPiAqIGxlYWRlcl9waWQ6IFRoZSBQSUQgb2YgdGhlIGxlYWRlciBwcm9jZXNz LiBUaGlzIGlzIHRoZSBjb2x1bW4gdGhhdCBjYW4gYmUgam9pbmVkIHdpdGggInBnX3N0YXRfcHJv Z3Jlc3NfdmFjdXVtIi4gbGVhZGVyX3BpZCBhbmQgcGlkIGNhbiBoYXZlIHRoZSBzYW1lIHZhbHVl IGFzIGEgbGVhZGVyIGNhbiBhbHNvIHBlcmZvcm0gYW4gaW5kZXggdmFjdXVtLg0KPg0KPiAqIGlu ZHJlbGlkOiBUaGUgcmVsaWQgb2YgdGhlIGluZGV4IGN1cnJlbnRseSBiZWluZyB2YWN1dW1lZA0K Pg0KPiAqIHZhY3V1bV9jeWNsZV9vcmRpbmFsX3Bvc2l0aW9uOiBUaGUgcHJvY2Vzc2luZyBwb3Np dGlvbiBvZiB0aGUgaW5kZXggYmVpbmcgdmFjdXVtZWQuIFRoaXMgY2FuIGJlIHVzZWZ1bCB0byBk ZXRlcm1pbmUgaG93IG1hbnkgaW5kZXhlcyBvdXQgb2YgdGhlIHRvdGFsIGluZGV4ZXMgKCBwZ19z dGF0X3Byb2dyZXNzX3ZhY3V1bS50b3RhbF9pbmRleF92YWN1dW0gKSBoYXZlIGJlZW4gdmFjdXVt ZWQNCj4NCj4gKiBpbmRleF90dXBsZXNfdmFjdXVtZWQ6IFRoaXMgaXMgdGhlIG51bWJlciBvZiBp bmRleCB0dXBsZXMgdmFjdXVtZWQgZm9yIHRoZSBpbmRleCBvdmVyYWxsLiBUaGlzIGlzIHVzZWZ1 bCB0byBzaG93IHRoYXQgdGhlIHZhY3V1bSBpcyBhY3R1YWxseSBkb2luZyB3b3JrLCBhcyB0aGUg IyBvZiB0dXBsZXMga2VlcHMgaW5jcmVhc2luZy4gDQoNClNob3VsZCB3ZSBhbHNvIHByb3ZpZGUg c29tZSBpbmZvcm1hdGlvbiBmb3IgZGV0ZXJtaW5pbmcgdGhlIHByb2dyZXNzDQpvZiB0aGUgY3Vy cmVudCBjeWNsZT8gIFBlcmhhcHMgdGhlcmUgc2hvdWxkIGJlIGFuDQppbmRleF90dXBsZXNfdmFj dXVtZWRfY3VycmVudF9jeWNsZSBjb2x1bW4gdGhhdCB1c2VycyBjYW4gY29tcGFyZSB3aXRoDQp0 aGUgbnVtX2RlYWRfdHVwbGVzIHZhbHVlIGluIHBnX3N0YXRfcHJvZ3Jlc3NfdmFjdXVtLiAgSG93 ZXZlciwNCnBlcmhhcHMgdGhlIG51bWJlciBvZiB0dXBsZXMgdmFjdXVtZWQgaW4gdGhlIGN1cnJl bnQgY3ljbGUgY2FuIGFscmVhZHkNCmJlIGRpc2NvdmVyZWQgdmlhIGluZGV4X3R1cGxlc192YWN1 dW1lZCAlIG1heF9kZWFkX3R1cGxlcy4NCg0KK3ZvaWQNCitydXNhZ2VfYWRqdXN0KGNvbnN0IFBH UlVzYWdlICpydTAsIFBHUlVzYWdlICpydTEpDQorew0KKwlpZiAocnUxLT50di50dl91c2VjIDwg cnUwLT50di50dl91c2VjKQ0KKwl7DQorCQlydTEtPnR2LnR2X3NlYy0tOw0KKwkJcnUxLT50di50 dl91c2VjICs9IDEwMDAwMDA7DQorCX0NCisJaWYgKHJ1MS0+cnUucnVfc3RpbWUudHZfdXNlYyA8 IHJ1MC0+cnUucnVfc3RpbWUudHZfdXNlYykNCisJew0KKwkJcnUxLT5ydS5ydV9zdGltZS50dl9z ZWMtLTsNCisJCXJ1MS0+cnUucnVfc3RpbWUudHZfdXNlYyArPSAxMDAwMDAwOw0KKwl9DQorCWlm IChydTEtPnJ1LnJ1X3V0aW1lLnR2X3VzZWMgPCBydTAtPnJ1LnJ1X3V0aW1lLnR2X3VzZWMpDQor CXsNCisJCXJ1MS0+cnUucnVfdXRpbWUudHZfc2VjLS07DQorCQlydTEtPnJ1LnJ1X3V0aW1lLnR2 X3VzZWMgKz0gMTAwMDAwMDsNCisJfQ0KK30NCg0KSSB0aGluayB0aGlzIGZ1bmN0aW9uIGNvdWxk IGJlbmVmaXQgZnJvbSBhIGNvbW1lbnQuICBXaXRob3V0IGdvaW5nDQp0aHJvdWdoIGl0IGxpbmUg YnkgbGluZSwgaXQgaXMgbm90IGNsZWFyIHRvIG1lIGV4YWN0bHkgd2hhdCBpdCBpcw0KZG9pbmcu DQoNCkkga25vdyB3ZSdyZSBzdGlsbCB3b3JraW5nIG9uIHdoYXQgZXhhY3RseSB0aGlzIHN0dWZm IHNob3VsZCBsb29rDQpsaWtlLCBidXQgSSB3b3VsZCBzdWdnZXN0IGFkZGluZyB0aGUgZG9jdW1l bnRhdGlvbiBjaGFuZ2VzIGluIHRoZSBuZWFyDQpmdXR1cmUuDQoNCk5hdGhhbg0KDQo=