Re: Add index scan progress to pg_stat_progress_vacuum

From:	"Imseih (AWS), Sami" <simseih(at)amazon(dot)com>
To:	Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc:	Peter Geoghegan <pg(at)bowt(dot)ie>, "Bossart, Nathan" <bossartn(at)amazon(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Add index scan progress to pg_stat_progress_vacuum
Date:	2022-03-16 21:47:49
Message-ID:	5E83F41D-8473-414A-B1FB-7E958C9C7C51@amazon.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2021-12-01 19:32:01 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎  2021-12-15 22:09:59 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>   2021-12-16 21:37:11 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>    2021-12-16 22:03:23 from Greg Stark <stark(at)mit(dot)edu>    2021-12-20 17:55:03 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎   2021-12-20 18:37:05 from Peter Geoghegan <pg(at)bowt(dot)ie>    2021-12-23 08:44:37 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>     2021-12-28 00:13:16 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>      2021-12-29 16:44:31 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎       2021-12-29 17:51:21 from Justin Pryzby <pryzby(at)telsasoft(dot)com>        2021-12-31 05:59:15 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎         2022-01-06 20:41:30 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>          2022-01-07 02:14:36 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>           2022-01-10 18:30:09 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>            2022-01-11 01:01:20 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎             2022-01-11 19:01:37 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>              2022-01-11 20:33:16 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>               2022-01-11 22:18:24 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>             2022-01-12 07:44:37 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>              2022-01-12 19:28:23 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>               2022-01-13 03:52:46 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                2022-01-27 02:07:51 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                 2022-01-27 02:15:16 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                 2022-01-27 21:09:05 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                 2022-02-01 20:33:16 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                  2022-02-10 19:39:56 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                   2022-02-17 13:52:23 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                    2022-02-21 19:03:39 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                     2022-02-21 19:09:10 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                      2022-02-23 18:02:08 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                       2022-02-23 18:41:36 from Peter Geoghegan <pg(at)bowt(dot)ie>                        2022-02-25 19:52:53 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                         2022-02-27 17:16:53 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                         2022-03-03 05:08:43 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                          2022-03-08 06:04:22 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                           2022-03-08 15:41:47 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                            2022-03-09 01:53:44 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                             2022-03-09 02:35:31 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                              2022-03-09 02:57:02 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                              2022-03-09 03:15:26 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                               2022-03-09 22:52:26 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                2022-03-10 00:52:37 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                 2022-03-10 01:22:37 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                  2022-03-10 01:37:58 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                   2022-03-10 21:30:57 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                    2022-03-10 22:36:55 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                 2022-03-12 07:00:06 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                  2022-03-12 21:20:04 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                  2022-03-14 01:44:32 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                   2022-03-14 16:20:51 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                    2022-03-14 22:21:50 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                     2022-03-16 21:47:49 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                      2022-03-16 23:33:13 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                      2022-03-22 03:28:47 from Andres Freund <andres(at)anarazel(dot)de>                                    2022-03-22 03:19:27 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                     2022-03-22 07:27:32 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                      2022-03-22 07:48:53 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                       2022-03-22 21:57:03 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                        2022-03-25 14:54:25 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                         2022-03-29 12:08:45 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                          2022-03-29 12:25:52 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                           2022-04-03 16:50:02 from Andres Freund <andres(at)anarazel(dot)de>                                            2022-04-05 16:42:28 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                             2022-04-05 17:19:04 from Robert Haas <robertmhaas(at)gmail(dot)com>                                              2022-04-06 21:22:38 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                               2022-04-07 13:20:04 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                2022-04-07 15:38:36 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                 2022-04-07 23:25:01 from Greg Stark <stark(at)mit(dot)edu>                                               2022-04-14 01:32:54 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                2022-05-02 03:30:12 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                 2022-05-05 19:26:51 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                                  2022-05-26 13:41:09 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                  2022-05-26 15:43:12 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                   2022-05-27 01:52:10 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                                    2022-06-03 05:39:52 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                   2022-06-06 14:41:54 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                    2022-06-20 06:35:00 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                     2022-08-02 18:06:59 from Jacob Champion <jchampion(at)timescale(dot)com>                                                     2022-10-11 13:50:51 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                      2022-10-12 07:15:19 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                       2022-10-14 20:05:41 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                                        2022-11-02 16:52:19 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                         2022-11-03 08:16:21 from Ian Lawrence Barwick <barwick(at)gmail(dot)com>                                                         2022-11-04 13:27:34 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                          2022-11-09 03:00:30 from Andres Freund <andres(at)anarazel(dot)de>                                                           2022-11-11 19:10:16 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                            2022-11-18 13:07:22 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                             2022-11-28 23:57:14 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                              2022-12-06 03:18:05 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                               2022-12-13 04:40:02 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                                                2022-12-14 01:43:10 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                 2022-12-14 05:09:46 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                  2022-12-30 18:39:55 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                                   2023-01-02 04:34:26 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                    2023-01-03 10:49:03 from vignesh C <vignesh21(at)gmail(dot)com>                                                                     2023-01-03 16:46:15 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                      2023-01-04 09:50:31 from "Drouvot, Bertrand" <bertranddrouvot(dot)pg(at)gmail(dot)com>                                                                       2023-01-04 19:24:26 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                        2023-01-05 08:11:36 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                         2023-01-06 03:07:11 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                                                          2023-01-06 07:55:54 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                           2023-01-07 01:59:40 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                            2023-01-10 01:52:47 from Andres Freund <andres(at)anarazel(dot)de>                                                                             2023-01-12 14:02:33 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                              2023-01-20 07:55:41 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                               2023-01-20 14:38:33 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                                                                2023-02-02 06:33:04 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                                 2023-02-08 02:03:11 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                                  2023-02-16 08:27:43 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎                                                                                   2023-02-18 02:46:27 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                                    2023-02-20 07:14:20 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                                     2023-02-20 16:47:58 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                                      2023-02-24 06:16:10 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                                       2023-04-05 07:47:25 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                        2023-04-05 08:21:02 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                                         2023-04-05 14:31:54 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                                          2023-04-06 03:28:04 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                           2023-04-06 15:14:20 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                                                                            2023-04-07 10:15:24 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                             2023-04-07 19:27:17 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                                              2023-04-09 22:32:07 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                               2023-04-10 19:20:42 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com> 📎                                                                                                2023-04-12 04:46:41 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                                                                                                 2023-04-12 12:22:34 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>                                                                                                  2023-07-06 02:07:14 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎                                                                                                   2023-07-06 02:14:51 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                                    2023-07-06 05:28:57 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎                                                                                                     2023-07-11 05:54:26 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                                           2023-04-07 19:01:17 from Andres Freund <andres(at)anarazel(dot)de>                                                                                            2023-04-09 23:14:18 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                             2023-04-10 22:34:17 from Andres Freund <andres(at)anarazel(dot)de>                                                         2022-11-08 07:49:27 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                             2022-04-05 17:31:25 from Andres Freund <andres(at)anarazel(dot)de>                                              2022-04-05 18:45:09 from "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>  2021-12-20 19:05:47 from Peter Geoghegan <pg(at)bowt(dot)ie>   2021-12-23 10:49:59 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>  2021-12-20 19:27:26 from Justin Pryzby <pryzby(at)telsasoft(dot)com>   2021-12-27 17:59:25 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v9-0001-Add-infrastructure-for-parallel-progress-reporting.patch	application/octet-stream	9.9 KB
v9-0002-Show-progress-for-index-vacuums.patch	application/octet-stream	10.8 KB
v9-0003-Expose-indexes-being-processed-in-a-VACUUM-operat.patch	application/octet-stream	16.8 KB
v9-0004-Rename-index_vacuum_count-in-pg_stat_pogress_vacu.patch	application/octet-stream	2.8 KB

In response to

• Re: Add index scan progress to pg_stat_progress_vacuum at 2022-03-14 22:21:50 from Imseih (AWS), Sami

Responses

• Re: Add index scan progress to pg_stat_progress_vacuum at 2022-03-16 23:33:13 from Nathan Bossart
• Re: Add index scan progress to pg_stat_progress_vacuum at 2022-03-22 03:28:47 from Andres Freund

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Alvaro Herrera	2022-03-16 22:06:18	Re: Support logical replication of DDLs
Previous Message	Zheng Li	2022-03-16 21:17:18	Re: Support logical replication of DDLs