Cloudera Docs

Tracking query service metrics

Track Cloudera Observability query cluster service metrics to optimize query performance and detect issues, such as how long queries take to run, how many resource usages are consumed while a query is running, and Determine if a particular query is slowing down due to resource constraints or inefficient execution.

Describes where to view the Cloudera Observability query service metrics.

  1. Verify that you are logged in to the Cloudera Observability web UI and that you selected an environment from the Analytics Environments page.
    1. Log in to Cloudera in a supported browser.
      The Cloudera web interface landing page opens.
    2. From the Your Enterprise Data Cloud landing page, select the Observability tile.
      The Cloudera Observability landing page opens to the main navigation panel.
    3. From the Cloudera Observability Environments page, select the environment required for analysis.

      The Environment navigation panel opens.

  2. To view service metrics for an engine in the environment's cluster, do the following:
    1. Locate the query of interest by doing one of the following:
      1. On the Cluster Summary page, locate the Query Trend or Jobs Trend chart widget.
      2. Click the link displayed for the Total Queries or Total Jobs field.
      3. On the Queries or Jobs page, from the Query or Job column, select the query or job.
      4. Optional: If not already expanded, from the Environment navigation panel, expand the ENGINES category and then select the engine.
    2. From the .../***engine name***/Queries/Query Details or .../***engine name***/Jobs/Job Detailspage, select the Cluster tab.
    3. From the Metrics tab, select the name of the Cloudera Manager health test metric from the list of services running on your workloads cluster. You can select up to five metrics.
      Metrics charts for the selected service are displayed.