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 1mxcTQ-0001Oo-UD for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Dec 2021 22:10:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mxcTP-0005Kp-Is for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Dec 2021 22:10:07 +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 1mxcTP-0005Kg-87 for pgsql-hackers@lists.postgresql.org; Wed, 15 Dec 2021 22:10:07 +0000 Received: from smtp-fw-9102.amazon.com ([207.171.184.29]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxcTM-0003Xj-L2 for pgsql-hackers@postgresql.org; Wed, 15 Dec 2021 22:10:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1639606205; x=1671142205; h=from:to:subject:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version; bh=Xc1unIGh7HmUZBJm70K6ILODxfJBBNv33ZU82V1DkXQ=; b=YiAouWGdmswqvUrAg784VUEDNGQf/n6nTQ+MT3530rz93OXliDQj28Kn fUr+E/wtQB5bjbm88vGfL1tvobU0ZbT9aRe4wpqQJP5yKeHHy5At6O4BW 71UnOM7UeyDVHXCnQp5lTddjmVbMiMbIkq1bAkOjNgl61wVhkLtGWfX8f 0=; X-IronPort-AV: E=Sophos;i="5.88,209,1635206400"; d="scan'208";a="181057390" Received: from pdx4-co-svc-p1-lb2-vlan3.amazon.com (HELO email-inbound-relay-iad-1a-8691d7ea.us-east-1.amazon.com) ([10.25.36.214]) by smtp-border-fw-9102.sea19.amazon.com with ESMTP; 15 Dec 2021 22:10:02 +0000 Received: from EX13MTAUWB001.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan2.iad.amazon.com [10.40.163.34]) by email-inbound-relay-iad-1a-8691d7ea.us-east-1.amazon.com (Postfix) with ESMTPS id C1565C0969 for ; Wed, 15 Dec 2021 22:10:00 +0000 (UTC) Received: from EX13D13UWA003.ant.amazon.com (10.43.160.181) by EX13MTAUWB001.ant.amazon.com (10.43.161.207) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Wed, 15 Dec 2021 22:09:59 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D13UWA003.ant.amazon.com (10.43.160.181) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Wed, 15 Dec 2021 22:09:59 +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; Wed, 15 Dec 2021 22:09:59 +0000 From: "Bossart, Nathan" To: "Imseih (AWS), Sami" , "pgsql-hackers@postgresql.org" Subject: Re: Add index scan progress to pg_stat_progress_vacuum Thread-Topic: Add index scan progress to pg_stat_progress_vacuum Thread-Index: AQHX5uocuLg5vK9yXkugZYU7JVvUD6wzrQ+A Date: Wed, 15 Dec 2021 22:09:59 +0000 Message-ID: <7874FB21-FAA5-49BD-8386-2866552656C7@amazon.com> References: <5478DFCD-2333-401A-B2F0-0D186AB09228@amazon.com> In-Reply-To: <5478DFCD-2333-401A-B2F0-0D186AB09228@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.161.34] Content-Type: text/plain; charset="utf-8" Content-ID: <5A5D02DE289C9C44B4D58D3E5EE350C7@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 T24gMTIvMS8yMSwgMzowMiBQTSwgIkltc2VpaCAoQVdTKSwgU2FtaSIgPHNpbXNlaWhAYW1hem9u LmNvbT4gd3JvdGU6DQo+IFRoZSBjdXJyZW50IGltcGxlbWVudGF0aW9uIG9mIHBnX3N0YXRfcHJv Z3Jlc3NfdmFjdXVtIGRvZXMgbm90DQo+IHByb3ZpZGUgcHJvZ3Jlc3Mgb24gd2hpY2ggaW5kZXgg aXMgYmVpbmcgdmFjdXVtZWQgbWFraW5nIGl0DQo+IGRpZmZpY3VsdCBmb3IgYSB1c2VyIHRvIGRl dGVybWluZSBpZiB0aGUgInZhY3V1bWluZyBpbmRleGVzIiBwaGFzZQ0KPiBpcyBtYWtpbmcgcHJv Z3Jlc3MuIEJ5IGV4cG9zaW5nIHdoaWNoIGluZGV4IGlzIGJlaW5nIHNjYW5uZWQgYXMgd2VsbA0K PiBhcyB0aGUgdG90YWwgcHJvZ3Jlc3MgdGhlIHNjYW4gaGFzIG1hZGUgZm9yIHRoZSBjdXJyZW50 IGN5Y2xlLCBhDQo+IHVzZXIgY2FuIG1ha2UgYmV0dGVyIGVzdGltYXRpb25zIG9uIHdoZW4gdGhl IHZhY3V1bSB3aWxsIGNvbXBsZXRlLg0KDQorMQ0KDQo+IFRoZSBwcm9wb3NlZCBwYXRjaCBhZGRz IDQgbmV3IGNvbHVtbnMgdG8gcGdfc3RhdF9wcm9ncmVzc192YWN1dW06DQo+DQo+IDEuIGluZHJl bGlkIC0gdGhlIHJlbGlkIG9mIHRoZSBpbmRleCBiZWluZyB2YWN1dW1lZA0KPiAyLiBpbmRleF9i bGtzX3RvdGFsIC0gdG90YWwgbnVtYmVyIG9mIGJsb2NrcyB0byBiZSBzY2FubmVkIGluIHRoZQ0K PiBjdXJyZW50IGN5Y2xlDQo+IDMuIGluZGV4X2Jsa3Nfc2Nhbm5lZCAtIG51bWJlciBvZiBibG9j a3Mgc2Nhbm5lZCBpbiB0aGUgY3VycmVudA0KPiBjeWNsZQ0KPiA0LiBsZWFkZXJfcGlkIC0gaWYg dGhlIHBpZCBmb3IgdGhlIHBnX3N0YXRfcHJvZ3Jlc3NfdmFjdXVtIGVudHJ5IGlzDQo+IGEgbGVh ZGVyIG9yIGEgdmFjdXVtIHdvcmtlci4gVGhpcyBwYXRjaCBwbGFjZXMgYW4gZW50cnkgZm9yIGV2 ZXJ5DQo+IHdvcmtlciBwaWQgKCBpZiBwYXJhbGxlbCApIGFzIHdlbGwgYXMgdGhlIGxlYWRlciBw aWQNCg0Kbml0cGljazogU2hvdWxkbid0IGluZGV4X2Jsa3Nfc2Nhbm5lZCBiZSBpbmRleF9ibGtz X3ZhY3V1bWVkPyAgSU1PIGl0DQppcyBtb3JlIGFuYWxvZ291cyB0byBoZWFwX2Jsa3NfdmFjdXVt ZWQuDQoNClRoaXMgd2lsbCB0ZWxsIHVzIHdoaWNoIGluZGV4ZXMgYXJlIGN1cnJlbnRseSBiZWlu ZyB2YWN1dW1lZCBhbmQgdGhlDQpjdXJyZW50IHByb2dyZXNzIG9mIHRob3NlIG9wZXJhdGlvbnMs IGJ1dCBpdCBkb2Vzbid0IHRlbGwgdXMgd2hpY2gNCmluZGV4ZXMgaGF2ZSBhbHJlYWR5IGJlZW4g dmFjdXVtZWQgb3Igd2hpY2ggb25lcyBhcmUgcGVuZGluZyB2YWN1dW0uDQpJIHRoaW5rIHN1Y2gg aW5mb3JtYXRpb24gaXMgbmVjZXNzYXJ5IHRvIHRydWx5IHVuZGVyc3RhbmQgdGhlIGN1cnJlbnQN CnByb2dyZXNzIG9mIHZhY3V1bWluZyBpbmRleGVzLCBhbmQgSSBjYW4gdGhpbmsgb2YgYSBjb3Vw bGUgb2Ygd2F5cyB3ZQ0KbWlnaHQgcHJvdmlkZSBpdDoNCg0KICAxLiBNYWtlIHRoZSBuZXcgY29s dW1ucyB5b3UndmUgcHJvcG9zZWQgcmV0dXJuIGFycmF5cy4gIFRoaXMgaXNuJ3QNCiAgICAgdmVy eSBjbGVhbiwgYnV0IGl0IHdvdWxkIGtlZXAgYWxsIHRoZSBpbmZvcm1hdGlvbiBmb3IgYSBnaXZl bg0KICAgICB2YWN1dW0gb3BlcmF0aW9uIGluIGEgc2luZ2xlIHJvdy4gIFRoZSBpbmRyZWxpZHMg Y29sdW1uIHdvdWxkIGJlDQogICAgIHBvcHVsYXRlZCB3aXRoIGFsbCB0aGUgaW5kZXhlcyB0aGF0 IGhhdmUgYmVlbiB2YWN1dW1lZCwgbmVlZCB0bw0KICAgICBiZSB2YWN1dW1lZCwgb3IgYXJlIHBy ZXNlbnRseSBiZWluZyB2YWN1dW1lZC4gIFRoZSBvdGhlciBpbmRleC0NCiAgICAgcmVsYXRlZCBj b2x1bW5zIHdvdWxkIHRoZW4gaGF2ZSB0aGUgYXNzb2NpYXRlZCBzdGF0cyBhbmQgdGhlDQogICAg IHdvcmtlciBQSUQgKHdoaWNoIG1pZ2h0IGJlIHRoZSBzYW1lIGFzIHRoZSBwaWQgY29sdW1uIGRl cGVuZGluZw0KICAgICBvbiB3aGV0aGVyIHBhcmFsbGVsIGluZGV4IHZhY3V1bSB3YXMgYmVpbmcg ZG9uZSkuICBBbHRlcm5hdGl2ZWx5LA0KICAgICB0aGUgaW5kZXggY29sdW1uIGNvdWxkIGhhdmUg YW4gYXJyYXkgb2YgcmVjb3JkcywgZWFjaCBjb250YWluaW5nDQogICAgIGFsbCB0aGUgaW5mb3Jt YXRpb24gZm9yIGEgZ2l2ZW4gaW5kZXguDQogIDIuIENyZWF0ZSBhIG5ldyB2aWV3IGZvciBqdXN0 IGluZGV4IHZhY3V1bSBwcm9ncmVzcyBpbmZvcm1hdGlvbi4NCiAgICAgVGhpcyB3b3VsZCBoYXZl IHNpbWlsYXIgaW5mb3JtYXRpb24gYXMgMS4gIFRoZXJlIHdvdWxkIGJlIGFuDQogICAgIGVudHJ5 IGZvciBlYWNoIGluZGV4IHRoYXQgaGFzIGJlZW4gdmFjdXVtZWQsIG5lZWRzIHRvIGJlDQogICAg IHZhY3V1bWVkLCBvciBpcyBjdXJyZW50bHkgYmVpbmcgdmFjdXVtZWQuICBBbmQgdGhlcmUgd291 bGQgYmUgYW4NCiAgICAgZWFzeSB3YXkgdG8gam9pbiB3aXRoIHBnX3N0YXRfcHJvZ3Jlc3NfdmFj dXVtIChlLmcuLCBsZWFkZXJfcGlkLA0KICAgICB3aGljaCBhZ2FpbiBtaWdodCBiZSB0aGUgc2Ft ZSBhcyBvdXIgaW5kZXggdmFjdXVtIFBJRCBkZXBlbmRpbmcNCiAgICAgb24gd2hldGhlciB3ZSB3 ZXJlIGRvaW5nIHBhcmFsbGVsIGluZGV4IHZhY3V1bSkuICBOb3RlIHRoYXQgaXQNCiAgICAgd291 bGQgYmUgcG9zc2libGUgZm9yIHRoZSBQSUQgb2YgdGhlc2UgZW50cmllcyB0byBiZSBudWxsIGJl Zm9yZQ0KICAgICBhbmQgYWZ0ZXIgd2UgcHJvY2VzcyB0aGUgaW5kZXguDQogIDMuIEluc3RlYWQg b2YgYWRkaW5nIGNvbHVtbnMgdG8gcGdfc3RhdF9wcm9ncmVzc192YWN1dW0sIGFkanVzdCB0aGUN CiAgICAgY3VycmVudCBvbmVzIHRvIGJlIG1vcmUgZ2VuZXJhbCwgYW5kIHRoZW4gYWRkIG5ldyBl bnRyaWVzIGZvcg0KICAgICBlYWNoIG9mIHRoZSBpbmRleGVzIHRoYXQgaGF2ZSBiZWVuLCBuZWVk IHRvIGJlLCBvciBjdXJyZW50bHkgYXJlDQogICAgIGJlaW5nIHZhY3V1bWVkLiAgVGhpcyBpcyB0 aGUgbW9zdCBzaW1pbGFyIG9wdGlvbiB0byB5b3VyIGN1cnJlbnQNCiAgICAgcHJvcG9zYWwsIGJ1 dCBpbnN0ZWFkIG9mIGludHJvZHVjaW5nIGEgY29sdW1uIGxpa2UNCiAgICAgaW5kZXhfYmxrc190 b3RhbCwgd2UnZCByZW5hbWUgaGVhcF9ibGtzX3RvdGFsIHRvIGJsa3NfdG90YWwgYW5kDQogICAg IHVzZSB0aGF0IGZvciBib3RoIHRoZSBoZWFwIGFuZCBpbmRleGVzLiAgSSB0aGluayB3ZSdkIHN0 aWxsIHdhbnQNCiAgICAgdG8gYWRkIGEgbGVhZGVyX3BpZCBjb2x1bW4uICBBZ2Fpbiwgd2UgaGF2 ZSB0byBiZSBwcmVwYXJlZCBmb3INCiAgICAgdGhlIFBJRCB0byBiZSBudWxsIGluIHRoaXMgY2Fz ZS4gIE9yIHdlIGNvdWxkIGp1c3QgbWFrZSB0aGUgcGlkDQogICAgIGNvbHVtbiBhbHdheXMgcmVm ZXIgdG8gdGhlIGxlYWRlciwgYW5kIHdlIGNvdWxkIGludHJvZHVjZSBhDQogICAgIHdvcmtlcl9w aWQgY29sdW1uLiAgVGhhdCBtaWdodCBjcmVhdGUgY29uZnVzaW9uLCB0aG91Z2guDQoNCkkgd2lz aCBvcHRpb24gIzEgd2FzIGNsZWFuZXIsIGJlY2F1c2UgSSB0aGluayBpdCB3b3VsZCBiZSByZWFs bHkgbmljZQ0KdG8gaGF2ZSBhbGwgdGhpcyBpbmZvcm1hdGlvbiBpbiBhIHNpbmdsZSByb3cuICBI b3dldmVyLCBJIGRvbid0IGV4cGVjdA0KbXVjaCBzdXBwb3J0IGZvciBhIDMtZGltZW5zaW9uYWwg dmlldywgc28gSSBzdXNwZWN0IG9wdGlvbiAjMg0KKGNyZWF0aW5nIGEgc2VwYXJhdGUgdmlldyBm b3IgaW5kZXggdmFjdXVtIHByb2dyZXNzKSBpcyB0aGUgd2F5IHRvIGdvLg0KVGhlIG90aGVyIGJl bmVmaXQgb2Ygb3B0aW9uICMyIHZlcnN1cyBvcHRpb24gIzMgb3IgeW91ciBvcmlnaW5hbA0KcHJv cG9zYWwgaXMgdGhhdCBpdCBjbGVhbmx5IHNlcGFyYXRlcyB0aGUgdG9wLWxldmVsIHZhY3V1bSBv cGVyYXRpb25zDQphbmQgdGhlIGluZGV4IHZhY3V1bSBvcGVyYXRpb25zLCB3aGljaCBhcmUgcmVs YXRlZCBhdCB0aGUgbW9tZW50LCBidXQNCndoaWNoIG1pZ2h0IG5vdCBhbHdheXMgYmUgdGllZCBz byBjbG9zZWx5IHRvZ2V0aGVyLg0KDQpOYXRoYW4NCg0K