Add index scan progress to pg_stat_progress_vacuum

Edit
ID 3617
Title Add index scan progress to pg_stat_progress_vacuum
Topic Monitoring & Control
Created 2022-04-12 13:38:38
Last modified 2023-07-11 05:54:21 (1 year, 2 months ago)
Latest email 2023-07-11 05:54:26 (1 year, 2 months ago)
Status
2023-07: Committed
2023-03: Moved to next CF
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-07: Moved to next CF
Target version
Authors Sami Imseih (simseih)
Reviewers Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn)Become reviewer
Committer Masahiko Sawada (masahikosawada)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3617
git checkout commitfest/cf/3617
Emails
Add index scan progress to pg_stat_progress_vacuum
First at 2021-12-01 19:32:01 by "Imseih (AWS), Sami" <simseih at amazon.com>
Latest at 2023-07-11 05:54:26 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest attachment (v31-0002-Report-index-vacuum-progress.patch) at 2023-07-06 05:28:57 from Masahiko Sawada <sawada.mshk at gmail.com>
    Attachment (v31-0002-Report-index-vacuum-progress.patch) at 2023-07-06 05:28:57 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v30-0001-Report-index-vacuum-progress.patch) at 2023-07-06 02:07:14 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Report-index-vacuum-progress.patch) at 2023-04-12 04:46:41 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v28-0001-Report-index-vacuum-progress.patch) at 2023-04-10 19:20:42 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v27-0001-Report-index-vacuum-progress.patch) at 2023-04-07 19:27:17 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v26-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2023-04-05 14:31:54 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v25-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2023-02-20 16:47:58 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v24-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2023-02-18 02:46:27 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (fix_v23_masahiko.patch) at 2023-02-16 08:27:43 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2023-02-08 02:03:11 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v22-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2023-01-12 14:02:33 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v21-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2023-01-07 01:59:40 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v20-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2023-01-04 19:24:26 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v19-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2023-01-03 16:46:15 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v18-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2023-01-02 04:34:26 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v17-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2022-12-14 05:09:46 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v16-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2022-11-28 23:57:14 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v15-0001-Add-2-new-columns-to-pg_stat_progress_vacuum.-Th.patch) at 2022-11-11 19:10:16 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v14-0002-Function-to-return-currently-vacuumed-or-cleaned.patch) at 2022-11-04 13:27:34 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v13-0001--Show-progress-for-index-vacuums.patch) at 2022-11-02 16:52:19 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v12-0001--Show-progress-for-index-vacuums.patch) at 2022-10-11 13:50:51 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v11-0001-Add-progress-reporting-callback-to-ParallelConte.patch) at 2022-05-26 13:41:09 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v10-0001-Add-progress-reporting-callback-to-ParallelConte.patch) at 2022-04-14 01:32:54 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v9-0001-Add-infrastructure-for-parallel-progress-reporting.patch) at 2022-03-16 21:47:49 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v8-0001-Add-infrastructure-for-parallel-progress-reportin.patch) at 2022-03-14 22:21:50 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v7-0001-Add-infrastructure-for-parallel-progress-reportin.patch) at 2022-03-14 16:20:51 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v5-0001-Show-progress-for-index-vacuums.patch) at 2022-03-12 07:00:06 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v4-0001-Show-progress-for-index-vacuums.patch) at 2022-03-10 21:30:57 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v3-0001-Show-progress-for-index-vacuums.patch) at 2022-03-09 02:57:02 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (v2-0009-Expose-progress-for-the-vacuuming-indexes-and-cleani.patch) at 2022-03-03 05:08:43 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (0011-Rename-index_vacuum_count-to-index_vacuum_cycle_coun.patch) at 2022-02-21 19:03:39 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (0007-Expose-progress-for-the-vacuuming-indexes-and-cleani.patch) at 2022-02-17 13:52:23 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (0006-Expose-progress-for-the-vacuuming-indexes-and-cleani.patch) at 2022-02-10 19:39:56 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (0005-Expose-progress-for-the-vacuuming-indexes-and-cleani.patch) at 2022-02-01 20:33:16 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (0004-Expose-progress-for-the-vacuuming-indexes-cleanup-ph.patch) at 2022-01-27 21:09:05 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (progress-reporting.html) at 2022-01-27 02:15:16 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: No)
    Attachment (monitoring.html) at 2022-01-27 02:07:51 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: No)
    Attachment (progress-reporting.html) at 2022-01-11 01:01:20 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: No)
    Attachment (0001-Add-index-scan-progress-to-pg_stat_progress_vacuum.patch) at 2021-12-31 05:59:15 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (0001-Add-index-scan-progress-to-pg_stat_progress_vacuum.patch) at 2021-12-29 16:44:31 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (0001-Add-index-scan-progress-to-pg_stat_progress_vacuum.patch) at 2021-12-27 17:59:25 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (patch.v2.txt) at 2021-12-20 17:55:03 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (patch.txt) at 2021-12-01 19:32:01 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
