Contents
Progress reporting
A collection of system catalogue views reporting progress for various operations
Beginning with PostgreSQL 9.6, a number of system catalogue views have been made available which provide reports on the progress of various database commands and utilities:
The following table lists the commands for which progress reporting is available, and the associated view together with the PostgreSQL version from which they are available:
| Operation | View | 13 | 12 | 11 | 10 | 9.6 |
|---|---|---|---|---|---|---|
| ANALYZE | pg_stat_progress_analyze | |||||
| CLUSTER | pg_stat_progress_cluster | |||||
| CREATE INDEX | pg_stat_progress_create_index | |||||
| VACUUM | pg_stat_progress_vacuum | |||||
| VACUUM FULL | pg_stat_progress_cluster | |||||
| pg_basebackup | pg_stat_progress_basebackup |
References
- PostgreSQL documentation: Progress reporting