Query Drilldown View

Use the Query drilldown to investigate how a single query pattern behaves across your environment. The drilldown helps you understand query usage, failures, and execution context so you can troubleshoot issues and assess impact.

You open the Query drilldown by selecting a query pattern from the Queries table in Settings, then Metric Data, then Usage Analysis, then Queries.

How the query drilldown works

Each entry in the Queries table represents a normalized query pattern. The Query drilldown focuses on one pattern and shows how it executes across locations for a selected day.

Every value you see in the drilldown is recalculated based on the selected date and any applied location filter.

Query pattern summary

The header summarizes the overall usage and health of the query pattern.

Query pattern

Shows the normalized query pattern in a read-only code block. Select the copy icon to copy the full pattern. This helps you confirm which query you are analyzing.

Times used

Shows how many times the query pattern executed on the selected date. Use this value to understand how heavily the query is used.

Last run

Shows the most recent execution time for the query pattern. This confirms whether the query is still active.

Status

Shows success and failure rates for executions on the selected date. This provides a quick signal of query health.

Date selector

Use the date selector to view query behavior for a specific day. All metrics and charts update when you change the date.

Raw query logs

Use the Raw query logs toggle to enable raw query log collection for this query pattern. This is useful when you need deeper visibility into individual executions.

View trends over time

The Trends section shows how the query pattern behaves across recent days.

Requests

Displays how many times the query pattern executed each day. Use this chart to identify usage spikes or drops.

Errors and failure rate

Shows how many executions failed and how the failure rate changes over time. Use this chart to spot recurring or isolated failures.

Analyze errors

The Errors section breaks down query failures.

Use Breakdown by to group errors by:

• Type
• Location

If the query did not fail on the selected date, the chart displays No data to display. This helps you quickly confirm whether failures occurred.

Analyze requests

Use the Requests section to see how executions are distributed.

Use Breakdown by to group requests by:

• Location
• Type

This view helps you understand where the query runs and which execution types contribute most to usage.

Review locations

The Locations table lists all locations where the query pattern ran.

For each location, the table shows:

• Location name
• Last runtime
• Success and failure rates
• Number of executions

Use the search field or location filter to narrow the list. This is useful when failures occur only in specific alerts or contexts.

Use the query drilldown effectively

Use the Query drilldown to:

• Investigate why a query pattern fails
• Confirm whether a query is still actively used
• Identify locations responsible for most executions
• Focus troubleshooting on high-impact queries

By combining usage metrics, trends, error breakdowns, and location data, the Query drilldown helps you move from symptom to root cause without leaving Coralogix.