Prometheus TSDB - Revision history

Costa at 15:05, 2 October 2026

2026-10-02T15:05:18Z

← Older revision		Revision as of 15:05, 2 October 2026
Line 45:		Line 45:

	curl -X POST -g 'http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total'		curl -X POST -g 'http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total'

	n=1 ; for i in $(cat unused_metrics.txt); do echo "$((n++)) $i" ; curl -X POST -g "http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=$i" ; done		n=1 ; for i in $(cat unused_metrics.txt); do echo "$((n++)) $i" ; curl -X POST -g "http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=$i" ; done

	curl -X POST http://10.0.0.200/prometheus/api/v1/admin/tsdb/clean_tombstones		curl -X POST http://10.0.0.200/prometheus/api/v1/admin/tsdb/clean_tombstones
	</pre>		</pre>

Costa at 15:04, 2 October 2026

2026-10-02T15:04:17Z

← Older revision		Revision as of 15:04, 2 October 2026
Line 46:		Line 46:
	curl -X POST -g 'http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total'		curl -X POST -g 'http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total'

	n=1		n=1 ; for i in $(cat unused_metrics.txt); do echo "$((n++)) $i" ; curl -X POST -g "http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=$i" ; done
	for i in $(cat unused_metrics.txt); do
	echo "$((n++)) $i"
	curl -X POST -g "http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=$i"
	done

	curl -X POST http://10.0.0.200/prometheus/api/v1/admin/tsdb/clean_tombstones		curl -X POST http://10.0.0.200/prometheus/api/v1/admin/tsdb/clean_tombstones
	</pre>		</pre>

Costa at 15:01, 2 October 2026

2026-10-02T15:01:30Z

← Older revision		Revision as of 15:01, 2 October 2026
Line 28:		Line 28:

	For reverse proxy:		For reverse proxy:
			<pre>
	curl -H "Authorization: Bearer glsa_20cNpxZw8mXIqebza9wk7jcFKm3KfZFk_2efbc31a" \		curl -H "Authorization: Bearer glsa_20cNpxZw8mXIqebza9wk7jcFKm3KfZFk_2efbc31a" \
	http://10.0.0.200/grafana/api/dashboards/home		http://10.0.0.200/grafana/api/dashboards/home
Line 42:		Line 43:

	# Delete unused metrics		# Delete unused metrics

	curl -X POST -g 'http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total'		curl -X POST -g 'http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total'

Line 51:		Line 53:

	curl -X POST http://10.0.0.200/prometheus/api/v1/admin/tsdb/clean_tombstones		curl -X POST http://10.0.0.200/prometheus/api/v1/admin/tsdb/clean_tombstones
			</pre>

Costa at 14:51, 2 October 2026

2026-10-02T14:51:23Z

← Older revision		Revision as of 14:51, 2 October 2026
Line 26:		Line 26:
	n=1 ; for i in `cat unused_metrics.txt`; do echo "$((n++)) $i" ; curl -X POST -g 'http://10.0.0.200:30900/api/v1/admin/tsdb/delete_series?match[]='$i ; done		n=1 ; for i in `cat unused_metrics.txt`; do echo "$((n++)) $i" ; curl -X POST -g 'http://10.0.0.200:30900/api/v1/admin/tsdb/delete_series?match[]='$i ; done
	curl -XPOST 'http://10.0.0.200:30900/api/v1/admin/tsdb/clean_tombstones'		curl -XPOST 'http://10.0.0.200:30900/api/v1/admin/tsdb/clean_tombstones'

			For reverse proxy:
			curl -H "Authorization: Bearer glsa_20cNpxZw8mXIqebza9wk7jcFKm3KfZFk_2efbc31a" \
			http://10.0.0.200/grafana/api/dashboards/home

			mimirtool analyze grafana \
			--address=http://10.0.0.200/grafana \
			--key="glsa_20cNpxZw8mXIqebza9wk7jcFKm3KfZFk_2efbc31a"

			mimirtool analyze prometheus \
			--address=http://10.0.0.200/prometheus

			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/prometheus/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total'

			n=1
			for i in $(cat unused_metrics.txt); do
			echo "$((n++)) $i"
			curl -X POST -g "http://10.0.0.200/prometheus/api/v1/admin/tsdb/delete_series?match[]=$i"
			done

			curl -X POST http://10.0.0.200/prometheus/api/v1/admin/tsdb/clean_tombstones

