live_ranges()

Get the live intervals from a heartbeat_agg

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.

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")

Arguments

The syntax is:

live_ranges(
    agg HEARTBEATAGG
) RETURNS TABLE (
    start TIMESTAMPTZ,
    end TIMESTAMPTZ
)

Name	Type	Default	Required	Description
agg	HeartbeatAgg	-	✔	A heartbeat aggregate to get the liveness data from

Returns

Column	Type	Description
live_ranges	TABLE (start TIMESTAMPTZ, end TIMESTAMPTZ)	The (start, end) pairs of when the system was live.