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.

Procedure

  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.

    opscPerfServiceSlowQueriesDetails

  4. Sort the slow queries by any column header.