GCP MQL query: getting metrics/minute

Question

This query gives me metrics/sec:

fetch https_lb_rule::loadbalancing.googleapis.com/https/request_count
                | within 5m
                | align rate(1m)
                | every 1m
                | group_by
                    [ metric.cache_result,metric.proxy_continent,metric.response_code_class,metric.response_code,metric.protocol,resource.backend_name,resource.backend_type,resource.backend_scope,resource.backend_scope_type,resource.backend_target_type,resource.backend_target_name,resource.forwarding_rule_name,resource.matched_url_path_rule,resource.target_proxy_name,resource.url_map_name,resource.region,resource.project_id ],
                    [value_request_count_aggregate: aggregate(value.request_count)]

How to get metrics/minute?

Answer 1

The units for the metric are "1" (as they are for most counter metrics). The rate aligner result are always per-second. So the output of the aligner has units "1/s". MQL has a scale[ function that can be used to scale a value. In this case, adding | value scale(val(), "1/min") after the align step can be used to scale this to have units "1/min". (A shortcut way of saying that is | scale "1/min")

A variation on this is to replace the "1" with an annotation of the thing being counted: `"{requests}/min". The units are given according to the UCUM units standard

The query is then

fetch https_lb_rule::loadbalancing.googleapis.com/https/request_count
                | align rate(1m)
                | scale "{requests}/min"
                | every 1m
                | group_by
                    [metric.cache_result,metric.proxy_continent,
                     metric.response_code_class,metric.response_code,
                     metric.protocol,resource.backend_name,
                     resource.backend_type,resource.backend_scope,
                     resource.backend_scope_type, resource.backend_target_type,
                     resource.backend_target_name, resource.forwarding_rule_name, 
                     resource.matched_url_path_rule,
                     resource.target_proxy_name, resource.url_map_name,
                     resource.region,resource.project_id ],
                    [value_request_count_aggregate:
                       aggregate(val(0))]
                | div 60
                | within 5m

Final style note: within gives the range of the output of the query (even if it isn't given at the end). Putting it at the end is a good idea.