History
When Who What
2023-07-11 05:54:21 Masahiko Sawada (masahikosawada) Closed in commitfest 2023-07 with status: Committed
2023-07-11 05:54:21 Masahiko Sawada (masahikosawada) Changed committer to masahikosawada
2023-04-12 04:47:24 Michael Paquier (michael-kun) Added michael-kun as committer
2023-04-12 04:47:21 Michael Paquier (michael-kun) New status: Ready for Committer
2023-04-09 22:32:48 Michael Paquier (michael-kun) New status: Waiting on Author
2023-04-09 03:21:10 Greg Stark (stark) Changed targetversion to None
2023-04-09 02:55:00 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-02-24 06:16:15 Masahiko Sawada (masahikosawada) New status: Ready for Committer
2023-02-21 12:49:12 Sami Imseih (simseih) New status: Needs review
2023-02-20 08:31:18 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2023-02-20 06:30:51 Masahiko Sawada (masahikosawada) Added masahikosawada as reviewer
2023-01-31 16:14:11 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-02 13:20:41 Sami Imseih (simseih) New status: Needs review
2022-12-30 20:02:55 Nathan Bossart (bossartn) New status: Waiting on Author
2022-12-28 13:05:13 Sami Imseih (simseih) New status: Needs review
2022-12-08 14:21:36 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-12-06 18:28:07 Andres Freund (andresfreund) New status: Waiting on Author
2022-11-03 11:57:20 Sami Imseih (simseih) New status: Needs review
2022-11-03 08:15:27 Ian Barwick (barwick) New status: Waiting on Author
2022-10-10 18:12:32 Sami Imseih (simseih) Detached mail thread 4CD97E17-B9E4-421E-9A53-4317C90EFF35@amazon.com
2022-10-10 18:12:01 Sami Imseih (simseih) Attached mail thread 4CD97E17-B9E4-421E-9A53-4317C90EFF35@amazon.com
2022-10-10 17:58:01 Sami Imseih (simseih) Closed in commitfest 2022-07 with status: Moved to next CF
2022-10-10 17:57:55 Sami Imseih (simseih) New status: Needs review
2022-08-02 18:06:44 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Returned with feedback
2022-07-18 20:12:10 Nathan Bossart (bossartn) New status: Waiting on Author
2022-04-14 01:41:49 Sami Imseih (simseih) New status: Needs review
2022-04-12 16:13:30 Sami Imseih (simseih) Changed name to Add index scan progress to pg_stat_progress_vacuum
2022-04-12 16:09:25 Sami Imseih (simseih) Changed name to New progress view called pg_stat_progress_vacuum_index to expose index being vacuumed
2022-04-12 16:07:42 Sami Imseih (simseih) Changed targetversion to 16
2022-04-12 13:45:05 Sami Imseih (simseih) New status: Waiting on Author
2022-04-12 13:44:56 Sami Imseih (simseih) Changed reviewers to Nathan Bossart (bossartn)
2022-04-12 13:39:36 Sami Imseih (simseih) Changed reviewers to Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn)
2022-04-12 13:39:36 Sami Imseih (simseih) Changed authors to Sami Imseih (simseih)
2022-04-12 13:39:36 Sami Imseih (simseih) Changed targetversion to 15
2022-04-12 13:38:38 Sami Imseih (simseih) Attached mail thread 5478DFCD-2333-401A-B2F0-0D186AB09228@amazon.com
2022-04-12 13:38:38 Sami Imseih (simseih) Created patch record
Edit