Viewing slow queries

View slow queries along with alerts and recommendations for improving query performance.

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.

Note: 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 for OpsCenter versions 6.0.9 and later.
  • When viewing slow queries for DSE versions 5.1 and later, slow queries are only shown for data since the last time the agent was restarted. For versions of DSE earlier than 5.1, all historical slow query data is available for slow queries. For more information, see the known issue and referenced KB article.

Procedure

  1. Click 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.