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

> System table which outputs introspection of all available keeper nodes.

# system.zookeeper_info

<Info>
  **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](/reference/system-tables/overview#system-tables-in-clickhouse-cloud) for further details.
</Info>

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

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

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

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