queries.md

Count number of readings over threshold over last 24h

POST /sensor_readings/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "readingDate": {
              "gte": "now-24h"
            }
          }
        },
        {
          "range": {
            "deltaMovementInMm": {
              "gte": 5
            }
          }
        },
        {
          "match": {
            "status": "ON"
          }
        },
        {
          "range": {
            "readingPlacement.depthInMeter": {
              "gte": 1
            }
          }
        }
      ]
    }
  },
  "size": 0
}

All over threshold and see what sensors are above the threshold (with number of readings)

POST /sensor_readings/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "readingDate": {
              "gte": "now-1d"
            }
          }
        },
        {
          "range": {
            "deltaMovementInMm": {
              "gte": 5
            }
          }
        },
        {
          "match": {
            "status": "ON"
          }
        },
        {
          "range": {
            "readingPlacement.depthInMeter": {
              "gte": 1
            }
          }
        }
      ]
    }
  },
  "size": 0,
  "aggs": {
    "sensorsOverThreshold": {
      "nested": {
        "path": "sensor"
      },
      "aggs": {
        "sensorIds": {
          "terms": {
            "field": "sensor.id",
            "size": 500,
            "order": {
              "_count": "desc"
            }
          }
        }
      }
    }
  }
}

Date histogram of one minute intervals (max reading)

POST /sensor_readings/_search
{
  "size": 0,
  "query": {
    "range": {
      "readingDate": {
        "gte": "now-10m"
      }
    }
  },
  "aggs": {
    "max_movement_per_min": {
      "date_histogram": {
        "field": "readingDate",
        "fixed_interval": "1m",
        "time_zone": "Europe/Oslo",
        "extended_bounds": {
          "min": "now-10m",
          "max": "now"
        }
      },
      "aggs": {
        "max_reading": {
          "max": {
            "field": "deltaMovementInMm"
          }
        }
      }
    }
  }
}

Get all sensors

POST /sensor_readings/_search
{
  "size": 0,
  "aggs": {
    "top_tags": {
      "terms": {
        "field": "sensorId",
        "size": 100
      },
      "aggs": {
        "top_sales_hits": {
          "top_hits": {
            "sort": [
              {
                "readingDate": {
                  "order": "desc"
                }
              }
            ],
            "size": 1
          }
        }
      }
    }
  }
}