v.23.6Improvement

System Table zookeeper_connection: Connection Time and Session Uptime Information

The system table zookeeper_connection connected_time identifies the time when the connection is established (standard format), and session_uptime_elapsed_seconds is added, which labels the duration of the established connection session (in seconds). #51026 (郭小龙).
Added new columns connected_time and session_uptime_elapsed_seconds to the zookeeper_connection system table to track connection start time and session duration.

Why it matters

This feature enables users to monitor the exact time when a ZooKeeper connection was established as well as how long the session has been active, providing better visibility and diagnostics for connection management.

How to use it

Query the system.zookeeper_connection table to access the new columns connected_time (connection start time) and session_uptime_elapsed_seconds (duration in seconds). For example:

sql<br>SELECT connected_time, session_uptime_elapsed_seconds FROM system.zookeeper_connection<br>