From: Bertrand Drouvot Date: Tue, 11 Feb 2025 09:00:00 +0000 Subject: [PATCH v3 4/4] Add wal_buffers_full to VACUUM/ANALYZE (VERBOSE) Now that wal_buffers_full is part of the WalUsage struct, let's report it in VACUUM/ANALYZE (VERBOSE) and autovacuum logs. --- src/backend/access/heap/vacuumlazy.c | 5 +++-- src/backend/commands/analyze.c | 5 +++-- 2 files changed, 6 insertions(+), 4 deletions(-) 50.0% src/backend/access/heap/ 50.0% src/backend/commands/ diff --git a/src/backend/access/heap/vacuumlazy.c b/src/backend/access/heap/vacuumlazy.c index 3df5b92afb8..64517ea5a3a 100644 --- a/src/backend/access/heap/vacuumlazy.c +++ b/src/backend/access/heap/vacuumlazy.c @@ -1106,10 +1106,11 @@ heap_vacuum_rel(Relation rel, VacuumParams *params, (long long) total_blks_read, (long long) total_blks_dirtied); appendStringInfo(&buf, - _("WAL usage: %lld records, %lld full page images, %llu bytes\n"), + _("WAL usage: %lld records, %lld full page images, %llu bytes, %lld buffers full\n"), (long long) walusage.wal_records, (long long) walusage.wal_fpi, - (unsigned long long) walusage.wal_bytes); + (unsigned long long) walusage.wal_bytes, + (long long) walusage.wal_buffers_full); appendStringInfo(&buf, _("system usage: %s"), pg_rusage_show(&ru0)); ereport(verbose ? INFO : LOG, diff --git a/src/backend/commands/analyze.c b/src/backend/commands/analyze.c index e4302f4cdb2..24d4ddc7c5d 100644 --- a/src/backend/commands/analyze.c +++ b/src/backend/commands/analyze.c @@ -823,10 +823,11 @@ do_analyze_rel(Relation onerel, VacuumParams *params, (long long) total_blks_read, (long long) total_blks_dirtied); appendStringInfo(&buf, - _("WAL usage: %lld records, %lld full page images, %llu bytes\n"), + _("WAL usage: %lld records, %lld full page images, %llu bytes, %lld buffers full\n"), (long long) walusage.wal_records, (long long) walusage.wal_fpi, - (unsigned long long) walusage.wal_bytes); + (unsigned long long) walusage.wal_bytes, + (long long) walusage.wal_buffers_full); appendStringInfo(&buf, _("system usage: %s"), pg_rusage_show(&ru0)); ereport(verbose ? INFO : LOG, -- 2.34.1 --H1RdLOdSxV0+9Lqb--