Use the PromQL query browser (in the Prometheus web interface) to debug
it. I suggest you first need to look at the inner query:
up{instance=~"instance"}
and graph it, setting the "instance" regexp to match one or more instances
of interest. What does it look like? Is it a mixture of 0's and 1's, or all
0's, or all 1's, or is it absent entirely? If it's absent entirely, then
that's a different problem you need to investigate - your scrape job is
completely broken.
If it's a mixture of 0's and 1's, then try this query:
max_over_time(up{instance=~"instance"}[2d])
It should show 1 for any instant where the server was up at any time over
the previous 48 hours. Does it not?
If it's all 0's for at least 48 hours, then
max_over_time(up{instance=~"instance"}[2d])
should show 0.
Once you've understood why your query wasn't working as you were expecting,
then for partially reachable you can try a query like this:
avg_over_time(up{instance=~"instance"}[2d]) > 0 < 0.9
(setting thresholds as appropriate)
On Tuesday, 9 August 2022 at 13:23:33 UTC+1 [email protected] wrote:
> Hi all,
>
> *First Query :*
> I want to find the servers which have not been reachable for the last X
> days. It should not be in a reachable state for the last X days. I tried
> the following query, but it didn't work out.
>
> Query : max_over_time(up{instance=~"instance"}[Xd]) == 0
>
> The above query gives me the info that servers are not reachable at least
> for 1 minute. But I want to know the info like it should not be reachable
> for the last X days.
>
> *Second Query :*
> I want to find the servers which are partially reachable for the last X
> days and it should not include the info that is totally unreachable state
> for the X days.
>
> Any leads?
>
> Thanks & regards,
> Bharath Kumar.
>
>
--
You received this message because you are subscribed to the Google Groups
"Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/prometheus-users/223d9dfb-5ac2-4629-b36a-a305d029fc21n%40googlegroups.com.
