Author: Michael Paquier <michael@paquier.xyz>
2025-02-24 [2421e9a51] Remove read/sync fields from pg_stat_wal and GUC track_w
Author: Michael Paquier <michael@paquier.xyz>
2025-02-26 [6c349d83b] Re-add GUC track_wal_io_timing
-->

<listitem>
<para>
Remove read/sync columns from pg_stat_wal (Bertrand Drouvot)
<ulink url="&commit_baseurl;2421e9a51">&sect;</ulink>
<ulink url="&commit_baseurl;6c349d83b">&sect;</ulink>
</para>

<para>
This removes columns wal_write, wal_sync, wal_write_time, and wal_sync_time.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2025-03-11 [76def4cdd] Add WAL data to backend statistics
-->

<listitem>
<para>
Add function pg_stat_get_backend_wal() to return per-backend WAL statistics (Bertrand Drouvot)
<ulink url="&commit_baseurl;76def4cdd">&sect;</ulink>
</para>

<para>
Per-backend WAL statistics can be cleared via pg_stat_reset_backend_stats().
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2024-10-11 [4e1fad378] Add pg_ls_summariesdir().
-->

<listitem>
<para>
Add function pg_ls_summariesdir() to specifically list the contents of PGDATA/pg_wal/summaries (Yushi Ogiwara)
<ulink url="&commit_baseurl;4e1fad378">&sect;</ulink>
</para>
</listitem>

<!--
Author: Fujii Masao <fujii@postgresql.org>
2024-09-30 [559efce1d] Add num_done counter to the pg_stat_checkpointer view.
-->

<listitem>
<para>
Add column pg_stat_checkpointer.num_done to report the number of completed checkpoints (Anton A. Melnikov)
<ulink url="&commit_baseurl;559efce1d">&sect;</ulink>
</para>

<para>
Columns num_timed and num_requested count both completed and skipped checkpoints.
</para>
</listitem>

<!--
Author: Fujii Masao <fujii@postgresql.org>
2024-10-02 [17cc5f666] Fix inconsistent reporting of checkpointer stats.
-->

<listitem>
<para>
Add column pg_stat_checkpointer.slru_written to report SLRU buffers written (Nitin Jadhav)
<ulink url="&commit_baseurl;17cc5f666">&sect;</ulink>
</para>

<para>
Also, modify the checkpoint server log message to report separate shared buffer and SLRU buffer values.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-11-11 [e7a9496de] Add two attributes to pg_stat_database for parallel work
-->

<listitem>
<para>
Add columns to pg_stat_database to report parallel workers activity (Benoit Lobréau)
<ulink url="&commit_baseurl;e7a9496de">&sect;</ulink>
</para>

<para>
The new columns are parallel_workers_to_launch and parallel_workers_launched.
</para>
</listitem>

<!--
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
2025-03-18 [62d712ecf] Introduce squashing of constant lists in query jumbling
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
2025-03-27 [9fbd53dea] Remove the query_id_squash_values GUC
-->

<listitem>
<para>
Have query jumbling of arrays consider only the first and last array elements (Dmitry Dolgov, Sami Imseih)
<ulink url="&commit_baseurl;62d712ecf">&sect;</ulink>
<ulink url="&commit_baseurl;9fbd53dea">&sect;</ulink>
</para>

<para>
Jumbling is used by pg_stat_statements.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2025-03-26 [787514b30] Use relation name instead of OID in query jumbling for R
-->

<listitem>
<para>
Adjust query jumbling to group together queries using the same relation name (Michael Paquier, Sami Imseih)
<ulink url="&commit_baseurl;787514b30">&sect;</ulink>
</para>

<para>
This is true even if the tables in different schemas have different column names.
</para>
</listitem>

<!--
Author: David Rowley <drowley@postgresql.org>
2024-07-01 [12227a1d5] Add context type field to pg_backend_memory_contexts
-->

<listitem>
<para>
Add column pg_backend_memory_contexts.type to report the type of memory context (David Rowley)
<ulink url="&commit_baseurl;12227a1d5">&sect;</ulink>
</para>
</listitem>

<!--
Author: David Rowley <drowley@postgresql.org>
2024-07-25 [32d3ed816] Add path column to pg_backend_memory_contexts view
-->

<listitem>
<para>
Add column pg_backend_memory_contexts.path