Timescale hyperfunctions are designed to efficiently process, aggregate, and analyze significant volumes of data while maintaining high performance. They let you run sophisticated analytical queries and get meaningful data in real time.
Timescale Cloud includes all hyperfunctions by default, while self-hosted TimescaleDB includes a subset of them. To include all hyperfunctions with TimescaleDB, install the Timescale Toolkit PostgreSQL extension on your self-hosted PostgreSQL deployment.
For more information, read the hyperfunctions blog post
.
- Learn about hyperfunctions to understand how they work before using them.
- Install the Toolkit extension to access more hyperfunctions on self-hosted TimescaleDB.
Function pipelines
Use functional programming to simplify complex SQL queries
Approximate count distincts
Count the number of unique values in a dataset
Statistical aggregates
Calculate descriptive statistics and models, including averages, standard deviation, linear regression, and more
Gapfilling and interpolation
Fill in data collected at irregular time intervals
Percentile approximation
Calculate percentiles
Counter aggregation
Calculate statistics from gauges and counters
Time-weighted averages
Calculate time-weighted averages
Keywords
Found an issue on this page?Report an issue or Edit this page in GitHub.