Skip to main content

Command line for pgextras

Project description

https://badge.fury.io/py/pgextrascli.png https://travis-ci.org/onjin/pgextrascli.png?branch=master https://pypip.in/d/pgextrascli/badge.png

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

This version
History Node

0.1.1

History Node

0.1.0

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
pgextrascli-0.1.1-py2.py3-none-any.whl (6.0 kB) Copy SHA256 hash SHA256 Wheel 2.7 May 3, 2014
pgextrascli-0.1.1.tar.gz (14.1 kB) Copy SHA256 hash SHA256 Source None May 3, 2014

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page