VACUUM VACUUM — garbage-collect and optionally analyze a database Synopsis VACUUM [ ( option [, ...] ) ] [ table_and_columns …| PostgreSQL Documentation
ANALYZE ANALYZE — collect statistics about a database Synopsis ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, …| PostgreSQL Documentation
28.2. The Cumulative Statistics System # 28.2.1. Statistics Collection Configuration 28.2.2. Viewing Statistics 28.2.3. pg_stat_activity 28.2.4. pg_stat_replication 28.2.5. pg_stat_replication_slots 28.2.6. pg_stat_wal_receiver …| PostgreSQL Documentation
28.4. Progress Reporting # 28.4.1. ANALYZE Progress Reporting 28.4.2. CLUSTER Progress Reporting 28.4.3. COPY Progress Reporting 28.4.4. CREATE INDEX Progress Reporting …| PostgreSQL Documentation