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.
Frequency analysis functions
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() | ✅ | ✅ |
当前内容版权归 TimescaleDB 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 TimescaleDB .