Difference between revisions of "Vacuum"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| + | https://andreigridnev.medium.com/db-maintenance-commands-in-postgresql-analyze-reindex-vacuum-4a14d75bee6c | ||
| + | |||
psql mydb | psql mydb | ||
``` | ``` | ||
Revision as of 17:07, 3 August 2022
psql mydb
vacuum analyze verbose
vacuum full analyze verbose
SHOW AUTOVACUUM;
Show bloat
https://wiki.postgresql.org/wiki/Show_database_bloat
Postgres Vacuum
$ docker run --rm -d --name postgres postgres:10.1 6732b0b9c6245fe9f19dd58e9737e5102089814e4aa96b66217af28a1596f786 $ docker exec -it postgres bash root@6732b0b9c624:/# psql -Upostgres psql (10.1) Type "help" for help. postgres=# CREATE TABLE floor ( postgres(# name text, postgres(# type text postgres(# ); CREATE TABLE postgres=# vacuum floor; VACUUM postgres=# SELECT relname, last_vacuum, last_autovacuum FROM pg_stat_user_tables; relname | last_vacuum | last_autovacuum ---------+-------------------------------+----------------- floor | 2019-04-24 17:52:26.044697+00 | (1 row)