Be able to see the max RPM in my app in a give period of time. Example: in the last week what was the max RPM we had?
We are in the process of setting some rate limits in our API and we want to know our ceiling.
We have this query:
SELECT rate(count(*), 1 minute) AS 'Requests per minute' FROM Transaction WHERE appName = 'app name' TIMESERIES 1 minute SINCE 1 week ago EXTRAPOLATE
The problem with the query above is that the graph can only show up to 366 buckets. So we can change that query to:
SELECT rate(count(*), 1 minute) AS 'Requests per minute' FROM Transaction WHERE appName = 'app name' TIMESERIES max SINCE 1 week ago EXTRAPOLATE
But then we actually lose data and we miss all the peaks leaving us with just averages.
Any suggestion how can we detect top RPM in a week? we don’t need a chart, it can be a number or a table ?