Skip to content

idelta_right()

Calculate the instantaneous change at the right, or latest, edge of a gauge aggregate

Since 1.25.0

Calculate the instantaneous change at the right, or latest, edge of a gauge aggregate. This is equal to the last value minus the second-last value when the last value is greater than or equal to the second-last. When the last value is lower than the second-last, the result is the last value itself.

Get the instantaneous change at the end of each 15-minute gauge aggregate.

SELECT
id,
bucket,
idelta_right(summary)
FROM (
SELECT
id,
time_bucket('15 min'::interval, ts) AS bucket,
gauge_agg(ts, val) AS summary
FROM foo
GROUP BY id, time_bucket('15 min'::interval, ts)
) t

The syntax is:

idelta_right(
summary GaugeSummary
) RETURNS DOUBLE PRECISION
NameTypeDefaultRequiredDescription
summaryGaugeSummary-✔A gauge aggregate created using gauge_agg
ColumnTypeDescription
idelta_rightDOUBLE PRECISIONThe instantaneous delta at the right, or latest, edge of the gauge aggregate