Viewing slow queries

About this task

View any slow queries along with alerts and recommendations for improving query performance. Any CQL tables with queries that take longer than the configured threshold appear in the Slow Queries list. System and OpsCenter keyspaces are excluded from the Slow Queries list.

The ability to trace queries requires permission granted in your user role.

Version-specific information:

  • The User column displays the users who are running slow queries.

  • Slow queries are only shown for data since the last time the agent was restarted. For more information, see the known issue.


  1. Select cluster name > Services.

  2. Click the Configure link for the Performance Service.

    The Overview tab displays the performance panels.

  3. Click the title bar of the Slow Queries panel.

    The Slow Queries performance details page appears.


  4. Sort the slow queries by any column header.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000,