From ad25744f436ed7809fc754e1a44630b087812fbc Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Mon, 3 Nov 2025 19:42:03 +0900 Subject: [PATCH] Add wal_fpi_bytes to VACUUM and ANALYZE logs The new wal_fpi_bytes counter calculates the total amount of full page images inserted in WAL records, in bytes. This commit adds this information to VACUUM and ANALYZE logs alongside the existing counters, building upon f9a09aa29520. Author: Shinya Kato Reviewed-by: Michael Paquier Discussion: https://postgr.es/m/aQMMSSlFXy4Evxn3@paquier.xyz --- src/backend/access/heap/vacuumlazy.c | 3 ++- src/backend/commands/analyze.c | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/src/backend/access/heap/vacuumlazy.c b/src/backend/access/heap/vacuumlazy.c index d2b031fdd06..61fe623cc60 100644 --- a/src/backend/access/heap/vacuumlazy.c +++ b/src/backend/access/heap/vacuumlazy.c @@ -1148,10 +1148,11 @@ heap_vacuum_rel(Relation rel, const VacuumParams params, total_blks_read, total_blks_dirtied); appendStringInfo(&buf, - _("WAL usage: %" PRId64 " records, %" PRId64 " full page images, %" PRIu64 " bytes, %" PRId64 " buffers full\n"), + _("WAL usage: %" PRId64 " records, %" PRId64 " full page images, %" PRIu64 " bytes, %" PRIu64 " full page image bytes, %" PRId64 " buffers full\n"), walusage.wal_records, walusage.wal_fpi, walusage.wal_bytes, + walusage.wal_fpi_bytes, walusage.wal_buffers_full); appendStringInfo(&buf, _("system usage: %s"), pg_rusage_show(&ru0)); diff --git a/src/backend/commands/analyze.c b/src/backend/commands/analyze.c index c2e216563c6..25089fae3e0 100644 --- a/src/backend/commands/analyze.c +++ b/src/backend/commands/analyze.c @@ -831,10 +831,11 @@ do_analyze_rel(Relation onerel, const VacuumParams params, total_blks_read, total_blks_dirtied); appendStringInfo(&buf, - _("WAL usage: %" PRId64 " records, %" PRId64 " full page images, %" PRIu64 " bytes, %" PRId64 " buffers full\n"), + _("WAL usage: %" PRId64 " records, %" PRId64 " full page images, %" PRIu64 " bytes, %" PRIu64 " full page image bytes, %" PRId64 " buffers full\n"), walusage.wal_records, walusage.wal_fpi, walusage.wal_bytes, + walusage.wal_fpi_bytes, walusage.wal_buffers_full); appendStringInfo(&buf, _("system usage: %s"), pg_rusage_show(&ru0)); -- 2.47.3