When compared to a other database types, a measurement in Influx can be considered, on a very high level, as being similar to a table in relational databases or a collection in document databases.
List all measurements for the currently active database:
$ show measurements
Lists all measurements for a particular database:
$ show measurements on <database_name>
Example result:
$ show measurements on devices
name: measurements
name
----
health
location
network
usage
Remarks:
The syntax also supports clauses like WITH
, WHERE
, LIMIT
and OFFSET
. In-depth information about this can be found in the API docs 'Show Measurements'.