The Row-Level TTL metrics let you monitor the performance of your Row-Level TTL jobs.
To view these graphs, select a cluster from the Clusters page, and click Metrics in the Monitoring section of the left side navigation. On the Metrics page, click the Row-Level TTL tab.
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. | The approximate number of rows on all TTL tables. |
| Expired Rows | jobs.row_level_ttl.total_expired_rows |
Approximate number of rows that have expired the TTL on the TTL table. | The approximate number of rows that have expired the TTL on all TTL tables. |
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. |
See also
- Metrics Overview
- Overview metrics tab
- Request Unit metrics
- SQL metrics
- Changefeed metrics
- Essential Metrics for Standard
Was this helpful?
