Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- GET _search
- {
- "query": {
- "bool": {
- "must": [
- {
- "match": {
- "site.id": "757"
- }
- },
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-29T22:00:00.000",
- "lt": "2016-01-31T22:00:00.000"
- }
- }
- }
- ]
- }
- },
- "from": 0,
- "size": 0,
- "aggs": {
- "non-operating-hours": {
- "filter": {
- "bool": {
- "should": [
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-30T00:00:00.000",
- "lt": "2016-01-30T09:00:00.000"
- }
- }
- },
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-31T00:00:00.000",
- "lt": "2016-01-31T09:00:00.000"
- }
- }
- },
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-30T17:00:00.000",
- "lt": "2016-01-30T23:59:59.000"
- }
- }
- },
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-31T17:00:00.000",
- "lt": "2016-01-31T23:59:59.000"
- }
- }
- }
- ]
- }
- },
- "aggs": {
- "sum_kwh": {
- "sum": {
- "field": "kwh_avg"
- }
- }
- }
- },
- "operating-hours": {
- "filter": {
- "bool": {
- "should": [
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-30T09:00:00.000",
- "lt": "2016-01-30T17:00:00.000"
- }
- }
- },
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-31T09:00:00.000",
- "lt": "2016-01-31T17:00:00.000"
- }
- }
- }
- ]
- }
- },
- "aggs": {
- "sum_kwh": {
- "sum": {
- "field": "kwh_avg"
- }
- }
- }
- },
- "peak": {
- "filter": {
- "bool": {
- "should": [
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-30T07:00:00.000",
- "lt": "2016-01-30T23:59:59.000"
- }
- }
- },
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-31T07:00:00.000",
- "lt": "2016-01-31T23:59:59.000"
- }
- }
- }
- ]
- }
- },
- "aggs": {
- "sum_kwh": {
- "sum": {
- "field": "kwh_avg"
- }
- },
- "sum_kwh_cost": {
- "sum": {
- "field": "kwh_avg",
- "script": {
- "inline": "_value * cost",
- "params": {
- "cost": 22.5
- }
- }
- }
- }
- }
- },
- "off-peak": {
- "filter": {
- "bool": {
- "should": [
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-30T00:00:00.000",
- "lt": "2016-01-30T06:59:59.000"
- }
- }
- },
- {
- "range": {
- "timestamp": {
- "gte": "2016-01-31T00:00:00.000",
- "lt": "2016-01-31T06:59:59.000"
- }
- }
- }
- ]
- }
- },
- "aggs": {
- "sum_kwh": {
- "sum": {
- "field": "kwh_avg"
- }
- },
- "sum_kwh_cost": {
- "sum": {
- "field": "kwh_avg",
- "script": {
- "inline": "_value * cost",
- "params": {
- "cost": 5.5
- }
- }
- }
- }
- }
- }
- }
- }
- {
- "took": 282,
- "timed_out": false,
- "_shards": {
- "total": 230,
- "successful": 230,
- "failed": 0
- },
- "hits": {
- "total": 139301,
- "max_score": 0,
- "hits": []
- },
- "aggregations": {
- "operating-hours": {
- "doc_count": 46440,
- "sum_kwh": {
- "value": 0.5701111111111342
- }
- },
- "off-peak": {
- "doc_count": 40612,
- "sum_kwh_cost": {
- "value": 3.438416666666704
- },
- "sum_kwh": {
- "value": 0.6251666666666927
- }
- },
- "peak": {
- "doc_count": 92881,
- "sum_kwh_cost": {
- "value": 336.82687499999844
- },
- "sum_kwh": {
- "value": 14.97008333333339
- }
- },
- "non-operating-hours": {
- "doc_count": 87053,
- "sum_kwh": {
- "value": 15.02513888888894
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement