Versions:

Percentile approximation

This section contains functions related to percentile approximation. Approximation algorithms are used to calculate a percentile without requiring all of the data. For more information about percentile approximation functions, see the hyperfunctions documentation.

Some hyperfunctions are included in the default TimescaleDB product. For additional hyperfunctions, you need to install the Timescale Toolkit PostgreSQL extension.

Hyperfunction familyTypesAPI CallsIncluded by defaultToolkit required
Percentile approximationApproximate percentilepercentile_agg
approx_percentile
approx_percentile_rank
rollup
max_val
mean
error
min_val
num_vals
Advanced aggregation methodsuddsketch
tdigest

Found an issue on this page?

Report an issue!

Related Content