mean(sketch UddSketch) RETURNS DOUBLE PRECISION
mean(digest tdigest) RETURNS DOUBLE PRECISION
Get the exact average of all the values in the percentile estimate. Percentiles
returned are estimates, the average is exact. This is provided in order to save
space when both a mean and a percentile estimate are required as part of
continuous aggregates. You can compute a single percentile estimator by
extracting the mean from the percentile estimator, without needing to specify a
- For more information about percentile approximation algorithms, see advanced aggregation methods.
- For more information about percentile approximation functions, see the hyperfunctions documentation.
|The sketch to extract the mean value from, usually from a |
|The average of the values in the percentile estimate.|
SELECT mean(percentile_agg(data)) FROM generate_series(0, 100) data;
mean ------ 50
Found an issue on this page?Report an issue!