Limit And Slimit - Influxdb

Use LIMIT to limit the number of rows returned per InfluxQL group. Use SLIMIT to limit the number of series returned in query results.

LIMIT clause
- Syntax
- Examples
SLIMIT clause

LIMIT clause

The LIMIT clause limits the number of rows to return from each InfluxQL group. If the query doesn't include a GROUP BY clause, the entire result set is considered a single group. If a query groups data by time, limits are applied after aggregate and selector operations are applied to each time window.

Syntax {#limit-syntax}

sql

SELECT_clause FROM_clause [WHERE_clause] [GROUP_BY_clause] [ORDER_BY_clause] LIMIT N

Arguments

N: Maximum number of points to return from each InfluxQL group. If N is greater than the number of points in a group, all points from the group are returned.

Examples {#limit-examples}

The following examples use the Home sensor sample data.

sql

SELECT * FROM home LIMIT 3

{{% influxql/table-meta %}} Name: home {{% /influxql/table-meta %}}

time	hum	room	temp
2022-01-01T08:00:00Z	35.9	Kitchen	21
2022-01-01T08:00:00Z	35.9	Living Room	21.1
2022-01-01T09:00:00Z	36.2	Kitchen	23

{{% expand "Limit the number of rows returned from each InfluxQL group" %}}

sql

SELECT
  MEAN(*)
FROM home
GROUP BY
  time(2h),
  room
LIMIT 3

{{% influxdb/custom-timestamps %}} {{% influxql/table-meta %}} name: home
tags: room=Kitchen {{% /influxql/table-meta %}}

time	mean_co	mean_hum	mean_temp
2022-01-01T08:00:00Z	0	36.05	22
2022-01-01T10:00:00Z	0	36.05	22.549999999999997
2022-01-01T12:00:00Z	0.5	36.25	22.65

{{% influxql/table-meta %}} name: home
tags: room=Living Room {{% /influxql/table-meta %}}

time	mean_hum	mean_temp
2022-01-01T08:00:00Z	35.9	21.25
2022-01-01T10:00:00Z	36	22
2022-01-01T12:00:00Z	35.95	22.299999999999997

SLIMIT clause

[!Important] InfluxQL is being rearchitected to work with the InfluxDB 3 storage engine. This process is ongoing and some InfluxQL features, such as SLIMIT are still being implemented. For more information, see InfluxQL feature support.