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, 4 months ago)

Latest email 2023-07-11 05:54:26 (1 year, 4 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