title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/operations/system-tables/zookeeper_info.md)

Querying in ClickHouse Cloud

The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the `clusterAllReplicas` function. See [here](/docs/operations/system-tables/overview#system-tables-in-clickhouse-cloud) for further details.

This table outputs combined introspection about zookeeper and the nodes are taken from config.

Columns:

- `zookeeper_cluster_name` ([String](/docs/sql-reference/data-types/string)) — ZooKeeper cluster's name.
- `host` ([String](/docs/sql-reference/data-types/string)) — The hostname/IP of the ZooKeeper node that ClickHouse connected to.
- `port` ([UInt16](/docs/sql-reference/data-types/int-uint)) — The port of the ZooKeeper node that ClickHouse connected to.
- `index` ([Nullable(UInt8)](/docs/sql-reference/data-types/int-uint)) — The index of the ZooKeeper node that ClickHouse connected to. The index is from ZooKeeper config. If not connected, this column is NULL.
- `is_connected` ([Nullable(UInt8)](/docs/sql-reference/data-types/int-uint)) — If zookeeper is connected or not.
- `is_readonly` ([UInt8](/docs/sql-reference/data-types/int-uint)) — Is read only.
- `version` ([String](/docs/sql-reference/data-types/string)) — The ZooKeeper version.
- `avg_latency` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The average latency.
- `max_latency` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The max latency.
- `min_latency` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The min latency.
- `packets_received` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The number of packets received.
- `packets_sent` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The number of packets sent.
- `outstanding_requests` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The number of outstanding requests.
- `server_state` ([String](/docs/sql-reference/data-types/string)) — Server state.
- `is_leader` ([UInt8](/docs/sql-reference/data-types/int-uint)) — Is this zookeeper leader.
- `znode_count` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The znode count.
- `watch_count` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The watch count.
- `ephemerals_count` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ephemerals count.
- `approximate_data_size` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The approximate data size.
- `followers` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The followers of the leader. This field is only exposed by the leader.
- `synced_followers` ([UInt64](/docs/sql-reference/data-types/int-uint)) — TThe synced followers of the leader. This field is only exposed by the leader.
- `pending_syncs` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The pending syncs of the leader. This field is only exposed by the leader.
- `open_file_descriptor_count` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The open file descriptor count. Only available on Unix platforms.
- `max_file_descriptor_count` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The max file descriptor count. Only available on Unix platforms.
- `connections` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper connections.
- `outstanding` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper outstanding.
- `zxid` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper zxid.
- `node_count` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper node count.
- `snapshot_dir_size` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper snapshot directory size.
- `log_dir_size` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper log directory size.
- `first_log_idx` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper first log index.
- `first_log_term` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper first log term.
- `last_log_idx` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper last log index.
- `last_log_term` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper last log term.
- `last_committed_idx` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper last committed index.
- `leader_committed_log_idx` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper leader committed log index.
- `target_committed_log_idx` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper target committed log index.
- `last_snapshot_idx` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The ZooKeeper last snapshot index.
  g

Was this page helpful?