What are the values for elasticsearch_cluster_health_status?

[prometheus-community]

What are the values for elasticsearch_cluster_health_status?

[jpdstan]

@zsrinivas for a single stat panel in grafana you can do something like

max(elasticsearch_cluster_health_status{color="green",cluster=~"my_cluster"}) + ON(cluster) 
max(elasticsearch_cluster_health_status{color="yellow",cluster=~"my_cluster"})* 2 + ON(cluster) 
max(elasticsearch_cluster_health_status{color="red",cluster=~"my_cluster"}) * 3

and then create value mappings in the grafana dashboard to map the values 1, 2, 3 to green, yellow, and red respectively.

[jpdstan]

@QuanTran91 you can think of them as SQL joins, i.e. "join results from left side with right side where cluster is the same". if you do not include the ON(<labels>), then the left side will "join" only with a metric that has the EXACT same set of labels. ON(<labels>) lets you specify the label(s) to join on. it's not always necessary but it's recommended since labels are very dynamic and it is possible that the green metric may have labels that the yellow metric does not have, or vice versa.

read more here: https://prometheus.io/docs/prometheus/latest/querying/operators/#many-to-one-and-one-to-many-vector-matches

[zwopir]

see https://github.com/justwatchcom/elasticsearch_exporter/blob/master/collector/cluster_health.go#L195 and
https://github.com/justwatchcom/elasticsearch_exporter/blob/master/collector/cluster_health.go#L275

So the values are for example

elasticsearch_cluster_health_status{cluster="elasticsearch",color="green"} 1
elasticsearch_cluster_health_status{cluster="elasticsearch",color="red"} 0
elasticsearch_cluster_health_status{cluster="elasticsearch",color="yellow"} 0

[burton-scalefastr]

wait,, both read AND yellow are 0 ??

[dannyk81]

Indeed, because Green is 1 it means that cluster status is Green

…

On 12 January 2018 at 09:41, burton-scalefastr ***@***.***> wrote: wait,, both read AND yellow are 0 ?? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#120 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AXJk7Aaq-6edzF4zfvcUqg9E9o-QLcu5ks5tJ28ggaJpZM4RblFA> .

[zwopir]

we chose this representation to avoid a made up mapping like

green = 1
yellow = 2
red = 3

(you can't have string values in prometheus. The json from ES contains a string in the cluster-health-status value).

I hope the explanation makes it clear, closing the issue. If there are further questions, just reopen the ticket

[zsrinivas]

hey @zwopir , any idea on how I can make a single stat panel in grafana with this kind of value format. also thought about a bit on how I can make an alert on this but still confused.

[QuanTran91]

Hi @jpdstan , I am just curios since I am a Promql newbie
What does the "ON(cluster) " mean here?
Thank a lot