pgextras CLI

Simple command line wrapper for https://github.com/scottwoodall/python-pgextras

• Free software: BSD license

Install

$ pip install pgextrascli

Usage

Usage: pgextrascli [OPTIONS] CMD

Options:

$ pgextrascli --help

-l, --list-commands  shows available commands
--host=HOST          database host, default: localhost
--port=PORT          database port, default: 5432
--dbname=DBNAME      database name, default: template1
--user=USER          database user, default: postgres
--password=PASSWORD  database password, default: empty
--help               Show this message and exit.

Available commands:

$ pgextrascli -l

bloat                          Table and index bloat in your database ordered by most wasteful.
blocking                       Queries holding locks other queryes are qaiting to be releases
cache_hit                      Calculates your cache hit rate (effective databases are at 99% and up).
calls                          Show 10 most frequently called queries. Requires the pg_stat_statements.
index_usage                    Calculates your index hit rate (effective databases are at 99% and up).
locks                          Display queries with active locks.
long_running_queries           Show all queries longer than five minutes by descending duration.
outliers                       Show 10 queries that have longest execution time in aggregate. Requires the pg_stat_statments.
ps                             View active queries with execution time.
seq_scans                      Show the count of sequential scans by table descending by order.
total_table_size               Show the size of the tables (including indexes), descending by size.
unused_indexes                 Show unused and almost unused indexes, ordered by their size relative to the number of index scans.
vacuum_stats                   Show dead rows and whether an automatic vacuum is expected to be triggered.
version                        Get the Postgres server version.