maintenance_io_concurrency's default values to 16 (Melanie Plageman)
<ulink url="&commit_baseurl;ff79b5b2a">§</ulink>
<ulink url="&commit_baseurl;cc6be07eb">§</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">§</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">§</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">§</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">§</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">§</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">§</ulink>
<ulink url="&commit_baseurl;7720082ae">§</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">§</ulink>
<ulink url="&commit_baseurl;bb7775234">§</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">§</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>