> So don't want the repeated duplicate data Why? What problem are you trying to solve?
On Thu, Mar 6, 2025 at 9:28 AM Suvendu Nayak <[email protected]> wrote: > Thanks Brain, I can do this on client side with Oracle SQLs but the > problem is when Prometheus gets those data it scrapes in every 15 secs and > most of the data are constant values for a longer period of time. So don't > want the repeated duplicate data. Even query for 10 mins gives same data > with time difference of 15 sec. > > On Wednesday, March 5, 2025 at 11:30:42 PM UTC+5:30 Brian Candler wrote: > >> Not a good one that I can think of. Can you do this on the client side >> (the API consumer?) >> >> Any complex PromQL expression on a range involves resampling it with a >> subquery, which is usually not desirable, and you'll lose the exact >> timestamps at which the scrapes took place. >> >> e.g. (foo != foo offset 15s)[10m:15s] >> >> On Wednesday, 5 March 2025 at 11:04:27 UTC Suvendu Nayak wrote: >> >>> Hi - As Prometheus collects the metrics in every 15 secs, when we do a >>> range query for some of the metrics the repeated values comes (which is >>> expected). Is there a way that we can filter only the change data values. >>> Example: >>> Time. Label Value >>> 10:10:15 a b c 1 >>> 10:10:30 a b c 1 >>> 10:10:45 a b c 1 >>> 10:11:00 d b c 2 >>> 10:11:15 d b c 2 >>> >>> for every 15 seconds, we want >>> Time. Label Value >>> 10:10:15 a b c 1 >>> 10:11:00 d b c 2 >>> >> -- > 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 visit > https://groups.google.com/d/msgid/prometheus-users/4269ed06-d3e6-4c57-85db-2586fc566539n%40googlegroups.com > <https://groups.google.com/d/msgid/prometheus-users/4269ed06-d3e6-4c57-85db-2586fc566539n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 visit https://groups.google.com/d/msgid/prometheus-users/CABbyFmp2wUVdupYi2LK%3D%3DdTQ%2BN1hSJpjVO0QiKkSwERsEQD%3DCw%40mail.gmail.com.
