Calculate downtime from a heartbeat aggregate, taking the heartbeat aggregate from the preceding interval to interpolate
values at the boundary. This checks when the last heartbeat in the predecessor was received and makes sure not to
consider the heartbeat interval after that time as unhealthy, even if it extends into the current aggregate prior to the
first heartbeat.
Given a table called liveness containing weekly heartbeat aggregates in column health with timestamp column date,
use this command to get the total interpolated downtime of the system during the week of Jan 9, 2022.
SELECT interpolated_downtime(health, pred)
FROM (
SELECTdate, health, LAG(health) OVER (ORDER BYdate) AS pred