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 14 13 12 11 10 9.6
ANALYZE pg_stat_progress_analyze            
CLUSTER pg_stat_progress_cluster            
COPY pg_stat_progress_copy            
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