Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs.
Nathan Bossart <nathan@postgresql.org>
Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs. Commit bb8dff9995 added this information to the pg_stat_progress_vacuum and pg_stat_progress_analyze system views. This commit adds the same information to the output of VACUUM and ANALYZE with the VERBOSE option and to the autovacuum logs. Suggested-by: Masahiro Ikeda <ikedamsh@oss.nttdata.com> Author: Bertrand Drouvot <bertranddrouvot.pg@gmail.com> Discussion: https://postgr.es/m/ZmaXmWDL829fzAVX%40ip-10-97-1-34.eu-west-3.compute.internal
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +6 −3 |
| src/backend/access/heap/vacuumlazy.c | modified | +11 −0 |
| src/backend/commands/analyze.c | modified | +9 −0 |
Documentation touched
Discussion
- Track the amount of time waiting due to cost_delay 67 messages · 2024-06-10 → 2025-02-14