pg_stat_progress_analyze

PostgreSQL documentation ↗Source definition ↗

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.

First seen PG 13Last seen PG 19Columns 13

9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19^β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns 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).

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Column evolution matrix

Hover a cell for the column type

PresentAdded / type or attribute changeRemoved

COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18
`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 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 19 ← 18

+ started_by1 column description updates

PostgreSQL 18 ← 17

+ delay_time

PostgreSQL 17 ← 16

1 column description updates

PostgreSQL 16 ← 15

1 column description updates

PostgreSQL 15 ← 14

1 column description updates

PostgreSQL 14 ← 13

1 column description updates

PostgreSQL 13 ← 12Catalog added

+ 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

Compare any two versions

FROMTOInclude description updates

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.