> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Row-Level TTL metrics

export const InternalLink = ({version, path = "", children, ...props}) => {
  let detectedVersion = version || "stable";
  if (typeof window !== 'undefined' && !version) {
    const match = window.location.pathname.match(/\/docs\/([^/]+)/);
    if (match) {
      detectedVersion = match[1];
    }
  }
  const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
  return <a href={`/docs/${detectedVersion}/${normalizedPath}`} {...props}>
      {children}
    </a>;
};

The Row-Level TTL metrics let you monitor the performance of your <InternalLink version="stable" path="row-level-ttl">Row-Level TTL jobs</InternalLink>.

To view these graphs, select a cluster from the <InternalLink path="cluster-management#view-clusters-page">**Clusters** page</InternalLink>, 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.                           | 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. |

## See also

* <InternalLink path="metrics">Metrics Overview</InternalLink>
* <InternalLink path="metrics-overview">Overview metrics tab</InternalLink>
* <InternalLink path="metrics-request-units">Request Unit metrics</InternalLink>
* <InternalLink path="metrics-sql">SQL metrics</InternalLink>
* <InternalLink path="metrics-changefeeds">Changefeed metrics</InternalLink>
* <InternalLink path="metrics-essential">Essential Metrics for Standard</InternalLink>