10.0.0.22 at 08:56, 15 May 2026

2026-05-15T08:56:42Z

← Older revision		Revision as of 08:56, 15 May 2026
Line 23:		Line 23:

	Delete unused metrics		Delete unused metrics
	curl -X POST -g http://10.0.0.200:30900/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total		<e.g.> 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		n=1 ; for i in `cat unused_metrics.txt`; do echo "$((n++)) $i" ; curl -X POST -g 'http://10.0.0.200:30900/api/v1/admin/tsdb/delete_series?match[]='$i ; done
	curl -XPOST 'http://10.0.0.200:30900/api/v1/admin/tsdb/clean_tombstones'		curl -XPOST 'http://10.0.0.200:30900/api/v1/admin/tsdb/clean_tombstones'

10.0.0.22 at 06:55, 15 May 2026

2026-05-15T06:55:51Z

← Older revision		Revision as of 06:55, 15 May 2026
Line 7:		Line 7:

	;Find all unused metrics		;Find all unused metrics
			mimirtool installation
			curl -L -o mimirtool https://github.com/grafana/mimir/releases/latest/download/mimirtool-linux-amd64
			chmod +x mimirtool
			sudo mv mimirtool /usr/local/bin/mimirtool

	Grafana token		Grafana token
	glsa_20cNpxZw8mXIqebza9wk7jcFKm3KfZFk_2efbc31a		glsa_20cNpxZw8mXIqebza9wk7jcFKm3KfZFk_2efbc31a

10.0.0.22 at 06:43, 15 May 2026

2026-05-15T06:43:25Z

← Older revision		Revision as of 06:43, 15 May 2026
Line 8:		Line 8:
	;Find all unused metrics		;Find all unused metrics
	Grafana token		Grafana token
	~~eyJrIjoibzQ4R3I5Mm9FcUMwOFZPNzdpWEtnNEl5ZU1IVkYyUG4iLCJuIjoibWltaXItdG9rZW4iLCJpZCI6MX0=~~		glsa_20cNpxZw8mXIqebza9wk7jcFKm3KfZFk_2efbc31a

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

	mimirtool analyze grafana --address=http://10.0.0.200:30725 --key="~~eyJrIjoibzQ4R3I5Mm9FcUMwOFZPNzdpWEtnNEl5ZU1IVkYyUG4iLCJuIjoibWltaXItdG9rZW4iLCJpZCI6MX0=~~"		mimirtool analyze grafana --address=http://10.0.0.200:30725 --key="glsa_20cNpxZw8mXIqebza9wk7jcFKm3KfZFk_2efbc31a"
	mimirtool analyze prometheus --address=http://10.0.0.200:30900		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 ".in_use_metric_counts[].metric" prometheus-metrics.json \| sort > used_metrics.txt

10.0.0.200 at 06:22, 23 March 2025

2025-03-23T06:22:44Z

← Older revision		Revision as of 06:22, 23 March 2025
Line 19:		Line 19:
	Delete unused metrics		Delete unused metrics
	curl -X POST -g http://10.0.0.200:30900/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total		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		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
	curl -XPOST 'http://10.0.0.200:30900/api/v1/admin/tsdb/clean_tombstones'		curl -XPOST 'http://10.0.0.200:30900/api/v1/admin/tsdb/clean_tombstones'

10.0.0.200 at 14:29, 9 January 2025

2025-01-09T14:29:28Z

← Older revision		Revision as of 14:29, 9 January 2025
Line 19:		Line 19:
	Delete unused metrics		Delete unused metrics
	curl -X POST -g http://10.0.0.200:30900/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total		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		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
	curl -XPOST 'http://10.0.0.200:30900/api/v1/admin/tsdb/clean_tombstones'		curl -XPOST 'http://10.0.0.200:30900/api/v1/admin/tsdb/clean_tombstones'

10.0.0.200 at 14:28, 9 January 2025

2025-01-09T14:28:40Z

← Older revision		Revision as of 14:28, 9 January 2025
Line 19:		Line 19:
	Delete unused metrics		Delete unused metrics
	curl -X POST -g http://10.0.0.200:30900/api/v1/admin/tsdb/delete_series?match[]=workqueue_adds_total		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		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
	curl -XPOST 'http://10.0.0.200:30900/api/v1/admin/tsdb/clean_tombstones'		curl -XPOST 'http://10.0.0.200:30900/api/v1/admin/tsdb/clean_tombstones'