min_val()

Toolkit

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

min_val(digest TDigest) RETURNS DOUBLE PRECISION

Get the minimum value from a tdigest. This does not work with percentile_agg or uddsketch based estimators. This saves space when you require both a minimum and a percentile estimate as part of a continuous aggregate. You can compute a single percentile estimator and do not need to specify a separate min aggregate, by extracting the min_val from the percentile estimator.

• 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 min_val(tdigest(100, data))
FROM generate_series(1, 100) data;

min_val
-----------
         1