我的书签
添加书签
移除书签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.
2. num_elements(
4. summary CounterSummary
6. ) RETURNS BIGINT
For more information about counter aggregation functions, see the hyperfunctions documentation.
Required arguments
| Name | Type | Description |
|---|---|---|
| summary | CounterSummary | The input CounterSummary from a counter_agg call |
Returns
| Name | Type | Description |
|---|---|---|
| num_elements | BIGINT | The number of points seen during the counter_agg call |
Sample usage
2. SELECT
4. id,
6. bucket,
8. num_elements(summary)
10. FROM (
12. SELECT
14. id,
16. time_bucket('15 min'::interval, ts) AS bucket,
18. counter_agg(ts, val) AS summary
20. FROM foo
22. GROUP BY id, time_bucket('15 min'::interval, ts)
24. ) t
