Report index vacuum progress.
authorMasahiko Sawada <msawada@postgresql.org>
Tue, 11 Jul 2023 03:34:01 +0000 (12:34 +0900)
committerMasahiko Sawada <msawada@postgresql.org>
Tue, 11 Jul 2023 03:34:01 +0000 (12:34 +0900)
commit46ebdfe164c61fbac961d1eb7f40e9a684289ae6
treeef873f39395f97a9eaf2d3c02e9fb28bf564b501
parentf1889729dd3ab0352dc0ccc2ffcc1b1901f8e39f
Report index vacuum progress.

This commit adds two columns: indexes_total and indexes_processed, to
pg_stat_progress_vacuum system view to show the index vacuum
progress. These numbers are reported in the "vacuuming indexes" and
"cleaning up indexes" phases.

This uses the new parallel message type for progress reporting added
by be06506e7.

Bump catversion because this changes the definition of
pg_stat_progress_vacuum.

Author: Sami Imseih
Reviewed by: Masahiko Sawada, Michael Paquier, Nathan Bossart, Andres Freund
Discussion: https://www.postgresql.org/message-id/flat/5478DFCD-2333-401A-B2F0-0D186AB09228@amazon.com
doc/src/sgml/monitoring.sgml
src/backend/access/heap/vacuumlazy.c
src/backend/catalog/system_views.sql
src/backend/commands/vacuumparallel.c
src/include/catalog/catversion.h
src/include/commands/progress.h
src/test/regress/expected/rules.out