diff options
| author | Masahiko Sawada | 2025-12-09 19:23:45 +0000 |
|---|---|---|
| committer | Masahiko Sawada | 2025-12-09 19:23:45 +0000 |
| commit | ab40db3852dfa093b64c9266dd372fee414e993f (patch) | |
| tree | e0e45ec04ae0932a3c0b9abd35905e5d03efc986 /doc/src | |
| parent | 0d789520619803cf6629ebf980e116d733b6756f (diff) | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index cc2b590e7a2..817fd9f4ca7 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -5770,6 +5770,31 @@ FROM pg_stat_get_backend_idset() AS backendid; zero). </para></entry> </row> + + <row> + <entry role="catalog_table_entry"><para role="column_definition"> + <structfield>started_by</structfield> <type>text</type> + </para> + <para> + Shows what caused the current <command>ANALYZE</command> operation to be + started. Possible values are: + <itemizedlist> + <listitem> + <para> + <literal>manual</literal>: The analyze was started by an explicit + <command>ANALYZE</command>, or by <command>VACUUM</command> with + the <option>ANALYZE</option> option. + </para> + </listitem> + <listitem> + <para> + <literal>autovacuum</literal>: The analyze was started by an + autovacuum worker. + </para> + </listitem> + </itemizedlist> + </para></entry> + </row> </tbody> </tgroup> </table> |