Time interval selection
The time interval selector at the top of each tab allows you to filter the view for a predefined or custom time interval. Use the navigation buttons to move to the previous, next, or current time interval. When you select a time interval, the same interval is selected for all charts on the Metrics page.Row-Level TTL Jobs
| Short Name | CockroachDB Metric Name | Description | Usage |
|---|---|---|---|
| Resume Completed | jobs.row\_level\_ttl.resume\_completed | Number of row_level_ttl jobs which successfully resumed to completion | If Row Level TTL is enabled, this metric should be nonzero and correspond to the ttl_cron setting that was chosen. If this metric is zero, it means the job is not running |
| Running | jobs.row\_level\_ttl.currently\_running | Number of row_level_ttl jobs currently running in Resume or OnFailOrCancel state | Monitor this metric to ensure there are not too many Row Level TTL jobs running at the same time. Generally, this metric should be in the low single digits. |
| Paused | jobs.row\_level\_ttl.currently\_paused | Number of row_level_ttl jobs currently considered Paused | Monitor this metric to ensure the Row Level TTL job does not remain paused inadvertently for an extended period. |
| Resume Failed | jobs.row\_level\_ttl.resume\_failed | Number of row_level_ttl jobs which failed with a non-retriable error | This metric should remain at zero. Repeated errors means the Row Level TTL job is not deleting data. |
| Failed Schedules | schedules.scheduled-row-level-ttl-executor.failed | Number of scheduled-row-level-ttl-executor jobs failed | Monitor this metric to ensure the Row Level TTL job is running. If it is non-zero, it means the job could not be created. |
Processing Rate
| Short Name | CockroachDB Metric Name | Description | Usage |
|---|---|---|---|
| Rows selected | jobs.row\_level\_ttl.rows\_selected | Number of rows selected for deletion by the row level TTL job. | Correlate this metric with the metric jobs.row_level_ttl.rows_deleted to ensure all the rows that should be deleted are actually getting deleted. |
| Rows deleted | jobs.row\_level\_ttl.rows\_deleted | Number of rows deleted by the row level TTL job. | Correlate this metric with the metric jobs.row_level_ttl.rows_selected to ensure all the rows that should be deleted are actually getting deleted. |
Estimated Rows
| Short Name | CockroachDB Metric Name | Description | Usage |
|---|---|---|---|
| Total Rows | jobs.row\_level\_ttl.total\_rows | Approximate number of rows on the TTL table. | See Description. |
| Expired Rows | jobs.row\_level\_ttl.total\_expired\_rows | Approximate number of rows that have expired the TTL on the TTL table. | See Description. |
Row-Level TTL Job Latency
| Short Name | CockroachDB Metric Name | Description | Usage |
|---|---|---|---|
| Select Latency (P90), Select Latency (P99) | jobs.row\_level\_ttl.select\_duration | Duration for select requests during row level TTL. | See Description. |
| Delete Latency (P90), Delete Latency (P99) | jobs.row\_level\_ttl.delete\_duration | Duration for delete requests during row level TTL. | See Description. |