analytics.getRatelimits from five tables. They record calls to ratelimit.limit and ratelimit.multiLimit. Limits on keys and identities show up as RATE_LIMITED outcomes in the key_verifications tables instead.
ratelimits_v1
One row per rate limit check.The
cost charged, 1 by default. Zero when the request sent cost: 0, or for older rows recorded before this column existed.Rollup tables
ratelimits_per_minute_v1, ratelimits_per_hour_v1, ratelimits_per_day_v1, and ratelimits_per_month_v1 have the same columns: one row per time bucket, namespace, and identifier.
Start of the bucket.
DateTime on per-minute and per-hour, Date on per-day and per-month.All checks in the bucket.
sum(total) - sum(passed) is the number rejected.Can’t be read, because
avgMerge isn’t allowed. Use avg(latency) on the raw table.