Home • Explore • Blog • CI
☰



postgresql
34th chunk of `doc/src/sgml/release-18.sgml`
eef24f8ca4e5baf73be579402882e04ae9060e8ad795fb73000000010000084c
 [50ba65e73] Add an additional hook for EXPLAIN option validation.
-->

<listitem>
<para>
Allow extensions to install custom EXPLAIN options (Robert Haas, Sami Imseih)
<ulink url="&commit_baseurl;c65bc2e1d">&sect;</ulink>
<ulink url="&commit_baseurl;4fd02bf7c">&sect;</ulink>
<ulink url="&commit_baseurl;50ba65e73">&sect;</ulink>
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-08-04 [7949d9594] Introduce pluggable APIs for Cumulative Statistics
Author: Michael Paquier <michael@paquier.xyz>
2024-08-05 [2eff9e678] Add helper routines to retrieve data for custom fixed-nu
-->

<listitem>
<para>
Allow extensions to use the server's cumulative statistics API (Michael Paquier)
<ulink url="&commit_baseurl;7949d9594">&sect;</ulink>
<ulink url="&commit_baseurl;2eff9e678">&sect;</ulink>
</para>
</listitem>

    </itemizedlist>

    <sect4 id="release-18-pgstatstatements">
     <title><link linkend="pgstatstatements"><application>pg_stat_statements</application></link></title>

     <itemizedlist>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-10-28 [6b652e6ce] Set query ID for inner queries of CREATE TABLE AS and DE
-->

<listitem>
<para>
Allow the queries of CREATE TABLE AS and DECLARE to be tracked by pg_stat_statements (Anthonin Bonnefoy)
<ulink url="&commit_baseurl;6b652e6ce">&sect;</ulink>
</para>

<para>
They are also now assigned query ids.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-09-30 [dc6851596] Show values of SET statements as constants in pg_stat_st
-->

<listitem>
<para>
Allow the parameterization of SET values in pg_stat_statements (Greg Sabino Mullane, Michael Paquier)
<ulink url="&commit_baseurl;dc6851596">&sect;</ulink>
</para>

<para>
This reduces the bloat caused by SET statements with differing constants.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-10-09 [cf54a2c00] pg_stat_statements: Add columns to track parallel worker
-->

<listitem>
<para>
Add pg_stat_statements columns to report parallel activity (Guillaume Lelarge)
<ulink url="&commit_baseurl;cf54a2c00">&sect;</ulink>
Title: PostgreSQL 18: Enhancements to Extensions and pg_stat_statements
Summary
This section highlights improvements related to extensions, allowing them to install custom EXPLAIN options and use the server's cumulative statistics API. It also details enhancements to pg_stat_statements, including tracking queries in CREATE TABLE AS and DECLARE statements, parameterizing SET values to reduce bloat, and adding columns to report parallel activity.