Metadata-Version: 2.1
Name: pg-vacuum
Version: 0.1a7
Summary: View and manage PostgteSQL vacuums and autovacuums.
Home-page: https://github.com/levkk/pg-vacuum
Author: Lev Kokotov
Author-email: lev.kokotov@instacart.com
License: UNKNOWN
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3.0
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.0
Description-Content-Type: text/markdown
Requires-Dist: Click (>=7.0)
Requires-Dist: colorama (>=0.4.3)
Requires-Dist: prettytable (>=0.7.2)
Requires-Dist: psycopg2 (>=2.8.4)

# 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.



