gauge_zero_time()

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

Early access Since 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.

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

Arguments

The syntax is:

gauge_zero_time(
    summary GaugeSummary
) RETURNS TIMESTAMPTZ

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

Returns

Column	Type	Description
gauge_zero_time	TIMESTAMPTZ	The time when the gauge value is predicted to have been zero