Documentation

Explore your schema with InfluxQL

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

Sample data

The following examples use data provided in sample data sets. To run the example queries and return identical results, follow the instructions provided for each sample data set to write the data to your InfluxDB Cloud Serverless bucket.

List measurements in a bucket

Use SHOW MEASUREMENTS to list measurements in your InfluxDB bucket.

SHOW MEASUREMENTS

View example output

List measurements that contain specific tag key-value pairs

To return only measurements with specific tag key-value pairs, include a WHERE clause with tag key-value pairs to query for.

SHOW MEASUREMENTS WHERE room = 'Kitchen'

View example output

List measurements that match a regular expression

To return only measurements with names that match a regular expression, include a WITH clause that compares the MEASUREMENT to a regular expression.

SHOW MEASUREMENTS WITH MEASUREMENT =~ /^home/

View example output

List field keys in a measurement

Use SHOW FIELD KEYS to return all field keys in a measurement. Include a FROM clause to specify the measurement. If no measurement is specified, the query returns all field keys in the bucket.

SHOW FIELD KEYS FROM home

View example output

List tag keys in a measurement

Use SHOW TAG KEYS to return all tag keys in a measurement. Include a FROM clause to specify the measurement. If no measurement is specified, the query returns all tag keys in the bucket.

SHOW TAG KEYS FROM home_actions

View example output

List tag keys in measurements that contain a specific tag key-value pair

To return all tag keys measurements that contain specific tag key-value pairs, include a WHERE clause with the tag key-value pairs to query for.

SHOW TAG KEYS WHERE room = 'Kitchen'

View example output

List tag values for a specific tag key

Use SHOW TAG VALUES to return all values for specific tags in a measurement.

  • Include a FROM clause to specify one or more measurements to query.
  • Use the WITH clause to compare KEY to tag keys to list the values of.
  • Use the WHERE clause to restrict the search to a specific time range (default time range is the last day).
SHOW TAG VALUES FROM weather WITH KEY = location

Include a FROM clause

We strongly recommend including a FROM clause with the SHOW TAG VALUES statement that specifies 1-50 tables to query. Without a FROM clause, the InfluxDB query engine must read data from all tables and return unique tag values from each.

Depending on the number of tables in your database and the number of unique tag values in each table, excluding a FROM clause can result in poor query performance, query timeouts, or unnecessary resource allocation that may affect other queries.

View example output

List tag values for multiple tags

To return tag values for multiple specific tag keys, use the IN operator in the WITH clause to compare KEY to a list of tag keys.

SHOW TAG VALUES FROM home_actions WITH KEY IN ("level", "action")

View example output

List tag values for tags that match a regular expression

To return only tag values from tags keys that match a regular expression, use regular expression comparison operators in your WITH clause to compare KEY to the regular expression.

SHOW TAG VALUES FROM home, home_actions WITH KEY =~ /oo/

View example output

List tag values associated with a specific tag key-value pair

To list tag values for tags associated with a specific tag key-value pair:

  • Use the WITH clause to identify what tag keys to return values for.
  • Include a WHERE clause that identifies the tag key-value pair to query for.

The following example returns tag values for the action and level tags for points where the room tag value is Kitchen.

SHOW TAG VALUES FROM home_actions WITH KEY IN ("action", "level") WHERE room = 'Kitchen'

View example output


Was this page helpful?

Thank you for your feedback!


Introducing InfluxDB Clustered

A highly available InfluxDB 3.0 cluster on your own infrastructure.

InfluxDB Clustered is a highly available InfluxDB 3.0 cluster built for high write and query workloads on your own infrastructure.

InfluxDB Clustered is currently in limited availability and is only available to a limited group of InfluxData customers. If interested in being part of the limited access group, please contact the InfluxData Sales team.

Learn more
Contact InfluxData Sales

The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Flux is going into maintenance mode and will not be supported in InfluxDB 3.0. This was a decision based on the broad demand for SQL and the continued growth and adoption of InfluxQL. We are continuing to support Flux for users in 1.x and 2.x so you can continue using it with no changes to your code. If you are interested in transitioning to InfluxDB 3.0 and want to future-proof your code, we suggest using InfluxQL.

For information about the future of Flux, see the following:

InfluxDB Cloud Serverless