Horton

Add stats_reset column to pg_stat_database_conflicts.

Fujii Masao <fujii@postgresql.org>

View on postgr.es
Commit: 723619eaa3a85f32ce8c2d32c063da26f89ca8d2
Author: Fujii Masao <fujii@postgresql.org>
Date: 2026-03-13T13:17:14Z
Releases: 19 (unreleased) 
Add stats_reset column to pg_stat_database_conflicts.

This commit adds a stats_reset column to pg_stat_database_conflicts,
allowing users to see when the statistics in this view were last reset.
This makes the view consistent with pg_stat_database and other statistics
views.

Catalog version bumped.

Author: Shihao Zhong <zhong950419@gmail.com>
Reviewed-by: Sami Imseih <samimseih@gmail.com>
Reviewed-by: Kirill Reshke <reshkekirill@gmail.com>
Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
Discussion: https://postgr.es/m/CAGRkXqS98OebEWjax99_LVAECsxCB8i=BfsdAL34i-5QHfwyOQ@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/monitoring.sgml modified +9 −0
src/backend/catalog/system_views.sql modified +2 −1
src/include/catalog/catversion.h modified +1 −1
src/test/regress/expected/rules.out modified +2 −1
src/test/regress/expected/stats.out modified +17 −2
src/test/regress/sql/stats.sql modified +7 −2

Discussion