Skip to content

Instantly share code, notes, and snippets.

@dsouzajude

dsouzajude/postgresql-vacuum-analyze.sql

Created October 24, 2022 20:46
Show Gist options
  • Save dsouzajude/402ce25a75a623e40de78d47943d28e8 to your computer and use it in GitHub Desktop.
Save dsouzajude/402ce25a75a623e40de78d47943d28e8 to your computer and use it in GitHub Desktop.
Download ZIP
Run VACUUM ANALYZE to remove bloat and get better query plans
Raw
postgresql-vacuum-analyze.sql
-- Analyzes the contents of a database’s tables and collects statistics to generate better query plans
ANALYZE VERBOSE;
-- Optional manually vacuume to remove bloat
VACUUM VERBOSE ANALYZE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment