Skip to main content

PostgreSQL health checker — monitor connections, bloat, vacuum status, locks, and replication lag

Project description

dargslan-postgres-health

PostgreSQL Health Checker — Monitor connections, bloat, vacuum status, locks, replication lag, and long-running queries. Zero external dependencies.

PyPI version License: MIT

Installation

pip install dargslan-postgres-health

CLI Usage

dargslan-pg report            # Full health report
dargslan-pg connections       # Connection stats
dargslan-pg databases         # Database sizes
dargslan-pg bloat             # Table bloat analysis
dargslan-pg vacuum            # Vacuum status
dargslan-pg locks             # Waiting locks
dargslan-pg queries           # Long-running queries
dargslan-pg replication       # Replication status
dargslan-pg json              # JSON output

Python API

from dargslan_postgres_health import PostgresHealth
ph = PostgresHealth(host="localhost", user="postgres")
conn = ph.connection_status()
bloat = ph.table_bloat()
ph.print_report()

More from Dargslan

License

MIT — see LICENSE

Project details


Download files

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

Source Distribution

dargslan_postgres_health-1.0.0.tar.gz (5.8 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

dargslan_postgres_health-1.0.0-py3-none-any.whl (6.9 kB view details)

Uploaded Python 3

File details

Details for the file dargslan_postgres_health-1.0.0.tar.gz.

File metadata

  • Download URL: dargslan_postgres_health-1.0.0.tar.gz
  • Upload date:
  • Size: 5.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.11.14

File hashes

Hashes for dargslan_postgres_health-1.0.0.tar.gz
Algorithm Hash digest
SHA256 cc5e72db246fe7ece1d0c8a0c0463ecf215fbeb3f929c92d16b4bc07379998c6
MD5 da80736c8ee64222c5d973dcb664264d
BLAKE2b-256 a68267d8aaa6f9a1d46ad331bdfde37e10653b7e031bb4763108ace99c296918

See more details on using hashes here.

File details

Details for the file dargslan_postgres_health-1.0.0-py3-none-any.whl.

File metadata

File hashes

Hashes for dargslan_postgres_health-1.0.0-py3-none-any.whl
Algorithm Hash digest
SHA256 03dbe84c5ae661d798db2318c5a423f8b3d0edef941a354a2d8f26d60d89bbaf
MD5 4dd5af1ada74f3d0b164d0b7e96cfe52
BLAKE2b-256 24bce7c5f0853f0b9a93b47b8d2bf9456d96f2f123927559041807a0c7400529

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page