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

Log in to edit
ID 5572
Title add cost delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Tags Monitoring
Created 2025-02-12 17:13:47
Last modified 2025-02-14 20:56:48 (1 year ago)
Latest email 2025-02-14 20:54:33 (1 year ago)
Status
2025-03 (2025-03-01 – 2025-04-08): Committed
Target version 18
Authors Bertrand Drouvot (bertranddrouvot.pg)
Reviewers Nathan Bossart (bossartn) Log in to 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
Log in to edit