Content-Type: multipart/mixed; boundary="------------Y0voC1SE57HOFTHi2q0FPLnb"
Message-ID: <821872a3-6f3e-4efc-afe8-540b83be40ff@tantorlabs.com>
Date: Mon, 24 Feb 2025 14:03:13 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: explain analyze rows=%.0f
To: Robert Haas <robertmhaas@gmail.com>
Cc: Andrei Lepikhov <lepihov@gmail.com>, pgsql-hackers@lists.postgresql.org,
 Tom Lane <tgl@sss.pgh.pa.us>, Matheus Alcantara <matheusssilv97@gmail.com>,
 Guillaume Lelarge <guillaume@lelarge.info>,
 Daniel Gustafsson <daniel@yesql.se>, Ibrar Ahmed <ibrar.ahmad@gmail.com>,
 "Gregory Stark (as CFM)" <stark.cfm@gmail.com>,
 Amit Kapila <amit.kapila16@gmail.com>, Justin Pryzby <pryzby@telsasoft.com>,
 Peter Geoghegan <pg@bowt.ie>, vignesh C <vignesh21@gmail.com>,
 "David G. Johnston" <david.g.johnston@gmail.com>,
 Alena Rybakina <a.rybakina@postgrespro.ru>
References: <CA+TgmoZv8DvmeQHQAX+rkn68id2N+DoUhFZB36d-_w1tyAeqeA@mail.gmail.com>
 <fc28108a-8e7e-4f7d-b8f4-0bcc1581650d@tantorlabs.com>
 <CA+Tgmobgkh5CW=4Xpejw9nR6Onv8SZh0nnr+=HmNAFyyHZb0eg@mail.gmail.com>
 <3212947.1739306803@sss.pgh.pa.us>
 <eb73d4e1-4235-41b5-90a8-b0196550f62b@gmail.com>
 <CA+TgmobT9gPQLtw143oGnKVNtaOrTDOy+ZbLfe18MVZ9POjaWg@mail.gmail.com>
 <3365160.1739385615@sss.pgh.pa.us>
 <0e4c813a-18eb-41e2-8edb-89b78d43c82d@gmail.com>
 <CA+TgmoYzawdq40C5cN==LRPBvQChZ7t5XxH6wv+zMxnyM7LjBQ@mail.gmail.com>
 <e434311c-0f84-4c2b-a10d-ecb67f1ec19d@tantorlabs.com>
 <CA+TgmobfeePej0uNfbLy0v6jUrB3D9m1Kh+QQ40_-A9KQjkqUw@mail.gmail.com>
 <f428e80d-8607-4a9d-950c-be9600f24904@gmail.com>
 <01ec86c1-e04b-4cbe-b641-22cae8b87604@tantorlabs.com>
 <CA+TgmobVWYnYDj1HZ--iqeKx+n7zTgtYCar+YfZ0V6wiX-t0Mg@mail.gmail.com>
 <73e2440e-7d8b-4860-974d-931a93326d95@gmail.com>
 <7ab512ac-eed1-4fc8-9c5f-b42c0b0d313e@tantorlabs.com>
 <CA+TgmoYp1KvG=7L7SjiRjJrXT8kEfH10kSGp54FQd03v19OwvA@mail.gmail.com>
Content-Language: en-US
From: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
In-Reply-To: <CA+TgmoYp1KvG=7L7SjiRjJrXT8kEfH10kSGp54FQd03v19OwvA@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/821872a3-6f3e-4efc-afe8-540b83be40ff%40tantorlabs.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------Y0voC1SE57HOFTHi2q0FPLnb
Content-Type: multipart/alternative;
 boundary="------------ApwHQq71qePU3nTpmq0gwZJ6"

--------------ApwHQq71qePU3nTpmq0gwZJ6
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit


On 22.02.2025 00:20, Robert Haas wrote:
> So, I've committed v11-0001. I'm not altogether convinced that
> v11-0002 is necessary -- no portion of the documentation that it
> modifies is falsified by the committed patch. Maybe we can just call
> this one done for now and move on?


Not quite. If no one objects to leaving the documentation as it is, 
there is one nuance that needs to be fixed—in example [0], there is a 
node with loops=10, so it should be updated to reflect the current 
state. I've attached a patch for that.

--------------ApwHQq71qePU3nTpmq0gwZJ6
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 22.02.2025 00:20, Robert Haas wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CA+TgmoYp1KvG=7L7SjiRjJrXT8kEfH10kSGp54FQd03v19OwvA@mail.gmail.com"><span
      style="white-space: pre-wrap">
</span>
      <pre class="moz-quote-pre" wrap="">So, I've committed v11-0001. I'm not altogether convinced that
v11-0002 is necessary -- no portion of the documentation that it
modifies is falsified by the committed patch. Maybe we can just call
this one done for now and move on?
</pre>
    </blockquote>
    <p><br>
    </p>
    <p>Not quite. If no one objects to leaving the documentation as it
      is, there is one nuance that needs to be fixed—in example [0],
      there is a node with loops=10, so it should be updated to reflect
      the current state. I've attached a patch for that.</p>
  </body>
