FuseQL is a new query language to perform analytics on log events. It is meant to be a drop-in replacement for Grafana’s logQL support in Kloudfuse. In addition, it also supports more advanced operators such as anomaly detection, outlier detection, forecasting and several arithmetic and trigonometric operators.

Users can switch between FuseQL and logQL with a toggle button on the log analytics page.

Query Builder

Log Filters

To filter out logs that you want to run your analytics query on, click (Search logs). If no filters are specified, FuseQL will consider all log lines.

Aggregations

Once the log filters have been added, you can apply an aggregation operator on the log lines. By default, FuseQL will display the count of all log lines that match the filter conditions.

For more information on various supported aggregation operators, refer to Aggregation Operators.

Groups

FuseQL also supports grouping of log lines by label and facets. Click on the by dropdown to add group by fields to your aggregation operators. By default, FuseQL groups by time buckets, and by collapsing all other labels.

Limit To

By default, FuseQL limits the resulting time series values to the top 10. This can be changed by editing the dropdown.

Roll Up

FuseQL aggregates data by roll up time period (for example, five seconds). The roll up value is auto-selected by the user-selected time range, but can be edited if needed. Editing the roll up will change the number of bucketed results you see in the visualization.

Below is an example of using a 1m roll up in a time range of 5m resulting in 5 buckets.

Functions

FuseQL supports various functions - you can choose any of the available functions by clicking on ∑ button. The list of functions supported can be broadly classified into the following three categories:

Add Query

To add a query, click (Add Query). Notice that a new query (B) appears under query (A), and it is a duplicate.

Add Formula

FuseQL also supports formulas by applying various mathematical operators on a set of queries. Currently we support the following mathematical operators:

Addition (+)
Subtraction/Difference (-)
Multiplication/Product (*)
Division (/)
Modulo (%)
Pow (^)

Each query can have its own set of filters and aggregation operators.

The screenshot below shows an example of counting all log lines with levels info, warn and error.

Formulas are currently not supported with any advanced functions or math operators. You can only use log filters and aggregation operators with formulas.