Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vxrfV-00HCku-11 for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 19:14:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxrfT-00E0NL-2P for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 19:14:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vxrfT-00E0ND-1P for pgsql-hackers@lists.postgresql.org; Wed, 04 Mar 2026 19:13:59 +0000 Received: from mail-ot1-x334.google.com ([2607:f8b0:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vxrfR-00000000aEj-1vZK for pgsql-hackers@postgresql.org; Wed, 04 Mar 2026 19:13:59 +0000 Received: by mail-ot1-x334.google.com with SMTP id 46e09a7af769-7d4c85307b2so5067624a34.0 for ; Wed, 04 Mar 2026 11:13:57 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772651636; cv=none; d=google.com; s=arc-20240605; b=JwuPdVHzCjvlOVuxiBpWXyZ+Tknye/tGGXv1ARp8qvFQ9lPDoZ/Gg7caDPO0SFykQX zGKon2xWYGEM6H65cIMVHGM8p5kRCIf6RqCZqDKz4UDVhjy9ick2+yItatWYyMHparvq SZ/6B2Gse5hOfqfb5AzOAuFUu+OLUmu9ECMDaleGVnezWz6E84eVywPeSLbcAPPD38TV HFEBgD5XWi3PRfhDwG49wOeboujP81Don2y7FMpB/Dru5/ElNE3DWwOZPwmtk3rCjJq/ pF8cZhdrExxuCervgi29YKF0CQ++OnFvTfuP4uDYHpSoNdeasf/eF75Skh3/KHKmsPUl pznw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=RLeKP3SlpIOUPT7VWGn0jzwth/TUcKYJAnqDXLhevg4=; fh=eZAsQUG4kg6W4KnrmnakXxApLWvr6oWNMZmsVCwffKk=; b=epCvMzdwI3Vyitg5ibOVjc9g7UqYz4PXNkMTe1NU9daeKqrssTo8l1YAAR6rD4rC15 3U+QzE43T7S6B0tTSYtLroVFhGweLl0HyZt2iAa77RgTxd0KCU0FEH1mTJB7amo6NVFr di15kL2bTGqIXFGFcCWFf8zqPorbCAfMkLMmM9rUWElbDYTgAB+iCnpaP9HjgQDOHMnw vI4VgRdFk+nQyFHSvafxl5cv2WBeJE/1gwdLzVYiWRxmrYm6bBL3STemQ2hxK4UQGmkz OABJIsaaDrkpiHYV65QA+gFsSSkYlzsOIxLYH93shSVkmZDUtpH3Oj1W2C4BSHnm3nVx hnjw==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pganalyze.com; s=google; t=1772651636; x=1773256436; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=RLeKP3SlpIOUPT7VWGn0jzwth/TUcKYJAnqDXLhevg4=; b=Y9IhoArOomKnVQBB9RCu5Kt304xT3ZAJk//HBcszTTfv5NirEcA7AciMcgnYxoJ6NU 1uxpx8wxoYHhrzDeqhQ/4AvAZSecOC4hW4YHnLlSDWbp2eyH2W8o9sGPgP6Yeo0NFnLW nmFu6M5MljlbLifN1/pRQewbFNgkYD6BqOA1l9f1TcY+Wbavw71R50Y5DGFm1HKVe6n4 nrlR6y+KfMho9pTbXsxcSceyuGBCNfjxkYeX9NEp+YumetAN5Ov0+m1ixXr36T8cUCK2 FX+XNvv9IKNBKwGMdUVXmEgqBJrIpwjm92oxnOSOtLpMZXZGNExge4Pul+nmY9c6kx74 RWyA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772651636; x=1773256436; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=RLeKP3SlpIOUPT7VWGn0jzwth/TUcKYJAnqDXLhevg4=; b=vTHOkWrMVAH3heU77PZW/tvxURV6AU8B6aeIr0whDhLCCtXJx9bIfqzk77i/z0SzTN kdQTlz14DoDQPL1qW9g+GQAtsbP30doMjnx2INnU121/ScuJnptip3+U/vpl4N//GdHg 3usE9kuYwTZL+HHyGbq8ijExtQJ5OswOzdWLBylCoV5itWGwZ8bpAqtOg2r1hc/bZDXy OUnvmMPjyfmUe6PKL+2arexvT6/RpxWGri+JjvhmQDzXgwKHNtRPfnQ2rsy8/Mx4Rt1g bME6VcfNN8sh479E82ZqGkoSHHxwIGrVCqwlJKRPWljq8flLUSCEugnIq3pR5gRz3scL ydMg== X-Forwarded-Encrypted: i=1; AJvYcCVuEiZ5Ickpy3UPnDccrYoLc6HuQe8NiSZeKakgjyQf7NNSPVeHeyQ/EXBT7cq89CJs8ZtjDrF+1meyqwxk@postgresql.org X-Gm-Message-State: AOJu0YxMjhbqaFAJZe5pWxAZZgMoCNcLqa3Jrkty3X0Ec6pGFFis269L vp+yh2SSSxnNHvl9Q9RgpxBeDMkj0aycwQnkX0foQU+1uxCrmT0vU/0I/EoAU3aGDVHeOAvPjle A0m176IxuG9At5GAWHR3Jm114db0AWG1wzLGM+hUnVA== X-Gm-Gg: ATEYQzztyZRNCa7fxgD49baGPhACpPEYna/3wMdHAG2A/LkMMoN8ZAyM3JmLvwTu5tn xzEeUoWVzZtQwMZ0jHi4YxSBAWU6vKWwlyDXQHuNXFfSvwxDN5omOk+rC9vELqt7lzeAxxHO3xj QDv/KuW3iU9XoHm4HraMCo7T3eDc7aQcY6XTYUPoo7iCwnhEblISiir0demhMyu0gsF/CczOIj2 5/D6dG9FF4b2Hq7QkCh60itf28SAwCy/fNgkBMYhdPkzZX9znubQm5B9DbFBOdG870WXiH9n74b mt8L8Z5BtCe6idK5eUsSdbp9GmeKzBOZ1EI47di7 X-Received: by 2002:a05:6830:6ade:b0:7cf:cd9c:3c25 with SMTP id 46e09a7af769-7d6caa5d389mr2610404a34.11.1772651636016; Wed, 04 Mar 2026 11:13:56 -0800 (PST) MIME-Version: 1.0 References: <34604.1758921116@sss.pgh.pa.us> <1d40131f-e01b-4c3f-a4b8-6b5f49edd3d1@tantorlabs.com> In-Reply-To: From: Maciek Sakrejda Date: Wed, 4 Mar 2026 11:13:45 -0800 X-Gm-Features: AaiRm52i8C2973MvHLjV2Fb2UiUg2KmBhjLkj6EaBm588ToQchxghbLkE50Hstg Message-ID: Subject: Re: V18 change on EXPLAIN ANALYZE To: Ilia Evdokimov Cc: maciek@sakrejda.org, Tom Lane , Robert Haas , Marcos Pegoraro , pgsql-hackers Content-Type: multipart/mixed; boundary="000000000000136ee6064c379ff1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000136ee6064c379ff1 Content-Type: text/plain; charset="UTF-8" Sorry, that should have been the attached v3. --000000000000136ee6064c379ff1 Content-Type: text/x-patch; charset="US-ASCII"; name="v3-0001-Improve-EXPLAIN-docs.patch" Content-Disposition: attachment; filename="v3-0001-Improve-EXPLAIN-docs.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mmcf0af20 RnJvbSAyNmNkMDIwMzgxOWY4ZWQwM2E2M2ZhOTk4MDAwZjYyYWY4MGM3MGRiIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBNYWNpZWsgU2FrcmVqZGEgPG0uc2FrcmVqZGFAZ21haWwuY29t PgpEYXRlOiBGcmksIDI2IFNlcCAyMDI1IDE3OjE3OjQxIC0wNzAwClN1YmplY3Q6IFtQQVRDSCB2 M10gSW1wcm92ZSBFWFBMQUlOIGRvY3MKCiAtIGNsYXJpZnkgZnJhY3Rpb25hbCByb3dzIGluIGxv b3BzCiAtIGFkZCBzb21lIGJhc2ljIGluZm8gb24gcGFyYWxsZWwgZXhlY3V0aW9uCi0tLQogZG9j L3NyYy9zZ21sL3BlcmZvcm0uc2dtbCB8IDY0ICsrKysrKysrKysrKysrKysrKysrKysrKysrKysr KysrKysrKy0tLQogMSBmaWxlIGNoYW5nZWQsIDYwIGluc2VydGlvbnMoKyksIDQgZGVsZXRpb25z KC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL3BlcmZvcm0uc2dtbCBiL2RvYy9zcmMvc2dt bC9wZXJmb3JtLnNnbWwKaW5kZXggNWY2ZjFkYjA0NjcuLmYwNzQ3MDU5ZjUwIDEwMDY0NAotLS0g YS9kb2Mvc3JjL3NnbWwvcGVyZm9ybS5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9wZXJmb3JtLnNn bWwKQEAgLTc1NiwxMyArNzU2LDY5IEBAIFdIRVJFIHQxLnVuaXF1ZTEgJmx0OyAxMCBBTkQgdDEu dW5pcXVlMiA9IHQyLnVuaXF1ZTI7CiAgICAgPGxpdGVyYWw+bG9vcHM8L2xpdGVyYWw+IHZhbHVl IHJlcG9ydHMgdGhlCiAgICAgdG90YWwgbnVtYmVyIG9mIGV4ZWN1dGlvbnMgb2YgdGhlIG5vZGUs IGFuZCB0aGUgYWN0dWFsIHRpbWUgYW5kIHJvd3MKICAgICB2YWx1ZXMgc2hvd24gYXJlIGF2ZXJh Z2VzIHBlci1leGVjdXRpb24uICBUaGlzIGlzIGRvbmUgdG8gbWFrZSB0aGUgbnVtYmVycwotICAg IGNvbXBhcmFibGUgd2l0aCB0aGUgd2F5IHRoYXQgdGhlIGNvc3QgZXN0aW1hdGVzIGFyZSBzaG93 bi4gIE11bHRpcGx5IGJ5Ci0gICAgdGhlIDxsaXRlcmFsPmxvb3BzPC9saXRlcmFsPiB2YWx1ZSB0 byBnZXQgdGhlIHRvdGFsIHRpbWUgYWN0dWFsbHkgc3BlbnQgaW4KLSAgICB0aGUgbm9kZS4gIElu IHRoZSBhYm92ZSBleGFtcGxlLCB3ZSBzcGVudCBhIHRvdGFsIG9mIDAuMDMwIG1pbGxpc2Vjb25k cwotICAgIGV4ZWN1dGluZyB0aGUgaW5kZXggc2NhbnMgb24gPGxpdGVyYWw+dGVuazI8L2xpdGVy YWw+LgorICAgIGNvbXBhcmFibGUgd2l0aCB0aGUgd2F5IHRoYXQgdGhlIGNvc3QgZXN0aW1hdGVz IGFyZSBzaG93bi4gIE11bHRpcGx5IGJ5IHRoZQorICAgIDxsaXRlcmFsPmxvb3BzPC9saXRlcmFs PiB2YWx1ZSB0byBnZXQgdGhlIHRvdGFsIHRpbWUgYWN0dWFsbHkgc3BlbnQgaW4gdGhlCisgICAg bm9kZSBhbmQgdGhlIHRvdGFsIG51bWJlciBvZiByb3dzIHByb2Nlc3NlZCBieSB0aGUgbm9kZSBh Y3Jvc3MgYWxsCisgICAgZXhlY3V0aW9ucy4gSW4gdGhlIGFib3ZlIGV4YW1wbGUsIHdlIHNwZW50 IGEgdG90YWwgb2YgMC4wMzAKKyAgICBtaWxsaXNlY29uZHMgZXhlY3V0aW5nIHRoZSBpbmRleCBz Y2FucyBvbiA8bGl0ZXJhbD50ZW5rMjwvbGl0ZXJhbD4sIGFuZAorICAgIHRoZXkgaGFuZGxlZCBh IHRvdGFsIG9mIDEwIHJvd3MuCiAgICA8L3BhcmE+CiAKICAgIDxwYXJhPgorICAgICBQYXJhbGxl bCBleGVjdXRpb24gd2lsbCBhbHNvIGNhdXNlIG5vZGVzIHRvIGJlIGV4ZWN1dGVkIG1vcmUgdGhh biBvbmNlLgorICAgICBUaGlzIGlzIGFsc28gaW5kaWNhdGVkIHdpdGggdGhlIDxsaXRlcmFsPmxv b3BzPC9saXRlcmFsPiB2YWx1ZS4gV2UgY2FuCisgICAgIGNoYW5nZSBzb21lIHBsYW5uZXIgc2V0 dGluZ3MgdG8gaGF2ZSB0aGUgcGxhbm5lciBwaWNrIGEgcGFyYWxsZWwgcGxhbiBmb3IKKyAgICAg dGhlIGFib3ZlIHF1ZXJ5OgorICAgPC9wYXJhPgorCis8c2NyZWVuPgorU0VUIG1pbl9wYXJhbGxl bF90YWJsZV9zY2FuX3NpemUgPSAwOworU0VUIHBhcmFsbGVsX3R1cGxlX2Nvc3QgPSAwOworU0VU IHBhcmFsbGVsX3NldHVwX2Nvc3QgPSAwOworCitFWFBMQUlOIEFOQUxZWkUgU0VMRUNUICoKK0ZS T00gdGVuazEgdDEsIHRlbmsyIHQyCitXSEVSRSB0MS51bmlxdWUxICZsdDsgMTAgQU5EIHQxLnVu aXF1ZTIgPSB0Mi51bmlxdWUyOworICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4gICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCistLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t Jnp3c3A7LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLSZ6d3NwOy0tLS0KKyBHYXRoZXIgIChjb3N0PTQuNjUuLjcwLjk2IHJv d3M9MTAgd2lkdGg9NDg4KSAoYWN0dWFsIHRpbWU9MS4xNjEuLjExLjY1NSByb3dzPTEwLjAwIGxv b3BzPTEpCisgICBXb3JrZXJzIFBsYW5uZWQ6IDIKKyAgIFdvcmtlcnMgTGF1bmNoZWQ6IDIKKyAg IEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9NzggcmVhZD02CisgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0 PTQuNjUuLjcwLjk2IHJvd3M9NCB3aWR0aD00ODgpIChhY3R1YWwgdGltZT0wLjI0Ny4uMC4zMTcg cm93cz0zLjMzIGxvb3BzPTMpCisgICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTc4IHJlYWQ9 NgorICAgICAgICAgLT4gIFBhcmFsbGVsIEJpdG1hcCBIZWFwIFNjYW4gb24gdGVuazEgdDEgIChj b3N0PTQuMzYuLjM5LjMxIHJvd3M9NCB3aWR0aD0yNDQpIChhY3R1YWwgdGltZT0wLjIyOC4uMC4y NDkgcm93cz0zLjMzIGxvb3BzPTMpCisgICAgICAgICAgICAgICBSZWNoZWNrIENvbmQ6ICh1bmlx dWUxICZsdDsgMTApCisgICAgICAgICAgICAgICBIZWFwIEJsb2NrczogZXhhY3Q9MTAKKyAgICAg ICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9NTQKKyAgICAgICAgICAgICAgIC0+ICBCaXRt YXAgSW5kZXggU2NhbiBvbiB0ZW5rMV91bmlxdWUxICAoY29zdD0wLjAwLi40LjM2IHJvd3M9MTAg d2lkdGg9MCkgKGFjdHVhbCB0aW1lPTAuNDM4Li4wLjQzOSByb3dzPTEwLjAwIGxvb3BzPTEpCisg ICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAodW5pcXVlMSAmbHQ7IDEwKQorICAgICAg ICAgICAgICAgICAgICAgSW5kZXggU2VhcmNoZXM6IDEKKyAgICAgICAgICAgICAgICAgICAgIEJ1 ZmZlcnM6IHNoYXJlZCBoaXQ9MgorICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgdGVuazJf dW5pcXVlMiBvbiB0ZW5rMiB0MiAgKGNvc3Q9MC4yOS4uNy45MCByb3dzPTEgd2lkdGg9MjQ0KSAo YWN0dWFsIHRpbWU9MC4wMTYuLjAuMDE3IHJvd3M9MS4wMCBsb29wcz0xMCkKKyAgICAgICAgICAg ICAgIEluZGV4IENvbmQ6ICh1bmlxdWUyID0gdDEudW5pcXVlMikKKyAgICAgICAgICAgICAgIElu ZGV4IFNlYXJjaGVzOiAxMAorICAgICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIGhpdD0yNCBy ZWFkPTYKKyBQbGFubmluZzoKKyAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9MzI3IHJlYWQ9MworIFBs YW5uaW5nIFRpbWU6IDQuNzgxIG1zCisgRXhlY3V0aW9uIFRpbWU6IDExLjg1OCBtcworKDIyIHJv d3MpCis8L3NjcmVlbj4KKworICA8cGFyYT4KKyAgICBUaGUgcGFyYWxsZWwgYml0bWFwIGhlYXAg c2NhbiB3YXMgZXhlY3V0ZWQgdGhyZWUgc2VwYXJhdGUgdGltZXMgaW4gcGFyYWxsZWw6CisgICAg b25jZSBpbiB0aGUgbGVhZGVyIChzaW5jZSA8eHJlZiBsaW5rZW5kPSJndWMtcGFyYWxsZWwtbGVh ZGVyLXBhcnRpY2lwYXRpb24iLz4KKyAgICBpcyBvbiBieSBkZWZhdWx0KSwgYW5kIG9uY2UgaW4g ZWFjaCBvZiB0aGUgdHdvIGxhdW5jaGVkIHdvcmtlcnMuICBTaW1pbGFybHkKKyAgICB0byBzZXF1 ZW50aWFsIHJlcGVhdGVkIGV4ZWN1dGlvbnMsIHJvd3MgYW5kIGFjdHVhbCB0aW1lIGFyZSBhdmVy YWdlcworICAgIHBlci13b3JrZXIuICBNdWx0aXBseSBieSB0aGUgPGxpdGVyYWw+bG9vcHM8L2xp dGVyYWw+IHZhbHVlIHRvIGdldCB0aGUKKyAgICB0b3RhbCBudW1iZXIgb2Ygcm93cyBwcm9jZXNz ZWQgYnkgdGhlIG5vZGUgYWNyb3NzIGFsbCB3b3JrZXJzLiAgVGhlIHRvdGFsCisgICAgdGltZSBz cGVudCBpbiBhbGwgd29ya2VycyBjYW4gYmUgc2ltaWxhcmx5IGNhbGN1bGF0ZWQsIGJ1dCBub3Rl IHRoaXMgdGltZQorICAgIGlzIHNwZW50IGNvbmN1cnJlbnRseSwgc28gaXQgaXMgbm90IGVxdWl2 YWxlbnQgdG8gdG90YWwgdGltZSBzcGVudCBpbiB0aGUKKyAgICBub2RlLgorICA8L3BhcmE+CisK KyAgPHBhcmE+CiAgICAgSW4gc29tZSBjYXNlcyA8Y29tbWFuZD5FWFBMQUlOIEFOQUxZWkU8L2Nv bW1hbmQ+IHNob3dzIGFkZGl0aW9uYWwgZXhlY3V0aW9uCiAgICAgc3RhdGlzdGljcyBiZXlvbmQg dGhlIHBsYW4gbm9kZSBleGVjdXRpb24gdGltZXMgYW5kIHJvdyBjb3VudHMuCiAgICAgRm9yIGV4 YW1wbGUsIFNvcnQgYW5kIEhhc2ggbm9kZXMgcHJvdmlkZSBleHRyYSBpbmZvcm1hdGlvbjoKLS0g CjIuNDMuMAoK --000000000000136ee6064c379ff1--