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.

The User column displays the users who are running slow queries for OpsCenter versions 6.0.9 and later.

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.