...
Let’s create a CQ that collects everything usable from default mgmt_api_request data. We can find the tag and field names with commands like SELECT * FROM mgmt_api_request LIMIT 1.
...
| breakoutMode | full-width |
|---|
...
CREATE
...
CONTINUOUS
...
QUERY
...
"mgmt_api_requests_5min_for_1month"
...
ON
...
"oneportal"
...
BEGIN
...
SELECT
...
count(auth_header_exists)
...
AS
...
"count_requests",
...
sum("request_duration")
...
AS
...
"sum_request_duration",
...
mean("request_duration")
...
AS
...
"mean_request_duration"
...
INTO
...
"one_month"."mgmt_api_requests"
...
FROM
...
"mgmt_api_request"
...
GROUP
...
BY
...
time(5m),
...
"path",
...
"method",
...
"api_client_id",
...
"oauth2_client_id"
...
END
We could have created a CQ that collects only the number of requests and groups them by path, but in anticipation of other needs, we collect more data and more tags.
...