跳转到主要内容
← 目录图谱 / pg_stat_progress_analyze

PROGRESS REPORT · 进度报告

pg_stat_progress_analyze

PostgreSQL 官方文档 ↗源码定义 ↗

Whenever ANALYZE is running, the pg_stat_progress_analyze view will contain a row for each backend that is currently running that command. The tables below describe the information that will be reported and provide information about how to interpret it.

首次收录 PG 13最近收录 PG 19当前字段 13
9.09.19.29.39.49.59.610111213141516171819β3

已与 PostgreSQL 18.6 实例逐字段核对 · 原始实测记录 ↗

字段结构 PostgreSQL 18

pg_stat_progress_analyze
字段 / COLUMN类型 / TYPE说明 / DESCRIPTION
pid integer Process ID of backend.
datid oid OID of the database to which this backend is connected.
datname name Name of the database to which this backend is connected.
relid oid OID of the table being analyzed.
phase text Current processing phase. See Table 27.39.
sample_blks_total bigint Total number of heap blocks that will be sampled.
sample_blks_scanned bigint Number of heap blocks scanned.
ext_stats_total bigint Number of extended statistics.
ext_stats_computed bigint Number of extended statistics computed. This counter only advances when the phase is computing extended statistics.
child_tables_total bigint Number of child tables.
child_tables_done bigint Number of child tables scanned. This counter only advances when the phase is acquiring inherited sample rows.
current_child_table_relid oid OID of the child table currently being scanned. This field is only valid when the phase is acquiring inherited sample rows.
delay_time double precision Total time spent sleeping due to cost-based delay (see Section 19.10.2), in milliseconds (if track_cost_delay_timing is enabled, otherwise zero).

标记“隐式列”的字段不包含在 SELECT * 中；部分早期统计视图由同版本源码补全，额外来源会显示在字段说明中。

字段演化矩阵

悬停查看字段类型
存在新增 / 类型或属性变化移除
字段 / COLUMN9.09.19.29.39.49.59.610111213141516171819
pid – – – – – – – – – –
datid – – – – – – – – – –
datname – – – – – – – – – –
relid – – – – – – – – – –
phase – – – – – – – – – –
sample_blks_total – – – – – – – – – –
sample_blks_scanned – – – – – – – – – –
ext_stats_total – – – – – – – – – –
ext_stats_computed – – – – – – – – – –
child_tables_total – – – – – – – – – –
child_tables_done – – – – – – – – – –
current_child_table_relid – – – – – – – – – –
delay_time – – – – – – – – – – – – – – –
started_by – – – – – – – – – – – – – – – –

9.0 是收录基线；基线中已存在的字段不标记为新增。矩阵按字段名称对齐，重命名显示为旧字段移除与新字段新增。

演化时间线

相邻大版本的变化

PostgreSQL 19 ← 18

+ started_by1 处字段说明更新

PostgreSQL 18 ← 17

+ delay_time

PostgreSQL 17 ← 16

1 处字段说明更新

PostgreSQL 16 ← 15

1 处字段说明更新

PostgreSQL 15 ← 14

1 处字段说明更新

PostgreSQL 14 ← 13

1 处字段说明更新

PostgreSQL 13 ← 12新增目录

+ pid+ datid+ datname+ relid+ phase+ sample_blks_total+ sample_blks_scanned+ ext_stats_total+ ext_stats_computed+ child_tables_total+ child_tables_done+ current_child_table_relid

比较任意两个版本

选择两个版本，查看字段的新增、移除与类型变化。交互比较需要 JavaScript；演化时间线可直接阅读。