Home • Explore • Blog • CI
☰



postgresql
19th chunk of `doc/src/sgml/release-18.sgml`
0db8546829b7842073167390413833388d62afaaf661a5cd0000000100000fcb
 <drowley@postgresql.org>
2024-07-05 [53abb1e0e] Fix newly introduced issue in EXPLAIN for Materialize no
Author: Tatsuo Ishii <ishii@postgresql.org>
2024-09-17 [95d6e9af0] Add memory/disk usage for Window aggregate nodes in EXPL
Author: Tatsuo Ishii <ishii@postgresql.org>
2024-09-23 [40708acd6] Add memory/disk usage for more executor nodes.
-->

<listitem>
<para>
Add memory and disk usage details to Material, Window Aggregate, and common table expression nodes in EXPLAIN (David Rowley, Tatsuo Ishii)
<ulink url="&commit_baseurl;1eff8279d">&sect;</ulink>
<ulink url="&commit_baseurl;53abb1e0e">&sect;</ulink>
<ulink url="&commit_baseurl;95d6e9af0">&sect;</ulink>
<ulink url="&commit_baseurl;40708acd6">&sect;</ulink>
</para>
</listitem>


<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-03-11 [8b1b34254] Improve EXPLAIN's display of window functions.
-->

<listitem>
<para>
Add details about window function arguments to EXPLAIN output (Tom Lane)
<ulink url="&commit_baseurl;8b1b34254">&sect;</ulink>
</para>
</listitem>

<!--
Author: David Rowley <drowley@postgresql.org>
2024-07-09 [5a1e6df3b] Show Parallel Bitmap Heap Scan worker stats in EXPLAIN A
-->

<listitem>
<para>
Add "Parallel Bitmap Heap Scan" worker cache statistics to EXPLAIN ANALYZE (David Geier, Heikki Linnakangas, Donghang Lin, Alena Rybakina, David Rowley)
<ulink url="&commit_baseurl;5a1e6df3b">&sect;</ulink>
</para>
</listitem>

<!--
Author: Robert Haas <rhaas@postgresql.org>
2024-08-21 [c01743aa4] Show number of disabled nodes in EXPLAIN ANALYZE output.
Author: David Rowley <drowley@postgresql.org>
2024-10-11 [161320b4b] Adjust EXPLAIN's output for disabled nodes
Author: David Rowley <drowley@postgresql.org>
2024-10-29 [84b8fccbe] Doc: add detail about EXPLAIN's "Disabled" property
-->

<listitem>
<para>
Indicate disabled nodes in EXPLAIN ANALYZE output (Robert Haas, David Rowley, Laurenz Albe)
<ulink url="&commit_baseurl;c01743aa4">&sect;</ulink>
<ulink url="&commit_baseurl;161320b4b">&sect;</ulink>
<ulink url="&commit_baseurl;84b8fccbe">&sect;</ulink>
</para>
</listitem>

     </itemizedlist>

    </sect4>

   </sect3>

   <sect3 id="release-18-datatypes">
    <title>Data Types</title>

    <itemizedlist>

<!--
Author: Jeff Davis <jdavis@postgresql.org>
2025-01-23 [4e7f62bc3] Add support for Unicode case folding.
Author: Jeff Davis <jdavis@postgresql.org>
2025-01-17 [286a365b9] Support Unicode full case mapping and conversion.
-->

<listitem>
<para>
Improve Unicode full case mapping and conversion (Jeff Davis)
<ulink url="&commit_baseurl;4e7f62bc3">&sect;</ulink>
<ulink url="&commit_baseurl;286a365b9">&sect;</ulink>
</para>

<para>
This adds the ability to do conditional and title case mapping, and case map single characters to multiple characters.
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-01-24 [a5579a90a] Make jsonb casts to scalar types translate JSON null to
-->

<listitem>
<para>
Allow jsonb "null" values to be cast to scalar types as NULL (Tom Lane)
<ulink url="&commit_baseurl;a5579a90a">&sect;</ulink>
</para>

<para>
Previously such casts generated an error.
</para>
</listitem>

<!--
Author: Andrew Dunstan <andrew@dunslane.net>
2025-03-05 [4603903d2] Allow json{b}_strip_nulls to remove null array elements
-->

<listitem>
<para>
Add optional parameter to json{b}_strip_nulls to allow removal of null array elements (Florents Tselai)
<ulink url="&commit_baseurl;4603903d2">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-04-01 [6c12ae09f] Introduce a SQL-callable function array_sort(anyarray).
-->

<listitem>
<para>
Add function array_sort() which sorts an array's first dimension (Junwang Zhao, Jian He)
<ulink url="&commit_baseurl;6c12ae09f">&sect;</ulink>
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-11-01 [49d6c7d8d] Add SQL function array_reverse()
-->

<listitem>
<para>
Add function array_reverse() which reverses an array's first dimension (Aleksander Alekseev)
<ulink url="&commit_baseurl;49d6c7d8d">&sect;</ulink>
Title: PostgreSQL 18: EXPLAIN Enhancements and Data Type Updates
Summary
This section covers further enhancements to EXPLAIN, including adding details about window function arguments, "Parallel Bitmap Heap Scan" worker cache statistics, and indicating disabled nodes in the output. It also details data type updates such as improving Unicode full case mapping and conversion, allowing jsonb "null" values to be cast to scalar types as NULL, adding an optional parameter to json{b}_strip_nulls to allow removal of null array elements, and introducing functions array_sort() and array_reverse() to sort and reverse an array's first dimension, respectively.