Documentation Grafana documentation Data sources InfluxDB Query editor

InfluxDB query editor

Grafana’s query editors are unique to each data source. For general information on Grafana query editors, refer to Query editors. For general information on querying data sources in Grafana, refer to Query and transform data.

The InfluxDB query editor is located on the Explore page. You can also access the InfluxDB query editor from a dashboard panel. Click the ellipsis in the upper right of the panel and select Edit.

You can also use the query editor to retrieve log data and annotate visualizations.

Choose a query editing mode

The InfluxDB data source has three different types of query editors, each corresponding to the query language selected in the data source configuration:

• InfluxQL
• SQL
• Flux

Editor options vary based on query language.

InfluxQL query editor

The InfluxQL query editor helps you select metrics and tags to create InfluxQL queries. There are two modes: visual editor mode and raw query mode. To switch between the two modes click the pencil icon in the upper right.

Visual query editor mode contains the following components:

• FROM - Select a measurement to query.
• WHERE - Select filters by clicking the + sign.
• SELECT - Select fields and functions from the drop-down. You can add multiple fields and functions by clicking the + sign.
• GROUP BY - Select a tag from the drop-down menu.
• TIMEZONE - Optional Group data by a specific timezone.
• ORDER BY TIME - Sort data by time in either ascending or descending order.
• LIMIT - Optional Limits the number of rows returned by the query.
• SLIMIT - Optional Limits the number of series returned by the query. Refer to SLIMIT clause for more information on this option.
• FORMAT AS - Select a format option from the drop-down menu.
• ALIAS - Add an alias. Refer to Alias patterns for more information.

Raw query editor mode

You can write raw InfluxQL queries by switching to raw query mode. Click the pencil in the upper right of the query editor to switch modes. Note that when you switch to visual editor mode, you will lose any changes made in raw query mode.

If you use raw query mode, your query must include WHERE $timeFilter. You should also provide a group by time and an aggregation function. Otherwise, InfluxDB may return hundreds of thousands of data points, potentially causing your browser to hang.

Match by regular expressions

You can enter regular expressions for metric names or tag filter values. Wrap the regex pattern in forward slashes (/), as shown in this example: /measurement/.

Grafana automatically adjusts the filter tag condition to use the InfluxDB regex match condition operator (=~).

Field and aggregation functions

In the SELECT row, you can specify which fields and functions to use.

If you group by time you must use an aggregation function. Certain functions such as derivative also require an aggregation function.

If you have the following:

The query editor input generates an InfluxDB SELECT clause:

sql Copy

SELECT derivative(mean("value"), 10s) / 10 AS "REQ/s"
FROM....

You can also use a * in a SELECT statement to select all fields.

sql Copy

SELECT * FROM <measurement_name>

GROUP BY results

To group results by a tag, specify the tag in the GROUP BY row:

1. Click the + sign in the GROUP BY row.
2. Select a tag from the drop-down.

You can GROUP BY multiple options.

To remove a GROUP BY option click the X icon next to the option.

Alias patterns

You can also use the [[tag_hostname]] pattern replacement syntax.

For example, entering the value Host: [[tag_hostname]] in the ALIAS BY field replaces it with the hostname tag value for each legend value.

An example legend value is Host: server1.

SQL query editor

Grafana supports the SQL query language in InfluxDB v3.0 and higher.

You construct your SQL query directly in the query editor.

Macros

You can use macros in your query to automatically substitute them with values from Grafana’s context.

Examples:

Copy

// with macro
1. SELECT * FROM cpu WHERE time >= $__timeFrom AND time <= $__timeTo
2. SELECT * FROM cpu WHERE $__timeFilter(time)
3. SELECT $__dateBin(time) from cpu

// interpolated
1. SELECT * FROM iox.cpu WHERE time >= cast('2023-12-15T12:38:30Z' as timestamp) AND time <= cast('2023-12-15T18:38:30Z' as timestamp)
2. SELECT * FROM cpu WHERE time >= '2023-12-15T12:41:28Z' AND time <= '2023-12-15T18:41:28Z'
3. SELECT date_bin(interval '15 second', time, timestamp '1970-01-01T00:00:00Z') from cpu

Flux query editor

Grafana supports Flux when running InfluxDB v1.8 and higher. If your data source is configured for Flux, you can use the Flux in the query editor, which serves as a text editor for raw Flux queries with macro support.

For more information and connection details, refer to InfluxDB 1.8 API compatibility.

Use macros

You can enter macros in the query to replace them with values from Grafana’s context. Macros support copying and pasting from Chronograf.

For example, consider the following Flux query:

flux Copy

from(bucket: v.defaultBucket)
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "cpu" or r["_measurement"] == "swap")
  |> filter(fn: (r) => r["_field"] == "usage_system" or r["_field"] == "free")
  |> aggregateWindow(every: v.windowPeriod, fn: mean)
  |> yield(name: "mean")

This Flux query is interpolated into the following query and sent to InfluxDB, with the interval and time period values changing according to the active time selection:

flux Copy

from(bucket: "grafana")
  |> range(start: 2020-06-11T13:59:07Z, stop: 2020-06-11T14:59:07Z)
  |> filter(fn: (r) => r["_measurement"] == "cpu" or r["_measurement"] == "swap")
  |> filter(fn: (r) => r["_field"] == "usage_system" or r["_field"] == "free")
  |> aggregateWindow(every: 2s, fn: mean)
  |> yield(name: "mean")

To view the interpolated version of a query with the Query inspector, refer to Panel Inspector.

Query logs

You can query and display log data from InfluxDB in Explore and in the dashboard Logs panel.

Select an InfluxDB data source in the Query editor. Under the Select measurement field next to the FROM section, choose a measurement containing your log data, then choose the appropriate fields that will display the log message. Add any additional filters by clicking the + sign next to the WHERE field. Add additional conditions in the GROUP BY, ORDER BY and the rest of the options.

After InfluxDB returns the results, the log panel displays log rows along with a bar chart. The x-axis represents time, while the y-axis shows the frequency or count.

Apply annotations

Annotations overlay rich event information on top of graphs. You can add annotation queries in the dashboard menu’s Annotations view.

For InfluxDB, your query must include WHERE $timeFilter.

If you select only one column, you don’t need to enter anything in the column mapping fields.

The Tags field’s value can be a comma-separated string.

Annotation query example

sql Copy

SELECT title, description
from events
WHERE $timeFilter
ORDER BY time ASC