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

# SHOW LOGICAL REPLICATION JOBS

> [!NOTE]
>
> **This feature is in [preview](/docs/releases/cockroachdb-feature-availability.md)** and subject to change. To share feedback and/or issues, contact [Support](https://support.cockroachlabs.com).

Logical data replication is only supported in CockroachDB self-hosted clusters.

The `SHOW LOGICAL REPLICATION JOBS` statement shows details of [**logical data replication (LDR)**](/docs/stable/logical-data-replication-overview.md) jobs on a cluster.

This page is a reference for the `SHOW LOGICAL REPLICATION JOBS` SQL statement, which includes information on its parameters and possible options. For more details on monitoring LDR, refer to the [Monitor Logical Data Replication](/docs/stable/logical-data-replication-monitoring.md) page.

## Required privileges

You must have one of the following to run `SHOW LOGICAL REPLICATION JOBS`:

* The [`admin` role](/docs/stable/security-reference/authorization#admin-role).
* The [`VIEWJOB` system privilege](/docs/stable/security-reference/authorization), which can view all jobs (including `admin`-owned jobs).

Use the [`GRANT SYSTEM`](/docs/stable/grant) statement:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
GRANT SYSTEM VIEWJOB TO user;
```

## Synopsis

\<?xml version="1.0" encoding="UTF-8"?>

### Parameters

| Parameter | Description |
| - | - |
| `show_logical_replication_jobs_options` | [Option](#options) to modify the output. |

## Options

| Option | Description |
| - | - |
| `details` | Includes the additional columns: `replication_start_time`, `conflict_resolution_type`, `description`. |

## Responses

| Field | Response |
| - | - |
| `job_id` | The job's ID. Use with [`CANCEL JOB`](/docs/stable/cancel-job), [`PAUSE JOB`](/docs/stable/pause-job), [`RESUME JOB`](/docs/stable/resume-job), [`SHOW JOB`](/docs/stable/show-jobs). |
| `status` | The job's current state. Possible values: `pending`, `paused`, `pause-requested`, `failed`, `succeeded`, `canceled`, `cancel-requested`, `running`, `retry-running`, `retry-reverting`, `reverting`, `revert-failed`. Refer to [Jobs status](/docs/stable/show-jobs.md#job-status) for a description of each status. |
| `tables` | The fully qualified name of the table(s) that are part of the LDR job. |
| `replicated_time` | The latest [timestamp](/docs/stable/timestamp.md) at which the destination cluster has consistent data. This time advances automatically as long as the LDR job proceeds without error. `replicated_time` is updated periodically (every 30s). |
| `replication_start_time` | The start time of the LDR job. |
| `conflict_resolution_type` | The type of [conflict resolution](/docs/stable/manage-logical-data-replication.md#conflict-resolution): `LWW` last write wins. |
| `command` | Description of the job including the replicating table(s) and the cluster connections. |

## Example

In the destination cluster's SQL shell, you can query `SHOW LOGICAL REPLICATION JOBS` to view the LDR jobs running on the cluster:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SHOW LOGICAL REPLICATION JOBS;
```

```
        job_id        | status  |          tables          |    replicated_time
----------------------+---------+--------------------------+-------------------------
  1131000153784844289 | running | {db_b.public.test_table} | 2025-12-09 19:33:20+00
  1131000167682211841 | running | {db_a.public.test_table} | 2025-12-09 19:33:20+00
(2 rows)
```

For additional detail on each LDR job, use the `WITH details` option:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SHOW LOGICAL REPLICATION JOBS WITH details;
```

```
        job_id        | status  |          tables          |    replicated_time     |    replication_start_time     | conflict_resolution_type |                                                                             command
----------------------+---------+--------------------------+------------------------+-------------------------------+--------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------
  1131000153784844289 | running | {db_b.public.test_table} | 2025-12-09 19:35:50+00 | 2025-12-08 20:04:15.512126+00 | LWW                      | CREATE LOGICALLY REPLICATED TABLE test_table FROM TABLE test_table ON 'external://conn_a' WITH OPTIONS (BIDIRECTIONAL ON 'external://conn_b')
  1131000167682211841 | running | {db_a.public.test_table} | 2025-12-09 19:35:50+00 | 2025-12-08 20:04:19.758587+00 | LWW                      | CREATE LOGICAL REPLICATION STREAM FROM TABLE test_table ON 'external://conn_b' INTO TABLE test_table WITH OPTIONS (CURSOR = $1, PARENT = '1131000153784844289')
```

## See also

* [`CREATE LOGICAL REPLICATION STREAM`](/docs/stable/create-logical-replication-stream)
* [Set Up Logical Data Replication](/docs/stable/set-up-logical-data-replication.md)