Set up docs MCPDescription
Shows currently active watches registered by this ClickHouse server on ZooKeeper nodes (including auxiliary ZooKeepers). Each row represents one watch.
Availability
system.zookeeper_watches exists only when ClickHouse Keeper or ZooKeeper is configured. On servers without either configured, the table does not exist and queries against it will fail with UNKNOWN_TABLE.
Columns
zookeeper_name(String) — Name of the ZooKeeper connection (“default” for the main connection, or the auxiliary name).create_time(DateTime) — Time when the watch was created.create_time_microseconds(DateTime64(6)) — Time when the watch was created with microsecond precision.path(String) — ZooKeeper path being watched.session_id(Int64) — Session ID of the connection that registered the watch.request_xid(Int64) — XID of the request that created the watch.op_num(Enum16(‘Close’ = -11, ‘Error’ = -1, ‘Watch’ = 0, ‘Create’ = 1, ‘Remove’ = 2, ‘Exists’ = 3, ‘Get’ = 4, ‘Set’ = 5, ‘GetACL’ = 6, ‘SetACL’ = 7, ‘SimpleList’ = 8, ‘Sync’ = 9, ‘Heartbeat’ = 11, ‘List’ = 12, ‘Check’ = 13, ‘Multi’ = 14, ‘Create2’ = 15, ‘Reconfig’ = 16, ‘CheckWatch’ = 17, ‘RemoveWatch’ = 18, ‘CreateContainer’ = 19, ‘CreateTTL’ = 21, ‘MultiRead’ = 22, ‘Auth’ = 100, ‘SetWatch’ = 101, ‘SetWatch2’ = 105, ‘AddWatch’ = 106, ‘FilteredList’ = 500, ‘CheckNotExists’ = 501, ‘CreateIfNotExists’ = 502, ‘RemoveRecursive’ = 503, ‘CheckStat’ = 504, ‘TryRemove’ = 505, ‘FilteredListWithStatsAndData’ = 506, ‘ListRecursive’ = 507, ‘SessionID’ = 997)) — Operation that created the watch.watch_type(Enum8(‘Unexpected’ = -1, ‘Children’ = 1, ‘Exists’ = 2, ‘Data’ = 3)) — Watch type: Children (list), Exists, or Data (get).
Examples
SELECT * FROM system.zookeeper_watches FORMAT Vertical;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