The Swiss Army knife
for PostgreSQL.
psq_toolkit is a self-hosted monitoring platform that gives you deep visibility into performance, disk usage, replication, logs, OS metrics, and more — with automated alerting that tells you what needs attention.
Everything you need, modular by design
Enable only what you need. Each module gives you deep visibility into a specific aspect of your PostgreSQL database.
Performance
5-second snapshots of active sessions, TPS, cache hit ratio, wait events, and blocking queries — all graphed over selectable time ranges.
Disk & Storage
Per-table and per-index size breakdowns with relation, index, and TOAST storage. Track cache hit ratios, detect unused indexes, and chart size trends over time.
Replication
Monitor publications, subscriptions, replication slots, and streaming replicas. Track WAL lag, slot status, and subscriber sync state at a glance.
OS Monitoring
CPU, memory, load averages, and per-mount disk usage reported every 5 seconds by a lightweight Go collector daemon. Per-device I/O stats included.
Log Monitoring
Stream PostgreSQL logs from a collector daemon, CloudWatch, or local files. Parsed, searchable, and filterable by level — stored in ClickHouse for fast queries.
Automated Tasks
Configurable thresholds that automatically create tasks when metrics cross limits — low cache hit ratio, replication lag, unused indexes, high disk usage, and more.
Live Queries
See every active session in real time. Inspect query text, wait events, and lock dependencies. Cancel or terminate runaway queries with one click.
Users & Roles
View all database users and roles with attributes, inheritance chains, schema privileges, and table-level grants. Spot overprivileged accounts instantly.
Configuration
Browse every postgresql.conf setting with current values, defaults, and pending restart flags. Edit tunable parameters directly from the UI.
Up and running in minutes
Add a connection
Enter your PostgreSQL host, port, database, and credentials. Import from .pg_service.conf for bulk setup.
Enable modules
Toggle on the monitoring modules you need. Install the collector daemon for OS metrics and log streaming.
Monitor everything
View real-time dashboards, track trends over time, and let automated tasks catch issues before they become incidents.
Built for PostgreSQL teams
Multi-database support
Monitor all your databases from one place. Switch between them instantly from the nav bar.
Lightweight collector
A single Go binary tails logs and reports OS metrics. One curl command to install, zero dependencies.
Threshold-based alerting
Configurable thresholds per-database with automatic task creation. Resolve, ignore, or let them accumulate.
Self-hosted
Deploy on your own infrastructure with Kamal. Your data never leaves your network.
Read-only by default
Reads system catalogs and statistics views. Never modifies your data or schema unless you explicitly act.
Team collaboration
Invite your team, share database connections, and manage access with role-based permissions.
CloudWatch integration
Stream RDS/Aurora logs via a Lambda forwarder. Deploy with one CloudFormation template.
Open source
MIT licensed. Inspect the code, contribute, and make it your own.
Start monitoring your PostgreSQL databases
Free and open source. Deploy in minutes.