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