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 1vmJuY-00Abtv-0k for pgsql-hackers@arkaria.postgresql.org; Sat, 31 Jan 2026 22:57:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vmJuV-009I9P-10 for pgsql-hackers@arkaria.postgresql.org; Sat, 31 Jan 2026 22:57:48 +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 1vmJuU-009I9C-3A for pgsql-hackers@lists.postgresql.org; Sat, 31 Jan 2026 22:57:47 +0000 Received: from mail-pg1-x534.google.com ([2607:f8b0:4864:20::534]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vmJuR-00000000QPP-2jOT for pgsql-hackers@postgresql.org; Sat, 31 Jan 2026 22:57:47 +0000 Received: by mail-pg1-x534.google.com with SMTP id 41be03b00d2f7-c65822dead7so1249753a12.3 for ; Sat, 31 Jan 2026 14:57:42 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769900260; cv=none; d=google.com; s=arc-20240605; b=PhRUC5m/15cNGv7J/887TIGav3fg3Xyyk8rIHtjx1YEUBtBEVL0VFKkbOOam2/qIGt R0ijfBMpJV5XEViL3jGYYSwb2MNHD/6lGCXrVXQFUFgFPKGSYlkmk1Vf4HGEdURReum7 yJMYC79OT8ayUkljWRw/f7s2iWePKNnI9jVH1c5Q6EnGSTtZAk3ROqgOgqU6flShQYLB N55XcfWfvCMA6Ehj/1bXycJhUKSIptZu3KRBz9hbKx09DcW9phWkKcUM5fCua0i4ZlVp P5zZkcnPSSc+aJ4wZrnhj+Bl4am5g28tLf8cjwQuuQGr1s1CpXrsi4hSNG2lo5NP3jsX s5Zg== 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:reply-to:in-reply-to:references :mime-version:dkim-signature; bh=1Hnmin9pUD8ONl+qzrSisLfk86BFdwtV90scBQahWR0=; fh=2Ww1O4wGlr+ffPt04q0tiLz0/RTJei67DRL/qMEFz3s=; b=BHDDOH2rH9hpDZrJrPanBonhw4o493ltPvOEx4esn/heHCeVXaR7SkxgXYMfD9KcLA UhBrLP1K03LQUsJtLNvpnr2Ou1okn2ddOIigiL0VZ6P7qrnkiziBE11S4XkQNCmypl/e lX4ElV2e8ECm2um61nA7tLkeiS112tqX3QXqAxCITCsdCiktmeEp9p1O8e+xaW6ktZyH nYchXQ4sHGgUQlhgriGo8dZJRbC7mYM/e5w2y7F4IXEaNIreRIM7Kf5XuEHT+Q5oJHuc bYm9qcBXc+ZYxR+WeNhP4Dsy0e83jxLg5gtrbzU1QH1cBb5UhvxmV/OkVQWiQBaq0RwG paVw==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1769900260; x=1770505060; darn=postgresql.org; h=cc:to:subject:message-id:date:from:reply-to:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=1Hnmin9pUD8ONl+qzrSisLfk86BFdwtV90scBQahWR0=; b=DqQ01L1T3tSK0PDrvt34gimitXTxvdqjQShP3Atnz1iXSHD4doYoUrj6QHxC/vRc4J mMoHN8JKE8diBO7YCW+xHFyBmNBgsAsBMXgKmfhelI2hy3DE3+hWA4QeVODDvlHdyRQZ J8zPSWIpqI7ErcqsH2pI/BQabWLuJvD5mkEvZp7s0+U6uHbsfE/VsqDhh+G7hX+lFNtU oF2fdCHpSnZf0gJ+sIJ4bmLnqsCNJW8yENjV6ysqSxeHQMF6quez65vd3H8Cjs3jZLWK DJk/sJmM/L92M6zwMe/xe6eO7EJKflbiLJAdcGqn6swdrh82ADfPmFLaStv95byn+w0h cCaQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769900260; x=1770505060; h=cc:to:subject:message-id:date:from:reply-to:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=1Hnmin9pUD8ONl+qzrSisLfk86BFdwtV90scBQahWR0=; b=YhhmbLC1qvkGLn66hGv0qD2H1r42Mz2R+BEF90lTX8Qc4c+GyeMWhmfvTEu66Yh+vj KiNjUol2zHITL0FDkwV7Cl4fvpFdYlYKyBcr2jLM4lhejXza6xtyj83MLukuUTy1Zf4f uqq1eG6tndxODy8jKWeWLIko8cwAuhxoFkmkkXIdVNCfu+Eh2rT0hBrwHmuF19uoTpsz JEbrlEDpML8/lcA2ZTvrvcNBN7jVJAoS81RNynwFGgkGP/+e73Cf30XcyWDXNdAMLOmu jO1yIMhGf019A23G4TQqmLoXMWOHI0OAWj7SZ6g/BC2CIQ1f9cGZHu0qYqhL6Q1TYZb0 JqXw== X-Forwarded-Encrypted: i=1; AJvYcCVkuSNbbW9mUSabSDU/jP1MKbgUhZTVFwmDft9KcKRPjbyUeYCsx1aTT0Q5ooagzzt7NV8ca7voIWxeg03O@postgresql.org X-Gm-Message-State: AOJu0Yz4mqbAtOKqMQhcH5C/vrf53KCmU6SoiFnxExaX2nocerxGd1vy X00z+/ANt2aXn6CKltSGBZ42zCnMsa1MFnM4QPETZjVPSaN0qfQCAtNsT2BjdfUGGOiAK8duZk3 uLTAZ/ONNtS7U0o6NO0F1ZNI5NsZNaag= X-Gm-Gg: AZuq6aKvQVpKCL7TH1FCyYRrsQ1Y9EI1k++6uXT7a6/FP38uqrIY/GXz75MJa9VHu0q 7C7OwnbYmBx07Z/RgHSl7kR64Qx3vB8AoTwmUyOy/1D01+T1FxuwDzqYJMeo+1vgfVDPVfzUZZj a3YbeczDRzlq1tBuatIAKh7Xzp3zskF9MF4S2rOrDiKNjdzOnYLBhBB4dfizzlwZOhumwtBizRg v8gOe8oUdyDJ3P9cHeJn6b1EqZPhZeFFg7GPqTCJVa+jm/nR/4JhT6bZ09uqxMFSnH+dKp6zdhU sr909Q== X-Received: by 2002:a17:90b:268b:b0:34a:8e4b:5b52 with SMTP id 98e67ed59e1d1-3543b2e003fmr6321925a91.8.1769900259873; Sat, 31 Jan 2026 14:57:39 -0800 (PST) MIME-Version: 1.0 References: <34604.1758921116@sss.pgh.pa.us> In-Reply-To: Reply-To: maciek@sakrejda.org From: Maciek Sakrejda Date: Sat, 31 Jan 2026 14:55:52 -0800 X-Gm-Features: AZwV_Qj8UX38blzEBjeH4PQ-JAyFsCAQrLTcvgwrmrKimjeHcC2DcPQF2ZVe2-k Message-ID: Subject: Re: V18 change on EXPLAIN ANALYZE To: Maciek Sakrejda Cc: Ilia Evdokimov , maciek@sakrejda.org, Tom Lane , Robert Haas , Marcos Pegoraro , pgsql-hackers Content-Type: multipart/mixed; boundary="000000000000475f470649b7046c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000475f470649b7046c Content-Type: text/plain; charset="UTF-8" I lost track of this, sorry. Here is an updated patch responding to review feedback. --000000000000475f470649b7046c 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_ml2wulhn0 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 --000000000000475f470649b7046c--