Was this page helpful?
Caution
You're viewing documentation for a previous version of ScyllaDB Open Source. Switch to the latest stable version.
Clients Table¶
Added in version 3.3.
This document describes how to work with Scylla’s client table, which provides real-time information on CQL clients currently connected to the Scylla cluster.
Viewing - List Active CQL connections¶
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 |
Scylla node shard handing the connection |