Health Monitor
Live view of database health — active queries, table sizes, cache hit ratios, and blocking locks
Health Monitor
The Health Monitor gives you a live view of your database’s operational health without leaving data-peek.
It’s the panel you open when something feels off: a query that won’t return, a dashboard that’s suddenly slow, or a table that’s ballooning on disk. Instead of remembering the pg_stat_activity and pg_locks incantations, you get the four things you actually reach for during an incident — what’s running, what’s blocking, what’s cached, and what’s big — in one auto-refreshing tab.
Opening the Monitor
Click Health Monitor in the sidebar to open it as a dedicated tab.
Panels
Active Queries
See all currently running queries with:
- Query text
- Duration
- State (active, idle, waiting)
- Terminate or Kill buttons to cancel long-running queries
Table Sizes
A sortable table showing:
- Table name
- Total size (data + indexes)
- Data size
- Index size
- Row count (estimated)
Sort by any column to find your largest tables or most indexed tables.
Cache Hit Ratios
Displays the cache hit ratio for your database, indicating how effectively PostgreSQL is using shared buffers. A healthy OLTP database usually sits well above 99% — a sustained dip often means a working set that no longer fits in memory.
Locks
Shows current lock activity and any blocking queries, helping you identify and resolve contention.
Auto-Refresh
Configure automatic polling:
| Interval | Use Case |
|---|---|
| 2s | Active debugging |
| 5s | General monitoring |
| 10s | Background monitoring |
| 30s | Low-frequency checks |
| Off | Manual refresh only |
Example: finding and clearing a blocker
A write is hanging. Open the Health Monitor, drop the refresh to 2s, and check the Locks panel — it surfaces the blocking query and what it’s holding. Cross-reference it in Active Queries (sort by duration to find the long-running culprit), confirm it’s safe to stop, and hit Terminate (graceful) or Kill (force). The blocked write clears immediately.
Share as Image
Each panel has a Share button that exports the data as a styled PNG image with your choice of background theme, perfect for sharing in Slack or documentation. See Share as Image.
The Health Monitor currently supports PostgreSQL. MySQL and MSSQL support is planned.
Related
- Query Plans —
EXPLAINthe slow query you just found - Query Telemetry — timing breakdown for a single execution
- Transactions — manage the open transactions that cause locks