View and manage PostgteSQL vacuums and autovacuums.
Project description
pg-vacuum
Managing PostgreSQL vacuums/autovacuums.
Features
This little tool will hopefully make managing the craziness that Postgres autovacuum is a little easier.
Show current vacuums/autovacuums
It will show you how long the vacuums are running for and how much is left to do.
$ pgvacuum --database=postgres://localhost/db
Show progress of vacuums/autovacuums
$ pgvacuum --database=postgres://localhost/db --progress
Enable/disable autovacuum on a table
$ pgvacuum --database=postgres://localhost/db --table=my_table --disable
$ pgvacuum --database=postgres://localhost/db --table=my_table --enable
Show table settings
Show what current settings are set on the table.
$ pgvacuum --database=postgres://localhost/db --table=my_table
Terminate the autovacuums
Ok, you've had enough of it.
$ pgvacuum --database=postgres://localhost/db --kill=1234
where 1234
is the PID of the vacuum/autovacuum process.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pg-vacuum-0.1a4.tar.gz
(3.7 kB
view hashes)
Built Distribution
Close
Hashes for pg_vacuum-0.1a4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e6e7305bbfac5d105aa0b65dc271959dc85f17a80e0799cee12132f64e340f93 |
|
MD5 | 1a5a0c10108accd45279bb0c5fa78e58 |
|
BLAKE2b-256 | 4c477f37dd1c49ba9fcfb7d121f20a19f429c2167bfed8713aefa69e2eb08645 |