gauge_agg()

Early access 1.6.0

This is the first step for performing any aggregate calculations on gauge data. Use gauge_agg to create an intermediate aggregate from your data. This intermediate form can then be used by one or more accessors in this group to compute final results. Optionally, you can combine multiple intermediate aggregate objects with rollup() before an accessor is applied.

Samples

Create a gauge aggregate to summarize daily gauge data.

SELECT
  time_bucket('1 day'::interval, ts) as dt,
  gauge_agg(ts, val) AS cs
FROM foo
WHERE id = 'bar'
GROUP BY time_bucket('1 day'::interval, ts)

Arguments

The syntax is:

gauge_agg(
  ts TIMESTAMPTZ,
  value DOUBLE PRECISION
  [, bounds TSTZRANGE]
) RETURNS GaugeSummary

Name	Type	Default	Required	Description
ts	TIMESTAMPTZ	-	✔	The time at each point
value	DOUBLE PRECISION	-	✔	The value of the gauge at each point
bounds	TSTZRANGE	-		The smallest and largest possible times that can be input to this aggregate. Bounds are required for extrapolation, but not for other accessor functions. If you don’t specify bounds at aggregate creation time, you can add them later using the with_bounds function.

Returns

Column	Type	Description
gauge_agg	GaugeSummary	The gauge aggregate, containing data about the variables in an intermediate form. Pass the aggregate to accessor functions in the gauge aggregates API to perform final calculations. Or, pass the aggregate to rollup functions to combine multiple gauge aggregates into larger aggregates.