diff options
| author | Masahiko Sawada <msawada@postgresql.org> | 2024-06-14 10:08:15 +0900 |
|---|---|---|
| committer | Masahiko Sawada <msawada@postgresql.org> | 2024-06-14 10:08:15 +0900 |
| commit | f1affb67055c9b3f31a7ee7eb521a9ba64fff488 (patch) | |
| tree | e2a52561fee7700bf89cc5ad6f0372d1a3d52556 /src/include/commands/progress.h | |
| parent | 56a8296212b68267dc2bddeb1fb40a893b1aadb3 (diff) | |
| download | postgresql-f1affb67055c9b3f31a7ee7eb521a9ba64fff488.tar.gz postgresql-f1affb67055c9b3f31a7ee7eb521a9ba64fff488.zip | |
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
Diffstat (limited to 'src/include/commands/progress.h')
| -rw-r--r-- | src/include/commands/progress.h | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/include/commands/progress.h b/src/include/commands/progress.h index 82a8fe6bd14..5616d645230 100644 --- a/src/include/commands/progress.h +++ b/src/include/commands/progress.h @@ -25,8 +25,9 @@ #define PROGRESS_VACUUM_NUM_INDEX_VACUUMS 4 #define PROGRESS_VACUUM_MAX_DEAD_TUPLE_BYTES 5 #define PROGRESS_VACUUM_DEAD_TUPLE_BYTES 6 -#define PROGRESS_VACUUM_INDEXES_TOTAL 7 -#define PROGRESS_VACUUM_INDEXES_PROCESSED 8 +#define PROGRESS_VACUUM_NUM_DEAD_ITEM_IDS 7 +#define PROGRESS_VACUUM_INDEXES_TOTAL 8 +#define PROGRESS_VACUUM_INDEXES_PROCESSED 9 /* Phases of vacuum (as advertised via PROGRESS_VACUUM_PHASE) */ #define PROGRESS_VACUUM_PHASE_SCAN_HEAP 1 |