---
title: num_live_ranges() | Tiger Data Docs
description: Count the number of live ranges
---

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

Return the number of live periods from a heartbeat aggregate.

## Samples

Given a table called `liveness` containing weekly heartbeat aggregates in column `health` with timestamp column `date`, use this query to see how many intervals the system was up in a given week:

```
SELECT num_live_ranges(health)
FROM liveness
WHERE date = '01-9-2022 UTC'
```

Returns:

```
 num_live_ranges
---------
 5
```

## Arguments

The syntax is:

```
num_live_ranges(
    agg HEARTBEATAGG
) RETURNS BIGINT
```

| Name | Type         | Default | Required | Description                                            |
| ---- | ------------ | ------- | -------- | ------------------------------------------------------ |
| agg  | HeartbeatAgg | -       | ✔        | A heartbeat aggregate to get the number of ranges from |

## Returns

| Column            | Type   | Description                                 |
| ----------------- | ------ | ------------------------------------------- |
| num\_live\_ranges | bigint | The number of live ranges in the aggregate. |