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 1mxyRF-0000dd-HY for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Dec 2021 21:37:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mxyRE-0003sF-Fd for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Dec 2021 21:37:20 +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 1mxyRE-0003s6-4p for pgsql-hackers@lists.postgresql.org; Thu, 16 Dec 2021 21:37:20 +0000 Received: from smtp-fw-2101.amazon.com ([72.21.196.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxyRA-00071a-C5 for pgsql-hackers@postgresql.org; Thu, 16 Dec 2021 21:37:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1639690636; x=1671226636; h=from:to:subject:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version; bh=Fip2bvst5bjqHhfbl++g8ZOLhFSGidxYHIfsUloI5pA=; b=t7iIR4U+o6S3gjXmvPsAKaWRI4qsheYT8tdW4pl4LyiOV6SflFudlv6C we1hIysBgQX31WDQeAFfMMXSWF5JRwuzuG6UmuGQDI/58ieI7YTIUitJ1 VcEEDHlrUFGq72CuOySZm5aIkmIHdeM0uNdBR864kdbYzE5z5ZvFU9hTS o=; X-IronPort-AV: E=Sophos;i="5.88,212,1635206400"; d="scan'208";a="159532403" Received: from iad12-co-svc-p1-lb1-vlan2.amazon.com (HELO email-inbound-relay-iad-1e-0168675e.us-east-1.amazon.com) ([10.43.8.2]) by smtp-border-fw-2101.iad2.amazon.com with ESMTP; 16 Dec 2021 21:37:14 +0000 Received: from EX13MTAUWC001.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan3.iad.amazon.com [10.40.163.38]) by email-inbound-relay-iad-1e-0168675e.us-east-1.amazon.com (Postfix) with ESMTPS id D84ECA28AE for ; Thu, 16 Dec 2021 21:37:13 +0000 (UTC) Received: from EX13D03UWC001.ant.amazon.com (10.43.162.136) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Thu, 16 Dec 2021 21:37:12 +0000 Received: from EX13D13UWB003.ant.amazon.com (10.43.161.233) by EX13D03UWC001.ant.amazon.com (10.43.162.136) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Thu, 16 Dec 2021 21:37:11 +0000 Received: from EX13D13UWB003.ant.amazon.com ([10.43.161.233]) by EX13D13UWB003.ant.amazon.com ([10.43.161.233]) with mapi id 15.00.1497.026; Thu, 16 Dec 2021 21:37:11 +0000 From: "Imseih (AWS), Sami" To: "Bossart, Nathan" , "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+AgAGqsoA= Date: Thu, 16 Dec 2021 21:37:11 +0000 Message-ID: <077D7D2E-FDC1-4884-A522-2E7770A2ED8C@amazon.com> References: <5478DFCD-2333-401A-B2F0-0D186AB09228@amazon.com> <7874FB21-FAA5-49BD-8386-2866552656C7@amazon.com> In-Reply-To: <7874FB21-FAA5-49BD-8386-2866552656C7@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.159] Content-Type: text/plain; charset="utf-8" Content-ID: <037541ABD93EF24A80EDE5E96B77A844@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 DQoNCu+7v09uIDEyLzE1LzIxLCA0OjEwIFBNLCAiQm9zc2FydCwgTmF0aGFuIiA8Ym9zc2FydG5A YW1hem9uLmNvbT4gd3JvdGU6DQoNCiAgICBPbiAxMi8xLzIxLCAzOjAyIFBNLCAiSW1zZWloIChB V1MpLCBTYW1pIiA8c2ltc2VpaEBhbWF6b24uY29tPiB3cm90ZToNCiAgICA+IFRoZSBjdXJyZW50 IGltcGxlbWVudGF0aW9uIG9mIHBnX3N0YXRfcHJvZ3Jlc3NfdmFjdXVtIGRvZXMgbm90DQogICAg PiBwcm92aWRlIHByb2dyZXNzIG9uIHdoaWNoIGluZGV4IGlzIGJlaW5nIHZhY3V1bWVkIG1ha2lu ZyBpdA0KICAgID4gZGlmZmljdWx0IGZvciBhIHVzZXIgdG8gZGV0ZXJtaW5lIGlmIHRoZSAidmFj dXVtaW5nIGluZGV4ZXMiIHBoYXNlDQogICAgPiBpcyBtYWtpbmcgcHJvZ3Jlc3MuIEJ5IGV4cG9z aW5nIHdoaWNoIGluZGV4IGlzIGJlaW5nIHNjYW5uZWQgYXMgd2VsbA0KICAgID4gYXMgdGhlIHRv dGFsIHByb2dyZXNzIHRoZSBzY2FuIGhhcyBtYWRlIGZvciB0aGUgY3VycmVudCBjeWNsZSwgYQ0K ICAgID4gdXNlciBjYW4gbWFrZSBiZXR0ZXIgZXN0aW1hdGlvbnMgb24gd2hlbiB0aGUgdmFjdXVt IHdpbGwgY29tcGxldGUuDQoNCiAgICArMQ0KDQogICAgPiBUaGUgcHJvcG9zZWQgcGF0Y2ggYWRk cyA0IG5ldyBjb2x1bW5zIHRvIHBnX3N0YXRfcHJvZ3Jlc3NfdmFjdXVtOg0KICAgID4NCiAgICA+ IDEuIGluZHJlbGlkIC0gdGhlIHJlbGlkIG9mIHRoZSBpbmRleCBiZWluZyB2YWN1dW1lZA0KICAg ID4gMi4gaW5kZXhfYmxrc190b3RhbCAtIHRvdGFsIG51bWJlciBvZiBibG9ja3MgdG8gYmUgc2Nh bm5lZCBpbiB0aGUNCiAgICA+IGN1cnJlbnQgY3ljbGUNCiAgICA+IDMuIGluZGV4X2Jsa3Nfc2Nh bm5lZCAtIG51bWJlciBvZiBibG9ja3Mgc2Nhbm5lZCBpbiB0aGUgY3VycmVudA0KICAgID4gY3lj bGUNCiAgICA+IDQuIGxlYWRlcl9waWQgLSBpZiB0aGUgcGlkIGZvciB0aGUgcGdfc3RhdF9wcm9n cmVzc192YWN1dW0gZW50cnkgaXMNCiAgICA+IGEgbGVhZGVyIG9yIGEgdmFjdXVtIHdvcmtlci4g VGhpcyBwYXRjaCBwbGFjZXMgYW4gZW50cnkgZm9yIGV2ZXJ5DQogICAgPiB3b3JrZXIgcGlkICgg aWYgcGFyYWxsZWwgKSBhcyB3ZWxsIGFzIHRoZSBsZWFkZXIgcGlkDQoNCiAgICBuaXRwaWNrOiBT aG91bGRuJ3QgaW5kZXhfYmxrc19zY2FubmVkIGJlIGluZGV4X2Jsa3NfdmFjdXVtZWQ/ICBJTU8g aXQNCiAgICBpcyBtb3JlIGFuYWxvZ291cyB0byBoZWFwX2Jsa3NfdmFjdXVtZWQuDQoNCk5vLCBX aGF0IGlzIGJlaW5nIHRyYWNrZWQgaXMgdGhlIG51bWJlciBvZiBpbmRleCBibG9ja3Mgc2Nhbm5l ZCBmcm9tIHRoZSB0b3RhbCBpbmRleCBibG9ja3MuIFRoZSBibG9jayB3aWxsIGJlIHNjYW5uZWQg cmVnYXJkbGVzcyBpZiBpdCB3aWxsIGJlIHZhY3V1bWVkIG9yIG5vdC4gDQoNCiAgICBUaGlzIHdp bGwgdGVsbCB1cyB3aGljaCBpbmRleGVzIGFyZSBjdXJyZW50bHkgYmVpbmcgdmFjdXVtZWQgYW5k IHRoZQ0KICAgIGN1cnJlbnQgcHJvZ3Jlc3Mgb2YgdGhvc2Ugb3BlcmF0aW9ucywgYnV0IGl0IGRv ZXNuJ3QgdGVsbCB1cyB3aGljaA0KICAgIGluZGV4ZXMgaGF2ZSBhbHJlYWR5IGJlZW4gdmFjdXVt ZWQgb3Igd2hpY2ggb25lcyBhcmUgcGVuZGluZyB2YWN1dW0uDQogICAgSSB0aGluayBzdWNoIGlu Zm9ybWF0aW9uIGlzIG5lY2Vzc2FyeSB0byB0cnVseSB1bmRlcnN0YW5kIHRoZSBjdXJyZW50DQog ICAgcHJvZ3Jlc3Mgb2YgdmFjdXVtaW5nIGluZGV4ZXMsIGFuZCBJIGNhbiB0aGluayBvZiBhIGNv dXBsZSBvZiB3YXlzIHdlDQogICAgbWlnaHQgcHJvdmlkZSBpdDoNCg0KICAgICAgMS4gTWFrZSB0 aGUgbmV3IGNvbHVtbnMgeW91J3ZlIHByb3Bvc2VkIHJldHVybiBhcnJheXMuICBUaGlzIGlzbid0 DQogICAgICAgICB2ZXJ5IGNsZWFuLCBidXQgaXQgd291bGQga2VlcCBhbGwgdGhlIGluZm9ybWF0 aW9uIGZvciBhIGdpdmVuDQogICAgICAgICB2YWN1dW0gb3BlcmF0aW9uIGluIGEgc2luZ2xlIHJv dy4gIFRoZSBpbmRyZWxpZHMgY29sdW1uIHdvdWxkIGJlDQogICAgICAgICBwb3B1bGF0ZWQgd2l0 aCBhbGwgdGhlIGluZGV4ZXMgdGhhdCBoYXZlIGJlZW4gdmFjdXVtZWQsIG5lZWQgdG8NCiAgICAg ICAgIGJlIHZhY3V1bWVkLCBvciBhcmUgcHJlc2VudGx5IGJlaW5nIHZhY3V1bWVkLiAgVGhlIG90 aGVyIGluZGV4LQ0KICAgICAgICAgcmVsYXRlZCBjb2x1bW5zIHdvdWxkIHRoZW4gaGF2ZSB0aGUg YXNzb2NpYXRlZCBzdGF0cyBhbmQgdGhlDQogICAgICAgICB3b3JrZXIgUElEICh3aGljaCBtaWdo dCBiZSB0aGUgc2FtZSBhcyB0aGUgcGlkIGNvbHVtbiBkZXBlbmRpbmcNCiAgICAgICAgIG9uIHdo ZXRoZXIgcGFyYWxsZWwgaW5kZXggdmFjdXVtIHdhcyBiZWluZyBkb25lKS4gIEFsdGVybmF0aXZl bHksDQogICAgICAgICB0aGUgaW5kZXggY29sdW1uIGNvdWxkIGhhdmUgYW4gYXJyYXkgb2YgcmVj b3JkcywgZWFjaCBjb250YWluaW5nDQogICAgICAgICBhbGwgdGhlIGluZm9ybWF0aW9uIGZvciBh IGdpdmVuIGluZGV4Lg0KICAgICAgMi4gQ3JlYXRlIGEgbmV3IHZpZXcgZm9yIGp1c3QgaW5kZXgg dmFjdXVtIHByb2dyZXNzIGluZm9ybWF0aW9uLg0KICAgICAgICAgVGhpcyB3b3VsZCBoYXZlIHNp bWlsYXIgaW5mb3JtYXRpb24gYXMgMS4gIFRoZXJlIHdvdWxkIGJlIGFuDQogICAgICAgICBlbnRy eSBmb3IgZWFjaCBpbmRleCB0aGF0IGhhcyBiZWVuIHZhY3V1bWVkLCBuZWVkcyB0byBiZQ0KICAg ICAgICAgdmFjdXVtZWQsIG9yIGlzIGN1cnJlbnRseSBiZWluZyB2YWN1dW1lZC4gIEFuZCB0aGVy ZSB3b3VsZCBiZSBhbg0KICAgICAgICAgZWFzeSB3YXkgdG8gam9pbiB3aXRoIHBnX3N0YXRfcHJv Z3Jlc3NfdmFjdXVtIChlLmcuLCBsZWFkZXJfcGlkLA0KICAgICAgICAgd2hpY2ggYWdhaW4gbWln aHQgYmUgdGhlIHNhbWUgYXMgb3VyIGluZGV4IHZhY3V1bSBQSUQgZGVwZW5kaW5nDQogICAgICAg ICBvbiB3aGV0aGVyIHdlIHdlcmUgZG9pbmcgcGFyYWxsZWwgaW5kZXggdmFjdXVtKS4gIE5vdGUg dGhhdCBpdA0KICAgICAgICAgd291bGQgYmUgcG9zc2libGUgZm9yIHRoZSBQSUQgb2YgdGhlc2Ug ZW50cmllcyB0byBiZSBudWxsIGJlZm9yZQ0KICAgICAgICAgYW5kIGFmdGVyIHdlIHByb2Nlc3Mg dGhlIGluZGV4Lg0KICAgICAgMy4gSW5zdGVhZCBvZiBhZGRpbmcgY29sdW1ucyB0byBwZ19zdGF0 X3Byb2dyZXNzX3ZhY3V1bSwgYWRqdXN0IHRoZQ0KICAgICAgICAgY3VycmVudCBvbmVzIHRvIGJl IG1vcmUgZ2VuZXJhbCwgYW5kIHRoZW4gYWRkIG5ldyBlbnRyaWVzIGZvcg0KICAgICAgICAgZWFj aCBvZiB0aGUgaW5kZXhlcyB0aGF0IGhhdmUgYmVlbiwgbmVlZCB0byBiZSwgb3IgY3VycmVudGx5 IGFyZQ0KICAgICAgICAgYmVpbmcgdmFjdXVtZWQuICBUaGlzIGlzIHRoZSBtb3N0IHNpbWlsYXIg b3B0aW9uIHRvIHlvdXIgY3VycmVudA0KICAgICAgICAgcHJvcG9zYWwsIGJ1dCBpbnN0ZWFkIG9m IGludHJvZHVjaW5nIGEgY29sdW1uIGxpa2UNCiAgICAgICAgIGluZGV4X2Jsa3NfdG90YWwsIHdl J2QgcmVuYW1lIGhlYXBfYmxrc190b3RhbCB0byBibGtzX3RvdGFsIGFuZA0KICAgICAgICAgdXNl IHRoYXQgZm9yIGJvdGggdGhlIGhlYXAgYW5kIGluZGV4ZXMuICBJIHRoaW5rIHdlJ2Qgc3RpbGwg d2FudA0KICAgICAgICAgdG8gYWRkIGEgbGVhZGVyX3BpZCBjb2x1bW4uICBBZ2Fpbiwgd2UgaGF2 ZSB0byBiZSBwcmVwYXJlZCBmb3INCiAgICAgICAgIHRoZSBQSUQgdG8gYmUgbnVsbCBpbiB0aGlz IGNhc2UuICBPciB3ZSBjb3VsZCBqdXN0IG1ha2UgdGhlIHBpZA0KICAgICAgICAgY29sdW1uIGFs d2F5cyByZWZlciB0byB0aGUgbGVhZGVyLCBhbmQgd2UgY291bGQgaW50cm9kdWNlIGENCiAgICAg ICAgIHdvcmtlcl9waWQgY29sdW1uLiAgVGhhdCBtaWdodCBjcmVhdGUgY29uZnVzaW9uLCB0aG91 Z2guDQoNCiAgICBJIHdpc2ggb3B0aW9uICMxIHdhcyBjbGVhbmVyLCBiZWNhdXNlIEkgdGhpbmsg aXQgd291bGQgYmUgcmVhbGx5IG5pY2UNCiAgICB0byBoYXZlIGFsbCB0aGlzIGluZm9ybWF0aW9u IGluIGEgc2luZ2xlIHJvdy4gIEhvd2V2ZXIsIEkgZG9uJ3QgZXhwZWN0DQogICAgbXVjaCBzdXBw b3J0IGZvciBhIDMtZGltZW5zaW9uYWwgdmlldywgc28gSSBzdXNwZWN0IG9wdGlvbiAjMg0KICAg IChjcmVhdGluZyBhIHNlcGFyYXRlIHZpZXcgZm9yIGluZGV4IHZhY3V1bSBwcm9ncmVzcykgaXMg dGhlIHdheSB0byBnby4NCiAgICBUaGUgb3RoZXIgYmVuZWZpdCBvZiBvcHRpb24gIzIgdmVyc3Vz IG9wdGlvbiAjMyBvciB5b3VyIG9yaWdpbmFsDQogICAgcHJvcG9zYWwgaXMgdGhhdCBpdCBjbGVh bmx5IHNlcGFyYXRlcyB0aGUgdG9wLWxldmVsIHZhY3V1bSBvcGVyYXRpb25zDQogICAgYW5kIHRo ZSBpbmRleCB2YWN1dW0gb3BlcmF0aW9ucywgd2hpY2ggYXJlIHJlbGF0ZWQgYXQgdGhlIG1vbWVu dCwgYnV0DQogICAgd2hpY2ggbWlnaHQgbm90IGFsd2F5cyBiZSB0aWVkIHNvIGNsb3NlbHkgdG9n ZXRoZXIuDQoNCk9wdGlvbiAjMSBpcyBub3QgY2xlYW4gYXMgeW91IHdpbGwgbmVlZCB0byB1bm5l c3QgdGhlIGFycmF5IHRvIG1ha2Ugc2Vuc2Ugb3V0IG9mIGl0LiBJdCB3aWxsIGJlIHRvbyBjb21w bGV4IHRvIHVzZS4NCk9wdGlvbiAjMyBJIGFtIHJlbHVjdGFudCB0byBzcGVudCB0aW1lIGxvb2tp bmcgYXQgdGhpcyBvcHRpb24uIEl0J3MgbW9yZSB2YWx1YWJsZSB0byBzZWUgcHJvZ3Jlc3MgcGVy IGluZGV4IGluc3RlYWQgb2YgdG90YWwuIA0KT3B0aW9uICMyIHdhcyBvbmUgdGhhdCBJIG9yaWdp bmFsbHkgZGVzaWduZWQgYnV0IGJhY2tlZCBhd2F5IGFzIGl0IHdhcyBpbnRyb2R1Y2luZyBhIG5l dyB2aWV3LiBUaGlua2luZyBhYm91dCBpdCBhIGJpdCBtb3JlLCB0aGlzIGlzIGEgY2xlYW5lciBh cHByb2FjaC4gDQoxLiBIYXZpbmcgYSB2aWV3IGNhbGxlZCBwZ19zdGF0X3Byb2dyZXNzX3ZhY3V1 bV93b3JrZXIgdG8gam9pbiB3aXRoIHBnX3N0YXRfcHJvZ3Jlc3NfdmFjdXVtIGlzIGNsZWFuDQoy LiBObyBjaGFuZ2VzIHJlcXVpcmVkIHRvIHBnX3N0YXRfcHJvZ3Jlc3NfdmFjdXVtDQozLiBJ4oCZ bGwgbGVhbiB0b3dhcmRzIGNhbGxpbmcgdGhlIHZpZXcgIiBwZ19zdGF0X3Byb2dyZXNzX3ZhY3V1 bV93b3JrZXIiIGluc3RlYWQgb2YgIiBwZ19zdGF0X3Byb2dyZXNzX3ZhY3V1bV9pbmRleCIsIHRv IHBlcmhhcHMgYWxsb3cgdXMgdG8gdHJhY2sgb3RoZXIgaXRlbXMgYSB2YWN1dW0gd29ya2VyIG1h eSBkbyBpbiBmdXR1cmUgcmVsZWFzZXMuIEFzIG9mIG5vdywgb25seSBpbmRleGVzIGFyZSB2YWN1 dW1lZCBieSB3b3JrZXJzLg0KSSB3aWxsIHJld29yayB0aGUgcGF0Y2ggZm9yIG9wdGlvbiAjMg0K DQogICAgTmF0aGFuDQoNCg0K