Aiven for Grafana

# Request rate
rate(http_requests_total[5m])

# Response time percentiles
histogram_quantile(0.95, 
  rate(http_request_duration_seconds_bucket[5m])
)

# Error rate
rate(http_requests_total{status=~"5.."}[5m])
/ rate(http_requests_total[5m])

# CPU usage
100 - (avg by (instance) (rate(node_cpu_seconds_total{mode="idle"}[5m])) * 100)

-- Daily revenue
SELECT
  DATE(order_time) as date,
  SUM(order_total) as revenue
FROM orders
WHERE $__timeFilter(order_time)
GROUP BY date
ORDER BY date

-- Active users
SELECT
  $__timeGroupAlias(login_time, 1h),
  COUNT(DISTINCT user_id) as active_users
FROM user_sessions
WHERE $__timeFilter(login_time)
GROUP BY 1

-- Conversion rate
SELECT
  date,
  (purchases::float / visitors) * 100 as conversion_rate
FROM daily_stats
WHERE $__timeFilter(date)

// OpenSearch query for errors
{
  "query": {
    "bool": {
      "must": [
        {"match": {"level": "error"}},
        {"range": {"@timestamp": {"gte": "$__from", "lte": "$__to"}}}
      ]
    }
  },
  "aggs": {
    "errors_over_time": {
      "date_histogram": {
        "field": "@timestamp",
        "interval": "$__interval"
      }
    }
  }
}