Usage Monitoring

Daily Active Users & Sessions

SELECT
  DATE(recorded_at) AS day,
  COUNT(DISTINCT labels->>'user.account_uuid') AS dau,
  SUM(value)::int AS sessions
FROM otel_metrics
WHERE metric_name = 'claude_code.session.count'
GROUP BY DATE(recorded_at)
ORDER BY day DESC
LIMIT 30;

Lines of Code by User

SELECT
  labels->>'user.email' AS email,
  SUM(CASE WHEN labels->>'type' = 'added' THEN value ELSE 0 END)::int AS lines_added,
  SUM(CASE WHEN labels->>'type' = 'removed' THEN value ELSE 0 END)::int AS lines_removed
FROM otel_metrics
WHERE metric_name = 'claude_code.lines_of_code.count'
GROUP BY labels->>'user.email'
ORDER BY lines_added DESC;

Commits & PRs by User

SELECT
  labels->>'user.email' AS email,
  SUM(CASE WHEN metric_name = 'claude_code.commit.count' THEN value ELSE 0 END)::int AS commits,
  SUM(CASE WHEN metric_name = 'claude_code.pull_request.count' THEN value ELSE 0 END)::int AS prs
FROM otel_metrics
WHERE metric_name IN ('claude_code.commit.count', 'claude_code.pull_request.count')
GROUP BY labels->>'user.email'
ORDER BY commits DESC;

Tool Usage Breakdown

SELECT
  attributes->>'tool_name' AS tool,
  COUNT(*)::int AS calls,
  COUNT(*) FILTER (WHERE (attributes->>'success')::boolean) AS successes,
  ROUND(AVG((attributes->>'duration_ms')::float)::numeric, 1) AS avg_ms
FROM otel_events
WHERE event_name = 'claude_code.tool_result'
GROUP BY attributes->>'tool_name'
ORDER BY calls DESC;

Active Time by User

SELECT
  labels->>'user.email' AS email,
  SUM(CASE WHEN labels->>'type' = 'user' THEN value ELSE 0 END)::int AS user_time_sec,
  SUM(CASE WHEN labels->>'type' = 'cli' THEN value ELSE 0 END)::int AS cli_time_sec,
  SUM(value)::int AS total_active_sec
FROM otel_metrics
WHERE metric_name = 'claude_code.active_time.total'
GROUP BY labels->>'user.email'
ORDER BY total_active_sec DESC;

By Team (via OTEL_RESOURCE_ATTRIBUTES)

SELECT
  labels->>'team.id' AS team,
  SUM(value)::bigint AS tokens
FROM otel_metrics
WHERE metric_name = 'claude_code.token.usage'
GROUP BY labels->>'team.id'
ORDER BY tokens DESC;

Key Metrics Summary