SYSTEM CATALOGS / PROGRESS REPORTING
pg_stat_progress_analyze
Read PG 18 manual ↗Whenever ANALYZE is running, the pg_stat_progress_analyze view will contain a row for each backend that is currently running that command.
- Kind
- Progress reporting
- Columns in this snapshot
- 13
- Definition source
- English manual
Columns 13
| 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
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
Version history 8
- PG 19 → 20changed
- PG 18 → 19changed
- PG 17 → 18changed
- PG 16 → 17changed
- PG 15 → 16changed
- PG 14 → 15changed
- PG 13 → 14changed
- PG 12 → 13added
Definition snapshot: english-manuals:13debb7f99b4a0cd3aab72a4287… · English manual source