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 <[email protected]> Reviewed-by: Satyanarayana Narlapuram <[email protected]> Reviewed-by: Bharath Rupireddy <[email protected]> Reviewed-by: Robert Treat <[email protected]> Discussion: https://postgr.es/m/CAA5RZ0s4xjMrB-VAnLccC7kY8d0-4806-Lsac-czJsdA1LXtAw%40mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/87f61f0c82806b7e4201f15bd77920e9e7108b11 Modified Files -------------- doc/src/sgml/maintenance.sgml | 6 ++ doc/src/sgml/monitoring.sgml | 179 +++++++++++++++++++++++++++++++++++ src/backend/catalog/system_views.sql | 18 ++++ src/backend/postmaster/autovacuum.c | 73 ++++++++++++++ src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_proc.dat | 7 ++ src/test/regress/expected/rules.out | 15 +++ 7 files changed, 299 insertions(+), 1 deletion(-)
