Required Arguments

    Optional Arguments

    NameDescription
    prevThe lookup expression for values before the gapfill time range (record)
    nextThe lookup expression for values after the gapfill time range (record)

    Sample Usage

    1. SELECT
    2.   time_bucket_gapfill('1 day', time, now() - INTERVAL '1 week', now()) AS day,
    3.   device_id,
    4.   avg(value) AS value,
    5.   interpolate(avg(temperature),
    6.     (SELECT (time,temperature) FROM metrics m2 WHERE m2.time > now() AND m.device_id = m2.device_id ORDER BY time DESC LIMIT 1)
    7.   ) AS interpolate
    8. FROM metrics m
    9. WHERE time > now () - INTERVAL '1 week'
    11. ORDER BY day;
    13.            day          | device_id | value | interpolate
    14.  2019-01-10 01:00:00+01 |         1 |       |         3.0
    15.  2019-01-11 01:00:00+01 |         1 |   5.0 |         5.0
    16.  2019-01-12 01:00:00+01 |         1 |       |         6.0
    17.  2019-01-13 01:00:00+01 |         1 |   7.0 |         7.0
    18.  2019-01-14 01:00:00+01 |         1 |       |         7.5
    19.  2019-01-15 01:00:00+01 |         1 |   8.0 |         8.0
    21. (7 row)