#!/bin/bash # Show top Grafana users by request count + their resource usage from Prometheus GRAFANA_URL="http://localhost:3000" PROM_URL="http://localhost:9090" echo "🔍 Fetching Grafana usage stats from Prometheus..." # Query Prometheus for top users by request count in last 5 minutes USERS=$(curl -s "${PROM_URL}/api/v1/query?query=topk(10,sum(rate(grafana_http_request_duration_seconds_count[5m])) by (user))" \ | jq -r '.data.result[] | "\(.metric.user) \(.value[1])"' | sort -k2 -nr) if [ -z "$USERS" ]; then echo "⚠️ No user data found. Make sure Grafana metrics are enabled and Prometheus is scraping Grafana." exit 1 fi echo -e "\n📊 Top 10 Grafana users by requests in last 5m:" echo "------------------------------------------" echo "$USERS" # Show CPU and memory usage of Grafana process (from node_exporter metrics) echo -e "\n⚡ Resource usage of Grafana (not per-user, but global):" CPU=$(curl -s "${PROM_URL}/api/v1/query?query=rate(process_cpu_seconds_total{job=\"grafana\"}[5m])" | jq -r '.data.result[0].value[1]') MEM=$(curl -s "${PROM_URL}/api/v1/query?query=process_resident_memory_bytes{job=\"grafana\"}" | jq -r '.data.result[0].value[1]') if [ -n "$CPU" ]; then echo " CPU Usage: $CPU cores" fi if [ -n "$MEM" ]; then echo " Memory Usage: $(echo "scale=2; $MEM/1024/1024" | bc) MB" fi echo -e "\n✅ Done!"