Skip to content
ClickHouse Docs
49.6kGet Started

zookeeper_info

View as MarkdownEdit this pageReport an issueSet up docs MCP

Autogenerated from ClickHouse system tables

Description

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.

Columns

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