gauge_zero_time()

Calculate the time when the gauge value is predicted to have been zero

Early access 1.6.0

Calculate the time when the gauge value is modeled to have been zero. This is the x-intercept of the linear fit between gauge value and time.

Arguments

Name	Type	Default	Required	Description
summary	GaugeSummary	-	✔	A gauge aggregate created using gauge_agg

Returns

TIMESTAMPTZ: The time when the gauge value is predicted to have been zero

Samples

Estimate the time when the gauge started

SELECT
    id,
    bucket,
    gauge_zero_time(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