Skip to content

Instantly share code, notes, and snippets.

@ldenson11

ldenson11/pressurealert.sql Secret

Created December 3, 2019 14:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ldenson11/f301a896845ba7b62e91249357d3f68f to your computer and use it in GitHub Desktop.
Save ldenson11/f301a896845ba7b62e91249357d3f68f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pressurealert.sql
-- find load data > 400psi
SELECT rigId, sensorName, MAX(sensorValue) as MaxLoad
FROM rigData
WHERE sensorType = 'Load'
AND sensorValue > 400
AND ts > CURRENT_TIMESTMAP - interval '5' minutes
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment