bulk querying Thanos for cpu frequency <= 200 MHz in the past month
ActivePublic
Actions

Authored by CDanis on Aug 25 2023, 4:46 PM.

Tags

None

Referenced Files

	F37630566: raw-paste-data.txt
	Aug 25 2023, 4:57 PM

	F37630550: raw-paste-data.txt
	Aug 25 2023, 4:46 PM

Subscribers

None

	❌cdanis@thanos-fe1001.eqiad.wmnet ~ 🕛☕ for N in `seq 30 -2 2` ; do end=$(date -d "$(( $N-2 )) day ago" +%s) ; start=$(date -d "$N day ago" +%s) ; curl http://thanos-query.svc.eqiad.wmnet/api/v1/query_range --data-urlencode 'query=node_cpu_scaling_frequency_hertz<=400e6' --data-urlencode "start=$start" --data-urlencode "end=$end" --data-urlencode step=30s ;echo ; done
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}



	❌cdanis@thanos-fe2001.codfw.wmnet ~ 🕧☕ for N in `seq 30 -2 2` ; do end=$(date -d "$(( $N-2 )) day ago" +%s) ; start=$(date -d "$N day ago" +%s) ; curl http://thanos-query.svc.codfw.wmnet/api/v1/query_range --data-urlencode 'query=node_cpu_frequency_hertz <= 200e6' --data-urlencode "start=$start" --data-urlencode "end=$end" --data-urlencode step=30s ; echo ; done
	{"status":"success","data":{"resultType":"matrix","result":[{"metric":{"__name__":"node_cpu_frequency_hertz","cluster":"jobrunner","cpu":"29","instance":"mw2419:9100","job":"node","prometheus":"ops","site":"codfw"},"values":[[1690393800,"179234000"],[1690393830,"179234000"]]}]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[{"metric":{"__name__":"node_cpu_frequency_hertz","cluster":"jobrunner","cpu":"43","instance":"mw2353:9100","job":"node","prometheus":"ops","site":"codfw"},"values":[[1690742310,"32710000"],[1690742340,"32710000"]]}]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[{"metric":{"__name__":"node_cpu_frequency_hertz","cluster":"analytics","cpu":"26","instance":"stat1006:9100","job":"node","prometheus":"ops","site":"eqiad"},"values":[[1691381160,"44165000"],[1691381190,"44165000"]]},{"metric":{"__name__":"node_cpu_frequency_hertz","cluster":"jobrunner","cpu":"29","instance":"mw2410:9100","job":"node","prometheus":"ops","site":"codfw"},"values":[[1691306790,"37842000"],[1691306820,"37842000"]]}]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[{"metric":{"__name__":"node_cpu_frequency_hertz","cluster":"jobrunner","cpu":"37","instance":"mw2410:9100","job":"node","prometheus":"ops","site":"codfw"},"values":[[1692255390,"29787000"],[1692255420,"29787000"]]}]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[]}}
	{"status":"success","data":{"resultType":"matrix","result":[{"metric":{"__name__":"node_cpu_frequency_hertz","cluster":"jobrunner","cpu":"37","instance":"mw2411:9100","job":"node","prometheus":"ops","site":"codfw"},"values":[[1692853560,"25629000"],[1692853590,"25629000"]]},{"metric":{"__name__":"node_cpu_frequency_hertz","cluster":"jobrunner","cpu":"41","instance":"mw2411:9100","job":"node","prometheus":"ops","site":"codfw"},"values":[[1692909720,"26935000"],[1692909750,"26935000"]]},{"metric":{"__name__":"node_cpu_frequency_hertz","cluster":"jobrunner","cpu":"8","instance":"mw2382:9100","job":"node","prometheus":"ops","site":"codfw"},"values":[[1692909600,"57717000"],[1692909630,"57717000"]]}]}}

Event Timeline

CDanis created this paste.Aug 25 2023, 4:46 PM

CDanis edited the content of this paste. (Show Details)Aug 25 2023, 4:57 PM

CDanis mentioned this in T163220: Add Icinga check for CPU frequency on Dell R320.Aug 25 2023, 4:59 PM

CDanis changed the title of this paste from untitled to bulk querying Thanos for cpu frequency <= 200 MHz in the past month.

bulk querying Thanos for cpu frequency <= 200 MHz in the past monthActivePublicActions

Event Timeline

bulk querying Thanos for cpu frequency <= 200 MHz in the past month
ActivePublic
Actions