Versions:
time_delta() ToolkitTimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale Cloud. Click to learn more.
Toolkit
TimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale Cloud. Click to learn more.
The observed change in time. Calculated by subtracting the first observed time from the last observed time over the period aggregated. Measured in seconds.
time_delta(
summary CounterSummary
) RETURNS DOUBLE PRECISIONFor more information about counter aggregation functions, see the hyperfunctions documentation.
Required arguments
| Name | Type | Description |
|---|---|---|
| summary | CounterSummary | The input CounterSummary from a counter_agg call |
Returns
| Name | Type | Description |
|---|---|---|
| time_delta | DOUBLE PRECISION | The total duration in seconds between the first and last observed times in the CounterSummary |
Sample usage
SELECT
id,
bucket,
time_delta(summary)
FROM (
SELECT
id,
time_bucket('15 min'::interval, ts) AS bucket,
counter_agg(ts, val) AS summary
FROM foo
GROUP BY id, time_bucket('15 min'::interval, ts)
) tFound an issue on this page?
Report an issue!