---
title: min_frequency() | Tiger Data Docs
description: Get the minimum bound of the estimated frequency for a given value in a space-saving aggregate
---

Since [1.16.0](https://github.com/timescale/timescaledb-toolkit/releases/tag/1.16.0)

Get the minimum bound of the estimated frequency for a given value in a space-saving aggregate.

## Samples

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

```
SELECT min_frequency(
    (SELECT mcv_agg(20, value) FROM value_test),
    3
);
```

## Arguments

The syntax is:

```
min_frequency (
    agg SpaceSavingAggregate,
    value AnyElement
) RETURNS DOUBLE PRECISION
```

| Name    | Type                 | Default | Required | Description                                                                                                                                                                                                            |
| ------- | -------------------- | ------- | -------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `agg`   | SpaceSavingAggregate | -       | ✔        | A space-saving aggregate created using either [`freq_agg`](/docs/reference/toolkit/frequency-analysis/freq_agg/freq_agg/index.md) or [`mcv_agg`](/docs/reference/toolkit/frequency-analysis/freq_agg/mcv_agg/index.md) |
| `value` | AnyElement           | -       | ✔        | The value to get the frequency of                                                                                                                                                                                      |

## Returns

| Column         | Type             | Description                                                                                                                                                                                                                                                                                 |
| -------------- | ---------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| min\_frequency | DOUBLE PRECISION | The minimum bound for the value’s estimated frequency. The minimum frequency might be 0 if the value’s frequency falls below the space-saving aggregate’s cut-off threshold. For more information, see [`freq_agg`](/docs/reference/toolkit/frequency-analysis/freq_agg/freq_agg/index.md). |