Skip to content

Commit 984702d

Browse files
bmomjianbmomjian
committed
doc PG 17 relnotes: move EXPLAIN items to their own section
Reported-by: Álvaro Herrera Discussion: https://postgr.es/m/202409111750.xtcbl7ppdoyn@alvherre.pgsql Backpatch-through: 17 only
1 parent 648397b commit 984702d

File tree

1 file changed

+80
-71
lines changed

1 file changed

+80
-71
lines changed

‎doc/src/sgml/release-17.sgml

Lines changed: 80 additions & 71 deletions
Original file line numberDiff line numberDiff line change
@@ -1557,77 +1557,6 @@ Author: Andrew Dunstan <andrew@dunslane.net>
15571557
</para>
15581558
</listitem>
15591559

1560-
<!--
1561-
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
1562-
2024-01-29 [5de890e36] Add EXPLAIN (MEMORY) to report planner memory consumptio
1563-
-->
1564-
1565-
<listitem>
1566-
<para>
1567-
Allow <link linkend="sql-explain"><command>EXPLAIN</command></link>
1568-
to report optimizer memory usage (Ashutosh Bapat)
1569-
<ulink url="&commit_baseurl;5de890e36">&sect;</ulink>
1570-
</para>
1571-
1572-
<para>
1573-
The option is called <literal>MEMORY</literal>.
1574-
</para>
1575-
</listitem>
1576-
1577-
<!--
1578-
Author: Tom Lane <tgl@sss.pgh.pa.us>
1579-
2024-04-03 [06286709e] Invent SERIALIZE option for EXPLAIN.
1580-
-->
1581-
1582-
<listitem>
1583-
<para>
1584-
Add <command>EXPLAIN</command> option <literal>SERIALIZE</literal>
1585-
to report the cost of converting data for network transmission
1586-
(Stepan Rutz, Matthias van de Meent)
1587-
<ulink url="&commit_baseurl;06286709e">&sect;</ulink>
1588-
</para>
1589-
</listitem>
1590-
1591-
<!--
1592-
Author: Michael Paquier <michael@paquier.xyz>
1593-
2023-10-19 [295c36c0c] Add local_blk_{read|write}_time I/O timing statistics fo
1594-
-->
1595-
1596-
<listitem>
1597-
<para>
1598-
Add local I/O block read/write timing statistics to
1599-
<command>EXPLAIN</command>'s <literal>BUFFERS</literal> output
1600-
(Nazir Bilal Yavuz)
1601-
<ulink url="&commit_baseurl;295c36c0c">&sect;</ulink>
1602-
</para>
1603-
</listitem>
1604-
1605-
<!--
1606-
Author: Tom Lane <tgl@sss.pgh.pa.us>
1607-
2024-03-19 [fd0398fcb] Improve EXPLAIN's display of SubPlan nodes and output pa
1608-
-->
1609-
1610-
<listitem>
1611-
<para>
1612-
Improve <command>EXPLAIN</command>'s display of SubPlan nodes and
1613-
output parameters (Tom Lane, Dean Rasheed)
1614-
<ulink url="&commit_baseurl;fd0398fcb">&sect;</ulink>
1615-
</para>
1616-
</listitem>
1617-
1618-
<!--
1619-
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
1620-
2023-09-08 [5a3423ad8] Add JIT deform_counter
1621-
-->
1622-
1623-
<listitem>
1624-
<para>
1625-
Add <acronym>JIT</acronym> <literal>deform_counter</literal>
1626-
details to <command>EXPLAIN</command> (Dmitry Dolgov)
1627-
<ulink url="&commit_baseurl;5a3423ad8">&sect;</ulink>
1628-
</para>
1629-
</listitem>
1630-
16311560
<!--
16321561
Author: Peter Eisentraut <peter@eisentraut.org>
16331562
2024-01-16 [699586315] Support identity columns in partitioned tables
@@ -1771,6 +1700,86 @@ Author: Nathan Bossart <nathan@postgresql.org>
17711700

17721701
</itemizedlist>
17731702

1703+
<sect4 id="release-17-explain">
1704+
<title><link linkend="sql-explain"><command>EXPLAIN</command></link></title>
1705+
1706+
<itemizedlist>
1707+
1708+
<!--
1709+
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
1710+
2024-01-29 [5de890e36] Add EXPLAIN (MEMORY) to report planner memory consumptio
1711+
-->
1712+
1713+
<listitem>
1714+
<para>
1715+
Allow <command>EXPLAIN</command> to report
1716+
optimizer memory usage (Ashutosh Bapat) <ulink
1717+
url="&commit_baseurl;5de890e36">&sect;</ulink>
1718+
</para>
1719+
1720+
<para>
1721+
The option is called <literal>MEMORY</literal>.
1722+
</para>
1723+
</listitem>
1724+
1725+
<!--
1726+
Author: Tom Lane <tgl@sss.pgh.pa.us>
1727+
2024-04-03 [06286709e] Invent SERIALIZE option for EXPLAIN.
1728+
-->
1729+
1730+
<listitem>
1731+
<para>
1732+
Add <command>EXPLAIN</command> option <literal>SERIALIZE</literal>
1733+
to report the cost of converting data for network transmission
1734+
(Stepan Rutz, Matthias van de Meent)
1735+
<ulink url="&commit_baseurl;06286709e">&sect;</ulink>
1736+
</para>
1737+
</listitem>
1738+
1739+
<!--
1740+
Author: Michael Paquier <michael@paquier.xyz>
1741+
2023-10-19 [295c36c0c] Add local_blk_{read|write}_time I/O timing statistics fo
1742+
-->
1743+
1744+
<listitem>
1745+
<para>
1746+
Add local I/O block read/write timing statistics to
1747+
<command>EXPLAIN</command>'s <literal>BUFFERS</literal> output
1748+
(Nazir Bilal Yavuz)
1749+
<ulink url="&commit_baseurl;295c36c0c">&sect;</ulink>
1750+
</para>
1751+
</listitem>
1752+
1753+
<!--
1754+
Author: Tom Lane <tgl@sss.pgh.pa.us>
1755+
2024-03-19 [fd0398fcb] Improve EXPLAIN's display of SubPlan nodes and output pa
1756+
-->
1757+
1758+
<listitem>
1759+
<para>
1760+
Improve <command>EXPLAIN</command>'s display of SubPlan nodes and
1761+
output parameters (Tom Lane, Dean Rasheed)
1762+
<ulink url="&commit_baseurl;fd0398fcb">&sect;</ulink>
1763+
</para>
1764+
</listitem>
1765+
1766+
<!--
1767+
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
1768+
2023-09-08 [5a3423ad8] Add JIT deform_counter
1769+
-->
1770+
1771+
<listitem>
1772+
<para>
1773+
Add <acronym>JIT</acronym> <literal>deform_counter</literal>
1774+
details to <command>EXPLAIN</command> (Dmitry Dolgov)
1775+
<ulink url="&commit_baseurl;5a3423ad8">&sect;</ulink>
1776+
</para>
1777+
</listitem>
1778+
1779+
</itemizedlist>
1780+
1781+
</sect4>
1782+
17741783
</sect3>
17751784

17761785
<sect3 id="release-17-datatypes">

0 commit comments

Comments
 (0)