PostgreSQL VACUUM

From wikieduonline
Revision as of 10:46, 5 August 2021 by Welcome (talk | contribs)
Jump to navigation Jump to search

PostgreSQL VACUUM garbage-collect and optionally analyze a database.

VACUUM reclaims storage occupied by dead tuples.


Examples:

  • VACUUM (VERBOSE, ANALYZE) my_table;


SELECT
  schemaname, relname,
  last_vacuum, last_autovacuum,
  vacuum_count, autovacuum_count
FROM pg_stat_user_tables;
select count(*) from pg_stat_activity where query like 'autovacuum:%';


Related terms

See also

Advertising: