Post-Upgrade Tasks: Statistics Quiz

Home › PostgreSQL DBA › Post-Upgrade Tasks: Statistics

✅ Postgres Database Administration – Post-Upgrade Tasks: Statistics

20 questions · 15 min timer · Explanations included · Free

Which PostgreSQL view provides information about the current autovacuum activity?

pg_stat_all_tables

pg_stat_activity

pg_stat_progress_vacuum

pg_stat_user_tables

None

The pg_stat_progress_vacuum view provides details about the progress of ongoing vacuum operations, including those triggered by autovacuum.

What is the effect of running VACUUM FULL on a PostgreSQL database?

It rebuilds all indexes in the database.

It locks the tables and reclaims space by rewriting the entire table.

It only removes dead tuples without locking the tables.

It updates the statistics for the query planner.

None

VACUUM FULL locks the tables and rewrites them to reclaim space, which can be disruptive in a production environment.

Loading questions...

Click Submit to see your final score!

Time's up

Scroll to Top