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.
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.