Add index scan progress to pg_stat_progress_vacuum

Edit

Title

Topic

Monitoring & Control

Created

2022-04-12 13:38:38

Last modified

2023-07-11 05:54:21 (4 months, 4 weeks ago)

Latest email

2023-07-11 05:54:26 (4 months, 4 weeks 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

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