> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-parallel-read-in-order-multi-part.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.

**Availability**

`system.zookeeper_info` 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`.

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