Merge/join two metrics in Prometheus/PromQL

prometheus promql
rcjsuen picture rcjsuen · Jul 14, 2018 · Viewed 9k times · Source

I have two different (but related metrics).

metric_1(id="abc",id2="def")
metric_2(id="abc",id2="def")

My goal ultimately is to have the following in Grafana. I plan to use the "instant" value and Grafana's table visualization widget to display this data.

id      id2     metric1 metric2
abc     def     1       2

What query/joining/relabeling should I use to achieve this?

Thank you in advance! :)

Answer

fche picture fche · Nov 1, 2020 
{__name__=~"metric_1|metric_2"}

https://stackoverflow.com/a/47415934/661150 https://prometheus.io/docs/prometheus/latest/querying/basics/

Related questions

Get Total requests in a period of time

I need to show, in Grafana, a panel with the number of requests in the period of time selected in the upper right corner. For this I need to solve 2 issues here, I will ask the prometheus question here and …

Read More
How can I group labels in a Prometheus query?

If I have a metric with the following labels: my_metric{group="group a"} 100 my_metric{group="group b"} 100 my_metric{group="group c"} 100 my_metric{group="misc group a"} 1 my_metric{group="misc group b"} 2 my_metric{group="misc …

Read More
Query label_values not found in Prometheus

In the Grafana documentation, I found that I should be able to query my Prometheus server for all instances delivering monitoring data using the label_values query. The query I'm using in Grafana is: label_values(up, instance) Unfortunately, Prometheus …

Read More