Influxdb : Print cardinality / series count per measurement

influxdb_measurement_series_count_per_measurement.sh

#!/usr/bin/env bash

if [ "$#" -ne 1 ]
then
  echo "Usage: $0 <db_name>"
  exit 1
fi

db_name=$1

meaurement_names=$(influx -database $db_name -execute 'SHOW MEASUREMENTS' | tail -n +4)
for meaurement_name in $meaurement_names; do
  number_of_series=$(influx -database $db_name -execute "SHOW SERIES FROM \"$meaurement_name\"" | tail -n +3 | wc -l)
  echo "$meaurement_name $number_of_series"
done