pg_stat_progress_analyze
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.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- progress
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- 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
- runtime verified
- false
- source
- english-manual
Definition PG 18
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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| pid | integer | Nullable | Process ID of backend. |
| datid | oid | Nullable | OID of the database to which this backend is connected. |
| datname | name | Nullable | Name of the database to which this backend is connected. |
| relid | oid | Nullable | OID of the table being analyzed. |
| phase | text | Nullable | Current processing phase. See Table 27.39. |
| sample_blks_total | bigint | Nullable | Total number of heap blocks that will be sampled. |
| sample_blks_scanned | bigint | Nullable | Number of heap blocks scanned. |
| ext_stats_total | bigint | Nullable | Number of extended statistics. |
| ext_stats_computed | bigint | Nullable | Number of extended statistics computed. This counter only advances when the phase is computing extended statistics. |
| child_tables_total | bigint | Nullable | Number of child tables. |
| child_tables_done | bigint | Nullable | Number of child tables scanned. This counter only advances when the phase is acquiring inherited sample rows. |
| current_child_table_relid | oid | Nullable | 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 | Nullable | 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). |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"progress-reporting.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"4a6cdd8228f2d858318f2056687ac4e2467e2c58e5fed10bdb583ba8eb66fec5","version":"18.7"},{"file":"progress-reporting.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"0ab33caa1959f857312f1a866b2b0f0afde18c3fd85db5d957eefa1b7a2e441f","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:435ea319b70bdbed14473c4cbe6bb45273d74d145894d26e00b337394dcc2607
Text language: en · catalog-bilingual-repair:435ea319b70bdbed14473c4cbe6bb45273d74d145894d26e00b337394dcc2607