Horton

Add pg_stat_autovacuum_scores system view.

Nathan Bossart <nathan@postgresql.org>

View on postgr.es
Commit: 87f61f0c82806b7e4201f15bd77920e9e7108b11
Author: Nathan Bossart <nathan@postgresql.org>
Date: 2026-04-06T21:56:33Z
Releases: 19 (unreleased) 
Add pg_stat_autovacuum_scores system view.

This view contains one row for each table in the current database,
showing the current autovacuum scores for that specific table.  It
also shows whether autovacuum would vacuum or analyze the table.

Bumps catversion.

Author: Sami Imseih <samimseih@gmail.com>
Reviewed-by: Satyanarayana Narlapuram <satyanarlapuram@gmail.com>
Reviewed-by: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Reviewed-by: Robert Treat <rob@xzilla.net>
Discussion: https://postgr.es/m/CAA5RZ0s4xjMrB-VAnLccC7kY8d0-4806-Lsac-czJsdA1LXtAw%40mail.gmail.com

Files

PathChange+/−
doc/src/sgml/maintenance.sgml modified +6 −0
doc/src/sgml/monitoring.sgml modified +179 −0
src/backend/catalog/system_views.sql modified +18 −0
src/backend/postmaster/autovacuum.c modified +73 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +7 −0
src/test/regress/expected/rules.out modified +15 −0

Discussion