Unfortunately, you can't apply value filters to range vectors
validator_statuses[1d] # this is OK
validator_statuses{foo="bar"}[1d] # this is OK
(validator_statuses == 2)[1d] # NOT IMPLEMENTED
(there are several scenarios in which I'd find this useful). The best you
can do is a subquery:
(validator_statuses == 2)[1d:1m]
This evaluates the inner expression repeatedly at different times 1m apart.
That will *approximate* what you want if the scraping interval for that
metric is also 1m; however each evaluation will look back up to 5 minutes
to find a value, so missing scrapes will be seen as the value of the
previous scrape.
On Friday, 19 May 2023 at 11:10:14 UTC+1 Stefano Mantini wrote:
> I’m looking at an efficient way of returning the MAX of each day’s
> metrics in a given time period
>
> The metric is a Gauge Vector that identifies each Validator by public key,
> and the value represents an ENUM value.
>
> Example
> validator_statuses{pubkey="pk0"} 0 // UNKNOWN
> validator_statuses{pubkey="pk1"} 1 // DEPOSITED
> validator_statuses{pubkey="pk2"} 2 // PENDING
> validator_statuses{pubkey="pk3"} 3 // ACTIVE
> validator_statuses{pubkey="pk4"} 4 //EXITING
> validator_statuses{pubkey="pk5"} 5 // SLASHING
> validator_statuses{pubkey="pk6"} 6 //EXITED
>
> I am retrieving the MAX by Day using this query:
> max_over_time( validator_statuses{} [1d])
>
> Which returns the timestamp of the day, the pubkey and the MAX status for
> that timestamp day
> +---------------------+--------+--------+
> | Time | Pubkey | Status |
> +---------------------+--------+--------+
> | 2023-05-01 00:00:00 | 0x0 | 1 |
> | 2023-05-02 00:00:00 | 0x0 | 2 |
> | 2023-05-03 00:00:00 | 0x0 | 2 |
> | 2023-05-04 00:00:00 | 0x0 | 3 |
> | 2023-05-05 00:00:00 | 0x0 | 3 |
> | 2023-05-06 00:00:00 | 0x0 | 3 |
> | 2023-05-07 00:00:00 | 0x0 | 3 |
> | 2023-05-08 00:00:00 | 0x0 | 3 |
> | 2023-05-09 00:00:00 | 0x0 | 3 |
> | 2023-05-010 00:00:00| 0x0 | 3 |
> +---------------------+--------+--------+
>
> However, i'm having trouble when trying to count by and aggregate those
> statuses
> My intention is to count the number of days a validator is in each status
> per $__range, the above data would return this kind of tablular data
>
>
> +--------+-----------+------------------+------------------+------------------+
> | Pubkey | StatusNow | Days In Status 1 | Days In Status 2 | Days In
> Status 3 |
>
> +--------+-----------+------------------+------------------+------------------+
> | 0x0 | 3 | 1 | 2 |
> 7 |
>
> +--------+-----------+------------------+------------------+------------------+
>
> Can this be done entirely in PromQL? Or will i have to leverage multiple
> queries and aggregate in Grafana?
>
> *All information and attachments included in this email are confidential
> and intended for the original recipient only. You must not share any part
> of this message with any third party. If you have received this message by
> mistake, please let us know** immediately, so that we can make sure such
> a mistake does not happen again and delete this message from your system.*
>
--
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/a6ce2623-bdf4-4c40-b4c9-938e0398c05cn%40googlegroups.com.