</html>

--------------ApwHQq71qePU3nTpmq0gwZJ6--
--------------Y0voC1SE57HOFTHi2q0FPLnb
Content-Type: text/x-patch; charset=UTF-8;
 name="v12-0001-Update-documentation-after-changing-the-rows-format.patch"
Content-Disposition: attachment;
 filename*0="v12-0001-Update-documentation-after-changing-the-rows-format";
 filename*1=".patch"
Content-Transfer-Encoding: base64

RnJvbSBjMTdjMTkyNjU5OGZiYjM1YTgyOWE5OGVhMzVkYjNjNDFmMWM3Y2NjIE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBJbGlhIEV2ZG9raW1vdiA8aWx5YS5ldmRva2ltb3ZA
dGFudG9ybGFicy5jb20+CkRhdGU6IE1vbiwgMjQgRmViIDIwMjUgMTM6NTU6MTUgKzAzMDAK
U3ViamVjdDogW1BBVENIIHYxMl0gVXBkYXRlIGRvY3VtZW50YXRpb24gYWZ0ZXIgY2hhbmdp
bmcgdGhlIHJvd3MgZm9ybWF0IGluCiBFWFBMQUlOIEFOQUxZWkUKCkZvbGxvd2luZyBjb21t
aXQgZGRiMTdlMywgdGhlIGZvcm1hdCBvZiB0aGUgYXZlcmFnZSByb3dzIiBmaWVsZAppbiBF
WFBMQUlOIEFOQUxZWkUgd2FzIG1vZGlmaWVkIHRvIGFsd2F5cyBkaXNwbGF5IGZyYWN0aW9u
YWwgdmFsdWVzCndoZW4gbG9vcHMgPiAxLiBUaGlzIGNvbW1pdCB1cGRhdGVzIHRoZSBleGFt
cGxlIGluIHRoZSBkb2N1bWVudGF0aW9uCnRvIHJlZmxlY3QgdGhlIG5ldyBvdXRwdXQgZm9y
bWF0LCBlbnN1cmluZyBjb25zaXN0ZW5jeSB3aXRoIHRoZSBsYXRlc3QgYmVoYXZpb3IuCi0t
LQogZG9jL3NyYy9zZ21sL3BlcmZvcm0uc2dtbCB8IDIgKy0KIDEgZmlsZSBjaGFuZ2VkLCAx
IGluc2VydGlvbigrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dt
bC9wZXJmb3JtLnNnbWwgYi9kb2Mvc3JjL3NnbWwvcGVyZm9ybS5zZ21sCmluZGV4IGE1MDJh
MmFhYmEuLjZhM2RjYzBiZmMgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9wZXJmb3JtLnNn
bWwKKysrIGIvZG9jL3NyYy9zZ21sL3BlcmZvcm0uc2dtbApAQCAtNzMwLDcgKzczMCw3IEBA
IFdIRVJFIHQxLnVuaXF1ZTEgJmx0OyAxMCBBTkQgdDEudW5pcXVlMiA9IHQyLnVuaXF1ZTI7
CiAgICAgICAgICAtJmd0OyAgQml0bWFwIEluZGV4IFNjYW4gb24gdGVuazFfdW5pcXVlMSAg
KGNvc3Q9MC4wMC4uNC4zNiByb3dzPTEwIHdpZHRoPTApIChhY3R1YWwgdGltZT0wLjAwNC4u
MC4wMDQgcm93cz0xMCBsb29wcz0xKQogICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHVu
aXF1ZTEgJmx0OyAxMCkKICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9Mgot
ICAgLSZndDsgIEluZGV4IFNjYW4gdXNpbmcgdGVuazJfdW5pcXVlMiBvbiB0ZW5rMiB0MiAg
KGNvc3Q9MC4yOS4uNy45MCByb3dzPTEgd2lkdGg9MjQ0KSAoYWN0dWFsIHRpbWU9MC4wMDMu
LjAuMDAzIHJvd3M9MSBsb29wcz0xMCkKKyAgIC0mZ3Q7ICBJbmRleCBTY2FuIHVzaW5nIHRl
bmsyX3VuaXF1ZTIgb24gdGVuazIgdDIgIChjb3N0PTAuMjkuLjcuOTAgcm93cz0xIHdpZHRo
PTI0NCkgKGFjdHVhbCB0aW1lPTAuMDAzLi4wLjAwMyByb3dzPTEuMDAgbG9vcHM9MTApCiAg
ICAgICAgICBJbmRleCBDb25kOiAodW5pcXVlMiA9IHQxLnVuaXF1ZTIpCiAgICAgICAgICBC
dWZmZXJzOiBzaGFyZWQgaGl0PTI0IHJlYWQ9NgogIFBsYW5uaW5nOgotLSAKMi4zNC4xCgo=


--------------Y0voC1SE57HOFTHi2q0FPLnb--