idelta_left()
Calculate the instantaneous change at the left, or earliest, edge of a gauge aggregate
Since 1.25.0
Calculate the instantaneous change at the left, or earliest, edge of a gauge aggregate. This is equal to the second value minus the first value when the second value is greater than or equal to the first. When the second value is lower than the first, the result is the second value itself.
Samples
Section titled “Samples”Get the instantaneous change at the start of each 15-minute gauge aggregate.
SELECT id, bucket, idelta_left(summary)FROM ( SELECT id, time_bucket('15 min'::interval, ts) AS bucket, gauge_agg(ts, val) AS summary FROM foo GROUP BY id, time_bucket('15 min'::interval, ts)) tArguments
Section titled “Arguments”The syntax is:
idelta_left( summary GaugeSummary) RETURNS DOUBLE PRECISION| Name | Type | Default | Required | Description |
|---|---|---|---|---|
summary | GaugeSummary | - | ✔ | A gauge aggregate created using gauge_agg |
Returns
Section titled “Returns”| Column | Type | Description |
|---|---|---|
| idelta_left | DOUBLE PRECISION | The instantaneous delta at the left, or earliest, edge of the gauge aggregate |