Admin and tuningPostgreSQL
VACUUM
VACUUM
ANALYZE
Maintain table statistics and reclaim storage.
Command
VACUUM (VERBOSE, ANALYZE) ;
Example usage
Optimize table performance by vacuuming and analyzing.
VACUUM (VERBOSE, ANALYZE) <table>;
ANALYZE VERBOSE;
Related tags
Admin and tuningANALYZEdatabasesqlpsql