Skip to main content
CockroachDB includes metrics to monitor , , and jobs. You can use monitoring integrations to alert when there are anomalies, such as backups that have failed or restore jobs encountering a retryable error. We recommend setting up monitoring to alert when anomalies occur. Depending on the tier of your CockroachDB Cloud cluster, you can use the following tools to monitor backup and restore metrics: You can then use the following SQL statements to inspect details relating to schedules, jobs, and backups:
For detail on that Cockroach Labs stores for your CockroachDB Cloud cluster, refer to the Backup and Restore page in the Cloud Console.
Metrics are reported per node. Therefore, it is necessary to retrieve metrics from every node in the cluster. For example, if you are monitoring whether a backup fails, it is necessary to track scheduled_backup_failed on each node.

​
Prometheus

This section outlines the available backup and restore job metrics with Prometheus. For instructions on accessing the metricexport endpoint for Prometheus, refer to:
  • .
  • .
We recommend the following guidelines:
  • Use the schedules.BACKUP.last-completed-time metric to monitor the specific backup job or jobs you would use to recover from a disaster.
  • Configure alerting on the schedules.BACKUP.last-completed-time metric to watch for cases where the timestamp has not moved forward as expected.

​
Datadog

You can export the following schedule backup metrics to Datadog using the , or access the Cloud Console Monitoring page to enable the integration. For instructions, refer to:
  • .
  • .

​
Available metrics in Datadog