Skip to content

corr()

Calculate the correlation coefficient from a gauge aggregate

Since 1.25.0

Calculate the correlation coefficient from a gauge aggregate. The calculation uses a linear least-squares fit, and returns a value between -1.0 and 1.0, up to floating-point rounding. The sign matches the sign of slope.

Calculate the correlation coefficient to determine the goodness of a linear fit between gauge value and time.

SELECT
id,
bucket,
corr(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)
) t

The syntax is:

corr(
summary GaugeSummary
) RETURNS DOUBLE PRECISION
NameTypeDefaultRequiredDescription
summaryGaugeSummary-✔A gauge aggregate created using gauge_agg
ColumnTypeDescription
corrDOUBLE PRECISIONThe correlation coefficient calculated with time as the independent variable and gauge value as the dependent variable.