max_val()

Toolkit

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

max_val(digest TDigest) RETURNS DOUBLE PRECISION

Get the maximum value from a tdigest. This does not work with percentile_agg or uddsketch based estimators. This is provided in order to save space when both a maximum and a percentile estimate are required as part of continuous aggregates. You can calculate a single percentile estimator by extracting the max_val from the percentile estimator, without needing to specify a separate max aggregate.

• For more information about percentile approximation algorithms, see advanced aggregation methods.
• For more information about percentile approximation functions, see the hyperfunctions documentation.

Required arguments

Returns

Sample usage

SELECT max_val(tdigest(100, data))
FROM generate_series(1, 100) data;

max_val
---------
     100