]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Add pg_stat_autovacuum_scores system view.
authorNathan Bossart <nathan@postgresql.org>
Mon, 6 Apr 2026 21:56:33 +0000 (16:56 -0500)
committerNathan Bossart <nathan@postgresql.org>
Mon, 6 Apr 2026 21:56:33 +0000 (16:56 -0500)
commit87f61f0c82806b7e4201f15bd77920e9e7108b11
tree75f5d7b986e4de1aa015b749724adde7d396fa77
parentb3a37ffbc5b94c0214f1f3f1953e800654a1962f
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
doc/src/sgml/maintenance.sgml
doc/src/sgml/monitoring.sgml
src/backend/catalog/system_views.sql
src/backend/postmaster/autovacuum.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/test/regress/expected/rules.out