Explore your schema with InfluxQL
Limited availability
InfluxDB Clustered is currently 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.
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 Clustered database.
- List measurements in a database
- List field keys in a measurement
- List tag keys in a measurement
- List tag values for a specific tag key
List measurements in a database
Use SHOW MEASUREMENTS
to list measurements in your InfluxDB database.
SHOW MEASUREMENTS
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'
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/
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 database.
SHOW FIELD KEYS FROM home
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 database.
SHOW TAG KEYS FROM home_actions
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'
List tag values for a specific tag key
Use SHOW TAG VALUES
to return all values for specific tags in a measurement.
- Include a
FROMclause to specify one or more measurements to query. - Use the
WITHclause to compareKEYto tag keys to list the values of. - Use the
WHEREclause 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.
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")
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/
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
WITHclause to identify what tag keys to return values for. - Include a
WHEREclause 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'
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.