Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 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.

Info

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

For some of the common use cases on how to use log analytics with FuseQL, refer to the cheatsheet page.

Query Builder

...

Log Filters

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

...

Add Query

To add a another query, click image-20241107-220237.png (Add Query). Notice that a new query image-20241107-220454.png (B) appears under query image-20241107-220509.png (A), and it is a duplicate.

...

Add Formula

FuseQL also supports formulas by applying various mathematical operators on a set of queries. Currently following mathematical operators are supported:

  • 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.

...

Note

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

Visualizations

FuseQL supports four different visualization types. The default visualization is Time Series.

...

Use Time Series Visualization when you want to analyze trends, patterns, and behaviors over in buckets spanning the selected time range.

...

Top List

...

Table

...

Pie Chart

...

Algorithms

Anomalies

Overlay a band on the metric, showing the expected behavior of a series based on past values.

Outliers

Highlight outliers series.

Forecast

Forecast future values based on past values.Use Top List when you want to quickly identify and compare the highest-ranking groups within the selected time range.

...

Table

Use Table when you need a detailed, row-by-row summary of your data for deeper comparison and analysis within the selected time range.

...

Pie Chart

Use Pie Chart when you want to visualize the relative proportions of different groups within your data in the selected time range.

...