rate()

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

Name	Type	Description
rate	DOUBLE PRECISION	The per second observed rate computed from the CounterSummary


SELECT
    id,
FROM (
    SELECT
        id,
        counter_agg(ts, val) AS summary
    FROM foo
    GROUP BY id