TiloBox
Back to directory
pg_activity project preview
Developer ToolsAlternative to Datadog PostgresAlternative to DataGrip MonitorAlternative to pgAdmin Dashboard

pg_activity

Real-time PostgreSQL server monitoring tool designed like the htop terminal utility.

View on GitHub
LicensePostgreSQL
GitHub stars4.5k
Last commit1 weeks ago
Tags5 topics
Postgresql Activity MonitorPg Activity ToolBackend Query InspectorDevopsHtop For Postgres
Overview

Why consider pg_activity?

pg_activity is an open-source real-time PostgreSQL server monitoring utility written in Python by Dalibo. Styled like the Unix htop tool, pg_activity displays active backend queries, locks, I/O rates, CPU/memory consumption, and allows administrators to cancel slow running queries.

Guided learning

Learn pg_activity by building

Practical setup notes, real use cases, and copy-ready examples in one focused guide.

1 min read 2 sections
In this guide2 sections

Overview of pg_activity

pg_activity inspects running database queries and active locks with htop-style interactive navigation.

Quickstart

bash
1pip install pg_activity
2pg_activity -U postgres -d company_db

pg_activity is licensed under the PostgreSQL License.

Related tools

More options with a similar category or technology profile.

diskus logo

diskus

Minimal, fast alternative to du -sh written in Rust using multi-threaded directory traversal.

peco logo

peco

Simplistic interactive filtering tool for Unix pipelines, process lists, and file trees.

Dapr CLI logo

Dapr CLI

Command-line tool for managing Dapr distributed application runtime environments and sidecars.

Freeze logo

Freeze

Generate beautiful image screenshots and SVGs of code snippets and terminal outputs.

pg_activity FAQs

pg_activity is listed as a Developer Tools tool on TiloBox. Review the overview, features, and official documentation on this page to decide whether it solves your specific workflow.

Start with the project's GitHub repository for supported installation and deployment instructions. Test the setup with representative data or a small project before rolling it out more widely.

pg_activity is listed under the PostgreSQL license. Read the complete license text and the project's notices before using, modifying, or distributing the software.

Production readiness depends on your requirements. Review maintenance activity, security practices, documentation, backup and upgrade procedures, and compatibility with your stack; then validate it in a non-production environment.

pg_activity is listed as an alternative to Datadog Postgres. Compare the core workflow, deployment model, integrations, and licensing against your must-have requirements before switching.