min_frequency() and max_frequency()

Toolkit

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

Experimental

Experimental features are not suitable for production environments. They are included under the TimescaleDB experimental schema. Click to learn more.

Returns the minimum or maximum estimated frequencies of a value within a dataset.

max_frequency (
    agg SpaceSavingAggregate,
    value AnyElement
) RETURNS DOUBLE PRECISION

min_frequency and max_frequency are accessors that operate on a frequency aggregate or a top N aggregate. Create a frequency or top N aggregate over the original dataset, then call min_frequency and max_frequency on the aggregate.

Required arguments

Returns

Sample usage

Find the minimum frequency of the value 3 in a column named value within the table value_test:

SELECT toolkit_experimental.min_frequency(
    (SELECT toolkit_experimental.freq_agg(0.05, value) FROM value_test),
    3
);

Find the maximum frequency of the value foo in a column named value within the table value_test:

SELECT toolkit_experimental.max_frequency(
    (SELECT toolkit_experimental.freq_agg(0.05, value) FROM value_test),
    'foo'
);