> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table showing currently active ZooKeeper watches registered by this ClickHouse server.

# system.zookeeper_watches

<h2 id="description">
  Description
</h2>

Shows currently active [watches](https://zookeeper.apache.org/doc/r3.3.3/zookeeperProgrammers.html#ch_zkWatches) registered by this ClickHouse server on ZooKeeper nodes (including auxiliary ZooKeepers). Each row represents one watch.

<h2 id="columns">
  Columns
</h2>

* `zookeeper_name` ([String](/reference/data-types/string)) — Name of the ZooKeeper connection (`default` for the main connection, or the auxiliary name).
* `create_time` ([DateTime](/reference/data-types/datetime)) — Time when the watch was created.
* `create_time_microseconds` ([DateTime64](/reference/data-types/datetime64)) — Time when the watch was created with microsecond precision.
* `path` ([String](/reference/data-types/string)) — ZooKeeper path being watched.
* `session_id` ([Int64](/reference/data-types/int-uint)) — Session ID of the connection that registered the watch.
* `request_xid` ([Int64](/reference/data-types/int-uint)) — XID of the request that created the watch.
* `op_num` ([Enum](/reference/data-types/enum)) — The type of the request that created the watch.
* `watch_type` ([Enum8](/reference/data-types/enum)) — Watch type. Possible values:
  * `Children` — watching for changes in the list of child nodes (set by `List` operations).
  * `Exists` — watching for node creation or deletion.
  * `Data` — watching for changes in node data (set by `Get` operations).

Example:

```sql theme={null}
SELECT * FROM system.zookeeper_watches FORMAT Vertical;
```

```text theme={null}
Row 1:
──────
zookeeper_name:           default
create_time:              2026-03-16 12:00:00
create_time_microseconds: 2026-03-16 12:00:00.123456
path:                     /clickhouse/task_queue/ddl
session_id:               106662742089334927
request_xid:              10858
op_num:                   List
watch_type:               Children
```

**See Also**

* [ZooKeeper](/guides/oss/best-practices/tips#zookeeper)
* [ZooKeeper guide](https://zookeeper.apache.org/doc/r3.3.3/zookeeperProgrammers.html)