Query bar is located on the Trace List Tab at the top of the Traces List. When you started to write a query by clicking on the query bar, query helper will be shown you to help you while writing queries.
Query helper for traces has 4 different sections:
Trace filters - Filter traces according to trace specific properties.
Statistical filters - Filter traces which display performance metrics according to the criteria set.
Sort parameters - Sort the list of traces by sorting criteria set.
Cheat Sheet - Example queries for your traces list.
TraceFilters allow you to filter your traces via trace specific property parameters. For example, you could use the trace specific parameters to attain all the traces with a specific error type. The parameters available explained in greater detail below.
Erroneous: Filter your traces depending on whether or not it resulted in an error.
Has Error: Filter your traces depending on whether or not it includes an error.
Has Cold Start: Filter your traces depending on whether or not it has cold start.
Error Type: Your traces could result in errors with various types of errors. Hence you can filter your traces by error-type, grouping the invocations depending on what error they resulted in.
Statistical parameters allow you to filter through your traces using exact numerical values related to the various runtime performances of the trace. Unlike Statistical Filters in the Query Helper for Functions, the Statistical Filters that you can set for traces are quite simple. There is no operator needed, and the options in the Metric field lists two options you can choose from:
Setting statistical parameters in the query involves 4 fields that you may set:
Operator - Operators are not applicable for the traces statistics. You need to select
Metric - The Metric field will display the appropriate metric parameters to select from.
Relation - After selecting the metric of choice from the displayed list of metrics in the Metric filed, you can choose the relation for the criteria to work on from the Relation field.
Value - Finally, fill in the value by which to filter in the Value field. After setting all the parameters in the respective fields. Click on the plus button to add more criteria.
These parameters allow you to order your list of traces according to the parameters set. Similar to the Statistical Filters, setting the operator you would like to sort by changes the metrics that you can choose from to sort by. The metrics to order by, are similar to that when setting statistical parameters. The final field allows you to choose whether you would like to sort it by ascending or descending order.
Click plus button to add more criteria.
If you have troubles while writing a query for your traces, you can take a look for the queries that we prepared for you. Click on the "Go to Cheat Sheet" link from query helper mode or manual mode to display example queries. If you want to filter your traces using one of these queries click on the play button next to the any query.
Here more example queries for you:
To bring the traces that have at least one cold started invocation:
HasColdStart=true ORDER BY StartTime DESC
To bring the traces that has the duration of more than a second (1000ms)
Duration > 1000 ORDER BY StartTime DESC
To combine two(or more) conditions together, you can use AND keyword. For example; the following query will return the traces that has at least one erroneous invocations and whose duration is more than 10 seconds. (10000ms)
HasError=trueAND Duration > 1000ORDER BY StartTime DESC