Command line for pgextras
Project description
Simple command line wrapper for https://github.com/scottwoodall/python-pgextras
Free software: BSD license
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.
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
pgextrascli-0.1.1.tar.gz
(14.1 kB
view hashes)
Built Distribution
Close
Hashes for pgextrascli-0.1.1-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 090100a1e322cef46e9b861aed8bb07dbe64a7639f9524b15796661a200e1abb |
|
MD5 | 166e29afb35dc017834ebee1edc84c1f |
|
BLAKE2b-256 | 705ac505170ebb15072f19ca30030a6314384913d72bcb0d458bb9c391fc61da |