{
    "info": {
        "author": "Olakunle Olaniyi",
        "author_email": "rugging24@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 2.7",
            "Topic :: System :: Networking :: Monitoring"
        ],
        "description": "# pg_monitor\nMonitors postgres and produces output usable by monitoring systems such as Nagios\n\nChecks for a PostgreSQL server\n\nInstallation :\n\tpip install pg_monitor\n\nRequirement :\n\tpython >= 2.7 \n\nPlatform :\n\tWindows, Linux\n\nBug report :\n\t\t\tPlease send your bug reports to rugging24@gmail.com\n\noptional arguments:\n  -h, --help            show this help message and exit\n  --port PORT           Port of the database to be accessed. Default: 5432\n  --user USER           Username allowed to access the database. Default:\n                        postgres\n  --password PASSWORD   Password of the supplied user. Default:\n  --dbname DBNAME       The name of the database to be accessed. Default:\n                        postgres\n  --host HOST           Host of the database. Default: localhost\n  --check               {backends,connections,wals,vacuum,autovacuum,analyze,autoanalyze,table_bloat,\n\t\t\tindex_bloat,blocking,nonblocking,table_size,index_size,database_size,\n\t\t\tcheckpoints,duplicate_indexes,replica_lag}\n                        \n\t\t\tOptions to be passed as checks :\n\t\t\t\n\t\t\t** backends -->> Checks for the number of clients/connections currently\n                        connected to the specified database \n\t\t\t** connections -->> Tests the databases if they currently accept\n                        connections or not \n\t\t\t** wals -->> keeps tab on the number/size of wal files present in the pg_xlog\n                        directory \n\t\t\t** vacuum -->> Inspects the tables and produces a report of those that has not\n\t\t\tbeen vauumed for a given period of time \n\t\t\t** autovacuum -->> Same as vacuum except that this is triggered by the database's\n                        internal processes \n\t\t\t** analyze -->> reports tables that have not been analyzed after a given period\n\t\t\tof time\n                        ** autoanalyze -->> Same as analyze but triggered by the database's internal \n\t\t\tprocesses. \n\t\t\t** table_bloat -->> Inspect all tables and reports the bloat percentage\n                        which is usually a function of vacuum and/or autovacuuming not running regularly \n\t\t\t** index_bloat -->> Same as table bloat, except for indexes. This could be\n                        remedied by reindexing \n\t\t\t** blocking -->> This checks for locks transactional/relational that are blocking\n\t\t\tother processes from running. \n\t\t\t** nonblocking -->> This checks for locks that are running more than the specified\n                        type. This normally do not block, but could become a blocking lock if ir runs \n\t\t\tlonger than necessary. In some cases, it is the long running locks that become\n                        the blocking types \n\t\t\t** table_size -->> Monitors table sizes \n\t\t\t** index_size -->> Monitors index sizes\n                        ** database_size -->> Monitors database sizes \n\t\t\t** checkpoints -->> Monitors checkpoint frequency \n\t\t\t** duplicate_indexes -->> Monitors indexes and report duplicates\n                        ** replica_lag -->> Monitors all replicas connected to a given master\n  --find FIND [FIND ...] Finding partterns in locks\n  --warning WARNING     Values to be considered as warning signs\n  --critical CRITICAL   Values for the critical checks\n\n\nSPECIAL NOTES :\nBackends \t\tDefault: warning --> 80% , critical --> 85% , of the number of connections\n\t\t\tAccepts both numbers and percentages, and could be combined with an or\n\t\t\te.g 20 or 10% is allowed\n\nVacuum/analyze\t\tDefault: warning --> 1 month.  No default critical value.\n\t\t\tAccepts : integers with the following units \n\t\t\tday(s), week(s), month(s), year(s)\n\nAutoanalyze/autovacuum  Same as for vacuum and analyze\n\t\t\t\nRelation sizes\t\t(tables,indexes and databases). Warning and/or critical value must be provided\n\t\t\tAccepts integers with the following units\n\t\t\tKB,MB,GB,TB,PB\n\nBloat \t\t\tDefault : warning --> 1GB. No default critical value provided\n\t\t\tAccepts integers with the following units\n\t\t\tKB,MB,GB,TB,PB\n\nLocks\t\t\tDefault : warning --> 1min . No default critical value provided\n\t\t\tAccepts integers with the smallest units being minute(s)\n\t\t\t** accept others higher than that, but they don't make any\n\t\t\ttechnical sence and might not be useful for the purpose of \n\t\t\tlock monitoring.\n \nReplica_lag\t\tDefault : warning --> 5. Critical --> 10 . (16MB worth of WAL files)\n\t\t\tAccepts only integers. Units not allowed\n\nWALS \t\t\tNo defaults. Warning and/or critical value must be provided\n\t\t\tOnly integer accepted\n\n\n\n\nSAMPLE USAGE :\nHelp \t\t\tpg_monitor --help \n\nChecking the number of backends \n\t\t\tpg_monitor --check=backends --user=monitor --password=secrete --dbname=mydbName --host=hostname \n\n\t\t\t*** Depending on your postgres hba settings, password may not be necessary.\n\n\t\t\tpg_monitor --check=backends --user=monitor --password=secrete --dbname=mydbName --host=hostname --warning='90 or 85%' --critical='95%'\n\n\t \n\nChecking for replica lag\n\t\t\tpg_monitor --check=replica_lag --user=monitor --password=secrete --dbname=mydbName --host=master,replica1,replica2,replicaN --port=master,replica1,replica2,replicaN",
        "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/rugging24/pg_monitor",
        "keywords": null,
        "license": "PostgreSQL License",
        "maintainer": null,
        "maintainer_email": null,
        "name": "pg_monitor",
        "package_url": "https://pypi.org/project/pg_monitor/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/pg_monitor/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "https://github.com/rugging24/pg_monitor"
        },
        "release_url": "https://pypi.org/project/pg_monitor/1.7.3/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "PostgreSQL monitoring checks",
        "version": "1.7.3"
    },
    "last_serial": 2053052,
    "releases": {
        "1.5.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "032e2acd172c1398cb88f84d035247c2",
                    "sha256": "f357fe6a80e41e427e4e4479418b0f1a3e64933d22b7f609c6f210d47d254016"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.5.7.tar.gz",
                "has_sig": false,
                "md5_digest": "032e2acd172c1398cb88f84d035247c2",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17263,
                "upload_time": "2016-03-19T14:25:05",
                "url": "https://files.pythonhosted.org/packages/5a/25/75704f3d8f81bd1b5b44e6334676472f19a8e77692198dc8dd7be68b5473/pg_monitor-1.5.7.tar.gz"
            }
        ],
        "1.5.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6cd89567b7bd701b27989528bd63e92c",
                    "sha256": "28dc9d2afb1c403250d6c69462a625bfa8426f242e1414c3118cb70d7268ec48"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.5.8.tar.gz",
                "has_sig": false,
                "md5_digest": "6cd89567b7bd701b27989528bd63e92c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17267,
                "upload_time": "2016-03-19T14:30:40",
                "url": "https://files.pythonhosted.org/packages/61/36/c53976050a558cc17022f1e2b1a76fd501e161206765c7172d00f75c6ec9/pg_monitor-1.5.8.tar.gz"
            }
        ],
        "1.5.9": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "83d5b6252e89cbecf3982044958936f1",
                    "sha256": "584346dab24636fe8dfc71fc2d4554465ca3bf0eeda835223497acb133d20b6b"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.5.9.tar.gz",
                "has_sig": false,
                "md5_digest": "83d5b6252e89cbecf3982044958936f1",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17281,
                "upload_time": "2016-03-21T07:48:54",
                "url": "https://files.pythonhosted.org/packages/f4/f6/5eb7a67d69de8dcd800b7a358aee68f37e337192e6a203f49f9185e965a3/pg_monitor-1.5.9.tar.gz"
            }
        ],
        "1.6.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "48e437f3a470b428d1d17d4ff3fd946f",
                    "sha256": "226a4a87da5374c42487bc264aefccbcb0c488b9a88bb1526f117a10c705d5f6"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.6.1.tar.gz",
                "has_sig": false,
                "md5_digest": "48e437f3a470b428d1d17d4ff3fd946f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17454,
                "upload_time": "2016-03-24T15:51:01",
                "url": "https://files.pythonhosted.org/packages/4e/08/00237ec314cb49a02a44a2a9783c9dde83229471eee34b3a2a10f1876266/pg_monitor-1.6.1.tar.gz"
            }
        ],
        "1.6.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "22cc5bd25c77e98ba87cf8bb41d06e40",
                    "sha256": "4066358fc63a775c683323473a0df62c5ce758dd6cd16fc411a7aff90b48a451"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.6.2.tar.gz",
                "has_sig": false,
                "md5_digest": "22cc5bd25c77e98ba87cf8bb41d06e40",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17493,
                "upload_time": "2016-03-24T16:27:00",
                "url": "https://files.pythonhosted.org/packages/24/61/d7a86901ecbf1cc3ab7065078ad2c8249db92212d946519a21e8a4689c09/pg_monitor-1.6.2.tar.gz"
            }
        ],
        "1.6.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "a6da9a4b32a33621ff660f71163f6229",
                    "sha256": "9e8452e0405baa3e6434603017be1b9759d31fd16290c82f5fb93d8a7579203b"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.6.3.tar.gz",
                "has_sig": false,
                "md5_digest": "a6da9a4b32a33621ff660f71163f6229",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17643,
                "upload_time": "2016-03-25T12:03:59",
                "url": "https://files.pythonhosted.org/packages/c8/c3/6040724dde165b741b2ae9967758e30ecf1551e45b4c2eee651858bc4eaa/pg_monitor-1.6.3.tar.gz"
            }
        ],
        "1.6.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5095abd3ed274083f241f734f12f95fa",
                    "sha256": "eff680c952ad8a29ebefc79878476506d9eecda21badc29c8034f0bf001b0d7e"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.6.4.tar.gz",
                "has_sig": false,
                "md5_digest": "5095abd3ed274083f241f734f12f95fa",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17629,
                "upload_time": "2016-03-29T07:57:27",
                "url": "https://files.pythonhosted.org/packages/a6/00/e2428840bd1d7630f75528e254b679a948f075d534fcbf8bd50fd74ef061/pg_monitor-1.6.4.tar.gz"
            }
        ],
        "1.6.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f88d9659e9800fefd4c799208cec4793",
                    "sha256": "a3453b0103d99ec9dbe00f8f4ca306d1714527175eb7773baaa84c0a888721a4"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.6.5.tar.gz",
                "has_sig": false,
                "md5_digest": "f88d9659e9800fefd4c799208cec4793",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17640,
                "upload_time": "2016-03-29T09:33:51",
                "url": "https://files.pythonhosted.org/packages/e0/dd/7f564776071a714218aa4a39ed7c12b0c16133662463612ff66ff6ac26f0/pg_monitor-1.6.5.tar.gz"
            }
        ],
        "1.6.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "d1e5ed7ff1af65b4338a3ccbcfaac37e",
                    "sha256": "4abdf4e36c5a3ab6b0e2dd93f6538d8336e6edcea88f70b5681112c36b6f3711"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.6.6.tar.gz",
                "has_sig": false,
                "md5_digest": "d1e5ed7ff1af65b4338a3ccbcfaac37e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17639,
                "upload_time": "2016-03-29T09:36:04",
                "url": "https://files.pythonhosted.org/packages/0d/a4/6488e9a7010b15c0ab223da09f644cdbe71486b744a89b9d1a71ff17ad8a/pg_monitor-1.6.6.tar.gz"
            }
        ],
        "1.6.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "7defa56d652b268c6c04bdc8f9f54a26",
                    "sha256": "88b73d9640c85971a3e8b956cf255ba274aced6c891b530a79523d71a5ad86bf"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.6.8.tar.gz",
                "has_sig": false,
                "md5_digest": "7defa56d652b268c6c04bdc8f9f54a26",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17635,
                "upload_time": "2016-03-29T15:11:21",
                "url": "https://files.pythonhosted.org/packages/9c/ba/f40231f8b3755f4ad31b767a010502b297f0ea458f505b7baa2513c29490/pg_monitor-1.6.8.tar.gz"
            }
        ],
        "1.6.9": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2c769d4d5d03a42d104c50ff2983ccb1",
                    "sha256": "3227631a4722d450fe26d101ef736d9f8c3c056c52746fd063f4c9d5c0c1c4ad"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.6.9.tar.gz",
                "has_sig": false,
                "md5_digest": "2c769d4d5d03a42d104c50ff2983ccb1",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17653,
                "upload_time": "2016-03-29T15:16:01",
                "url": "https://files.pythonhosted.org/packages/c1/e9/17122e7c029dc14238f9cf0e2fe3a41f4c2efdf6441f5383042d2ac7de88/pg_monitor-1.6.9.tar.gz"
            }
        ],
        "1.7.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c6abb236615677689061e7447b17b319",
                    "sha256": "773a9bb1c936d7d862fe9f400e54522cc8c33c847bb65ef51467a36a40d84614"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.7.0.tar.gz",
                "has_sig": false,
                "md5_digest": "c6abb236615677689061e7447b17b319",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17660,
                "upload_time": "2016-03-29T15:20:21",
                "url": "https://files.pythonhosted.org/packages/5a/83/97e5c7019cbafe5e3ec0dc609ff892fb5878537da1505d8d369cd63652eb/pg_monitor-1.7.0.tar.gz"
            }
        ],
        "1.7.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "dcd8e3702026be7869112a129edb67c7",
                    "sha256": "f257c66f256e6a8f0d4d6eeaa8a2cf057607352d8f90bb8d28718b7d925047b4"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.7.1.tar.gz",
                "has_sig": false,
                "md5_digest": "dcd8e3702026be7869112a129edb67c7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17792,
                "upload_time": "2016-04-08T08:15:43",
                "url": "https://files.pythonhosted.org/packages/e9/4f/fbf85885217a4b0ddb492978368f4da2e73b976214d8a40d915b2a39dbdf/pg_monitor-1.7.1.tar.gz"
            }
        ],
        "1.7.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2ce706b198b0094e2074211d487b3c10",
                    "sha256": "fc11a9e8ce43e2591accfa3128f28937f8c289b868caf67c822e61228ff9055e"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.7.2.tar.gz",
                "has_sig": false,
                "md5_digest": "2ce706b198b0094e2074211d487b3c10",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17788,
                "upload_time": "2016-04-08T08:50:01",
                "url": "https://files.pythonhosted.org/packages/43/9f/017c9af9abd70062330d97c0c775e1c61ea2939f851ccc76e3ba3459c476/pg_monitor-1.7.2.tar.gz"
            }
        ],
        "1.7.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e8bca6b092c6da51d3ce5845e179b455",
                    "sha256": "ea102f03f3796346c9e79fb38b9e659937a9bdda1c15f6439c031f1af516d608"
                },
                "downloads": -1,
                "filename": "pg_monitor-1.7.3.tar.gz",
                "has_sig": false,
                "md5_digest": "e8bca6b092c6da51d3ce5845e179b455",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17795,
                "upload_time": "2016-04-08T08:54:18",
                "url": "https://files.pythonhosted.org/packages/af/f6/d872956758d502072d3f549162b81b4d4e8f5c700fb8e2b5d678d91196ff/pg_monitor-1.7.3.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "e8bca6b092c6da51d3ce5845e179b455",
                "sha256": "ea102f03f3796346c9e79fb38b9e659937a9bdda1c15f6439c031f1af516d608"
            },
            "downloads": -1,
            "filename": "pg_monitor-1.7.3.tar.gz",
            "has_sig": false,
            "md5_digest": "e8bca6b092c6da51d3ce5845e179b455",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 17795,
            "upload_time": "2016-04-08T08:54:18",
            "url": "https://files.pythonhosted.org/packages/af/f6/d872956758d502072d3f549162b81b4d4e8f5c700fb8e2b5d678d91196ff/pg_monitor-1.7.3.tar.gz"
        }
    ]
}