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          

Categories

Monitoring, Progress reporting view