Reintroduce dead tuple counter in pg_stat_progress_vacuum.
Masahiko Sawada <msawada@postgresql.org>
Reintroduce dead tuple counter in pg_stat_progress_vacuum. Commit 667e65aac3 changed both num_dead_tuples and max_dead_tuples columns to dead_tuple_bytes and max_dead_tuple_bytes columns, respectively. But as per discussion, the number of dead tuples collected still provides meaningful insights for users. This commit reintroduces the column for the count of dead tuples, renamed as num_dead_item_ids. It avoids confusion with the number of dead tuples removed by VACUUM, which includes dead heap-only tuples but excludes any pre-existing LP_DEAD items left behind by opportunistic pruning. Bump catalog version. Reviewed-by: Peter Geoghegan, Álvaro Herrera, Andrey Borodin Discussion: https://postgr.es/m/CAD21AoBL5sJE9TRWPyv%2Bw7k5Ee5QAJqDJEDJBUdAaCzGWAdvZw%40mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/monitoring.sgml | modified | +9 −0 |
| src/backend/access/heap/vacuumlazy.c | modified | +9 −3 |
| src/backend/catalog/system_views.sql | modified | +2 −1 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/commands/progress.h | modified | +3 −2 |
| src/test/regress/expected/rules.out | modified | +3 −2 |
Documentation touched
Discussion
- Revive num_dead_tuples column of pg_stat_progress_vacuum 15 messages · 2024-06-03 → 2024-06-19