{
    "info": {
        "author": "Marek Wywia\u0142",
        "author_email": "onjinx@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable"
        ],
        "description": "===============================\r\npgextras CLI\r\n===============================\r\n\r\n.. image:: https://badge.fury.io/py/pgextrascli.png\r\n    :target: http://badge.fury.io/py/pgextrascli\r\n    \r\n.. image:: https://travis-ci.org/onjin/pgextrascli.png?branch=master\r\n        :target: https://travis-ci.org/onjin/pgextrascli\r\n\r\n.. image:: https://pypip.in/d/pgextrascli/badge.png\r\n        :target: https://pypi.python.org/pypi/pgextrascli\r\n\r\n\r\nSimple command line wrapper for https://github.com/scottwoodall/python-pgextras\r\n\r\n* Free software: BSD license\r\n\r\nUsage\r\n-----\r\nUsage: pgextrascli [OPTIONS] CMD\r\n\r\nOptions:\r\n\r\n.. code-block::\r\n\r\n  $ pgextrascli --help\r\n\r\n  -l, --list-commands  shows available commands\r\n  --host=HOST          database host, default: localhost\r\n  --port=PORT          database port, default: 5432\r\n  --dbname=DBNAME      database name, default: template1\r\n  --user=USER          database user, default: postgres\r\n  --password=PASSWORD  database password, default: empty\r\n  --help               Show this message and exit.\r\n\r\nAvailable commands:\r\n\r\n.. code-block::\r\n\r\n  $ pgextrascli -l\r\n\r\n  bloat                          Table and index bloat in your database ordered by most wasteful.\r\n  blocking                       Queries holding locks other queryes are qaiting to be releases\r\n  cache_hit                      Calculates your cache hit rate (effective databases are at 99% and up).\r\n  calls                          Show 10 most frequently called queries. Requires the pg_stat_statements.\r\n  index_usage                    Calculates your index hit rate (effective databases are at 99% and up).\r\n  locks                          Display queries with active locks.\r\n  long_running_queries           Show all queries longer than five minutes by descending duration.\r\n  outliers                       Show 10 queries that have longest execution time in aggregate. Requires the pg_stat_statments.\r\n  ps                             View active queries with execution time.\r\n  seq_scans                      Show the count of sequential scans by table descending by order.\r\n  total_table_size               Show the size of the tables (including indexes), descending by size.\r\n  unused_indexes                 Show unused and almost unused indexes, ordered by their size relative to the number of index scans.\r\n  vacuum_stats                   Show dead rows and whether an automatic vacuum is expected to be triggered.\r\n  version                        Get the Postgres server version.",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "UNKNOWN",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/onjin/pgextrascli",
        "keywords": "pgextrascli",
        "license": "BSD",
        "maintainer": "",
        "maintainer_email": "",
        "name": "pgextrascli",
        "package_url": "https://pypi.org/project/pgextrascli/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/pgextrascli/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "https://github.com/onjin/pgextrascli"
        },
        "release_url": "https://pypi.org/project/pgextrascli/0.1.1/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "Command line for pgextras",
        "version": "0.1.1"
    },
    "last_serial": 1081848,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9ca43f5422186f20a2e5a58029ad1b12",
                    "sha256": "d3c304a46a6da272bd830145bd60378bd2867c62e2fee7549fcaacdf4f936f37"
                },
                "downloads": -1,
                "filename": "pgextrascli-0.1.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "9ca43f5422186f20a2e5a58029ad1b12",
                "packagetype": "bdist_wheel",
                "python_version": "2.7",
                "requires_python": null,
                "size": 6008,
                "upload_time": "2014-05-03T07:46:55",
                "url": "https://files.pythonhosted.org/packages/1a/1c/a0c46104656661a8145ee6105b5b8360e26085ef418952a5278fcbe338ed/pgextrascli-0.1.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "92ef856d7c1c7da547fb2de325faddc7",
                    "sha256": "5df3d0a4a4ebef46b133800aa192f58f77b6a8bc79ac79db6e07f28dab1e8f5f"
                },
                "downloads": -1,
                "filename": "pgextrascli-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "92ef856d7c1c7da547fb2de325faddc7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 14074,
                "upload_time": "2014-05-03T07:46:52",
                "url": "https://files.pythonhosted.org/packages/05/2f/3abfb8dd5b23042fb992ab07703ca15de240d5e732734df19c1341df7b45/pgextrascli-0.1.0.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "166e29afb35dc017834ebee1edc84c1f",
                    "sha256": "090100a1e322cef46e9b861aed8bb07dbe64a7639f9524b15796661a200e1abb"
                },
                "downloads": -1,
                "filename": "pgextrascli-0.1.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "166e29afb35dc017834ebee1edc84c1f",
                "packagetype": "bdist_wheel",
                "python_version": "2.7",
                "requires_python": null,
                "size": 5979,
                "upload_time": "2014-05-03T07:56:18",
                "url": "https://files.pythonhosted.org/packages/70/5a/c505170ebb15072f19ca30030a6314384913d72bcb0d458bb9c391fc61da/pgextrascli-0.1.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "f5d890c4150dbccd25045a3220ce986f",
                    "sha256": "a07722fc63b3f8bfc0dec970f17e15b79ff00900b8817c6dbe7c63288aedcaa1"
                },
                "downloads": -1,
                "filename": "pgextrascli-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "f5d890c4150dbccd25045a3220ce986f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 14070,
                "upload_time": "2014-05-03T07:56:01",
                "url": "https://files.pythonhosted.org/packages/d7/69/9de58faf011aadd78be9a0ae2f7227cdac23445cbcc1ba330e398915f0d0/pgextrascli-0.1.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "166e29afb35dc017834ebee1edc84c1f",
                "sha256": "090100a1e322cef46e9b861aed8bb07dbe64a7639f9524b15796661a200e1abb"
            },
            "downloads": -1,
            "filename": "pgextrascli-0.1.1-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "166e29afb35dc017834ebee1edc84c1f",
            "packagetype": "bdist_wheel",
            "python_version": "2.7",
            "requires_python": null,
            "size": 5979,
            "upload_time": "2014-05-03T07:56:18",
            "url": "https://files.pythonhosted.org/packages/70/5a/c505170ebb15072f19ca30030a6314384913d72bcb0d458bb9c391fc61da/pgextrascli-0.1.1-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "f5d890c4150dbccd25045a3220ce986f",
                "sha256": "a07722fc63b3f8bfc0dec970f17e15b79ff00900b8817c6dbe7c63288aedcaa1"
            },
            "downloads": -1,
            "filename": "pgextrascli-0.1.1.tar.gz",
            "has_sig": false,
            "md5_digest": "f5d890c4150dbccd25045a3220ce986f",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 14070,
            "upload_time": "2014-05-03T07:56:01",
            "url": "https://files.pythonhosted.org/packages/d7/69/9de58faf011aadd78be9a0ae2f7227cdac23445cbcc1ba330e398915f0d0/pgextrascli-0.1.1.tar.gz"
        }
    ]
}