Percentile approximation
Toolkit
TimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale Cloud. Click to learn more.

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 family	Types	API Calls	Included by default	Toolkit required
Percentile approximation	Approximate percentile	`percentile_agg`	❌	✅
		`approx_percentile`	❌	✅
		`approx_percentile_rank`	❌	✅
		`rollup`	❌	✅
		`max_val`	✅	❌
		`mean`	✅	❌
		`error`	✅	❌
		`min_val`	✅	❌
		`num_vals`	✅	❌
	Advanced aggregation methods	`uddsketch`	❌	✅
		`tdigest`	❌	✅

Found an issue on this page?

Report an issue!

Previousinterpolate Nextpercentile_agg

Percentile approximation ToolkitTimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale Cloud. Click to learn more.

Related Content

Percentile approximation
Toolkit
TimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale Cloud. Click to learn more.