Versions:

Frequency analysis

This section includes functions used to measure how often particular values occur. These are broken further into state aggregate APIs, which measure the time spent in a relatively small number of states, and frequency aggregate APIs, which find the most common elements out of a set of vastly more varied values.

Some hyperfunctions are included in the default TimescaleDB product. For additional hyperfunctions, you need to install the Timescale Toolkit PostgreSQL extension.

Hyperfunction subfamilyHyperfunction typeAPI callToolkitExperimental
StateAggAggregatestate_agg
Accessorduration_in
into_values
SpaceSavingAggregateAggregatefreq_agg
topn_agg
Accessorinto_values
min_frequency | max_frequency
topn

Found an issue on this page?

Report an issue!

Related Content