It's even easier
sum by (group) (my_metric)
Top answer 1 of 3
74
It's even easier
sum by (group) (my_metric)
2 of 3
57
Yes, you can you use label replace to group all the misc together:
sum by (new_group) (
label_replace(
label_replace(my_metric, "new_group", "$1", "group", ".+"),
"new_group", "misc", "group", "misc group.+"
)
)
The inner label_replace copies all values from group into new_group, the outer overwrites those which match "misc group.+" with "misc", and we then sum by the "new_group" label. The reason for using a new label is the series would no longer be unique if we just overwrote the "group" label, and the sum wouldn't work.
Last9
last9.io › blog › prometheus-group-by-label
Prometheus Group By Label: Advanced Aggregation Techniques for Monitoring | Last9
June 12, 2026 - Prometheus treats each unique combination of labels as a separate time series. When you group by specific labels, you’re telling Prometheus which dimensions to preserve and which to collapse during aggregation.
SigNoz
signoz.io › guides › how to group labels in prometheus queries - a practical guide
How to Group Labels in Prometheus Queries - A Practical Guide | SigNoz
July 24, 2024 - Prometheus Query Language (PromQL) offers powerful tools for label grouping. The primary method involves using the group() operator along with the by clause.
What are Prometheus labels?
Prometheus labels are key-value pairs that add context to metrics and help in filtering and aggregating your metrics for enhanced observability.
middleware.io
middleware.io › blog › prometheus-labels
Prometheus Labels: Understanding and Best Practices
What is the job label in Prometheus?
The job label identifies the target being scraped. It’s automatically assigned by Prometheus and helps group metrics by application, service, or source as defined in the scrape configuration.
last9.io
last9.io › blog › prometheus-group-by-label
Prometheus Group By Label: Advanced Aggregation Techniques for ...
How can I group labels in a Prometheus query?
Use by (label1, label2) to retain specific labels or without (label) to exclude one or more. For example: sum(cpu_usage) by (region) sum(memory_usage) without (instance)
last9.io
last9.io › blog › prometheus-group-by-label
Prometheus Group By Label: Advanced Aggregation Techniques for ...
Better Stack
betterstack.com › community › questions › how-can-group-labels-in-prometheus-query
How Can I Group Labels in a Prometheus Query? | Better Stack Community
August 5, 2025 - Grouping labels in a Prometheus ... across different dimensions. You can use the by clause in Prometheus Query Language (PromQL) to group your results according to one or more labels....
Medium
medium.com › @suchitasharma1106 › a-comprehensive-guide-to-grouping-and-functions-in-promql-cc3c438be320
A Comprehensive Guide to Grouping and Functions in PromQL | by Suchita Sharma | Medium
October 7, 2024 - In this blog, we’ll cover grouping ... helps in aggregating data across multiple dimensions. It allows you to summarize or categorize metrics based on their labels......
Prometheus
prometheus.io › docs › prometheus › latest › querying › operators
Operators | Prometheus
group(v) (all values in the resulting vector are 1) ... These operators can either be used to aggregate over all label dimensions or preserve distinct dimensions by including a without or by clause.
Prometheus
prometheus.io › docs › prometheus › latest › querying › examples
Query examples | Prometheus
Assuming that the http_requests_total time series all have the labels job (fanout by job name) and instance (fanout by instance of the job), we might want to sum over the rate of all instances, so we get fewer output time series, but still preserve the job dimension:
Coralogix
coralogix.com › home › promql tutorial: 5 tricks to become a prometheus god
PromQL Tutorial: 5 Tricks to Become a Prometheus God
June 3, 2025 - What if you want to aggregate by a label just to get values for that label? Prometheus 2.0 introduced the group() operator for exactly this purpose.
Reddit
reddit.com › r/prometheusmonitoring › prometheus group by wildcard substring of label
r/PrometheusMonitoring on Reddit: Prometheus group by wildcard substring of label
May 18, 2024 - groups: - name: registration-availability rules: - record: slo:sli_error:ratio_rate5m expr: |- (avg_over_time( ( ( (sum(rate( fastapi_responses_total{ app_name=~".*registration-api.*", status_code!~"5.."}[5m] )) ) / on(app_name) group_right() (sum(rate( fastapi_responses_total{ app_name=~".*registration-api.*"}[5m]) )) ) OR on() vector(0))[5m:60s]) ) labels: slo_id: registration-availability slo_service: registration slo: availability - name: checkout-availability rules: - record: slo:sli_error:ratio_rate5m expr: |- (avg_over_time( ( ( (sum(rate( fastapi_responses_total{ app_name=~".*checkout-api.*", status_code!~"5.."}[5m] )) ) / on(app_name) group_right() (sum(rate( fastapi_responses_total{ app_name=~".*checkout-api.*"}[5m]) )) ) OR on() vector(0))[5m:60s]) ) labels: slo_id: checkout-availability slo_service: checkout slo: availability
Middleware
middleware.io › blog › prometheus-labels
Prometheus Labels: Understanding and Best Practices
Moreover, Prometheus labels are used for PromQL aggregations like grouping and filtering.
Robust Perception
robustperception.io › using-the-group-aggregator-in-promql
Using the group() aggregator in PromQL – Robust Perception | Prometheus Monitoring Experts
August 10, 2020 - group always produces 1 as a the value of the aggregation group, but more importantly signifies for anyone reading the PromQL expression that it is the aggregation's label handling that is what's important rather than the numeric result:
Prometheus
prometheus.io › docs › prometheus › latest › querying › basics
Querying basics | Prometheus
It is possible to filter these time series further by appending a comma-separated list of label matchers in curly braces ({}). This example selects only those time series with the http_requests_total metric name that also have the job label set to prometheus and their group label set to canary:
Promlabs
promlabs.com › blog › 2020 › 12 › 17 › promql-queries-for-exploring-your-metrics
PromLabs | Blog - PromQL Queries for Exploring Your Metrics
December 17, 2020 - If your UI does not already show you this list in one way or another (it really should!), you can query for it by first selecting all series, then grouping by the special metric name label __name__: ... Note: A more efficient, non-PromQL way to get the same information is to use Prometheus's label values metadata endpoint to get all values for the __name__ label, e.g.: https://demo.promlabs.com/api/v1/label/name/values.
Top answer 1 of 3
10
It is possible to use label_replace() function in order to extract the needed parts of the label into a separate label and then group by this label when summing the results. For example, the following query extracts the project.sample-y from project.sample-y.jksdjkfs-2f16-11e7-3454-005056bf2fbf.2018.03.11 value stored in the index label and puts the extracted value into project_name label. Then the sum() is grouped by project_name label values:
sum(
label_replace(metric, "project_name", "$1", "index", "(project[.][^.]+).+")
) by (project_name)
2 of 3
6
While it'd be best to fix the metrics, the next best thing is to use metric_relabel_configs using the same technique as this blog post:
metric_relabel_configs:
- source_labels: [index]
regex: 'project\.([^.]*)\..*'
replacement: '${1}'
target_label: project
You will then have a project label that you can use as usual.
OneUptime
oneuptime.com › home › blog › how to write prometheus queries that return label values
How to Write Prometheus Queries That Return Label Values
December 17, 2025 - The group() function returns 1 for each unique label combination, effectively listing all label values: # Get all unique namespace values (returns 1 for each) group(kube_pod_info) by (namespace) # Get all unique job/instance combinations group(up) ...
GitHub
github.com › prometheus › prometheus › discussions › 12205
Promql group by label for absent or absent_over_time · prometheus/prometheus · Discussion #12205
So the way I'm filling value with 0 is by doing · sum without() (up{service="service1"}) or (0 * absent(up{service="service1"})) This works if I specify service label, but I have many services, I want to have 0 filled for all of them, but absent or absent_over_time does not support group by label, which means (sum without() (up) or (0 * absent(up))) just doesn't work.
Author: prometheus
daily.dev
daily.dev › posts › prometheus-group-by-label-advanced-aggregation-techniques-for-monitoring-tdw0bxnmc
Prometheus Group By Label: Advanced Aggregation Techniques for Monitoring | daily.dev
July 7, 2025 - Prometheus grouping transforms overwhelming metric volumes into actionable insights by organizing time series by shared label values. The guide covers...
SigNoz
signoz.io › guides › how to write prometheus queries to return label values
How to Write Prometheus Queries to Return Label Values | SigNoz
July 25, 2024 - PromQL is a powerful language designed specifically for time series data manipulation. To select metrics with specific labels, use this basic syntax: ... This query returns the total number of HTTP requests grouped by the method label.
Stack Overflow
stackoverflow.com › questions › 79181729 › how-can-i-group-values-by-label-in-prometheus-query
grafana - How can I group values by label in Prometheus query? - Stack Overflow
I already configured $Region dashboard variable, so I can filter out values by specific region. ... What is the actual question here? Query seems fine, grouping is already done.
OneUptime
oneuptime.com › home › blog › how to count unique label values in prometheus
How to Count Unique Label Values in Prometheus
December 17, 2025 - However, understanding how many ... you how to count unique label values using PromQL. Use count(group by (label_name) (metric_name)) to count unique label values...