MIME-Version: 1.0
From: Nikolay Samokhvalov <samokhvalov@gmail.com>
Date: Tue, 5 Nov 2024 10:02:33 -0800
Message-ID: <CANNMO++9W_UA8PB9AkDRF3JBv4K7K1FnisrXTjicL+WZhwUJzw@mail.gmail.com>
Subject: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
To: pgsql-hackers@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000004b1d3106262e352a"
Archived-At: <https://www.postgresql.org/message-id/CANNMO%2B%2B9W_UA8PB9AkDRF3JBv4K7K1FnisrXTjicL%2BWZhwUJzw%40mail.gmail.com>
Precedence: bulk

--0000000000004b1d3106262e352a
Content-Type: text/plain; charset="UTF-8"

hi, I have a proposal, resulted from numerous communications with various
folks, both very experienced and new Postgres users:

1) EXPLAIN ANALYZE Is sometimes very confusing (because there is ANALYZE).
Let's rename it to EXPLAIN EXECUTE?

2) VERBOSE doesn't include BUFFERS, and doesn't include SETTINGS; it might
be also confusing sometimes. Let's include them so VERBOSE would be really
verbose?

3) small thing about grammar: allow omitting parentheses, so EXPLAIN
EXECUTE VERBOSE would work.

if both changes are done, we could use EXPLAIN (EXECUTE, VERBOSE) to be
able to collect data in a great way for analysis.

have a really nice week,
Nik

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

<div dir=3D"ltr">hi, I have a proposal, resulted from numerous=C2=A0communi=
cations with various folks, both very experienced and new Postgres users:<d=
iv><br></div><div>1) EXPLAIN ANALYZE Is sometimes very confusing (because t=
here is ANALYZE). Let&#39;s rename it to EXPLAIN EXECUTE?</div><div><br></d=
iv><div>2) VERBOSE doesn&#39;t include BUFFERS, and doesn&#39;t include SET=
TINGS; it might be also confusing sometimes. Let&#39;s include them so VERB=
OSE would be really verbose?</div><div><br></div><div>3) small thing about =
grammar: allow omitting parentheses, so EXPLAIN EXECUTE VERBOSE would work.=
</div><div><br></div><div>if both changes are done, we could use EXPLAIN (E=
XECUTE, VERBOSE) to be able to collect data in a great way for analysis.</d=
iv><div><br></div><div>have a really=C2=A0nice week,</div><div>Nik</div></d=
iv>

--0000000000004b1d3106262e352a--