MIME-Version: 1.0
References: <CANNMO++9W_UA8PB9AkDRF3JBv4K7K1FnisrXTjicL+WZhwUJzw@mail.gmail.com>
 <CA+TgmoZF7PbO7DB_VMQS4664EgOdObhFtAoLUb83bp3i-623UQ@mail.gmail.com>
 <CANNMO++d9CKuJEzSnRWFCHcmKr2DGASTtEMZ9bpEYHSa4QFQvA@mail.gmail.com>
 <3076356.1730831425@sss.pgh.pa.us> <CANNMO++W7MM8T0KyXN3ZheXXt-uLVM3aEtZd+WNfZ=obxffUiA@mail.gmail.com>
 <CAKFQuwbLq3GWoJw-zNa43pkcfg5gh4gGQKMptQtp4qX_nQL9AQ@mail.gmail.com>
 <CAApHDvrYwEt=ueMTn39okNihZffhKgqvxedLqDJu=hmSsZ=g9Q@mail.gmail.com>
 <CAFwT4nC5255GkSt1WEfTHi6cwUuY4fjUmH15nD91c1JvNoOxNA@mail.gmail.com>
 <CAECtzeUKbyZNuFRu4DTr_3p44egDXGbPpGonixqJninWXyBvnQ@mail.gmail.com>
 <CA+TgmobY4N3QYWTW4bj9K=gG3Q4rTAsZLvi_=ODZYRBpk=ZVNA@mail.gmail.com>
 <CAECtzeVvrjxXmE3TB9zz3MD_RwiE=MCg2Xjx0HXoSn4e-VRSOg@mail.gmail.com>
 <CAECtzeWpusNrZADkQ01ZZL_fFtOWtwtnw_uixqy9hgK0qUCScQ@mail.gmail.com>
 <CA+TgmoZO2HtDGHf7K4rmNdfUGuS=ngsPgwrH=JdyF6Okcnzfkw@mail.gmail.com>
 <CAECtzeW=yo4H-G8rBheWwiET-e+PaBpOHHaL9Yu0JpYTd557_Q@mail.gmail.com>
 <CAKAnmmLOkvJ85MGyouFBr2tS+0TSZ87=t=8iaZKU25WG98nZaw@mail.gmail.com>
 <CAECtzeUwpK5gNWQqoK4ZjwXANtdE2fWirJyaBDqkytPzfWZqzg@mail.gmail.com>
 <CAKAnmm+QQP-dTkjsDVbEcphrdXqCTq-ALTCMUwPaYWZmqUp=NQ@mail.gmail.com>
 <CAECtzeVkkmvmHWVOTzwpX_GX+k4h7EWAyfERqes9C0z4pzMN2A@mail.gmail.com>
 <CAApHDvpj0Cj6Z8VnDN5htzF24b4_hKL+1_n=HOehLHkBK_E_TQ@mail.gmail.com>
 <CAECtzeUWiA+FNq0qGp94Ez4UAwbEZyB7avTqKDs6wkPhU56mpw@mail.gmail.com>
 <CAApHDvqjmr=CZ2M57eErxn2Ubcb0d2EmppZhTj8k==Ud_eRfoQ@mail.gmail.com>
 <CAApHDvqLdzgz77JsE-yTki3w9UiKQ-uTMLRctazcu+99-ips3g@mail.gmail.com> <CACJufxGF6fg4+YH8sRTf0d7E-84ZCPy2rUivS=yAWAKYyJ9+mg@mail.gmail.com>
In-Reply-To: <CACJufxGF6fg4+YH8sRTf0d7E-84ZCPy2rUivS=yAWAKYyJ9+mg@mail.gmail.com>
From: Guillaume Lelarge <guillaume@lelarge.info>
Date: Wed, 11 Dec 2024 21:29:36 +0100
Message-ID: <CAECtzeXsJbONQDGu1dC9f_RO2WLFK2ZwPNrFKTvYMbWE+w-oAQ@mail.gmail.com>
Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
To: jian he <jian.universality@gmail.com>
Cc: David Rowley <dgrowleyml@gmail.com>, Greg Sabino Mullane <htamfids@gmail.com>, 
	Robert Haas <robertmhaas@gmail.com>, Michael Christofides <michael@pgmustard.com>, 
	"David G. Johnston" <david.g.johnston@gmail.com>, Nikolay Samokhvalov <samokhvalov@gmail.com>, 
	Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Content-Type: multipart/mixed; boundary="0000000000007be92d06290475df"
