high_cardinality_metrics.py

from atsd_client import connect, connect_url
from atsd_client.services import MetricsService

'''
Locate metrics with series that have too many tags.
Print out metric name and the maximum number of tags combinations.
'''

# Connect to ATSD server
#connection = connect('/path/to/connection.properties')
connection = connect_url('https://atsd_hostname:8443', 'username', 'password')

# Initialize services
metrics_service = MetricsService(connection)

# query all metrics that have last_insert_date, i.e. series
metrics = metrics_service.list(min_insert_date="1970-01-01T00:00:00.000Z")

# set cardinality
cardinality = 10
metric_count = 0

print('metric,maximum number of tags')
for metric in metrics:
    # query series list for each metric
    series_list = metrics_service.series(metric)
    max_tags = -1
    for s in series_list:
        # check tags cardinality for each series in list
        tags_count = len(s.tags)
        if tags_count > cardinality and tags_count > max_tags:
            max_tags = tags_count
    if max_tags > -1:
        metric_count += 1
        print('%s,%d' % (metric.name, max_tags))

print("Number of metrics that have more than %d tag combinations is %d " % (cardinality, metric_count))