Horton

Add started_by column to pg_stat_progress_analyze view.

Masahiko Sawada <msawada@postgresql.org>

View on postgr.es
Commit: ab40db3852dfa093b64c9266dd372fee414e993f
Author: Masahiko Sawada <msawada@postgresql.org>
Date: 2025-12-09T19:23:45Z
Releases: 19 (unreleased) 
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.kato@gmail.com>
Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com>
Reviewed-by: Sami Imseih <samimseih@gmail.com>
Reviewed-by: Yu Wang <wangyu_runtime@163.com>
Discussion: https://postgr.es/m/CAA5RZ0suoicwxFeK_eDkUrzF7s0BVTaE7M%2BehCpYcCk5wiECpw%40mail.gmail.com

Files

PathChange+/−
doc/src/sgml/monitoring.sgml modified +25 −0
src/backend/catalog/system_views.sql modified +4 −1
src/backend/commands/analyze.c modified +6 −0
src/include/catalog/catversion.h modified +1 −1
src/include/commands/progress.h modified +5 −0
src/test/regress/expected/rules.out modified +6 −1

Discussion