Add index scan progress to pg_stat_progress_vacuum

Edit

Title

Topic

Monitoring & Control

Created

2022-04-12 13:38:38

Last modified

2023-01-31 16:14:11 (6 days, 19 hours ago)

Latest email

2023-02-02 06:33:04 (5 days, 4 hours ago)

Status

2023-03: Needs review

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

Nathan Bossart (bossartn)Become reviewer

Committer

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-02-02 06:33:04 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest 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>
    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-01-31 16:14:11	vignesh 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