VACUUM VACUUM — garbage-collect and optionally analyze a database Synopsis VACUUM [ ( option [, ...] ) ] [ table_and_columns …| PostgreSQL Documentation
EXPLAIN EXPLAIN — show the execution plan of a statement Synopsis EXPLAIN [ ( option [, ...] ) ] statement …| PostgreSQL Documentation
ALTER TABLE ALTER TABLE — change the definition of a table Synopsis ALTER TABLE [ IF EXISTS ] [ ONLY …| PostgreSQL Documentation
19.7. Query Planning # 19.7.1. Planner Method Configuration 19.7.2. Planner Cost Constants 19.7.3. Genetic Query Optimizer 19.7.4. Other Planner Options 19.7.1. Planner …| PostgreSQL Documentation
Chapter 24. Routine Database Maintenance Tasks Table of Contents 24.1. Routine Vacuuming 24.1.1. Vacuuming Basics 24.1.2. Recovering Disk Space 24.1.3. Updating Planner …| PostgreSQL Documentation
24.1. Routine Vacuuming # 24.1.1. Vacuuming Basics 24.1.2. Recovering Disk Space 24.1.3. Updating Planner Statistics 24.1.4. Updating the Visibility Map 24.1.5. …| PostgreSQL Documentation
19.11. Client Connection Defaults # 19.11.1. Statement Behavior 19.11.2. Locale and Formatting 19.11.3. Shared Library Preloading 19.11.4. Other Defaults 19.11.1. Statement Behavior …| PostgreSQL Documentation
27.4. Progress Reporting # 27.4.1. ANALYZE Progress Reporting 27.4.2. CLUSTER Progress Reporting 27.4.3. COPY Progress Reporting 27.4.4. CREATE INDEX Progress Reporting …| PostgreSQL Documentation