corr()

Calculate the correlation coefficient from a gauge aggregate

Early access Since 1.6.0

Calculate the correlation coefficient from a gauge aggregate. The calculation uses a linear least-squares fit, and returns a value between 0.0 and 1.0, from no correlation to the strongest possible correlation.

Samples

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

Arguments

The syntax is:

corr(
    summary GaugeSummary
) RETURNS DOUBLE PRECISION

Name	Type	Default	Required	Description
summary	GaugeSummary	-	✔	A gauge aggregate created using gauge_agg

Returns

Column	Type	Description
corr	DOUBLE PRECISION	The correlation coefficient calculated with time as the independent variable and gauge value as the dependent variable.