Add index scan progress to pg_stat_progress_vacuum

Edit

ID 3456

Title Add index scan progress to pg_stat_progress_vacuum

Topic Monitoring & Control

Created 2021-12-15 20:01:29

Last modified 2022-04-07 23:23:58 (2 years, 7 months ago)

Latest email 2023-07-11 05:54:26 (1 year, 4 months ago)

Status

2022-03: Returned with feedback

2022-01: Moved to next CF

Target version 15

Authors Sami Imseih (simseih)

Reviewers Nathan Bossart (bossartn), Justin Pryzby (justinpryzby)Become reviewer

Committer

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/3456
git checkout commitfest/cf/3456

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
2022-04-07 23:23:58	Greg Stark (stark)	Closed in commitfest 2022-03 with status: Returned with feedback
2022-03-03 05:14:42	Sami Imseih (simseih)	New status: Needs review
2022-02-25 21:10:31	Nathan Bossart (bossartn)	New status: Waiting on Author
2022-02-02 16:29:46	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-27 21:11:24	Sami Imseih (simseih)	New status: Needs review
2022-01-27 21:03:55	Sami Imseih (simseih)	New status: Waiting on Author
2022-01-27 21:01:38	Sami Imseih (simseih)	New status: Needs review
2022-01-20 17:27:40	Nathan Bossart (bossartn)	New status: Waiting on Author
2022-01-03 17:09:25	Sami Imseih (simseih)	New status: Needs review
2021-12-29 17:52:06	Justin Pryzby (justinpryzby)	Added justinpryzby as reviewer
2021-12-29 16:35:07	Justin Pryzby (justinpryzby)	New status: Waiting on Author
2021-12-15 22:10:56	Nathan Bossart (bossartn)	Changed authors to Sami Imseih (simseih)
2021-12-15 22:10:56	Nathan Bossart (bossartn)	Changed targetversion to 15
2021-12-15 22:10:35	Nathan Bossart (bossartn)	Added bossartn as reviewer
2021-12-15 20:01:29	Sami Imseih (simseih)	Attached mail thread 5478DFCD-2333-401A-B2F0-0D186AB09228@amazon.com
2021-12-15 20:01:29	Sami Imseih (simseih)	Created patch record

Edit