Rollbar RQL to pull most frequent Rails errors in the last 24 hours

rollbar24.rql

SELECT item.counter, item.title, count(*), max(timestamp), item.framework
FROM item_occurrence
WHERE timestamp > unix_timestamp() - 60 * 60 * 24
  AND item.environment = 'production'
  AND item.framework = 1
  AND item.level > 30
GROUP BY item.counter
ORDER BY count(*) DESC
LIMIT 1000

framework may change depending on integration, I'm not sure.

For us, it's 1 = Rails (I figured it out by inspecting the filter dropdown in Rollbar)

the twist if you want to see ActiveJobs only

SELECT item.counter, item.title, count(*), max(timestamp), item.framework
FROM item_occurrence
WHERE timestamp > unix_timestamp() - 60 * 60 * 24
  AND item.environment = 'production'
  AND item.framework = 1
  AND item.level > 30
  AND body.trace.extra.job IS NOT NULL
GROUP BY item.counter
ORDER BY count(*) DESC
LIMIT 1000