Monitoring

2 min read Updated 1 day ago

Monitoring

Managed databases come with built-in monitoring tools to help you understand performance and diagnose issues.

Overview Tab

The Overview tab shows a summary of your database:

  • Current status and operational state
  • Node health (for multi-node setups, each node's role and state)
  • Engine version
  • Plan details (CPU, RAM, storage)
  • Maintenance window information

Metrics

The Overview tab displays real-time metrics for your database:

  • CPU usage - How much processing power your database is using
  • Memory usage - RAM utilization
  • Disk usage - Storage consumption
  • Disk I/O - Read and write operations per second
  • Network traffic - Incoming and outgoing data
  • Database connections - Number of active connections

Use these metrics to identify performance bottlenecks and decide when to upgrade your plan.

Query Statistics

The Query statistics tab shows your most resource-intensive queries. This helps you identify slow queries and optimize your application's database access patterns.

For each query, you can see:

  • Query digest (anonymized query pattern)
  • Call count
  • Total execution time
  • Average execution time
  • Rows examined vs rows sent

Logs

The Logs tab shows recent database engine logs. These are useful for debugging connection issues, query errors, and replication problems.

Session Management

The Overview tab also shows active database sessions. You can:

  • View all currently active connections
  • See which queries are running
  • Terminate specific sessions if needed (e.g., killing a long-running query)

When to Upgrade

Consider upgrading your plan when:

  • CPU usage is consistently above 80%
  • Memory usage is at or near the limit
  • Disk usage is approaching storage capacity
  • Query performance is degrading under load
  • Connection count is near the plan's limit

Next Steps

  • Properties - Configure database engine settings
  • Scaling - Upgrade your database plan