Sorry, I still don't understand what your metrics currently represent, and what condition (in terms of the values of those metrics) you need to alert on. Perhaps if you give some specific examples of those metrics it would help, both in a normal condition, and an error condition.
On Wednesday 14 February 2024 at 13:39:21 UTC h0ksa wrote: > I apologize if my explanation was unclear. I currently have four tables > for web analytics data. I aim to create a query that triggers an alert when > either the data retrieval stops or the number of rows falls below one. Any > recommendations on how to formulate this query? > On Wednesday, February 14, 2024 at 2:28:33 PM UTC+1 Brian Candler wrote: > >> I'm not sure why you're summing over increase, but if you plot that >> PromQL expression in the web UI, does its value drop to zero when the >> problem occurs? >> >> If so, just add "== 0" to the end of this expression and you can use it >> as an alerting expression. >> >> On Wednesday 14 February 2024 at 11:37:32 UTC h0ksa wrote: >> >>> sum by (table) (increase(pinot_server_realtimeRowsConsumed_Count[5m])) >>> >>> right now iam using this query >>> >>> and rows are always rising in the database but i want to know when they >>> stop and trigger an alert >>> >>> On Wednesday, February 14, 2024 at 12:31:53 PM UTC+1 Brian Candler wrote: >>> >>>> What Prometheus metrics are you collecting? For example, do you have a >>>> metric for the total number of rows in the database? Or do you have a >>>> metric for the last time a row was inserted? Or some other metric which >>>> can >>>> identify new rows - if so, what? >>>> >>>> What is the "previously suggested function"? >>>> >>>> We can't really suggest an alerting function without seeing the metrics >>>> themselves. >>>> >>>> On Wednesday 14 February 2024 at 10:16:01 UTC h0ksa wrote: >>>> >>>>> Hi all , >>>>> >>>>> >>>>> I have a dataset with 5000 rows, and my objective is to determine if >>>>> any new rows have been inserted or created within the last 5 minutes. The >>>>> previously suggested function may not be suitable because the row count >>>>> is >>>>> never expected to drop below 1. Consequently, my focus is on identifying >>>>> instances where no rows have been created within a 5-minute timeframe. If >>>>> no new rows are found during this period, I intend to initiate an alert. >>>>> So >>>>> which function to use >>>>> increase() >>>>> delta() >>>>> increase() or another one . >>>> >>>> -- 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 on the web visit https://groups.google.com/d/msgid/prometheus-users/b5b14849-9b21-4194-8d86-b1c8b6675131n%40googlegroups.com.
