On this page
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
