Cassandra Long Running Query Test

This test tracks the currently executing queries on a Cassandra database node and determines the number of queries that have been running for a long time. Using this test, resource-intensive queries to a database can be quickly isolated.

Target of the test : A Cassandra Database

Agent deploying the test : An external/remote agent.

Outputs of the test : One set of results for the target Cassandra Database node being monitored.

Configurable parameters for the test
Parameters Description

Test Period

How often should the test be executed.


The host for which the test is to be configured.


The port on which the specified host listens. By default, this is 9042.

CQL User

Specify the name of the CQL User with the following privileges in this text box:

SELECT privilege on the system_traces.sessions table

SELECT privilege on the system.peer_events table

CQL Password

Specify the password corresponding to the CQL User.

Confirm Password

Confirm the CQL Password by retyping it in this text box.

Elapsed Time (seconds)

Specify the duration (in seconds) for which a query should have executed for it to be regarded as a long running query. The default value is 10.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Number of queries

Indicates the number of queries that are currently executing on the database beyond the configured ELAPSED TIME.


The detailed diagnosis for this measure indicates the exact queries and which user is executing the queries. This information can be very useful in identifying queries that may be candidates for optimization.