Skip to content

delta()

Calculate the change in a gauge from a gauge aggregate

Since 1.25.0

Get the change in a gauge over a time period. This is the simple delta, computed by subtracting the first value from the last.

Get the change in each gauge over the entire time interval in table foo.

SELECT
id,
delta(summary)
FROM (
SELECT
id,
gauge_agg(ts, val) AS summary
FROM foo
GROUP BY id
) t

The syntax is:

delta(
summary GaugeSummary
) RETURNS DOUBLE PRECISION
NameTypeDefaultRequiredDescription
summaryGaugeSummary-✔A gauge aggregate created using gauge_agg
ColumnTypeDescription
deltaDOUBLE PRECISIONThe change in the gauge over the bucketed interval