Because with every 15s data for a span of 1 hour, I get 240 records where only 2-3 records are useful. Data volume goes up when time increases, and have to scroll all through.
In Graph its fine may be but in table its huge and have to go through all. On Thursday, March 6, 2025 at 2:09:34 PM UTC+5:30 Ben Kochie wrote: > > 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 <apps.suv...@gmail.com> > 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 prometheus-use...@googlegroups.com. >> 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 prometheus-users+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/prometheus-users/d11d4dd6-019f-48a6-ac67-b1e119be8329n%40googlegroups.com.
