add cost delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs

Edit
ID 5572
Title add cost delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Monitoring & Control
Created 2025-02-12 17:13:47
Last modified 2025-02-14 20:56:48 (6 days, 19 hours ago)
Latest email 2025-02-14 20:54:33 (6 days, 19 hours ago)
Status
2025-03: Committed
Target version 18
Authors Bertrand Drouvot (bertranddrouvot.pg)
Reviewers Nathan Bossart (bossartn)Become reviewer
Committer Nathan Bossart (bossartn)
Links
Emails
Track the amount of time waiting due to cost_delay
First at 2024-06-10 06:05:13 by Bertrand Drouvot <bertranddrouvot.pg at gmail.com>
Latest at 2025-02-14 20:54:33 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (v18-0001-Add-delay-time-to-VACUUM-ANALYZE-VERBOSE-and-aut.patch) at 2025-02-12 17:13:13 from Nathan Bossart <nathandbossart at gmail.com>
    Attachment (v18-0001-Add-delay-time-to-VACUUM-ANALYZE-VERBOSE-and-aut.patch) at 2025-02-12 17:13:13 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Add-is_analyze-parameter-to-vacuum_delay_point.patch) at 2025-02-11 08:51:15 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Add-is_analyze-parameter-to-vacuum_delay_point.patch) at 2025-02-10 20:52:46 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Introduce-analyze_delay_point.patch) at 2025-02-04 10:14:48 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Add-cost-based-delay-time-to-progress-views.patch) at 2024-12-17 05:15:06 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Add-cost-based-delay-time-to-progress-views.patch) at 2024-12-16 10:11:23 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Add-cost-based-delay-time-to-progress-views.patch) at 2024-12-14 04:06:08 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Report-the-total-amount-of-time-that-vacuum-has-.patch) at 2024-12-13 05:04:13 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Report-the-total-amount-of-time-that-vacuum-has-.patch) at 2024-12-12 04:36:21 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Report-the-total-amount-of-time-that-vacuum-has-.patch) at 2024-12-09 16:41:03 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Report-the-total-amount-of-time-that-vacuum-has-b.patch) at 2024-12-06 09:31:11 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Report-the-total-amount-of-time-that-vacuum-has-b.patch) at 2024-12-05 10:43:51 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Report-the-total-amount-of-time-that-vacuum-has-b.patch) at 2024-10-11 17:12:34 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Report-the-total-amount-of-time-that-vacuum-has-b.patch) at 2024-09-05 04:59:54 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Report-the-total-amount-of-time-that-vacuum-has-b.patch) at 2024-09-02 05:11:36 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Report-the-total-amount-of-time-that-vacuum-has-b.patch) at 2024-08-20 12:48:29 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Report-the-total-amount-of-time-that-vacuum-has-b.patch) at 2024-06-24 10:50:13 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Report-the-total-amount-of-time-that-vacuum-has-b.patch) at 2024-06-13 11:56:26 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (record_actual_time.txt) at 2024-06-11 09:49:11 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Report-the-total-amount-of-time-that-vacuum-has-b.patch) at 2024-06-10 06:05:13 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
History
When Who What
2025-02-14 20:56:48 Nathan Bossart (bossartn) Closed in commitfest 2025-03 with status: Committed
2025-02-12 17:14:09 Nathan Bossart (bossartn) New status: Ready for Committer
2025-02-12 17:14:05 Nathan Bossart (bossartn) Changed reviewers to Nathan Bossart (bossartn)
2025-02-12 17:14:05 Nathan Bossart (bossartn) Changed authors to Bertrand Drouvot (bertranddrouvot.pg)
2025-02-12 17:14:05 Nathan Bossart (bossartn) Changed committer to bossartn
2025-02-12 17:14:04 Nathan Bossart (bossartn) Changed targetversion to 18
2025-02-12 17:13:47 Nathan Bossart (bossartn) Attached mail thread ZmaXmWDL829fzAVX@ip-10-97-1-34.eu-west-3.compute.internal
2025-02-12 17:13:47 Nathan Bossart (bossartn) Created patch record
Edit