APM Trace Queries

You can use multiple queries in the Kloudfuse APM Traces interfaces.

When you specify the first filter, you define the first query. Kloudfuse identifies it as query a (a) in the interface. You can add additional queries, b (b) and others, to your analysis.

Specify a query

You can refine the time series in your Trace interfaces using the Query builder. Follow these steps:

Query builder

  1. In the count ofcount of (Show count of) drop-down, select All spans (default), any named span, or any other filter. Note that these filters are the ones that appear in the Filters panel.

    See APM Traces Filters.

    Depending on the selected filter, the aggregation Count of may change to Count unique of,

  2. In the by (by) drop-down, choose Everything, or one of the many prepared labels.

    You can add multiple options to the by (by) clause. They appear as separate tiles.

  3. In the limit to (limit to) drop-down, select either bottom (bottom) or top (top), and specify the number of records to show: 2, 5, 10, 15, 25, 30, 50, or 100.

  4. In the up every (roll up every) drop-down, select time-based grouping. These change depending on the overall time interval.

In this example, we use a time interval of 3 hours, group by the app_ads_contextKeys value, limit the query to the top 100, and roll up every 2 minutes.

Query builder

This query produces the following graph:

trace time series

Add query

  1. To add a query, click Add Query button (Add Query).

  2. Notice that a new query B (B) appears under query A (A), and it is a duplicate.

    This is intentional, and makes it is easier to perform calculations across the time series retrieved by the two queries.

  3. Change the selected filter in query B (B).

  4. The interface displays the result of two queries.

Separate Query Charts

When you combine 2 or more queries on the same chart, it is relatively easy to see their relationship.

However, because the two metrics often have significantly different value ranges on the Y axis, it may be difficult to see the detail. By separating the queries into their individual charts, you vertically "expand" the axis, making it easier to visualize patterns and trends.

To separate a graph into its constituent queries, click the Combine all queries into one chart option to deselect it. The interface displays the two charts side-by-side.

Combine query charts

To combine separate charts, click to select the Combine all queries into one chart option.

Refresh the query

Whenever you load a query, it fetches the results from the specified time interval. If that time interval is relative to now(), as the default of Last 5 minutes, time passes. To refresh the charts, perform a new data fetch.

To refresh the graphs with the same options, follow these steps:

  1. Click the Refresh icon, refresh, at the top right of the interface.

  2. Kloudfuse refreshes the view.

Remove a query

You can remove a query from the interface when working with multiple queries. You cannot remove the only (last) query on the page; instead, select a different query in the first drop-down.

When you specify an object in the search bar, Kloudfuse adds it as a tile. You can add multiple tiles to your query.

To remove one of the tiles, hover your pointer over it and click dismiss (delete).

To clear the query (remove all tiles), hover over and click red dismiss at the end of the line (delete all).

You can use multiple queries in your analysis. See Add query.

You can further configure the query using aggregations. See Aggregating trace metrics.