Skip to main content
Early access 1.6.0 Get the change in a gauge over a time period. This is the simple delta, computed by subtracting the last seen value from the first.

​
Arguments

NameTypeDefaultRequiredDescription
summaryGaugeSummary-✔A gauge aggregated created using gauge_agg

​
Returns

DOUBLE PRECISION: The change in the gauge over the bucketed interval

​
Samples

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