Query data with InfluxQL

Explore your schema with InfluxQL

Use InfluxQL SHOW statements to return information about your data schema.

List measurements

SHOW MEASUREMENTS

List field keys in a measurement

SHOW FIELD KEYS FROM "measurement"

List tag keys in a measurement

SHOW TAG KEYS FROM "measurement"

List tag values for a specific tag key

SHOW TAG VALUES FROM "measurement" WITH KEY = "tag-key" WHERE time > now() - 1d

Read more

Perform a basic InfluxQL query

A basic InfluxQL query that queries data from InfluxDB most commonly includes SELECT, FROM, and WHERE clauses.

SELECT temp, room FROM home WHERE time >= now() - 1d

Read more

Aggregate data with InfluxQL

Use InfluxQL aggregate and selector functions to perform aggregate operations on your time series data.

Aggregate fields by groups

SELECT
  MEAN(temp) AS mean,
  FIRST(hum) as first,
FROM home
GROUP BY tag

Aggregate by time-based intervals

SELECT
  MEAN(temp),
  sum(hum),
FROM home
WHERE time >= now() - 24h
GROUP BY time(1h),room

Read more

Troubleshoot InfluxQL errors

Learn how to troubleshoot and fix common InfluxQL errors.

Use parameterized queries with InfluxQL

Use parameterized queries to prevent injection attacks and make queries more reusable.

SELECT * FROM home
WHERE time >= $min_time
  AND temp >= $min_temp
  AND room = $room

Read more