| From: | Masahiko Sawada <msawada(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Add started_by column to pg_stat_progress_analyze view. |
| Date: | 2025-12-09 19:24:14 |
| Message-ID: | E1vT3Jl-003fz3-24@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Add started_by column to pg_stat_progress_analyze view.
The new column, started_by, indicates the initiator of the
analyze ('manual' or 'autovacuum'), helping users and monitoring tools
to better understand ANALYZE behavior.
Bump catalog version.
Author: Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>
Reviewed-by: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Reviewed-by: Sami Imseih <samimseih(at)gmail(dot)com>
Reviewed-by: Yu Wang <wangyu_runtime(at)163(dot)com>
Discussion: https://postgr.es/m/CAA5RZ0suoicwxFeK_eDkUrzF7s0BVTaE7M%2BehCpYcCk5wiECpw%40mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/ab40db3852dfa093b64c9266dd372fee414e993f
Modified Files
--------------
doc/src/sgml/monitoring.sgml | 25 +++++++++++++++++++++++++
src/backend/catalog/system_views.sql | 5 ++++-
src/backend/commands/analyze.c | 6 ++++++
src/include/catalog/catversion.h | 2 +-
src/include/commands/progress.h | 5 +++++
src/test/regress/expected/rules.out | 7 ++++++-
6 files changed, 47 insertions(+), 3 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nathan Bossart | 2025-12-09 19:35:03 | pgsql: Add ParallelSlotSetIdle(). |
| Previous Message | Masahiko Sawada | 2025-12-09 18:51:51 | pgsql: Add mode and started_by columns to pg_stat_progress_vacuum view. |