pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql: Report index vacuum progress.
3+ messages / 3 participants
[nested] [flat]
* pgsql: Report index vacuum progress.
@ 2023-07-11 03:36 Masahiko Sawada <msawada@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Masahiko Sawada @ 2023-07-11 03:36 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Report index vacuum progress.
This commit adds two columns: indexes_total and indexes_processed, to
pg_stat_progress_vacuum system view to show the index vacuum
progress. These numbers are reported in the "vacuuming indexes" and
"cleaning up indexes" phases.
This uses the new parallel message type for progress reporting added
by be06506e7.
Bump catversion because this changes the definition of
pg_stat_progress_vacuum.
Author: Sami Imseih
Reviewed by: Masahiko Sawada, Michael Paquier, Nathan Bossart, Andres Freund
Discussion: https://www.postgresql.org/message-id/flat/5478DFCD-2333-401A-B2F0-0D186AB09228@amazon.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/46ebdfe164c61fbac961d1eb7f40e9a684289ae6
Modified Files
--------------
doc/src/sgml/monitoring.sgml | 23 ++++++++++++
src/backend/access/heap/vacuumlazy.c | 70 ++++++++++++++++++++++++++++++-----
src/backend/catalog/system_views.sql | 3 +-
src/backend/commands/vacuumparallel.c | 9 ++++-
src/include/catalog/catversion.h | 2 +-
src/include/commands/progress.h | 2 +
src/test/regress/expected/rules.out | 4 +-
7 files changed, 100 insertions(+), 13 deletions(-)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgsql: Report index vacuum progress.
@ 2023-07-11 03:53 Michael Paquier <michael@paquier.xyz>
parent: Masahiko Sawada <msawada@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Paquier @ 2023-07-11 03:53 UTC (permalink / raw)
To: Masahiko Sawada <msawada@postgresql.org>; +Cc: pgsql-committers@lists.postgresql.org
On Tue, Jul 11, 2023 at 03:36:32AM +0000, Masahiko Sawada wrote:
> This uses the new parallel message type for progress reporting added
> by be06506e7.
Seems like this should be f188972.
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgsql: Report index vacuum progress.
@ 2023-07-11 04:02 Masahiko Sawada <sawada.mshk@gmail.com>
parent: Michael Paquier <michael@paquier.xyz>
0 siblings, 0 replies; 3+ messages in thread
From: Masahiko Sawada @ 2023-07-11 04:02 UTC (permalink / raw)
To: Michael Paquier <michael@paquier.xyz>; +Cc: Masahiko Sawada <msawada@postgresql.org>; pgsql-committers@lists.postgresql.org
On Tue, Jul 11, 2023 at 12:53 PM Michael Paquier <michael@paquier.xyz> wrote:
>
> On Tue, Jul 11, 2023 at 03:36:32AM +0000, Masahiko Sawada wrote:
> > This uses the new parallel message type for progress reporting added
> > by be06506e7.
>
> Seems like this should be f188972.
Hmm, right. I forgot to update the commit hash number after resetting
commit timestamps.
Regards,
--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-07-11 04:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-07-11 03:36 pgsql: Report index vacuum progress. Masahiko Sawada <msawada@postgresql.org>
2023-07-11 03:53 ` Michael Paquier <michael@paquier.xyz>
2023-07-11 04:02 ` Masahiko Sawada <sawada.mshk@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox