Skip to content

Instantly share code, notes, and snippets.

@honewatson

honewatson/apm.sql

Last active June 25, 2020 02:04
Show Gist options
  • Save honewatson/b7579af4df466376bf9324228f45a9c2 to your computer and use it in GitHub Desktop.
Save honewatson/b7579af4df466376bf9324228f45a9c2 to your computer and use it in GitHub Desktop.
Download ZIP
New Relic SRE SLI Availability % percentage proportion insights
Raw
apm.sql
SELECT (100 - (filter(count(*), WHERE (httpResponseCode = '429') OR httpResponseCode > '499')/count(*)*100)) as 'Success (%)'
FROM Transaction
WHERE httpResponseCode IS NOT NULL
SINCE 30 days ago
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment