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.
Filename, size | File type | Python version | Upload date | Hashes |
---|---|---|---|---|
Filename, size pgextrascli-0.1.1-py2.py3-none-any.whl (6.0 kB) | File type Wheel | Python version 2.7 | Upload date | Hashes View |
Filename, size pgextrascli-0.1.1.tar.gz (14.1 kB) | File type Source | Python version None | Upload date | Hashes View |
Close
Hashes for pgextrascli-0.1.1-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 090100a1e322cef46e9b861aed8bb07dbe64a7639f9524b15796661a200e1abb |
|
MD5 | 166e29afb35dc017834ebee1edc84c1f |
|
BLAKE2-256 | 705ac505170ebb15072f19ca30030a6314384913d72bcb0d458bb9c391fc61da |