Accessing Monitoring
To access monitoring for any database:- Go to the Databases section in the sidebar menu.
- Select the database you want to monitor.
- View the Monitoring section on the overview page for a quick summary.
- Click the Monitoring tab for detailed charts.
Overview Page Metrics
The database overview page displays real-time sparklines for:- CPU Usage: CPU utilization percentage
- Memory Usage: Memory consumption percentage
- Transactions Per Second (TPS): Transaction throughput rate
Monitoring Page
The monitoring page provides detailed time-series charts:- CPU Usage: CPU utilization over time
- Memory Usage: Memory consumption over time
- Transactions Per Second (TPS): Transaction rate over time
- Database Size: Storage growth over time
Why storage matters
PostgreSQL reserves approximately 5% of disk space for Write-Ahead Log (WAL) operations—a critical mechanism for data integrity and crash recovery. When your database reaches 95% total disk usage, WAL operations may fail, causing:- Connection disruptions
- Transaction failures
- Potential data loss
Recommended actions
If your database is approaching capacity:- Upgrade your database plan - Scale to a larger plan with more storage capacity from your database settings.
- Remove unused data - Delete obsolete records, truncate logs, or archive historical data.
- Optimize storage - Run
VACUUM FULLto reclaim space from deleted rows, or review large tables for optimization opportunities.