Clients Table

New 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