Frequency analysis

This section includes frequency aggregate APIs, which find the most common elements out of a set of vastly more varied values.

For these hyperfunctions, you need to install the TimescaleDB Toolkit PostgreSQL extension.

Hyperfunction type	Hyperfunction name	Toolkit	Experimental
count_min_sketch() functions
Aggregate	count_min_sketch()	✅	✅
Accessor	approx_count()	✅	✅
freq_agg() functions
Aggregate	freq_agg()	✅	✅
Accessor	into_values()	✅	✅
min_frequency(), max_frequency()	✅	✅
topn_agg() functions
Aggregate	topn_agg()	✅	✅
Accessor	into_values()	✅	✅
min_frequency(), max_frequency()	✅	✅
topn()	✅	✅

Frequency Analysis