Monitor
Monitor active queries, connection pool usage, table statistics, and run database backups in tpaw.
The Monitor section gives you real-time visibility into what your PostgreSQL database is doing. Open active query dashboards, inspect connection pool health, analyze table sizes and vacuum status, and manage backups — all without leaving tpaw.
Monitor panels
| Panel | What you see |
|---|---|
| Active Queries | Currently running queries with PID, state, duration, and SQL |
| Connections | Connection pool utilization, idle/active counts, insights |
| Table Stats | Table sizes, row counts, dead tuple ratios, vacuum history |
| Backup | pg_dump-based backup and restore interface |
Opening Monitor panels
With a connection active, click the Monitor icon in the sidebar navigation, or select a specific panel from the recents menu. Monitor panels open as tabs and can remain open alongside query and data grid tabs.
Each panel has a Refresh button (or auto-refreshes at set intervals) to get the latest data.
Auto-refresh
Active Queries auto-refreshes every few seconds. Connections and Table Stats refresh on demand. Use the refresh button in each panel's toolbar to force an update.
What's in this section
- Active Queries — See running queries and kill stuck processes
- Connections — Monitor connection pool health and usage
- Table Stats — Analyze table sizes, dead tuples, and vacuum status
- Backup — Create and restore pg_dump backups