Skip to content

Instantly share code, notes, and snippets.

@dictvm

dictvm/influxdb_series_per_measurement.sh

Forked from endeepak/influxdb_measurement_series_count_per_measurement.sh
Last active December 20, 2018 10:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dictvm/96d2136cd1eb566ab41d16caa2a49783 to your computer and use it in GitHub Desktop.
Save dictvm/96d2136cd1eb566ab41d16caa2a49783 to your computer and use it in GitHub Desktop.
Download ZIP
Influxdb : Print cardinality / series count per measurement
Raw
influxdb_series_per_measurement.sh
#!/usr/bin/env sh
if [ "$#" -ne 1 ]
then
echo "Usage: $0 <db_name>"
exit 1
fi
db_name=$1
measurement_names=$(influx -database $db_name -execute 'SHOW MEASUREMENTS' | tail -n +4)
for measurement_name in $measurement_names; do
number_of_series=$(influx -database $db_name -execute "SHOW SERIES FROM \"$measurement_name\"" | tail -n +3 | wc -l)
echo "$measurement_name $number_of_series"
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment