Was this page helpful?
Caution
You're viewing documentation for an unstable version of ScyllaDB Manual. Switch to the latest stable version.
Clients TableCopy
This document describes how to work with ScyllaDB’s client table, which provides real-time information on CQL clients currently connected to the ScyllaDB cluster.
Viewing - List Active CQL connectionsCopy
SELECT address, port FROM system.clients;
Example output:
address | port
------------+-------
172.17.0.2 | 33296
172.17.0.2 | 33298
Significant columns in the Client table:
Parameter |
Description |
|---|---|
address (PK) |
Client’s IP address |
port (CK) |
Client’s outgoing port number |
username |
Username - when Authentication is used |
shard_id |
ScyllaDB node shard handing the connection |