num_resets()

Get the number of counter resets from a counter aggregate

Since 1.3.0

Get the number of times the counter is reset.

Arguments

Name	Type	Default	Required	Description
summary	CounterSummary	-	✔	A counter aggregate created using counter_agg

Returns

BIGINT: The number of resets within the counter aggregate

Samples

Get the number of counter resets for each 15-minute counter aggregate.

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