Query with RQL

{
  "project": "your-project",
  "query": "SELECT uniqExact(event_id) AS events FROM events",
  "time_range": {
    "from": "2026-01-01T00:00:00Z",
    "to": "2026-01-08T00:00:00Z"
  }
}

SELECT ai_model, uniqExact(event_id) AS events FROM events WHERE timestamp >= now() - INTERVAL 1 DAY GROUP BY ai_model ORDER BY events DESC LIMIT 20

SELECT uniqExact(event_id) AS events, uniqExactIf(event_id, has_errors) AS failed_events, uniqExactIf(user_id, has_errors) AS affected_users FROM events WHERE timestamp >= now() - INTERVAL 1 DAY

SELECT toStartOfHour(timestamp) AS hour, uniqExact(event_id) AS events FROM events WHERE timestamp >= now() - INTERVAL 1 DAY GROUP BY hour ORDER BY hour

SELECT arrayJoin(mapKeys(properties)) AS property_key, uniqExact(event_id) AS events FROM events WHERE timestamp >= now() - INTERVAL 1 DAY AND event_name = 'chat_message' GROUP BY property_key ORDER BY events DESC LIMIT 20

SELECT event_id, timestamp, ai_input FROM events WHERE event_name = 'chat_message' AND match(ai_input, 'refund') ORDER BY timestamp DESC LIMIT 20

SELECT span_name, uniqExact(tuple(trace_id, span_id)) AS failed_spans FROM traces WHERE timestamp >= now() - INTERVAL 1 DAY AND status = 'ERROR' GROUP BY span_name ORDER BY failed_spans DESC LIMIT 20