Report progress of REINDEX operations
Peter Eisentraut <peter@eisentraut.org>
Report progress of REINDEX operations This uses the same infrastructure that the CREATE INDEX progress reporting uses. Add a column to pg_stat_progress_create_index to report the OID of the index being worked on. This was not necessary for CREATE INDEX, but it's useful for REINDEX. Also edit the phase descriptions a bit to be more consistent with the source code comments. Discussion: https://www.postgresql.org/message-id/ef6a6757-c36a-9e81-123f-13b19e36b7d7%402ndquadrant.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/monitoring.sgml | modified | +39 −11 |
| src/backend/catalog/index.c | modified | +10 −0 |
| src/backend/catalog/system_views.sql | modified | +6 −3 |
| src/backend/commands/indexcmds.c | modified | +36 −5 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/commands/progress.h | modified | +3 −0 |
| src/test/regress/expected/rules.out | modified | +6 −3 |
Documentation touched
Discussion
- monitoring CREATE INDEX [CONCURRENTLY] 60 messages · 2018-12-20 → 2019-04-07