mean()

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 separate avg aggregate.

Required arguments

NameTypeDescription
sketch/digestUddSketch/tdigestThe sketch to extract the mean value from, usually from a percentile_agg()

Returns

ColumnTypeDescription
meanDOUBLE PRECISIONThe average of the values in the percentile estimate.

Sample usage

SELECT mean(percentile_agg(data))
FROM generate_series(0, 100) data;
mean
------
 50

Found an issue on this page?

Report an issue!

Related Content