Archived-At: <https://www.postgresql.org/message-id/CAECtzeXsJbONQDGu1dC9f_RO2WLFK2ZwPNrFKTvYMbWE%2Bw-oAQ%40mail.gmail.com>
Precedence: bulk

--0000000000007be92d06290475df
Content-Type: multipart/alternative; boundary="0000000000007be92c06290475dd"

--0000000000007be92c06290475dd
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Le mer. 11 d=C3=A9c. 2024 =C3=A0 15:00, jian he <jian.universality@gmail.co=
m> a
=C3=A9crit :

> do we also need to update doc/src/sgml/rules.sgml?
>
> https://www.postgresql.org/docs/current/rules-materializedviews.html
>

Yes, you're right. Here is a fix. (Not a patch with a commit message as I
don't know if David will want to commit everything (the CI issue, this, and
probably more) in one patch.)


--=20
Guillaume.

--0000000000007be92c06290475dd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_quote gmail_quote_container"><div dir=
=3D"ltr" class=3D"gmail_attr">Le=C2=A0mer. 11 d=C3=A9c. 2024 =C3=A0=C2=A015=
:00, jian he &lt;<a href=3D"mailto:jian.universality@gmail.com">jian.univer=
sality@gmail.com</a>&gt; a =C3=A9crit=C2=A0:<br></div><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">do we also need to update doc/src/sgml/rules.s=
gml?<br>
<br>
<a href=3D"https://www.postgresql.org/docs/current/rules-materializedviews.=
html" rel=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/=
current/rules-materializedviews.html</a><br>
</blockquote></div><div><br clear=3D"all"></div><div>Yes, you&#39;re right.=
 Here is a fix. (Not a patch with a commit message as I don&#39;t know if D=
avid will want to commit everything (the CI issue, this, and probably more)=
 in one patch.)<br></div><div><br></div><div><br></div><div><span class=3D"=
gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signa=
ture"><div dir=3D"ltr"><div><div dir=3D"ltr"><div>Guillaume.<br></div></div=
></div></div></div></div></div>

