System Catalogs / Progress reporting
pg_stat_progress_analyze
Read the PG 18 manualWhenever ANALYZE is running, the pg_stat_progress_analyze view will contain a row for each backend that is currently running that command.
Reading PG 18current·documented in 8 of 24 versions, 13 to 20
- Kind
- Progress reporting
- Columns in this snapshot
- 13
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 13
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
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). |
Column history across versions
Version history 8
Definition snapshot: english-manuals:a5ae72875cbe2f04b551bd244d6… · English manual source