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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/prometheus-users/be4578b4-a5bb-4b26-97dc-9d2755cac6fan%40googlegroups.com.

Reply via email to