counter_zero_time()

The time at which the counter value is predicted to have been zero based on the least squares fit line computed from the points in the CounterSummary.

counter_zero_time(
    summary CounterSummary
) RETURNS TIMESTAMPTZ

For more information about counter aggregation functions, see the hyperfunctions documentation.

Required arguments

Returns

Sample usage

SELECT
    id,
    bucket,
    counter_zero_time(summary)
FROM (
    SELECT
        id,
        time_bucket('15 min'::interval, ts) AS bucket,
        counter_agg(ts, val) AS summary
    FROM foo
    GROUP BY id, time_bucket('15 min'::interval, ts)
) t