num_vals()

num_vals(sketch UddSketch) RETURNS DOUBLE PRECISION

num_vals(digest tdigest) RETURNS DOUBLE PRECISION

Get the number of values contained in a percentile estimate. This is provided in order to save space when both a count and a percentile estimate are required as part of continuous aggregates. You can simply compute a single percentile estimator and do not need to specify a separate count aggregate, just extract the num_vals from the percentile estimator.

Required arguments

Returns

Sample usage

SELECT num_vals(percentile_agg(data))
FROM generate_series(0, 100) data;

num_vals
-----------
       101