Prometheus TSDB

Oldest record in Prometheus

cd /home/costa/data/prometheus-data ;grep -r minTime --include meta.json | awk '{print $3}' | sort | head -n1 | rev| cut -c5- | rev | { read gmt ; date -d "@$gmt" ; }

snapshot https://gist.github.com/ksingh7/d5e4414d92241e0802e59fa4c585b98b

How to drop and delete metrics in Prometheus https://faun.pub/how-to-drop-and-delete-metrics-in-prometheus-7f5e6911fb33

Find all unused metrics

Grafana token

eyJrIjoibzQ4R3I5Mm9FcUMwOFZPNzdpWEtnNEl5ZU1IVkYyUG4iLCJuIjoibWltaXItdG9rZW4iLCJpZCI6MX0=

curl -H "Authorization: Bearer eyJrIjoibzQ4R3I5Mm9FcUMwOFZPNzdpWEtnNEl5ZU1IVkYyUG4iLCJuIjoibWltaXItdG9rZW4iLCJpZCI6MX0=" http://10.0.0.200:30725/api/dashboards/home

mimirtool analyze grafana --address=http://10.0.0.200:30725 --key="eyJrIjoibzQ4R3I5Mm9FcUMwOFZPNzdpWEtnNEl5ZU1IVkYyUG4iLCJuIjoibWltaXItdG9rZW4iLCJpZCI6MX0="
mimirtool analyze prometheus --address=http://10.0.0.200:30900
jq -r ".in_use_metric_counts[].metric" prometheus-metrics.json | sort > used_metrics.txt
jq -r ".additional_metric_counts[].metric" prometheus-metrics.json | sort > unused_metrics.txt

Delete unused metrics

curl -X POST -g http://10.0.0.200:30900/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total
for i in `cat unused_metrics.txt`; do curl -X POST -g 'http://10.0.0.200:30900/api/v1/admin/tsdb/delete_series?match[]='$i ; done