--0000000000007be92c06290475dd--
--0000000000007be92d06290475df
Content-Type: text/x-patch; charset="US-ASCII"; name="rules.patch"
Content-Disposition: attachment; filename="rules.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_m4kcflua0>
X-Attachment-Id: f_m4kcflua0

ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9ydWxlcy5zZ21sIGIvZG9jL3NyYy9zZ21sL3J1bGVz
LnNnbWwKaW5kZXggN2E5MjhiZDdiOS4uNmNlYmVkNWMzNyAxMDA2NDQKLS0tIGEvZG9jL3NyYy9z
Z21sL3J1bGVzLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3J1bGVzLnNnbWwKQEAgLTEwNDIsMTIg
KzEwNDIsMTYgQEAgU0VMRUNUIGNvdW50KCopIEZST00gd29yZHMgV0hFUkUgd29yZCA9ICdjYXRl
cnBpbGVyJzsKICAgICBJZiB0aGUgbWF0ZXJpYWxpemVkIHZpZXcgaXMgdXNlZCBpbnN0ZWFkLCB0
aGUgcXVlcnkgaXMgbXVjaCBmYXN0ZXI6CiAKIDxwcm9ncmFtbGlzdGluZz4KLSBBZ2dyZWdhdGUg
IChjb3N0PTQuNDQuLjQuNDUgcm93cz0xIHdpZHRoPTApIChhY3R1YWwgdGltZT0wLjA0Mi4uMC4w
NDIgcm93cz0xIGxvb3BzPTEpCi0gICAtJmd0OyAgSW5kZXggT25seSBTY2FuIHVzaW5nIHdyZF93
b3JkIG9uIHdyZCAgKGNvc3Q9MC40Mi4uNC40NCByb3dzPTEgd2lkdGg9MCkgKGFjdHVhbCB0aW1l
PTAuMDM5Li4wLjAzOSByb3dzPTAgbG9vcHM9MSkKKyBBZ2dyZWdhdGUgIChjb3N0PTQuNDQuLjQu
NDUgcm93cz0xIHdpZHRoPTgpIChhY3R1YWwgdGltZT0wLjEzOC4uMC4xMzkgcm93cz0xIGxvb3Bz
PTEpCisgICBCdWZmZXJzOiBzaGFyZWQgcmVhZD0zCisgICAtJmd0OyAgSW5kZXggT25seSBTY2Fu
IHVzaW5nIHdyZF93b3JkIG9uIHdyZCAgKGNvc3Q9MC40Mi4uNC40NCByb3dzPTEgd2lkdGg9MCkg
KGFjdHVhbCB0aW1lPTAuMTMyLi4wLjEzMyByb3dzPTAgbG9vcHM9MSkKICAgICAgICAgIEluZGV4
IENvbmQ6ICh3b3JkID0gJ2NhdGVycGlsZXInOjp0ZXh0KQogICAgICAgICAgSGVhcCBGZXRjaGVz
OiAwCi0gUGxhbm5pbmcgdGltZTogMC4xNjQgbXMKLSBFeGVjdXRpb24gdGltZTogMC4xMTcgbXMK
KyAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCByZWFkPTMKKyBQbGFubmluZzoKKyAgIEJ1ZmZlcnM6
IHNoYXJlZCBoaXQ9NQorIFBsYW5uaW5nIFRpbWU6IDAuMTQzIG1zCisgRXhlY3V0aW9uIFRpbWU6
IDAuMjAwIG1zCiA8L3Byb2dyYW1saXN0aW5nPgogCiAgICAgRWl0aGVyIHdheSwgdGhlIHdvcmQg
aXMgc3BlbGxlZCB3cm9uZywgc28gbGV0J3MgbG9vayBmb3Igd2hhdCB3ZSBtaWdodApAQCAtMTA4
NywxMSArMTA5MSwxNSBAQCBTRUxFQ1Qgd29yZCBGUk9NIHdvcmRzIE9SREVSIEJZIHdvcmQgJmx0
Oy0mZ3Q7ICdjYXRlcnBpbGVyJyBMSU1JVCAxMDsKICAgICBVc2luZyB0aGUgbWF0ZXJpYWxpemVk
IHZpZXc6CiAKIDxwcm9ncmFtbGlzdGluZz4KLSBMaW1pdCAgKGNvc3Q9MC4yOS4uMS4wNiByb3dz
PTEwIHdpZHRoPTEwKSAoYWN0dWFsIHRpbWU9MTg3LjIyMi4uMTg4LjI1NyByb3dzPTEwIGxvb3Bz
PTEpCi0gICAtJmd0OyAgSW5kZXggU2NhbiB1c2luZyB3cmRfdHJnbSBvbiB3cmQgIChjb3N0PTAu
MjkuLjM3MDIwLjg3IHJvd3M9NDc5ODI5IHdpZHRoPTEwKSAoYWN0dWFsIHRpbWU9MTg3LjIxOS4u
MTg4LjI1MiByb3dzPTEwIGxvb3BzPTEpCisgTGltaXQgIChjb3N0PTAuMjkuLjEuMDYgcm93cz0x
MCB3aWR0aD0xNCkgKGFjdHVhbCB0aW1lPTEzNS4wMjcuLjEzNS40NzUgcm93cz0xMCBsb29wcz0x
KQorICAgQnVmZmVyczogc2hhcmVkIGhpdD00NDY1CisgICAtJmd0OyAgSW5kZXggU2NhbiB1c2lu
ZyB3cmRfdHJnbSBvbiB3cmQgIChjb3N0PTAuMjkuLjM3MjI0LjgxIHJvd3M9NDc5ODI2IHdpZHRo
PTE0KSAoYWN0dWFsIHRpbWU9MTM1LjAyMy4uMTM1LjQ3MCByb3dzPTEwIGxvb3BzPTEpCiAgICAg
ICAgICBPcmRlciBCeTogKHdvcmQgJmx0Oy0mZ3Q7ICdjYXRlcnBpbGVyJzo6dGV4dCkKLSBQbGFu
bmluZyB0aW1lOiAwLjE5NiBtcwotIEV4ZWN1dGlvbiB0aW1lOiAxOTguNjQwIG1zCisgICAgICAg
ICBCdWZmZXJzOiBzaGFyZWQgaGl0PTQ0NjUKKyBQbGFubmluZzoKKyAgIEJ1ZmZlcnM6IHNoYXJl
ZCBoaXQ9ODAKKyBQbGFubmluZyBUaW1lOiAwLjc2NyBtcworIEV4ZWN1dGlvbiBUaW1lOiAxNDAu
ODM2IG1zCiA8L3Byb2dyYW1saXN0aW5nPgogCiAgICAgSWYgeW91IGNhbiB0b2xlcmF0ZSBwZXJp
b2RpYyB1cGRhdGUgb2YgdGhlIHJlbW90ZSBkYXRhIHRvIHRoZSBsb2NhbAo=
--0000000000007be92d06290475df--