num_elements()

The total number of points seen while calculating the CounterSummary. Only points with distinct times are counted, as duplicate times are usually discarded in these calculations.

num_elements(
summary CounterSummary
) RETURNS BIGINT

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

Required arguments

NameTypeDescription
summaryCounterSummaryThe input CounterSummary from a counter_agg call

Returns

NameTypeDescription
num_elementsBIGINTThe number of points seen during the counter_agg call

Sample usage

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

Found an issue on this page?

Report an issue!

Keywords

Related Content