dalibo/pg_activity
pg_activity is a top like application for PostgreSQL server activity monitoring. observed · 2026-08-28
Health v2 · maintenance only
82/100
- Activity 95
- Release rhythm 55
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: 234.0
- age_days: 5057
- days_rel: 89
- days_push: 32
- n_releases_24m: 3
Adoption not part of the score
3034 stars · 190 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
pg_activity is a top-like command line tool for monitoring PostgreSQL server activity in real time. It displays running queries, waits, CPU, memory, and I/O usage, working locally or remotely.
Use cases
- monitor postgres server activity from the terminal
- see which queries are running on postgresql right now
- watch cpu and io usage of my postgres database
- find long-running or blocking queries in postgres
- top-like tool for postgres
- debug slow queries on a postgres server
When to choose
- you want a lightweight, htop-style live view of PostgreSQL activity without a web dashboard
- you need quick ad-hoc inspection of running queries, waits, and system resource usage
- you prefer a CLI tool installable via pip, pipx, or distro packages
When to avoid
- you need long-term metrics storage, dashboards, or alerting (use Prometheus/pgwatch instead)
- you need monitoring of many servers from one place
- you cannot connect as a superuser or the postgres OS user and need full system-level stats
Facets
cli-tool · maturity active
monitoring database cli databases monitoring developer-tools python cli postgresql top-like database-monitoring terminal-ui sql command-line linux macos
2 sources
- readme: https://github.com/dalibo/pg_activity · fetched 2026-08-28 · 1aa68b2f8858
- registry_pypi: https://pypi.org/pypi/pg_activity/json · fetched 2026-08-29 · a90b42de2fd1
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| dalibo/pg_activity | main | 82 |
For agents
markdown · JSON · MCP: product_card(name="dalibo/pg_activity")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem