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 1vyQv8-0006pm-0I for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Mar 2026 08:52:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vyQv4-0049u6-0d for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Mar 2026 08:52:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vyQv3-0049tp-2S for pgsql-hackers@lists.postgresql.org; Fri, 06 Mar 2026 08:52:26 +0000 Received: from mail-oo1-xc35.google.com ([2607:f8b0:4864:20::c35]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vyQv1-00000000kLI-3ofq for pgsql-hackers@postgresql.org; Fri, 06 Mar 2026 08:52:25 +0000 Received: by mail-oo1-xc35.google.com with SMTP id 006d021491bc7-67a02dcc450so4928347eaf.2 for ; Fri, 06 Mar 2026 00:52:23 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772787142; cv=none; d=google.com; s=arc-20240605; b=lqhh2WVJxvBTOGSw/zie8iJZE6ECyuMDTp8LMWSvsA07wEZEHmHgJgeU+nBbq8hLFR L4tjw5iv4IZ3Gh7TtszQyg9zEwXEtWfGlt0qbsuXMtLZrUZw1JYEfJXtdQFeoMdJgG1I wvKapTYqh/KbX/0cKb6OvOiGEuMZq6Zdc1xyQJH0AxyzmgQmVvZVXl7P3MXby80kx4/x D65CMVhbLlvQ6wWFK8Euqhf9f0JDSHFYNFDjqsL4haEr4e9yo/d4xZ/4cvjAnrIE2Z19 V4PgT9AjJsV5VkTthgc+dWSaTaZcXssfdYyBLnOQh6qctd4cWLBOR7kdQYUXnJSNd/9t 5xVg== 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=zqt69w5LIA/4strN8bcpIamukeObKpeBv5TJalNrQi4=; fh=XGpYSqywjM3hxyJ1Z3sBZFqzVDgo436C06DDR3YYZw8=; b=UfsNH7nR9pDHwe+qzuQk2jBUee6ReiPVl3aXmCtUcyGrZgY3htBnyjZKkxcGqucTmv gYsYeEVvrGhXDSPVu7xTEqTFiBz6Bc5Wos+DqsgqSuUhkD6lnAroEwsge/NaxSlQDFQh ToX8GPMI3jTOmsIJ3o2dn0WaODhp0nyIxD8PW3/iXKXIdjgbW2yb0wOkwr8EseIN3wWH C9cjAsnENqRCYPdhjz162uwbG+atHRg7vvNhO3fG4WCbpVLTX0oSl1Wt8KUrz5CEtLy0 ZzPXXfGUKsilOoNIQaBRpf8KHbvscy2k+On5j/Mt5jTf52FIJp8LRW3SrkjqDSewY5nn mkUw==; 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=1772787142; x=1773391942; 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=zqt69w5LIA/4strN8bcpIamukeObKpeBv5TJalNrQi4=; b=egIJBumaidz3e3FU1u4OlQqbZzAlQ2S9eSO+JGkbCL806EOQS38adW/lk8/0HCWtiP 8yvnwwEYmpMhjnJe3AxfsOVtEqiKBvq+1Vsac2Dh50FSuk7LtTXBtDuYkK8uOn7/5pLW CoyqW+WIspT2oOYlJqOUN3iBLvdGAETKPTDOVf9Icdu+6D+cvRI42xGEvM6YunFWHmeB pEVhPJw8Xbs2Wk2LdM3sygs38fyaZBGsVTqgYcgqK6WNYEYhIkD0KHttzqrNt4WyMuZ8 Y9Q92ueWWgXY01cBIw1XkGgdvFp6GTuEy1fImzESJ0aefU1wlEnWwDxEoOtvQG4hpT2G 14XQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772787142; x=1773391942; 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=zqt69w5LIA/4strN8bcpIamukeObKpeBv5TJalNrQi4=; b=aiKKrfrxkWc4lNhXrC6ELao+WemPCHZiOKhWVgrqRb8THWlsHUJEdE2wJ/VcWyJGl8 zCxHjXvLwuIdU9D/dysTw3C+Zfhq3WZyP8IMFbuZ7DXFg/Tn8lj4rXv9a0TwO++BKzkp 3ETdgAHi/1OpJBDn5Vw+PFWUbj/KESyq2/t3rATnWj0dMHUFlwOzxppX0B8HPqHAjKFO rkCTGXfhlcSdOwFGArup5myTnByQF0lumVkWSP77Vou8lfFsnC961WUez5Cl9ltXzc0w XgjVBfODZKDSHkYPNjNi53Sl58YjaFE8fGpw6zOr615/W+iLEkdg7jvQvL3tcCy/J9NI RgMw== X-Forwarded-Encrypted: i=1; AJvYcCWbRO3m9A/F+txv25CJO1C8RPjTN9+o8SysJx0S/xj9A5U+iD11cXUCa6Jbjv+brAsLTJn9G2v9v8UqZrou@postgresql.org X-Gm-Message-State: AOJu0YzwQ3WrpmMA0xsTsE0OX1l7XdpDMf20UuIl7rNaBv94/dl6gQFJ Os2SL9gH8WIXGso1fqqYLBRjNor0QHWbSDOdgxt7OPas0zJTxslUqgsP14xU2RAi8Aq6oVS1wdF w+ghi4TKRdLwU8EcYVSJu9mkwXjOKtgLkEMdwWlPuDA== X-Gm-Gg: ATEYQzweszzI7M40cswYln3Mn8Brq2YkAO9IZut+pUKYtig1K9a9er3jZvmtrUby99H V5R3od/Rfe9/NK9qVrpY1OC9NR83CQMWwYQI2p4/EQ/40zDrkyEHeZ7/mnaa+QnMIfXJvYzSEfJ vAN0XnfATaODWUBb+ffV0n0UxB3NLCymnlE0t/e0ZmGkxqOuuejoQ9iveeW+yibfesupdlek9jV kVUKfbrc58+MMBYC56AeckZ89K5IWBvp6ZlPkzsfA7iEtDUPmThrUJHBMqSzV7seeJHxvq21NHA P77QFMAwiAoo+hNeA841DRz8wSZWuujNobyKlHc= X-Received: by 2002:a05:6820:228e:b0:676:eb1e:df29 with SMTP id 006d021491bc7-67b9bcc0e80mr956609eaf.31.1772787142488; Fri, 06 Mar 2026 00:52:22 -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: Fri, 6 Mar 2026 00:52:10 -0800 X-Gm-Features: AaiRm50B0mpl-hrWFfC3sWdax3UK4RMf9RlSCffSDqpcy3-5tIxTVYAHYAXTzOk 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="000000000000e42c6a064c572bda" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e42c6a064c572bda Content-Type: text/plain; charset="UTF-8" Ah, good catch. Fixed in attached v4. --000000000000e42c6a064c572bda Content-Type: text/x-patch; charset="US-ASCII"; name="v4-0001-Improve-EXPLAIN-docs.patch" Content-Disposition: attachment; filename="v4-0001-Improve-EXPLAIN-docs.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mmenom5j0 RnJvbSA3NmNhYzMyNjViMjViOTMyMjg5NDE4ODgyZGJmNGU3OWFmNDRhYzkzIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBNYWNpZWsgU2FrcmVqZGEgPG0uc2FrcmVqZGFAZ21haWwuY29t PgpEYXRlOiBGcmksIDI2IFNlcCAyMDI1IDE3OjE3OjQxIC0wNzAwClN1YmplY3Q6IFtQQVRDSCB2 NF0gSW1wcm92ZSBFWFBMQUlOIGRvY3MKCiAtIGNsYXJpZnkgZnJhY3Rpb25hbCByb3dzIGluIGxv b3BzCiAtIGFkZCBzb21lIGJhc2ljIGluZm8gb24gcGFyYWxsZWwgZXhlY3V0aW9uCi0tLQogZG9j L3NyYy9zZ21sL3BlcmZvcm0uc2dtbCB8IDY0ICsrKysrKysrKysrKysrKysrKysrKysrKysrKysr KysrKysrKy0tLQogMSBmaWxlIGNoYW5nZWQsIDYwIGluc2VydGlvbnMoKyksIDQgZGVsZXRpb25z KC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL3BlcmZvcm0uc2dtbCBiL2RvYy9zcmMvc2dt bC9wZXJmb3JtLnNnbWwKaW5kZXggNWY2ZjFkYjA0NjcuLjY1MTgzZTA3NzUxIDEwMDY0NAotLS0g 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 ICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4KKy0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0mendzcDst LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tJnp3c3A7LS0tLQorIEdhdGhlciAgKGNvc3Q9NC42NS4uNzAuOTYgcm93cz0xMCB3 aWR0aD00ODgpIChhY3R1YWwgdGltZT0xLjE2MS4uMTEuNjU1IHJvd3M9MTAuMDAgbG9vcHM9MSkK KyAgIFdvcmtlcnMgUGxhbm5lZDogMgorICAgV29ya2VycyBMYXVuY2hlZDogMgorICAgQnVmZmVy czogc2hhcmVkIGhpdD03OCByZWFkPTYKKyAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9NC42NS4u NzAuOTYgcm93cz00IHdpZHRoPTQ4OCkgKGFjdHVhbCB0aW1lPTAuMjQ3Li4wLjMxNyByb3dzPTMu MzMgbG9vcHM9MykKKyAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9NzggcmVhZD02CisgICAg ICAgICAtPiAgUGFyYWxsZWwgQml0bWFwIEhlYXAgU2NhbiBvbiB0ZW5rMSB0MSAgKGNvc3Q9NC4z Ni4uMzkuMzEgcm93cz00IHdpZHRoPTI0NCkgKGFjdHVhbCB0aW1lPTAuMjI4Li4wLjI0OSByb3dz PTMuMzMgbG9vcHM9MykKKyAgICAgICAgICAgICAgIFJlY2hlY2sgQ29uZDogKHVuaXF1ZTEgJmx0 OyAxMCkKKyAgICAgICAgICAgICAgIEhlYXAgQmxvY2tzOiBleGFjdD0xMAorICAgICAgICAgICAg ICAgQnVmZmVyczogc2hhcmVkIGhpdD01NAorICAgICAgICAgICAgICAgLT4gIEJpdG1hcCBJbmRl eCBTY2FuIG9uIHRlbmsxX3VuaXF1ZTEgIChjb3N0PTAuMDAuLjQuMzYgcm93cz0xMCB3aWR0aD0w KSAoYWN0dWFsIHRpbWU9MC40MzguLjAuNDM5IHJvd3M9MTAuMDAgbG9vcHM9MSkKKyAgICAgICAg ICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh1bmlxdWUxICZsdDsgMTApCisgICAgICAgICAgICAg ICAgICAgICBJbmRleCBTZWFyY2hlczogMQorICAgICAgICAgICAgICAgICAgICAgQnVmZmVyczog c2hhcmVkIGhpdD0yCisgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyB0ZW5rMl91bmlxdWUy IG9uIHRlbmsyIHQyICAoY29zdD0wLjI5Li43LjkwIHJvd3M9MSB3aWR0aD0yNDQpIChhY3R1YWwg dGltZT0wLjAxNi4uMC4wMTcgcm93cz0xLjAwIGxvb3BzPTEwKQorICAgICAgICAgICAgICAgSW5k ZXggQ29uZDogKHVuaXF1ZTIgPSB0MS51bmlxdWUyKQorICAgICAgICAgICAgICAgSW5kZXggU2Vh cmNoZXM6IDEwCisgICAgICAgICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTI0IHJlYWQ9Ngor IFBsYW5uaW5nOgorICAgQnVmZmVyczogc2hhcmVkIGhpdD0zMjcgcmVhZD0zCisgUGxhbm5pbmcg VGltZTogNC43ODEgbXMKKyBFeGVjdXRpb24gVGltZTogMTEuODU4IG1zCisoMjIgcm93cykKKzwv c2NyZWVuPgorCisgIDxwYXJhPgorICAgIFRoZSBwYXJhbGxlbCBiaXRtYXAgaGVhcCBzY2FuIHdh cyBleGVjdXRlZCB0aHJlZSBzZXBhcmF0ZSB0aW1lcyBpbiBwYXJhbGxlbDoKKyAgICBvbmNlIGlu IHRoZSBsZWFkZXIgKHNpbmNlIDx4cmVmIGxpbmtlbmQ9Imd1Yy1wYXJhbGxlbC1sZWFkZXItcGFy dGljaXBhdGlvbiIvPgorICAgIGlzIG9uIGJ5IGRlZmF1bHQpLCBhbmQgb25jZSBpbiBlYWNoIG9m IHRoZSB0d28gbGF1bmNoZWQgd29ya2Vycy4gIFNpbWlsYXJseQorICAgIHRvIHNlcXVlbnRpYWwg cmVwZWF0ZWQgZXhlY3V0aW9ucywgcm93cyBhbmQgYWN0dWFsIHRpbWUgYXJlIGF2ZXJhZ2VzCisg ICAgcGVyLXdvcmtlci4gIE11bHRpcGx5IGJ5IHRoZSA8bGl0ZXJhbD5sb29wczwvbGl0ZXJhbD4g dmFsdWUgdG8gZ2V0IHRoZQorICAgIHRvdGFsIG51bWJlciBvZiByb3dzIHByb2Nlc3NlZCBieSB0 aGUgbm9kZSBhY3Jvc3MgYWxsIHdvcmtlcnMuICBUaGUgdG90YWwKKyAgICB0aW1lIHNwZW50IGlu IGFsbCB3b3JrZXJzIGNhbiBiZSBzaW1pbGFybHkgY2FsY3VsYXRlZCwgYnV0IG5vdGUgdGhpcyB0 aW1lCisgICAgaXMgc3BlbnQgY29uY3VycmVudGx5LCBzbyBpdCBpcyBub3QgZXF1aXZhbGVudCB0 byB0b3RhbCB0aW1lIHNwZW50IGluIHRoZQorICAgIG5vZGUuCisgIDwvcGFyYT4KKworICA8cGFy YT4KICAgICBJbiBzb21lIGNhc2VzIDxjb21tYW5kPkVYUExBSU4gQU5BTFlaRTwvY29tbWFuZD4g c2hvd3MgYWRkaXRpb25hbCBleGVjdXRpb24KICAgICBzdGF0aXN0aWNzIGJleW9uZCB0aGUgcGxh biBub2RlIGV4ZWN1dGlvbiB0aW1lcyBhbmQgcm93IGNvdW50cy4KICAgICBGb3IgZXhhbXBsZSwg U29ydCBhbmQgSGFzaCBub2RlcyBwcm92aWRlIGV4dHJhIGluZm9ybWF0aW9uOgotLSAKMi40My4w Cgo= --000000000000e42c6a064c572bda--