User Statistics

The user statistics endpoint provides per-user breakdowns of query activity, helping administrators identify power users, quota consumers, and users who may need training.

Endpoint

GET /v1/analytics/users

curl "http://query-engine:8080/v1/analytics/users?days=7" \
  -H "Authorization: Bearer $JWT_TOKEN"

[
  {
    "userId": "6ba7b810-9dad-11d1-80b4-00c04fd430c8",
    "queryCount": 450,
    "successRate": 0.96,
    "avgLatencyMs": 2100,
    "totalBytesScanned": 2199023255552,
    "cacheHitRate": 0.38,
    "favoriteEngine": "TRINO",
    "lastQueryAt": "2026-02-12T10:15:00Z"
  },
  {
    "userId": "7cb8c920-aebe-22e2-91c5-11d05fe541d9",
    "queryCount": 280,
    "successRate": 0.89,
    "avgLatencyMs": 4500,
    "totalBytesScanned": 1099511627776,
    "cacheHitRate": 0.22,
    "favoriteEngine": "TRINO",
    "lastQueryAt": "2026-02-12T09:30:00Z"
  }
]

Use Cases

Quota management: Identify users consuming disproportionate resources
Training: Users with low success rates may benefit from SQL training
Cache optimization: Users with low cache hit rates may be writing variable queries that resist caching
Cost allocation: Attribute compute costs to specific users

Engine Statistics Time Series