Skip to content

idelta_left()

Calculate the instantaneous change at the left, or earliest, edge of a gauge aggregate

Since 1.25.0

Calculate the instantaneous change at the left, or earliest, edge of a gauge aggregate. This is equal to the second value minus the first value when the second value is greater than or equal to the first. When the second value is lower than the first, the result is the second value itself.

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

SELECT
id,
bucket,
idelta_left(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_left(
summary GaugeSummary
) RETURNS DOUBLE PRECISION
NameTypeDefaultRequiredDescription
summaryGaugeSummary-✔A gauge aggregate created using gauge_agg
ColumnTypeDescription
idelta_leftDOUBLE PRECISIONThe instantaneous delta at the left, or earliest, edge of the gauge aggregate