Skip to content

Instantly share code, notes, and snippets.

@oboxodo

oboxodo/rollbar-rql.sql

Created February 23, 2019 01:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save oboxodo/2dca24114a68a8cc8238868b73e3d482 to your computer and use it in GitHub Desktop.
Save oboxodo/2dca24114a68a8cc8238868b73e3d482 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
rollbar-rql.sql
-- Trying to get similar info that can be get from https://rollbar.com/quimbee/quimbee/versions/
-- but based on a custom attribute instead of the `code_version`.
-- Still not there.
SELECT body.trace.extra.code_version_release_iteration, max(timestamp), count_distinct(item.counter), count(*)
FROM item_occurrence
WHERE item.environment = "production"
AND item.level >= 30
GROUP BY 1
ORDER BY 2 DESC
LIMIT 20
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment