pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Masahiko Sawada <msawada@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Report index vacuum progress.
Date: Tue, 11 Jul 2023 03:36:32 +0000
Message-ID: <E1qJ4Ay-002vIX-PG@gemulon.postgresql.org> (raw)

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(-)



view thread (3+ messages)  latest in thread

Message-ID: <E1qJ4Ay-002vIX-PG@gemulon.postgresql.org>
Permalink:  ../E1qJ4Ay-002vIX-PG@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1qJ4Ay-002vIX-PG@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: msawada@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Report index vacuum progress.
  In-Reply-To: <E1qJ4Ay-002vIX-PG@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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