pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Add information about WAL buffers being full to EXPLAIN (WAL) 2+ messages / 1 participants [nested] [flat]
* pgsql: Add information about WAL buffers being full to EXPLAIN (WAL) @ 2025-02-17 05:56 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 2+ messages in thread From: Michael Paquier @ 2025-02-17 05:56 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Add information about WAL buffers being full to EXPLAIN (WAL) This is similar to ce5bcc4a9f26, relying on the addition of wal_buffers_full to WalUsage. This time, the information is added to the output generated by EXPLAIN (WAL). Author: Bertrand Drouvot Reviewed-by: Ilia Evdokimov Discussion: https://postgr.es/m/Z6SOha5YFFgvpwQY@ip-10-97-1-34.eu-west-3.compute.internal Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/320545bfcfee9c6826d9ae96a880ec82fc03d860 Modified Files -------------- doc/src/sgml/ref/explain.sgml | 5 +++-- src/backend/commands/explain.c | 7 ++++++- 2 files changed, 9 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Add information about WAL buffers full to VACUUM/ANALYZE (VERBOS @ 2025-02-17 06:15 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 2+ messages in thread From: Michael Paquier @ 2025-02-17 06:15 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Add information about WAL buffers full to VACUUM/ANALYZE (VERBOSE) This commit adds the information about the number of times WAL buffers have been full to the logs generated by VACUUM/ANALYZE (VERBOSE) and in the logs generated by autovacuum, complementing the existing information stored by WalUsage. This is the last part of the backend code where the value of wal_buffers_full can be reported, similarly to all the other fields of WalUsage. 320545bfcfee and ce5bcc4a9f26 have done the same for EXPLAIN and pgss. Author: Bertrand Drouvot Reviewed-by: Ilia Evdokimov Discussion: https://postgr.es/m/Z6SOha5YFFgvpwQY@ip-10-97-1-34.eu-west-3.compute.internal Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/6a8a7ce476bd5f042999a04a0d767b38ea6faec0 Modified Files -------------- src/backend/access/heap/vacuumlazy.c | 5 +++-- src/backend/commands/analyze.c | 5 +++-- 2 files changed, 6 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-02-17 06:15 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-02-17 05:56 pgsql: Add information about WAL buffers being full to EXPLAIN (WAL) Michael Paquier <michael@paquier.xyz> 2025-02-17 06:15 pgsql: Add information about WAL buffers full to VACUUM/ANALYZE (VERBOS Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox