Overview
The monitoring features are accessible directly from your database’s overview page within the Latitude.sh dashboard. You will find a dedicated “Monitoring” section that provides a quick glance at essential metrics. Key metrics displayed in the Monitoring section on the database overview page include:- CPU Usage: Shows the percentage of CPU resources being consumed by your database instance.
- Memory Usage: Displays the percentage of memory currently in use by the database.
- Transactions Per Second (TPS): Indicates the number of transactions your database is processing each second.
Monitoring Overview Page
For more in detail insights of your database’s performance over time, you can also see the dedicated monitoring overview page. To access this page:- Go to the Databases section in the sidebar menu.
- Select the database you wish to monitor.
- Click on the “Monitoring” tab on the database overview page.
- CPU Usage: A time-series chart showing CPU utilization trends.
- Memory Usage: A time-series chart illustrating memory consumption patterns.
- Transactions Per Second (TPS): A chart displaying the transaction rate over time.
- Database Size: Shows the growth of your database size.
Storage Alerts
Latitude.sh automatically monitors your database storage usage and sends email alerts when capacity thresholds are reached. This proactive notification system helps prevent service interruptions caused by disk exhaustion.How it works
- Threshold: Alerts are triggered when storage usage reaches 85% capacity.
- Recipients: All team members with administrator or owner roles receive email notifications.
- Frequency: To avoid alert fatigue, there’s a cooldown period between notifications.
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
When you receive a storage alert:- 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.
Storage alerts are sent automatically. No configuration is required—monitoring
begins as soon as your database is deployed.