Explore your schema with InfluxQL

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

• List measurements in a database
  • List measurements that contain specific tag key-value pairs
  • List measurements that match a regular expression
• List field keys in a measurement
• List tag keys in a measurement
  • List tag keys in measurements that contain a specific tag key-value pair
• List tag values for a specific tag key
  • List tag values for multiple tags
  • List tag values for tags that match a regular expression
  • List tag values associated with a specific tag key-value pair

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 FROM clause to specify the measurement. If no measurement is specified, the query returns all tag values from the specified tag keys in the database.
• 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 current time minus 1 day).

SHOW TAG VALUES FROM weather WITH KEY = location

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 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 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 WITH KEY IN ("action", "level") WHERE room = 'Kitchen'