Skip to main content
Since 1.15.0 Return a set of (start_time, end_time) pairs representing when the underlying system was live during the interval of the aggregate. 
live_ranges(
    agg HEARTBEATAGG
) RETURNS TABLE (
    start TIMESTAMPTZ,
    end TIMESTAMPTZ
)

​
Arguments

NameTypeDefaultRequiredDescription
aggHeartbeatAgg-✔A heartbeat aggregate to get the liveness data from

​
Returns

ColumnTypeDescription
live_rangesTABLE (start TIMESTAMPTZ, end TIMESTAMPTZ)The (start, end) pairs of when the system was live

​
Samples

Given a table called liveness containing weekly heartbeat aggregates in column health with timestamp column date, use the following to get the intervals where the system was live during the week of Jan 9, 2022. 
SELECT live_ranges(health)
FROM liveness
WHERE date = '01-9-2022 UTC'
Returns: 
                    live_ranges
-----------------------------------------------------
("2022-01-09 00:00:30+00","2022-01-12 15:27:22+00")
("2022-01-12 15:31:17+00","2022-01-16 00:00:00+00")