Hyperfunctions allow you to perform critical time-series queries quickly, analyze time-series data, and extract meaningful information.
Some hyperfunctions are included by default in Timescale. For additional hyperfunctions, you need to install the Timescale Toolkit PostgreSQL extension.
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.
Use functional programming to simplify complex SQL queries
Approximate count distincts
Count the number of unique values in a dataset
Calculate descriptive statistics and models, including averages, standard deviation, linear regression, and more
Gapfilling and interpolation
Fill in data collected at irregular time intervals
Calculate statistics from gauges and counters
Calculate time-weighted averages
Found an issue on this page?Report an issue!