SELECT machine, AVG(vib_mm_s) FILTER (WHERE ts > now() - '24 h') - AVG(vib_mm_s) FILTER (WHERE ts <= now() - '24 h') AS trend FROM line_a_sensors -- simulated line, 7 days GROUP BY machine ORDER BY trend DESC;
Bearing 6205-2RS × 1,200 · Shaft seal 25×47 × 400 · Delivery 14 Nov