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 1vxrd3-00HCjM-23 for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 19:11:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxrd1-00DyPG-07 for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 19:11:27 +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 1vxrd0-00DyP7-1o for pgsql-hackers@lists.postgresql.org; Wed, 04 Mar 2026 19:11:27 +0000 Received: from mail-oa1-x33.google.com ([2001:4860:4864:20::33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vxrcy-00000000Q3D-3yP1 for pgsql-hackers@postgresql.org; Wed, 04 Mar 2026 19:11:26 +0000 Received: by mail-oa1-x33.google.com with SMTP id 586e51a60fabf-415c8a4d2e6so911704fac.0 for ; Wed, 04 Mar 2026 11:11:24 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772651484; cv=none; d=google.com; s=arc-20240605; b=ezJvochakfavO8IUtK86/0ETkot7+L0vzZJt5hv/256xYCIlOvhYl/OuGifKQA5m4s USJfFDCgP34rpY/4M1OpzlW7eSuHi+iopkiNPdrn63aDReDl0NmYUEehhdB43F/9cqpO AW4Hbr24F8JfZoBNX4gESpU9bQdGKhYwBKwpW48pm4OKLBm4Zzk9sqPGrZbrIeg/MBUq AvUeKy+ydMENdT5SZrU3UhTku2E5RurNb2YAz2mAOfzLKNDL5YNXAtUdSk4aoo/WREP7 53GsqAQMuWJuVPMBtTJI2sWveWyJ1JG0e0ynOsTXwciR2PJBHoZ3fvkC8aDvczJBUrDd kyLQ== 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=2D5lBGiqU9bSxb9WwWL5YRfSOi6ePxnalAL2no5f150=; fh=PrmhQUQR9O3meFQEcbCfT5sdTZos6yYY1eUxgTtWvh4=; b=OYoJ8m8WRw81UQC4cUGPKWLi1CTgILRdLhYYwvKhAOYJs8Nxq78vGtwo+cdrlH9xlk 6iXGQB7ZkvOICosqd+nCgfD1GEG2LehPijJNOjdC8b1CF94bpUDi0qFcxSlsoPFJ8T3w Tkkpz1JrVNzFut63OxEn5CvoFr0FEpAjCuSrVhxJH8S0vY0fSeKAFG5jDTJ3t6bEhwt0 BDpSxY34kayL1v/MmZWPgK0MvrrxTzn+QgpeUgmad1pNleq8egYnP8fic6BwPTz5idVs fnNtx5Yv41x1zKX+HWP+ToY0595rAvkglhb57fGHgW405pmXj6IBWQ+I85Ze9332JtRw +GZA==; 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=1772651484; x=1773256284; 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=2D5lBGiqU9bSxb9WwWL5YRfSOi6ePxnalAL2no5f150=; b=I0PyyBmLTRbD4aTyhuaFLVH2Q7PWW3xhh8TBOIap8hhRVAQ7smSkGiIW7luqQO8FQB tim7CSR8PfLv6K9HyNNOLWaeO2fqOSZ5V+3zyuauKWHWpOK+4rQrmEVQZ0udKTzFF7Fq zGYAbIhGVL/tldwTVip8P1Baifa6yZVcnvyRSljZJwmcSDhWmmXzJ4ejuuySnq6PN6vl 7JrGcc/zSJ9HJ7kw3T90asStXxfzfEQQHUr1eqRSDMwx9Ftzjd4hV5whQW81Y2iEMe2Y JhQSJdgbdnfldTqpizb9Eh6UwV6IadTg2gedIdYeEzl1o2RjIASygwckOJltfeF1IidA b8bA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772651484; x=1773256284; 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=2D5lBGiqU9bSxb9WwWL5YRfSOi6ePxnalAL2no5f150=; b=etIdcFo/I+kVdo2Kqwz5MWlxrTOSZZuq8isoL2Jwt5UX6HX7C1OBviLLbUqFCpA+FF Rbb4H6OH26o7Hv6msBtgDQHSVcqJPvHQninY1nWJa8uLCE22/4OFQPv4rUVGJ37BO38z PqMD1wWEEMNbPU8NnEnq/6n1+rCgFqhT/2nvsMYeLoIqEplzUCn/wCvvQMAf5g9ywf5g PswaDS6m6wUuKla8cxGDd6EQwlI0ZqWYREwpAn0CW6HL5emgujhAxI6qysFwC3t4LEUQ ONODB7jmjcA1U9slMkb4dWBXLeBbrnraxJ42QW5+7mwUX3v3FxMprF8K6TO1JUu3P7+1 0rYA== X-Forwarded-Encrypted: i=1; AJvYcCU/v5kIhMr1PvHM++vc/d8UHRHJ+SMc0DAYeKZYCntSUOwWQttrSTJ9541Mr4ijTXSfRDm4UZiwmVNx7xP5@postgresql.org X-Gm-Message-State: AOJu0YyEYkAr8MPWGE427P29CaYYbgPTZZ5H5rdskl1KH0aPDfixQ6LH lzTEyFDCLUCJkUpyDAI0vcg1Up4cTgL1UnHvpArVSk4PyOJNsp2MSCimZ5kygwxRaPJhG68iJdj aksoCpfQp6XolD7JNnH5hRb4EUKxyJinv1KozFFFBAg== X-Gm-Gg: ATEYQzx8UoPLgYycTidm4buTt0BFgLgos989mq2smbVuCSfWn6XySbTfKtMzBW3LOUm PNuCA5vsypmd1VaYb5T4XNKWtX4M4NSEhN+EwuCkg1jEcVV/zVTKTXRApHf3biR+2nVjWErYvZj Tpgl09VcJ65UYfMEc7rz8nQRA8frJ0WqRQYlcR8lUmBA+kpPrXS+u6eiEQfjjXyGa8GC+Z9dtSQ baP5pBBERqGSk69kFgK3A5CNrGSLUsez8x614dAEZFPQ1aHeyD40vtSgHES7oyKzxvvnHsYkNwY /ERU9JQFbiMBJRW4Mhrie5BI7ATiY5v54oPp6PXF6k6PB03PIWQ= X-Received: by 2002:a05:6871:78d:b0:40a:5e90:e0c3 with SMTP id 586e51a60fabf-416abc025a9mr1624574fac.55.1772651484065; Wed, 04 Mar 2026 11:11:24 -0800 (PST) MIME-Version: 1.0 References: <34604.1758921116@sss.pgh.pa.us> <1d40131f-e01b-4c3f-a4b8-6b5f49edd3d1@tantorlabs.com> In-Reply-To: <1d40131f-e01b-4c3f-a4b8-6b5f49edd3d1@tantorlabs.com> From: Maciek Sakrejda Date: Wed, 4 Mar 2026 11:11:12 -0800 X-Gm-Features: AaiRm52OyZA1sOThQvHwD4fCDY8sBmzUS4aFAzCjFvarbBhngewFqVU9Em5q6_g 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="00000000000004d76e064c37964a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000004d76e064c37964a Content-Type: text/plain; charset="UTF-8" Thanks for the feedback! I'm attaching a v2 fixing these issues. --00000000000004d76e064c37964a Content-Type: text/x-patch; charset="US-ASCII"; name="v2-0001-Improve-EXPLAIN-docs.patch" Content-Disposition: attachment; filename="v2-0001-Improve-EXPLAIN-docs.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mmcewz2v0 RnJvbSA1MDExYjg4OTAyYzBmMzE2YmU0YWE4NzdkMzViNzNkY2Q2NDYzNzI4IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBNYWNpZWsgU2FrcmVqZGEgPG0uc2FrcmVqZGFAZ21haWwuY29t PgpEYXRlOiBGcmksIDI2IFNlcCAyMDI1IDE3OjE3OjQxIC0wNzAwClN1YmplY3Q6IFtQQVRDSCB2 Ml0gSW1wcm92ZSBFWFBMQUlOIGRvY3MKCiAtIGNsYXJpZnkgZnJhY3Rpb25hbCByb3dzIGluIGxv b3BzCiAtIGFkZCBzb21lIGJhc2ljIGluZm8gb24gcGFyYWxsZWwgZXhlY3V0aW9uCi0tLQogZG9j L3NyYy9zZ21sL3BlcmZvcm0uc2dtbCB8IDY0ICsrKysrKysrKysrKysrKysrKysrKysrKysrKysr KysrKysrKy0tLQogMSBmaWxlIGNoYW5nZWQsIDYwIGluc2VydGlvbnMoKyksIDQgZGVsZXRpb25z KC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL3BlcmZvcm0uc2dtbCBiL2RvYy9zcmMvc2dt bC9wZXJmb3JtLnNnbWwKaW5kZXggNWY2ZjFkYjA0NjcuLmIxOTdiNDgxNDNjIDEwMDY0NAotLS0g 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 T00gdGVuazEgdDEsIHRlbmsyIHQyCitXSEVSRSB0MS51bmlxdWUxIDwgMTAgQU5EIHQxLnVuaXF1 ZTIgPSB0Mi51bmlxdWUyOworICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4gICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCistLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0KKyBHYXRoZXIgIChjb3N0PTQuNjUuLjcwLjk2IHJvd3M9MTAgd2lkdGg9NDg4 KSAoYWN0dWFsIHRpbWU9MS4xNjEuLjExLjY1NSByb3dzPTEwLjAwIGxvb3BzPTEpCisgICBXb3Jr ZXJzIFBsYW5uZWQ6IDIKKyAgIFdvcmtlcnMgTGF1bmNoZWQ6IDIKKyAgIEJ1ZmZlcnM6IHNoYXJl ZCBoaXQ9NzggcmVhZD02CisgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTQuNjUuLjcwLjk2IHJv d3M9NCB3aWR0aD00ODgpIChhY3R1YWwgdGltZT0wLjI0Ny4uMC4zMTcgcm93cz0zLjMzIGxvb3Bz PTMpCisgICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTc4IHJlYWQ9NgorICAgICAgICAgLT4g IFBhcmFsbGVsIEJpdG1hcCBIZWFwIFNjYW4gb24gdGVuazEgdDEgIChjb3N0PTQuMzYuLjM5LjMx IHJvd3M9NCB3aWR0aD0yNDQpIChhY3R1YWwgdGltZT0wLjIyOC4uMC4yNDkgcm93cz0zLjMzIGxv b3BzPTMpCisgICAgICAgICAgICAgICBSZWNoZWNrIENvbmQ6ICh1bmlxdWUxIDwgMTApCisgICAg ICAgICAgICAgICBIZWFwIEJsb2NrczogZXhhY3Q9MTAKKyAgICAgICAgICAgICAgIEJ1ZmZlcnM6 IHNoYXJlZCBoaXQ9NTQKKyAgICAgICAgICAgICAgIC0+ICBCaXRtYXAgSW5kZXggU2NhbiBvbiB0 ZW5rMV91bmlxdWUxICAoY29zdD0wLjAwLi40LjM2IHJvd3M9MTAgd2lkdGg9MCkgKGFjdHVhbCB0 aW1lPTAuNDM4Li4wLjQzOSByb3dzPTEwLjAwIGxvb3BzPTEpCisgICAgICAgICAgICAgICAgICAg ICBJbmRleCBDb25kOiAodW5pcXVlMSA8IDEwKQorICAgICAgICAgICAgICAgICAgICAgSW5kZXgg U2VhcmNoZXM6IDEKKyAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9Mgor ICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgdGVuazJfdW5pcXVlMiBvbiB0ZW5rMiB0MiAg KGNvc3Q9MC4yOS4uNy45MCByb3dzPTEgd2lkdGg9MjQ0KSAoYWN0dWFsIHRpbWU9MC4wMTYuLjAu MDE3IHJvd3M9MS4wMCBsb29wcz0xMCkKKyAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh1bmlx dWUyID0gdDEudW5pcXVlMikKKyAgICAgICAgICAgICAgIEluZGV4IFNlYXJjaGVzOiAxMAorICAg ICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIGhpdD0yNCByZWFkPTYKKyBQbGFubmluZzoKKyAg IEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9MzI3IHJlYWQ9MworIFBsYW5uaW5nIFRpbWU6IDQuNzgxIG1z CisgRXhlY3V0aW9uIFRpbWU6IDExLjg1OCBtcworKDIyIHJvd3MpCis8L3NjcmVlbj4KKworICA8 cGFyYT4KKyAgICBUaGUgcGFyYWxsZWwgYml0bWFwIGhlYXAgc2NhbiB3YXMgZXhlY3V0ZWQgdGhy ZWUgc2VwYXJhdGUgdGltZXMgaW4gcGFyYWxsZWw6CisgICAgb25jZSBpbiB0aGUgbGVhZGVyIChz aW5jZSA8eHJlZiBsaW5rZW5kPSJndWMtcGFyYWxsZWwtbGVhZGVyLXBhcnRpY2lwYXRpb24iLz4K KyAgICBpcyBvbiBieSBkZWZhdWx0KSwgYW5kIG9uY2UgaW4gZWFjaCBvZiB0aGUgdHdvIGxhdW5j aGVkIHdvcmtlcnMuICBTaW1pbGFybHkKKyAgICB0byBzZXF1ZW50aWFsIHJlcGVhdGVkIGV4ZWN1 dGlvbnMsIHJvd3MgYW5kIGFjdHVhbCB0aW1lIGFyZSBhdmVyYWdlcworICAgIHBlci13b3JrZXIu ICBNdWx0aXBseSBieSB0aGUgPGxpdGVyYWw+bG9vcHM8L2xpdGVyYWw+IHZhbHVlIHRvIGdldCB0 aGUKKyAgICB0b3RhbCBudW1iZXIgb2Ygcm93cyBwcm9jZXNzZWQgYnkgdGhlIG5vZGUgYWNyb3Nz IGFsbCB3b3JrZXJzLiAgVGhlIHRvdGFsCisgICAgdGltZSBzcGVudCBpbiBhbGwgd29ya2VycyBj YW4gYmUgc2ltaWxhcmx5IGNhbGN1bGF0ZWQsIGJ1dCBub3RlIHRoaXMgdGltZQorICAgIGlzIHNw ZW50IGNvbmN1cnJlbnRseSwgc28gaXQgaXMgbm90IGVxdWl2YWxlbnQgdG8gdG90YWwgdGltZSBz cGVudCBpbiB0aGUKKyAgICBub2RlLgorICA8L3BhcmE+CisKKyAgPHBhcmE+CiAgICAgSW4gc29t ZSBjYXNlcyA8Y29tbWFuZD5FWFBMQUlOIEFOQUxZWkU8L2NvbW1hbmQ+IHNob3dzIGFkZGl0aW9u YWwgZXhlY3V0aW9uCiAgICAgc3RhdGlzdGljcyBiZXlvbmQgdGhlIHBsYW4gbm9kZSBleGVjdXRp b24gdGltZXMgYW5kIHJvdyBjb3VudHMuCiAgICAgRm9yIGV4YW1wbGUsIFNvcnQgYW5kIEhhc2gg bm9kZXMgcHJvdmlkZSBleHRyYSBpbmZvcm1hdGlvbjoKLS0gCjIuNDMuMAoK --00000000000004d76e064c37964a--