Add dead items memory usage to VACUUM (VERBOSE) and autovacuum logs.
Masahiko Sawada <msawada@postgresql.org>
Author:
Masahiko Sawada <msawada@postgresql.org>
Date: 2025-12-30T21:12:10Z
Releases:
19 (unreleased)
Add dead items memory usage to VACUUM (VERBOSE) and autovacuum logs. This commit adds the total memory allocated during vacuum, the number of times the dead items storage was reset, and the configured memory limit. This helps users understand how much memory VACUUM required, and such information can be used to avoid multiple index scans. Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Discussion: https://www.postgresql.org/message-id/flat/CAHza6qcPitBCkyiKJosDTt3bmxMvzZOTONoebwCkBZrr3rk65Q%40mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/access/heap/vacuumlazy.c | modified | +33 −0 |
Discussion
- [PATCH] Add memory usage reporting to VACUUM VERBOSE 27 messages · 2025-11-16 → 2025-12-31