intercept()

The intercept of the least squares fit line computed from the adjusted counter values and times input in the CounterSummary. This corresponds to the projected value at the PostgreSQL epoch (2000-01-01 00:00:00+00). This is useful for drawing the best fit line on a graph, using the slope and the intercept.

2. intercept(

4. summary CounterSummary

6. ) RETURNS DOUBLE PRECISION

For more information about counter aggregation functions, see the hyperfunctions documentation.

Required arguments

Returns

Sample usage

2. SELECT

4. id,

6. bucket,

8. intercept(summary)

10. FROM (

12. SELECT

14. id,

16. time_bucket('15 min'::interval, ts) AS bucket,

18. counter_agg(ts, val) AS summary

20. FROM foo

22. GROUP BY id, time_bucket('15 min'::interval, ts)

24. ) t