API ReferenceHyperfunctionsStatistical aggregatesnum_vals
Versions:

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

num_vals(summary StatsSummary1D) RETURNS BIGINT
num_vals(summary StatsSummary2D) RETURNS BIGINT

Get the number of values contained in a statistical aggregate. This saves space when you need both a count and other statistical aggregates as part of a continuous aggregate. You do not need to specify a separate count aggregate.

For more information about statistical aggregate functions, see the hyperfunctions documentation.

Required arguments

NameTypeDescription
summaryStatsSummary1D/StatsSummary2DThe already constructed data structure from a previous stats_agg call

Returns

ColumnTypeDescription
num_valsBIGINTThe number of values in the stats agg

Sample usage

SELECT num_vals(stats_agg(data))
FROM generate_series(0, 100) data;
num_vals
-----------
       101

Found an issue on this page?

Report an issue!

Keywords

statisticsstatistical aggregatehyperfunctionstoolkit
Previouskurtosis / kurtosis_y / kurtosis_xNextskewness / skewness_y / skewness_x

Related Content

CREATE MATERIALIZED VIEW (Continuous Aggregate)
The CREATE MATERIALIZED VIEW statement is used to create continuous aggregates
into_values (for freq_agg)
This function returns the data accumulated in a frequency aggregate or top N aggregate
topn
Returns the most common values accumulated in a frequency aggregate or top N aggregate
average / average_y / average_x
Get the average of the values contained in a statistical aggregate