Home Explore Blog CI



postgresql

8th chunk of `doc/src/sgml/release-18.sgml`
5cfbe47ee4617aa2cb770659c51e8fa242fb9eea0204b8ea0000000100000fa6
 maintenance_io_concurrency's default values to 16 (Melanie Plageman)
<ulink url="&commit_baseurl;ff79b5b2a">&sect;</ulink>
<ulink url="&commit_baseurl;cc6be07eb">&sect;</ulink>
</para>

<para>
This more accurately reflects modern hardware.
</para>
</listitem>

     </itemizedlist>

    </sect4>

    <sect4 id="release-18-monitoring">
     <title>Monitoring</title>

     <itemizedlist>

<!--
Author: Melanie Plageman <melanieplageman@gmail.com>
2025-03-12 [9219093ca] Modularize log_connections output
-->

<listitem>
<para>
Increase the logging granularity of server variable log_connections (Melanie Plageman)
<ulink url="&commit_baseurl;9219093ca">&sect;</ulink>
</para>

<para>
This server variable was previously only boolean;  these options are still supported.
</para>
</listitem>

<!--
Author: Melanie Plageman <melanieplageman@gmail.com>
2025-03-12 [18cd15e70] Add connection establishment duration logging
-->

<listitem>
<para>
Add log_connections option to report the duration of connection stages (Melanie Plageman)
<ulink url="&commit_baseurl;18cd15e70">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-04-07 [3516ea768] Add local-address escape "%L" to log_line_prefix.
-->

<listitem>
<para>
Add log_line_prefix escape "%L" to output the client IP address (Greg Sabino Mullane)
<ulink url="&commit_baseurl;3516ea768">&sect;</ulink>
</para>
</listitem>

<!--
Author: Fujii Masao <fujii@postgresql.org>
2025-03-14 [6d376c3b0] Add GUC option to log lock acquisition failures.
-->

<listitem>
<para>
Add server variable log_lock_failures to log lock acquisition failures (Yuki Seino)
<ulink url="&commit_baseurl;6d376c3b0">&sect;</ulink>
</para>

<para>
Specifically it reports SELECT ... NOWAIT lock failures.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2025-01-28 [30a6ed0ce] Track per-relation cumulative time spent in [auto]vacuum
-->

<listitem>
<para>
Modify pg_stat_all_tables and its variants to report the time spent in vacuum, analyze, and their automatic variants (Sami Imseih)
<ulink url="&commit_baseurl;30a6ed0ce">&sect;</ulink>
</para>

<para>
The new columns are total_vacuum_time, total_autovacuum_time, total_analyze_time, and total_autoanalyze_time.
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2025-02-11 [bb8dff999] Add cost-based vacuum delay time to progress views.
Author: Nathan Bossart <nathan@postgresql.org>
2025-02-14 [7720082ae] Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuu
-->

<listitem>
<para>
Add delay time reporting to VACUUM and ANALYZE (Bertrand Drouvot, Nathan Bossart)
<ulink url="&commit_baseurl;bb8dff999">&sect;</ulink>
<ulink url="&commit_baseurl;7720082ae">&sect;</ulink>
</para>

<para>
This information appears in the autovacuum logs, the system views pg_stat_progress_vacuum and pg_stat_progress_analyze, and the output of VACUUM and ANALYZE when in VERBOSE
mode; tracking must be enabled with the server variable track_cost_delay_timing.
</para>
</listitem>

<!--
Author: Masahiko Sawada <msawada@postgresql.org>
2024-08-13 [4c1b4cdb8] Add resource statistics reporting to ANALYZE VERBOSE.
Author: Masahiko Sawada <msawada@postgresql.org>
2024-09-09 [bb7775234] Add WAL usage reporting to ANALYZE VERBOSE output.
-->

<listitem>
<para>
Add WAL, CPU, and average read statistics output to ANALYZE VERBOSE (Anthonin Bonnefoy)
<ulink url="&commit_baseurl;4c1b4cdb8">&sect;</ulink>
<ulink url="&commit_baseurl;bb7775234">&sect;</ulink>
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2025-02-17 [6a8a7ce47] Add information about WAL buffers full to VACUUM/ANALYZE
-->

<listitem>
<para>
Add full WAL buffer count to VACUUM/ANALYZE (VERBOSE) and autovacuum log output (Bertrand Drouvot)
<ulink url="&commit_baseurl;6a8a7ce47">&sect;</ulink>
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-12-19 [9aea73fc6] Add backend-level statistics to pgstats
Author: Michael Paquier <michael@paquier.xyz>

Title: PostgreSQL 18: Enhanced Monitoring Capabilities - Logging, Statistics, and Performance Analysis
Summary
PostgreSQL 18 introduces several improvements to monitoring capabilities. These include increased logging granularity for connection events, a new option to report connection stage durations, and the ability to log client IP addresses. It also introduces logging of lock acquisition failures and enhanced statistics tracking for vacuum and analyze operations. New columns are added to pg_stat_all_tables and its variants to report time spent in vacuum, analyze and their automatic variants. Delay time reporting is added to VACUUM and ANALYZE commands. Finally, improvements include outputting WAL, CPU, and read statistics to ANALYZE VERBOSE, and including WAL buffer count in vacuum/analyze logs.