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.
Prometheus
prometheus.io › docs › prometheus › latest › querying › examples
Query examples | Prometheus
...we could get the top 3 CPU users grouped by application (app) and process type (proc) like this:
Group by option in query for prometheus
Is there a way to do a group by query on Prometheus database like there’s for Graphite databases? More on community.grafana.com
2
0
June 15, 2017📢 Prometheus Real Estate Group [HIRING] a Maintenance Technician ...
r/jobboardsearch: The official community of JobBoardSearch 🔎 Meta directory of job boards with filters. Posting the latest jobs every hour 🔥 Join our… More on reddit.com
Leasing Consultant at Prometheus Real Estate Group
Reddit gives you the best of the internet in one place. Get a constantly updating feed of breaking news, fun stories, pics, memes, and videos just for you. Passionate about something niche? Reddit has thousands of vibrant communities with people that share your interests. More on reddit.com
Not So Pro Tip: Pulse Point App
Can also recommend the CrimeRadar app, it even has dispatch’s audio for events around town More on reddit.com
5
26
March 21, 2026How 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 ...
What is the difference between group_left and group_right in Prometheus?
group_left is used when the left side of a vector match has more time series than the right. group_right is for the opposite case—when the right side has more time series. These are used to join metrics that have different cardinalities, such as pairing metrics with metadata.
last9.io
last9.io › blog › prometheus-group-by-label
Prometheus Group By Label: Advanced Aggregation Techniques for ...
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 ...
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.
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 - PromQL is a versatile query language ... and grouping capabilities that make it ideal for analyzing time-series data in a Prometheus-based monitoring system. Whether you’re aggregating metrics, computing rates, or calculating percentiles, mastering these techniques will allow you to monitor the health and performance of your systems with precision. By understanding ...
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....
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.
Prometheus
prometheus.io › docs › prometheus › latest › querying › operators
Operators | Prometheus
Grouping modifiers can only be used for comparison, arithmetic, and trigonometric operators. Set operators match with all possible entries on either side by default.
Grafana
community.grafana.com › prometheus
Group by option in query for prometheus - Prometheus - Grafana Labs Community Forums
June 15, 2017 - Is there a way to do a group by query on Prometheus database like there’s for Graphite databases?
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 - If you’re familiar with SQL, you’ll remember that GROUP BY allows you to group results by a field (e.g country or city) and apply an aggregate function, such as AVG() or COUNT(), to values of another field.
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 › functions
Query functions | Prometheus
(This implies that a change in the data labels in the conventional Prometheus view constitutes the end of one info series and the beginning of a new info series, while the “logical” view of the info function is that the same info series continues to exist, just with different “data”.) The conventional approach of adding data labels is sometimes called a “join query”, as illustrated by the following example: rate(http_server_request_duration_seconds_count[2m]) * on (job, instance) group_left (k8s_cluster_name) target_info
Prometheus Group
prometheusgroup.com
Enterprise Asset Management Solutions for Maintenance | Prometheus Group
Capital Project Management Prometheus DSO Decision Support & Optimization Project & Portfolio Management Co-Console Commissioning & Completions Management Doc-Console Document Management Weld-Console Weld Management
Published: May 9, 2025
StreetInsider
streetinsider.com › SEC+Filings › Form+DA+Prometheus+Therapeutics › 26318715.html
Form D/A Prometheus Therapeutics
April 15, 2026 - Each Issuer identified above has read this notice, knows the contents to be true, and has duly caused this notice to be signed on its behalf by the undersigned duly authorized person.
Prometheus Group
prometheusgroup.com › solutions › reporting-and-analytics
EAM Analytics and Reporting Software Solution | Prometheus Group
Reporting & Analytics Software - Leverage data-driven insights with our web-based RCM software for reporting and analytics. Make informed decisions, improve performance, and drive results. If we didn’t have this software, we would have to compute everything feeding into us. Performance Analytics calculates the benefits for me instantly. The key for us is, instead of just going out to search for leaks indiscriminately, we want to be able to see which specific areas need the leak detection. Gain access to tailored reports to see where you can improve efficiency in your maintenance and operations with Prometheus Group's Reportin
Promlabs
promlabs.com › promql-cheat-sheet
PromLabs | PromQL Cheat Sheet
Available aggregation operators: sum(), min(), max(), avg(), stddev(), stdvar(), count(), count_values(), group(), bottomk(), topk(), quantile() ... Only keep series from the left-hand side whose sample values are larger than their right-hand-side matches: ... histogram_quantile( 0.9, sum by(le, path, method) ( rate(demo_api_request_duration_seconds_bucket[5m]) ) )
Sherwood News
sherwood.news › tech › bezos-poaches-xai-cofounder-from-openai-for-his-project-prometheus-startup
Bezos poaches xAI cofounder from OpenAI for his Project Prometheus startup - Sherwood News
April 7, 2026 - The Financial Times reports that xAI cofounder Kyle Kosic has been poached from OpenAI by Amazon founder Jeff Bezos for his new AI industrial manufacturing startup, Project Prometheus.
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 - The applications run on an organisation entity and this entity is represented by the substring managed-cus-test-1. The name of the organisation that an application belongs to always starts with the string managed- but can it have any wildcard value after the string "managed-" e.g managed-cus-test-1 , managed-cus-test-2, managed-cus-test-3 · To calculate the availability SLO for these applications I have prepared the following set of recording rules: groups: - name: registration-availability rules: - record: slo:sli_error:ratio_rate5m expr: |- (avg_over_time( ( ( (sum(rate( fastapi_responses_t
Kubernetes
kubernetes.io › docs › concepts › workloads › autoscaling › horizontal-pod-autoscale
Horizontal Pod Autoscaling | Kubernetes
August 3, 2026 - In Kubernetes, a HorizontalPodAutoscaler automatically updates a workload resource (such as a Deployment or StatefulSet), with the aim of automatically scaling capacity to match demand. Horizontal scaling means that the response to increased load is to deploy more Pods.
Middleware
middleware.io › blog › prometheus-labels
Prometheus Labels: Understanding and Best Practices
Moreover, Prometheus labels are used for PromQL aggregations like grouping and filtering.
InfoQ
infoq.com › news › 2026 › 04 › airbnd-opentelemetry-vmagent
Airbnb Migrates High-Volume Metrics Pipeline to OpenTelemetry - InfoQ
April 14, 2026 - In the end, vmagent was selected for its built-in streaming aggregation for Prometheus metrics, horizontal sharding support, approachable documentation, and a small codebase of roughly 10,000 lines that made internal customization tractable. The production architecture uses two layers of vmagent: stateless router pods that shard metrics by consistently hashing all labels except the ones to be aggregated away, and stateful aggregator pods that maintain running totals in memory.