Am 2014-03-27 09:23, schrieb Andreas Goetz:
> Hallo Bernd,
>
> 15sec für die Abfrage sind immer noch ziemlich mächtig. Könntest Du
> das relevante JSON bitte mal raussuchen (Debugkonsole im Firefox mit
> Ctrl-Shift-K), mit &debug=1 die URL verlängern, aufrufen und mit den
> Output schicken?
klar:
Laufzeit:
Unbekannte Eigenschaft 'zoom'. Deklaration ignoriert.
jquery-treeTable.css:14
21:44:16.058 Unbekannte Eigenschaft '-moz-border-radius'. Deklaration
ignoriert. style.css:38
21:44:16.058 Unbekannte Eigenschaft '-moz-border-radius'. Deklaration
ignoriert. style.css:96
21:44:16.058 'none' oder URL erwartet, aber 'alpha(' gefunden. Fehler
beim Verarbeiten des Wertes für 'filter'. Deklaration ignoriert.
style.css:129
21:44:16.058 Unbekannte Eigenschaft '-moz-opacity'. Deklaration
ignoriert. style.css:130
21:44:16.141 Unbekannte Eigenschaft 'box-sizing'. Deklaration
ignoriert. index.html
21:44:16.254 GET http://volkszaehler/middleware.php/capabilities.json
[HTTP/1.1 200 OK 139ms]
21:44:16.416 GET
http://volkszaehler/middleware.php/entity/fc73fdb0-831f-11e2-ab63-050a66acca61.json
[HTTP/1.1 200 OK 1359ms]
21:44:16.417 GET
http://volkszaehler/middleware.php/entity/8102dbc0-6fcd-11e2-a8b7-a1307aa80770.json
[HTTP/1.1 200 OK 1475ms]
21:44:16.417 GET
http://volkszaehler/middleware.php/entity/16a5a410-8a11-11e2-bfb5-55e9d027a1f8.json
[HTTP/1.1 200 OK 1350ms]
21:44:16.417 GET
http://volkszaehler/middleware.php/entity/2dd2cb00-8a11-11e2-b8a9-214e007465a4.json
[HTTP/1.1 200 OK 1382ms]
21:44:16.418 GET
http://volkszaehler/middleware.php/entity/3c391a00-8a11-11e2-92ec-0d9f1daff99d.json
[HTTP/1.1 200 OK 1404ms]
21:44:16.418 GET
http://volkszaehler/middleware.php/entity/1e6e25a0-8a11-11e2-96be-cd4b755a40c6.json
[HTTP/1.1 200 OK 1407ms]
21:44:16.419 GET
http://volkszaehler/middleware.php/entity/2414a2e0-8a11-11e2-8319-eb6370d8f760.json
[HTTP/1.1 200 OK 2670ms]
21:44:16.419 GET
http://volkszaehler/middleware.php/entity/27fd1e00-89c9-11e2-bc92-c922d3bff0dc.json
[HTTP/1.1 200 OK 2659ms]
21:44:16.419 GET
http://volkszaehler/middleware.php/entity/635481a0-6fcd-11e2-8587-eda25228f8bf.json
[HTTP/1.1 200 OK 2695ms]
21:44:16.419 GET
http://volkszaehler/middleware.php/entity/3a513760-89c9-11e2-8948-81bd1f67b0d0.json
[HTTP/1.1 200 OK 2673ms]
21:44:16.420 GET
http://volkszaehler/middleware.php/entity/89a19f80-6fcd-11e2-be46-d7713e888ef4.json
[HTTP/1.1 200 OK 2684ms]
21:44:19.220 GET http://volkszaehler/middleware.php/data.json [HTTP/1.1
200 OK 13850ms]
21:44:33.062 Fehler beim Verarbeiten des Wertes für 'width'.
Deklaration ignoriert. index.html
URL:
http://volkszaehler/middleware.php/data.json?from=1395866656140&to=1395953056140&tuples=433&uuid[]=fc73fdb0-831f-11e2-ab63-050a66acca61&uuid[]=8102dbc0-6fcd-11e2-a8b7-a1307aa80770&uuid[]=16a5a410-8a11-11e2-bfb5-55e9d027a1f8&uuid[]=2dd2cb00-8a11-11e2-b8a9-214e007465a4&uuid[]=3c391a00-8a11-11e2-92ec-0d9f1daff99d&uuid[]=1e6e25a0-8a11-11e2-96be-cd4b755a40c6&uuid[]=2414a2e0-8a11-11e2-8319-eb6370d8f760&uuid[]=27fd1e00-89c9-11e2-bc92-c922d3bff0dc&uuid[]=635481a0-6fcd-11e2-8587-eda25228f8bf&uuid[]=3a513760-89c9-11e2-8948-81bd1f67b0d0&uuid[]=89a19f80-6fcd-11e2-be46-d7713e888ef4&debug=1
Output:
{
"version": "0.3",
"data": [
{
"uuid": "fc73fdb0-831f-11e2-ab63-050a66acca61",
"from": 1395866534886,
"to": 1395953132737,
"min": [
1395896090155,
1.338
],
"max": [
1395927444188,
14.238
],
"average": 8.523,
"rows": 475,
"tuples": [
[
1395866880576,
4.548,
5
],
[
1395867225030,
4.608,
5
],
[
1395867569297,
4.462,
5
],
[
1395867923259,
4.212,
5
],
[
1395868265475,
4.088,
5
],
[
1395868607606,
3.814,
5
],
[
1395868951730,
3.488,
5
],
[
1395869294477,
3.378,
5
],
[
1395869635181,
3.286,
5
],
[
1395869978313,
3.38,
5
],
[
1395870321397,
3.464,
5
],
[
1395870664883,
3.548,
5
],
[
1395871007552,
3.326,
5
],
[
1395871363977,
3.124,
5
],
[
1395871701447,
2.838,
5
],
[
1395872041192,
2.586,
5
],
[
1395872384928,
2.428,
5
],
[
1395872727251,
2.186,
5
],
[
1395873066816,
1.876,
5
],
[
1395873404611,
1.702,
5
],
[
1395873745060,
1.688,
5
],
[
1395874083260,
1.864,
5
],
[
1395874421783,
2.024,
5
],
[
1395874761558,
2.4,
5
],
[
1395875113618,
2.75,
5
],
[
1395875454462,
2.952,
5
],
[
1395875792706,
3.036,
5
],
[
1395876133393,
3.084,
5
],
[
1395876477929,
3.148,
5
],
[
1395876822135,
3.238,
5
],
[
1395877164266,
3.338,
5
],
[
1395877511202,
3.452,
5
],
[
1395877859084,
3.548,
5
],
[
1395878201554,
3.674,
5
],
[
1395878551811,
3.864,
5
],
[
1395878889347,
4.012,
5
],
[
1395879229017,
4.048,
5
],
[
1395879568989,
4.108,
5
],
[
1395879913014,
4.148,
5
],
[
1395880258532,
4.214,
5
],
[
1395880599066,
4.274,
5
],
[
1395880945282,
4.31,
5
],
[
1395881293031,
4.31,
5
],
[
1395881631624,
4.338,
5
],
[
1395881971658,
4.38,
5
],
[
1395882319133,
4.452,
5
],
[
1395882663360,
4.536,
5
],
[
1395883005381,
4.648,
5
],
[
1395883346376,
4.726,
5
],
[
1395883685866,
4.738,
5
],
[
1395884026341,
4.738,
5
],
[
1395884367493,
4.712,
5
],
[
1395884705341,
4.596,
5
],
[
1395885044309,
4.5,
5
],
[
1395885383680,
4.44,
5
],
[
1395885732224,
4.416,
5
],
[
1395886076441,
4.31,
5
],
[
1395886417178,
4.352,
5
],
[
1395886761153,
4.392,
5
],
[
1395887104681,
4.44,
5
],
[
1395887451703,
4.44,
5
],
[
1395887817252,
4.404,
5
],
[
1395888181195,
4.264,
5
],
[
1395888550795,
4.086,
5
],
[
1395888917302,
3.952,
5
],
[
1395889289122,
3.84,
5
],
[
1395889662219,
3.702,
5
],
[
1395890042432,
3.598,
5
],
[
1395890424049,
3.476,
5
],
[
1395890801908,
3.38,
5
],
[
1395891173170,
3.198,
5
],
[
1395891547294,
2.85,
5
],
[
1395891924480,
2.648,
5
],
[
1395892301906,
2.548,
5
],
[
1395892656912,
2.326,
5
],
[
1395893006001,
2.124,
5
],
[
1395893346247,
2.188,
5
],
[
1395893685171,
2.098,
5
],
[
1395894023236,
1.988,
5
],
[
1395894366807,
1.952,
5
],
[
1395894706003,
1.776,
5
],
[
1395895045358,
1.662,
5
],
[
1395895393163,
1.464,
5
],
[
1395895739034,
1.364,
5
],
[
1395896090155,
1.338,
5
],
[
1395896440573,
1.428,
5
],
[
1395896783744,
1.55,
5
],
[
1395897125555,
1.69,
5
],
[
1395897468433,
1.738,
5
],
[
1395897811716,
1.738,
5
],
[
1395898159008,
1.598,
5
],
[
1395898500785,
1.56,
5
],
[
1395898858376,
1.624,
5
],
[
1395899202663,
1.84,
5
],
[
1395899547358,
1.988,
5
],
[
1395899892440,
2.212,
5
],
[
1395900248268,
2.488,
5
],
[
1395900588276,
2.838,
5
],
[
1395900929808,
3.212,
5
],
[
1395901272092,
4.126,
5
],
[
1395901613357,
7.126,
5
],
[
1395901953795,
8.738,
5
],
[
1395902293278,
10,
5
],
[
1395902638140,
10.836,
5
],
[
1395902977725,
11.824,
5
],
[
1395903316422,
11.526,
5
],
[
1395903661060,
9.014,
5
],
[
1395904004881,
8.586,
5
],
[
1395904345932,
8.878,
5
],
[
1395904692132,
8.838,
5
],
[
1395905032565,
9.25,
5
],
[
1395905380779,
11.688,
5
],
[
1395905723139,
13.276,
5
],
[
1395906063614,
11.738,
5
],
[
1395906403762,
9.426,
5
],
[
1395906744542,
10.114,
5
],
[
1395907103023,
12.036,
5
],
[
1395907452296,
12.086,
5
],
[
1395907794757,
13.236,
5
],
[
1395908137772,
13.802,
5
],
[
1395908477161,
14.024,
5
],
[
1395908816589,
13.676,
5
],
[
1395909155782,
13.564,
5
],
[
1395909496470,
13.224,
5
],
[
1395909836306,
13.488,
5
],
[
1395910174802,
13.352,
5
],
[
1395910514877,
13.476,
5
],
[
1395910859243,
13.422,
5
],
[
1395911201183,
12.838,
5
],
[
1395911542655,
11.776,
5
],
[
1395911884061,
11.572,
5
],
[
1395912224609,
11.392,
5
],
[
1395912563131,
11.366,
5
],
[
1395912907401,
11.612,
5
],
[
1395913250983,
11.714,
5
],
[
1395913600371,
11.636,
5
],
[
1395913943784,
11.614,
5
],
[
1395914293487,
11.938,
5
],
[
1395914639776,
12,
5
],
[
1395914980626,
11.94,
5
],
[
1395915323058,
11.952,
5
],
[
1395915664206,
12.012,
5
],
[
1395916008628,
12.2,
5
],
[
1395916350994,
11.976,
5
],
[
1395916691504,
12.214,
5
],
[
1395917032094,
12.276,
5
],
[
1395917375324,
12.276,
5
],
[
1395917718868,
12.54,
5
],
[
1395918080466,
12.724,
5
],
[
1395918430118,
12.864,
5
],
[
1395918781589,
13.15,
5
],
[
1395919124450,
13.302,
5
],
[
1395919476638,
13.39,
5
],
[
1395919818340,
13.338,
5
],
[
1395920158974,
13.414,
5
],
[
1395920502106,
13.524,
5
],
[
1395920846667,
13.488,
5
],
[
1395921189728,
13.4,
5
],
[
1395921535096,
13.134,
5
],
[
1395921903410,
13.174,
5
],
[
1395922247433,
13.214,
5
],
[
1395922598024,
13.2,
5
],
[
1395922945350,
13.392,
5
],
[
1395923290639,
13.364,
5
],
[
1395923635496,
13.338,
5
],
[
1395923989861,
13.352,
5
],
[
1395924342793,
13.34,
5
],
[
1395924688098,
13.524,
5
],
[
1395925028849,
13.648,
5
],
[
1395925382475,
13.688,
5
],
[
1395925725104,
13.75,
5
],
[
1395926069684,
13.89,
5
],
[
1395926413013,
13.876,
5
],
[
1395926755195,
13.988,
5
],
[
1395927099448,
14.2,
5
],
[
1395927444188,
14.238,
5
],
[
1395927812168,
14.148,
5
],
[
1395928156138,
14.06,
5
],
[
1395928508582,
14,
5
],
[
1395928857052,
13.976,
5
],
[
1395929204800,
14.072,
5
],
[
1395929547953,
14.134,
5
],
[
1395929909926,
14.226,
5
],
[
1395930252587,
14.238,
5
],
[
1395930594299,
14.072,
5
],
[
1395930938196,
14.012,
5
],
[
1395931281726,
14,
5
],
[
1395931625241,
13.988,
5
],
[
1395931966757,
14.024,
5
],
[
1395932308227,
13.976,
5
],
[
1395932655427,
13.988,
5
],
[
1395932997673,
14.012,
5
],
[
1395933340971,
13.94,
5
],
[
1395933684276,
13.892,
5
],
[
1395934027289,
13.88,
5
],
[
1395934368323,
13.852,
5
],
[
1395934708764,
13.714,
5
],
[
1395935053325,
13.646,
5
],
[
1395935395671,
13.548,
5
],
[
1395935744833,
13.512,
5
],
[
1395936106381,
13.44,
5
],
[
1395936449775,
13.392,
5
],
[
1395936797516,
13.314,
5
],
[
1395937140219,
13.25,
5
],
[
1395937484841,
13.19,
5
],
[
1395937826566,
13.16,
5
],
[
1395938172178,
13.148,
5
],
[
1395938517364,
13.096,
5
],
[
1395938862737,
13.072,
5
],
[
1395939204656,
13,
5
],
[
1395939546696,
12.878,
5
],
[
1395939900451,
12.738,
5
],
[
1395940242375,
12.612,
5
],
[
1395940583625,
12.34,
5
],
[
1395940928784,
12.162,
5
],
[
1395941272503,
12.024,
5
],
[
1395941613021,
11.826,
5
],
[
1395941955269,
11.598,
5
],
[
1395942298549,
11.416,
5
],
[
1395942644444,
11.264,
5
],
[
1395942989369,
11.038,
5
],
[
1395943342172,
10.85,
5
],
[
1395943686126,
10.764,
5
],
[
1395944032518,
10.572,
5
],
[
1395944377487,
10.572,
5
],
[
1395944722264,
10.5,
5
],
[
1395945067822,
10.324,
5
],
[
1395945410677,
10.25,
5
],
[
1395945751643,
10.148,
5
],
[
1395946094407,
10.2,
5
],
[
1395946438387,
10.072,
5
],
[
1395946780641,
10.06,
5
],
[
1395947137104,
9.964,
5
],
[
1395947482064,
9.88,
5
],
[
1395947825760,
9.812,
5
],
[
1395948169422,
9.75,
5
],
[
1395948513881,
9.588,
5
],
[
1395948859669,
9.224,
5
],
[
1395949205137,
9.176,
5
],
[
1395949550141,
8.962,
5
],
[
1395949895325,
8.686,
5
],
[
1395950241178,
8.62,
5
],
[
1395950593084,
8.488,
5
],
[
1395950937155,
8.314,
5
],
[
1395951279035,
8.412,
5
],
[
1395951622355,
8.674,
5
],
[
1395951965259,
8.788,
5
],
[
1395952306919,
8.786,
5
],
[
1395952649220,
8.55,
5
],
[
1395952994370,
8.44,
5
],
[
1395953132737,
8.38,
2
]
]
},
{
"uuid": "8102dbc0-6fcd-11e2-a8b7-a1307aa80770",
"from": 1395866583474,
"to": 1395953143280,
"min": [
1395894620313,
0.003
],
"max": [
1395894695044,
1.956
],
"average": 0.194,
"consumption": 4.66,
"rows": 536,
"tuples": [
[
1395866667597,
0.856,
2
],
[
1395866758132,
0.795,
2
],
[
1395866849916,
0.784,
2
],
[
1395866948347,
0.731,
2
],
[
1395894620313,
0.003,
2
],
[
1395894658237,
1.899,
2
],
[
1395894695044,
1.956,
2
],
[
1395894733167,
1.889,
2
],
[
1395894783045,
1.444,
2
],
[
1395894836171,
1.355,
2
],
[
1395894889413,
1.352,
2
],
[
1395894946239,
1.267,
2
],
[
1395895006399,
1.197,
2
],
[
1395895069605,
1.139,
2
],
[
1395895136095,
1.083,
2
],
[
1395895206039,
1.029,
2
],
[
1395895278750,
0.99,
2
],
[
1395895353956,
0.957,
2
],
[
1395895433273,
0.908,
2
],
[
1395895515926,
0.871,
2
],
[
1395895602593,
0.831,
2
],
[
1395895693514,
0.792,
2
],
[
1395895787780,
0.764,
2
],
[
1395895883974,
0.748,
2
],
[
1395895981455,
0.739,
2
],
[
1395896637610,
0.11,
2
],
[
1395896773672,
0.529,
2
],
[
1395896914662,
0.511,
2
],
[
1395897026653,
0.643,
2
],
[
1395897115723,
0.808,
2
],
[
1395897234633,
0.605,
2
],
[
1395897357228,
0.587,
2
],
[
1395897467156,
0.655,
2
],
[
1395897522546,
1.3,
2
],
[
1395897561709,
1.838,
2
],
[
1395897600781,
1.843,
2
],
[
1395897639675,
1.851,
2
],
[
1395897678502,
1.854,
2
],
[
1395897717574,
1.843,
2
],
[
1395897757292,
1.813,
2
],
[
1395897801623,
1.624,
2
],
[
1395897848663,
1.531,
2
],
[
1395897898275,
1.451,
2
],
[
1395897951199,
1.36,
2
],
[
1395898006005,
1.314,
2
],
[
1395898061196,
1.305,
2
],
[
1395898119808,
1.228,
2
],
[
1395898181991,
1.158,
2
],
[
1395898244315,
1.155,
2
],
[
1395898308706,
1.118,
2
],
[
1395898379072,
1.023,
2
],
[
1395898455225,
0.945,
2
],
[
1395898535428,
0.898,
2
],
[
1395898619571,
0.856,
2
],
[
1395899276191,
0.11,
2
],
[
1395899412495,
0.528,
2
],
[
1395899556354,
0.5,
2
],
[
1395900371712,
0.088,
2
],
[
1395900880331,
0.142,
2
],
[
1395900919979,
1.816,
2
],
[
1395900959197,
1.836,
2
],
[
1395901004885,
1.576,
2
],
[
1395901063789,
1.222,
2
],
[
1395901121671,
1.244,
2
],
[
1395901180416,
1.226,
2
],
[
1395901243343,
1.144,
2
],
[
1395901307473,
1.123,
2
],
[
1395901377061,
1.035,
2
],
[
1395901459737,
0.871,
2
],
[
1395901543956,
0.855,
2
],
[
1395901652126,
0.666,
2
],
[
1395902320790,
0.108,
2
],
[
1395902462410,
0.508,
2
],
[
1395902604089,
0.508,
2
],
[
1395902746012,
0.507,
2
],
[
1395902888383,
0.506,
2
],
[
1395903030951,
0.505,
2
],
[
1395903173316,
0.506,
2
],
[
1395903316022,
0.505,
2
],
[
1395903457462,
0.509,
2
],
[
1395903599395,
0.507,
2
],
[
1395903741838,
0.505,
2
],
[
1395904355736,
0.117,
2
],
[
1395904409337,
1.343,
2
],
[
1395904449757,
1.781,
2
],
[
1395904492920,
1.668,
2
],
[
1395904560724,
1.062,
2
],
[
1395904630505,
1.032,
2
],
[
1395904700863,
1.023,
2
],
[
1395904777220,
0.943,
2
],
[
1395904856111,
0.913,
2
],
[
1395904938528,
0.874,
2
],
[
1395905025435,
0.828,
2
],
[
1395905705775,
0.106,
2
],
[
1395905846758,
0.511,
2
],
[
1395906338087,
0.147,
2
],
[
1395906867662,
0.136,
2
],
[
1395907004435,
0.526,
2
],
[
1395907146649,
0.506,
2
],
[
1395907278157,
0.547,
2
],
[
1395908384250,
0.065,
2
],
[
1395908508347,
0.58,
2
],
[
1395908629180,
0.596,
2
],
[
1395908683701,
1.321,
2
],
[
1395908734410,
1.42,
2
],
[
1395908819059,
0.851,
2
],
[
1395908906581,
0.823,
2
],
[
1395908993592,
0.827,
2
],
[
1395909080941,
0.824,
2
],
[
1395909175213,
0.764,
2
],
[
1395910321893,
0.063,
2
],
[
1395910454567,
0.543,
2
],
[
1395910597048,
0.505,
2
],
[
1395910915434,
0.226,
2
],
[
1395911046536,
0.549,
2
],
[
1395911187932,
0.509,
2
],
[
1395911329402,
0.509,
2
],
[
1395912275569,
0.076,
2
],
[
1395912417373,
0.508,
2
],
[
1395912820830,
0.178,
2
],
[
1395912955649,
0.534,
2
],
[
1395914213921,
0.057,
2
],
[
1395914355008,
0.51,
2
],
[
1395914497544,
0.505,
2
],
[
1395914571829,
0.969,
2
],
[
1395914618772,
1.534,
2
],
[
1395914676163,
1.255,
2
],
[
1395914766474,
0.797,
2
],
[
1395914858634,
0.781,
2
],
[
1395914958820,
0.719,
2
],
[
1395915060466,
0.708,
2
],
[
1395915975297,
0.079,
2
],
[
1395916112333,
0.525,
2
],
[
1395916254735,
0.506,
2
],
[
1395916616507,
0.199,
2
],
[
1395918013638,
0.052,
2
],
[
1395918151848,
0.521,
2
],
[
1395918292958,
0.51,
2
],
[
1395918638758,
0.208,
2
],
[
1395919130541,
0.146,
2
],
[
1395919263172,
0.543,
2
],
[
1395919403407,
0.513,
2
],
[
1395920154853,
0.096,
2
],
[
1395920282953,
0.562,
2
],
[
1395920791466,
0.142,
2
],
[
1395920930919,
0.516,
2
],
[
1395921058233,
0.566,
2
],
[
1395921111357,
1.355,
2
],
[
1395921153507,
1.708,
2
],
[
1395921200395,
1.536,
2
],
[
1395921270216,
1.031,
2
],
[
1395921341002,
1.017,
2
],
[
1395921414150,
0.984,
2
],
[
1395921493678,
0.905,
2
],
[
1395921577132,
0.863,
2
],
[
1395921664783,
0.821,
2
],
[
1395921794332,
0.556,
2
],
[
1395922490723,
0.103,
2
],
[
1395923305021,
0.088,
2
],
[
1395923438464,
0.54,
2
],
[
1395923969429,
0.136,
2
],
[
1395924489182,
0.139,
2
],
[
1395925621808,
0.064,
2
],
[
1395925748892,
0.567,
2
],
[
1395926297851,
0.131,
2
],
[
1395926494907,
0.365,
2
],
[
1395926535836,
1.759,
2
],
[
1395926576997,
1.749,
2
],
[
1395926650029,
0.986,
2
],
[
1395926727557,
0.929,
2
],
[
1395926801217,
0.977,
2
],
[
1395926882436,
0.886,
2
],
[
1395926967326,
0.848,
2
],
[
1395927058343,
0.791,
2
],
[
1395927148071,
0.802,
2
],
[
1395927539301,
0.184,
2
],
[
1395927679623,
0.513,
2
],
[
1395928176398,
0.145,
2
],
[
1395929851610,
0.043,
2
],
[
1395929992016,
0.513,
2
],
[
1395931872325,
0.038,
2
],
[
1395931921091,
1.476,
2
],
[
1395931959721,
1.864,
2
],
[
1395932001105,
1.74,
2
],
[
1395932065627,
1.116,
2
],
[
1395932133869,
1.055,
2
],
[
1395932202260,
1.053,
2
],
[
1395932277576,
0.956,
2
],
[
1395932357945,
0.896,
2
],
[
1395932443794,
0.839,
2
],
[
1395932533894,
0.799,
2
],
[
1395935824444,
0.022,
2
],
[
1395936691402,
0.083,
2
],
[
1395936735352,
1.638,
2
],
[
1395936786482,
1.408,
2
],
[
1395936894972,
0.664,
2
],
[
1395936992776,
0.736,
2
],
[
1395937098066,
0.684,
2
],
[
1395939391594,
0.031,
2
],
[
1395939519305,
0.564,
2
],
[
1395942405132,
0.025,
2
],
[
1395942854691,
0.16,
2
],
[
1395942898427,
1.646,
2
],
[
1395942946991,
1.483,
2
],
[
1395943060043,
0.637,
2
],
[
1395943161726,
0.708,
2
],
[
1395943267055,
0.684,
2
],
[
1395947569716,
0.017,
2
],
[
1395947695219,
0.574,
2
],
[
1395948416990,
0.1,
2
],
[
1395948465467,
1.485,
2
],
[
1395948503593,
1.888,
2
],
[
1395948541843,
1.882,
2
],
[
1395948590985,
1.465,
2
],
[
1395948651389,
1.192,
2
],
[
1395948711206,
1.204,
2
],
[
1395948773102,
1.163,
2
],
[
1395948839604,
1.083,
2
],
[
1395948909329,
1.033,
2
],
[
1395948981737,
0.994,
2
],
[
1395949058607,
0.937,
2
],
[
1395949140638,
0.878,
2
],
[
1395949224551,
0.858,
2
],
[
1395949310126,
0.841,
2
],
[
1395949403039,
0.775,
2
],
[
1395952578564,
0.023,
2
],
[
1395952625708,
1.527,
2
],
[
1395952670439,
1.61,
2
],
[
1395952764748,
0.763,
2
],
[
1395952857939,
0.773,
2
],
[
1395952944673,
0.83,
2
],
[
1395953040063,
0.755,
2
],
[
1395953143280,
0.698,
2
]
]
},
{
"uuid": "16a5a410-8a11-11e2-bfb5-55e9d027a1f8",
"from": 1395866530039,
"to": 1395953127213,
"min": [
1395894701459,
20.904
],
"max": [
1395904000021,
36.488
],
"average": 25.56,
"rows": 475,
"tuples": [
[
1395866875927,
25.464,
5
],
[
1395867220018,
25.326,
5
],
[
1395867563622,
25.202,
5
],
[
1395867917939,
25.352,
5
],
[
1395868260479,
27.124,
5
],
[
1395868603056,
32.962,
5
],
[
1395868946494,
30.174,
5
],
[
1395869289867,
28.512,
5
],
[
1395869630641,
27.376,
5
],
[
1395869973525,
26.526,
5
],
[
1395870316201,
25.862,
5
],
[
1395870659566,
25.376,
5
],
[
1395871003157,
25,
5
],
[
1395871356095,
24.66,
5
],
[
1395871697314,
24.388,
5
],
[
1395872036395,
24.186,
5
],
[
1395872379658,
23.988,
5
],
[
1395872722751,
23.826,
5
],
[
1395873062561,
23.674,
5
],
[
1395873400277,
23.56,
5
],
[
1395873740518,
23.44,
5
],
[
1395874078834,
23.338,
5
],
[
1395874417133,
23.226,
5
],
[
1395874756926,
23.134,
5
],
[
1395875109192,
23.036,
5
],
[
1395875450010,
22.964,
5
],
[
1395875787954,
22.88,
5
],
[
1395876127929,
22.798,
5
],
[
1395876472627,
22.738,
5
],
[
1395876816603,
22.662,
5
],
[
1395877158756,
22.584,
5
],
[
1395877505575,
22.512,
5
],
[
1395877853688,
22.452,
5
],
[
1395878197107,
22.392,
5
],
[
1395878544636,
22.324,
5
],
[
1395878885216,
22.262,
5
],
[
1395879224572,
22.214,
5
],
[
1395879564557,
22.162,
5
],
[
1395879907581,
22.096,
5
],
[
1395880253113,
22.06,
5
],
[
1395880594902,
22.012,
5
],
[
1395880939869,
21.976,
5
],
[
1395881287635,
21.94,
5
],
[
1395881626932,
21.88,
5
],
[
1395881967159,
21.824,
5
],
[
1395882313849,
21.798,
5
],
[
1395882657865,
21.75,
5
],
[
1395882999922,
21.714,
5
],
[
1395883341830,
21.69,
5
],
[
1395883681663,
21.634,
5
],
[
1395884021814,
21.62,
5
],
[
1395884362844,
21.56,
5
],
[
1395884701239,
21.548,
5
],
[
1395885039765,
21.5,
5
],
[
1395885379387,
21.488,
5
],
[
1395885725932,
21.452,
5
],
[
1395886070947,
21.416,
5
],
[
1395886411648,
21.38,
5
],
[
1395886755700,
21.38,
5
],
[
1395887099216,
21.31,
5
],
[
1395887443884,
21.31,
5
],
[
1395887810415,
21.286,
5
],
[
1395888174322,
21.25,
5
],
[
1395888544427,
21.238,
5
],
[
1395888911079,
21.19,
5
],
[
1395889278291,
21.19,
5
],
[
1395889654910,
21.148,
5
],
[
1395890033549,
21.12,
5
],
[
1395890413895,
21.12,
5
],
[
1395890793873,
21.06,
5
],
[
1395891164033,
21.06,
5
],
[
1395891538194,
21.06,
5
],
[
1395891916508,
21.024,
5
],
[
1395892292330,
21,
5
],
[
1395892651257,
21,
5
],
[
1395893001324,
20.988,
5
],
[
1395893342007,
20.94,
5
],
[
1395893680612,
20.94,
5
],
[
1395894018869,
20.94,
5
],
[
1395894362255,
20.916,
5
],
[
1395894701459,
20.904,
5
],
[
1395895041262,
21.274,
5
],
[
1395895387037,
23.162,
5
],
[
1395895733394,
23.774,
5
],
[
1395896077913,
25.538,
5
],
[
1395896434137,
30.66,
5
],
[
1395896779392,
27.95,
5
],
[
1395897120726,
29.962,
5
],
[
1395897462965,
34.852,
5
],
[
1395897806451,
26.676,
5
],
[
1395898154525,
25.176,
5
],
[
1395898496207,
24.75,
5
],
[
1395898853870,
29.902,
5
],
[
1395899197351,
27.374,
5
],
[
1395899541871,
25.012,
5
],
[
1395899887107,
24.648,
5
],
[
1395900243022,
26.674,
5
],
[
1395900583242,
34.426,
5
],
[
1395900924968,
27.264,
5
],
[
1395901267678,
25.312,
5
],
[
1395901608853,
24.576,
5
],
[
1395901948947,
32.888,
5
],
[
1395902288350,
34.138,
5
],
[
1395902633303,
34.9,
5
],
[
1395902973102,
32.3,
5
],
[
1395903311804,
30.286,
5
],
[
1395903655635,
30.824,
5
],
[
1395904000021,
36.488,
5
],
[
1395904340975,
35.038,
5
],
[
1395904687442,
32.864,
5
],
[
1395905028171,
29.926,
5
],
[
1395905376454,
28.086,
5
],
[
1395905718767,
27.102,
5
],
[
1395906059230,
33.212,
5
],
[
1395906399212,
36.002,
5
],
[
1395906739483,
34.414,
5
],
[
1395907098334,
31.474,
5
],
[
1395907447445,
29.362,
5
],
[
1395907790047,
28.362,
5
],
[
1395908133146,
27.7,
5
],
[
1395908472800,
28.076,
5
],
[
1395908812269,
29.8,
5
],
[
1395909151429,
26.3,
5
],
[
1395909490735,
25.674,
5
],
[
1395909831782,
25.428,
5
],
[
1395910170406,
25.364,
5
],
[
1395910510068,
25.752,
5
],
[
1395910852500,
25.788,
5
],
[
1395911196485,
30.674,
5
],
[
1395911538429,
33.514,
5
],
[
1395911879302,
31.348,
5
],
[
1395912220003,
29.688,
5
],
[
1395912558325,
28.476,
5
],
[
1395912902353,
30.088,
5
],
[
1395913245898,
26.864,
5
],
[
1395913595236,
25.904,
5
],
[
1395913939290,
25.976,
5
],
[
1395914288710,
28.108,
5
],
[
1395914635512,
31.552,
5
],
[
1395914975733,
26.512,
5
],
[
1395915317434,
25.638,
5
],
[
1395915659138,
25.212,
5
],
[
1395916003208,
33.572,
5
],
[
1395916345859,
33.186,
5
],
[
1395916686884,
31.878,
5
],
[
1395917026851,
29.888,
5
],
[
1395917370243,
28.488,
5
],
[
1395917713336,
27.538,
5
],
[
1395918073801,
31.15,
5
],
[
1395918424862,
33.198,
5
],
[
1395918776470,
29.864,
5
],
[
1395919119372,
28.324,
5
],
[
1395919471661,
30.512,
5
],
[
1395919813034,
33.126,
5
],
[
1395920154285,
28.388,
5
],
[
1395920496675,
27.412,
5
],
[
1395920841728,
27.826,
5
],
[
1395921184733,
30.014,
5
],
[
1395921529786,
26.276,
5
],
[
1395921890209,
25.55,
5
],
[
1395922242486,
25.3,
5
],
[
1395922592980,
27.338,
5
],
[
1395922940029,
32.588,
5
],
[
1395923285196,
27.788,
5
],
[
1395923630032,
26.938,
5
],
[
1395923983900,
26.35,
5
],
[
1395924337419,
25.8,
5
],
[
1395924682637,
25.388,
5
],
[
1395925024489,
25.11,
5
],
[
1395925374843,
24.976,
5
],
[
1395925719869,
24.964,
5
],
[
1395926064346,
24.878,
5
],
[
1395926408898,
24.648,
5
],
[
1395926749989,
24.676,
5
],
[
1395927094222,
24.846,
5
],
[
1395927438943,
28.276,
5
],
[
1395927807122,
30.814,
5
],
[
1395928151446,
29.388,
5
],
[
1395928495561,
27.702,
5
],
[
1395928850503,
26.8,
5
],
[
1395929199670,
26.2,
5
],
[
1395929542723,
25.776,
5
],
[
1395929896117,
25.612,
5
],
[
1395930248210,
25.3,
5
],
[
1395930588978,
24.902,
5
],
[
1395930932847,
24.724,
5
],
[
1395931277101,
24.524,
5
],
[
1395931620317,
24.44,
5
],
[
1395931961373,
24.502,
5
],
[
1395932303402,
25.614,
5
],
[
1395932650892,
24.998,
5
],
[
1395932992889,
24.524,
5
],
[
1395933336356,
24.712,
5
],
[
1395933679250,
24.876,
5
],
[
1395934022229,
25,
5
],
[
1395934363866,
25.096,
5
],
[
1395934704172,
25.176,
5
],
[
1395935048092,
25.176,
5
],
[
1395935391252,
25.172,
5
],
[
1395935732137,
25.338,
5
],
[
1395936098755,
24.986,
5
],
[
1395936445264,
24.714,
5
],
[
1395936791878,
24.726,
5
],
[
1395937135129,
24.75,
5
],
[
1395937480155,
24.536,
5
],
[
1395937821345,
24.452,
5
],
[
1395938166559,
24.5,
5
],
[
1395938512904,
24.622,
5
],
[
1395938857115,
24.726,
5
],
[
1395939199832,
25.084,
5
],
[
1395939541940,
25.072,
5
],
[
1395939894973,
24.672,
5
],
[
1395940237788,
24.608,
5
],
[
1395940578938,
24.536,
5
],
[
1395940924324,
24.464,
5
],
[
1395941267918,
24.404,
5
],
[
1395941608138,
24.312,
5
],
[
1395941949820,
24.226,
5
],
[
1395942292912,
24.326,
5
],
[
1395942639745,
24.238,
5
],
[
1395942983525,
24.074,
5
],
[
1395943334755,
24.072,
5
],
[
1395943680596,
23.892,
5
],
[
1395944026830,
23.838,
5
],
[
1395944372264,
23.916,
5
],
[
1395944717415,
24.036,
5
],
[
1395945062747,
24.162,
5
],
[
1395945405991,
24.226,
5
],
[
1395945747021,
24.25,
5
],
[
1395946089185,
24.238,
5
],
[
1395946433259,
24.238,
5
],
[
1395946775547,
24.19,
5
],
[
1395947132292,
24.134,
5
],
[
1395947476449,
24.084,
5
],
[
1395947820764,
23.94,
5
],
[
1395948164456,
23.94,
5
],
[
1395948508526,
24.026,
5
],
[
1395948854596,
24.352,
5
],
[
1395949200032,
24.25,
5
],
[
1395949544371,
24.136,
5
],
[
1395949890341,
24.012,
5
],
[
1395950235799,
24.024,
5
],
[
1395950587916,
24.186,
5
],
[
1395950932617,
24.364,
5
],
[
1395951274338,
24.524,
5
],
[
1395951616676,
24.608,
5
],
[
1395951960180,
24.662,
5
],
[
1395952302179,
24.648,
5
],
[
1395952643972,
24.646,
5
],
[
1395952989252,
24.812,
5
],
[
1395953127213,
24.69,
2
]
]
},
{
"uuid": "2dd2cb00-8a11-11e2-b8a9-214e007465a4",
"from": 1395866529012,
"to": 1395953125834,
"min": [
1395894360860,
20.94
],
"max": [
1395927805856,
38.698
],
"average": 25.03,
"rows": 475,
"tuples": [
[
1395866874534,
25.964,
5
],
[
1395867218577,
25.826,
5
],
[
1395867562189,
25.714,
5
],
[
1395867916917,
25.902,
5
],
[
1395868259240,
26.124,
5
],
[
1395868601939,
26.364,
5
],
[
1395868945179,
26.036,
5
],
[
1395869288584,
25.764,
5
],
[
1395869629605,
25.536,
5
],
[
1395869972320,
25.314,
5
],
[
1395870314939,
25.11,
5
],
[
1395870658321,
24.914,
5
],
[
1395871002019,
24.724,
5
],
[
1395871354302,
24.548,
5
],
[
1395871696284,
24.39,
5
],
[
1395872035272,
24.238,
5
],
[
1395872378287,
24.072,
5
],
[
1395872721459,
23.964,
5
],
[
1395873061361,
23.826,
5
],
[
1395873399230,
23.674,
5
],
[
1395873739271,
23.584,
5
],
[
1395874077804,
23.464,
5
],
[
1395874416106,
23.366,
5
],
[
1395874755483,
23.262,
5
],
[
1395875108102,
23.162,
5
],
[
1395875448911,
23.084,
5
],
[
1395875786837,
23,
5
],
[
1395876126530,
22.928,
5
],
[
1395876471600,
22.838,
5
],
[
1395876815580,
22.774,
5
],
[
1395877157441,
22.702,
5
],
[
1395877504182,
22.62,
5
],
[
1395877852270,
22.56,
5
],
[
1395878195850,
22.524,
5
],
[
1395878542968,
22.376,
5
],
[
1395878884160,
22.38,
5
],
[
1395879223518,
22.324,
5
],
[
1395879563271,
22.262,
5
],
[
1395879906158,
22.202,
5
],
[
1395880251856,
22.162,
5
],
[
1395880593550,
22.108,
5
],
[
1395880938484,
22.048,
5
],
[
1395881286333,
22,
5
],
[
1395881625905,
21.964,
5
],
[
1395881966138,
21.94,
5
],
[
1395882312432,
21.88,
5
],
[
1395882656681,
21.824,
5
],
[
1395882998791,
21.798,
5
],
[
1395883340751,
21.75,
5
],
[
1395883680631,
21.726,
5
],
[
1395884020708,
21.69,
5
],
[
1395884361762,
21.634,
5
],
[
1395884700166,
21.608,
5
],
[
1395885038654,
21.572,
5
],
[
1395885378084,
21.56,
5
],
[
1395885724560,
21.536,
5
],
[
1395886069830,
21.512,
5
],
[
1395886410588,
21.44,
5
],
[
1395886754472,
21.364,
5
],
[
1395887098108,
21.38,
5
],
[
1395887442108,
21.366,
5
],
[
1395887808196,
21.366,
5
],
[
1395888172567,
21.298,
5
],
[
1395888542710,
21.274,
5
],
[
1395888909310,
21.25,
5
],
[
1395889276309,
21.238,
5
],
[
1395889653032,
21.19,
5
],
[
1395890031284,
21.19,
5
],
[
1395890411468,
21.176,
5
],
[
1395890791991,
21.12,
5
],
[
1395891161807,
21.12,
5
],
[
1395891535870,
21.096,
5
],
[
1395891914511,
21.06,
5
],
[
1395892289764,
21.06,
5
],
[
1395892649860,
21,
5
],
[
1395893000284,
21.012,
5
],
[
1395893340813,
21,
5
],
[
1395893679582,
21,
5
],
[
1395894017828,
20.952,
5
],
[
1395894360860,
20.94,
5
],
[
1395894700243,
20.964,
5
],
[
1395895040238,
21.424,
5
],
[
1395895385626,
23.188,
5
],
[
1395895732365,
23.84,
5
],
[
1395896076843,
25.574,
5
],
[
1395896432229,
29.76,
5
],
[
1395896778370,
26.962,
5
],
[
1395897119682,
25.978,
5
],
[
1395897461871,
25.964,
5
],
[
1395897805191,
26.374,
5
],
[
1395898153079,
26.35,
5
],
[
1395898495035,
29.876,
5
],
[
1395898852528,
30.662,
5
],
[
1395899195781,
29.84,
5
],
[
1395899540842,
27.824,
5
],
[
1395899885762,
26.688,
5
],
[
1395900241821,
26.25,
5
],
[
1395900582162,
26.61,
5
],
[
1395900923950,
26.6,
5
],
[
1395901266647,
25.65,
5
],
[
1395901607574,
24.65,
5
],
[
1395901947903,
24.366,
5
],
[
1395902287329,
24.962,
5
],
[
1395902632277,
25.538,
5
],
[
1395902971923,
25.962,
5
],
[
1395903310774,
26.186,
5
],
[
1395903653787,
26.35,
5
],
[
1395903998700,
26.612,
5
],
[
1395904339943,
26.764,
5
],
[
1395904686124,
29.002,
5
],
[
1395905027149,
27.588,
5
],
[
1395905375347,
26.276,
5
],
[
1395905717660,
25.826,
5
],
[
1395906058041,
25.662,
5
],
[
1395906397951,
25.886,
5
],
[
1395906738422,
26.538,
5
],
[
1395907096943,
29,
5
],
[
1395907446211,
33.452,
5
],
[
1395907788851,
28.788,
5
],
[
1395908131756,
27.928,
5
],
[
1395908471717,
28,
5
],
[
1395908810820,
28.5,
5
],
[
1395909150410,
27.55,
5
],
[
1395909489368,
26.438,
5
],
[
1395909830516,
26.124,
5
],
[
1395910169378,
26.048,
5
],
[
1395910509044,
26.486,
5
],
[
1395910850432,
26.548,
5
],
[
1395911195220,
30.4,
5
],
[
1395911537401,
33.512,
5
],
[
1395911877859,
28.348,
5
],
[
1395912218973,
27.524,
5
],
[
1395912557277,
27.438,
5
],
[
1395912901211,
27.224,
5
],
[
1395913244810,
26.7,
5
],
[
1395913593948,
26.34,
5
],
[
1395913938168,
26.172,
5
],
[
1395914287534,
26.338,
5
],
[
1395914634489,
26.74,
5
],
[
1395914974685,
26.3,
5
],
[
1395915316216,
25.474,
5
],
[
1395915658115,
25.096,
5
],
[
1395916001872,
25.21,
5
],
[
1395916344735,
25.686,
5
],
[
1395916685850,
25.838,
5
],
[
1395917025822,
25.81,
5
],
[
1395917369031,
25.702,
5
],
[
1395917711948,
25.752,
5
],
[
1395918072536,
26,
5
],
[
1395918423569,
26.134,
5
],
[
1395918775322,
26.174,
5
],
[
1395919118195,
26.938,
5
],
[
1395919470550,
30.886,
5
],
[
1395919811975,
33.538,
5
],
[
1395920153004,
30.7,
5
],
[
1395920495649,
29.152,
5
],
[
1395920840320,
27.928,
5
],
[
1395921183515,
27.198,
5
],
[
1395921528554,
26.786,
5
],
[
1395921889081,
29.826,
5
],
[
1395922241116,
29.778,
5
],
[
1395922591856,
27.174,
5
],
[
1395922938766,
26.586,
5
],
[
1395923284160,
26.612,
5
],
[
1395923628687,
26.35,
5
],
[
1395923982768,
26.05,
5
],
[
1395924336094,
25.712,
5
],
[
1395924681282,
25.4,
5
],
[
1395925023256,
25.2,
5
],
[
1395925373445,
25.122,
5
],
[
1395925718851,
25.176,
5
],
[
1395926062975,
25.19,
5
],
[
1395926407860,
24.976,
5
],
[
1395926748719,
24.964,
5
],
[
1395927093141,
25.128,
5
],
[
1395927437807,
25.186,
5
],
[
1395927805856,
38.698,
5
],
[
1395928149922,
28.238,
5
],
[
1395928494538,
29.398,
5
],
[
1395928848903,
28.262,
5
],
[
1395929198329,
27.286,
5
],
[
1395929541699,
26.648,
5
],
[
1395929894689,
26.314,
5
],
[
1395930247055,
25.914,
5
],
[
1395930587583,
25.5,
5
],
[
1395930931816,
25.224,
5
],
[
1395931275398,
24.964,
5
],
[
1395931618859,
24.838,
5
],
[
1395931960127,
24.886,
5
],
[
1395932302158,
25.95,
5
],
[
1395932649565,
25.35,
5
],
[
1395932991866,
24.926,
5
],
[
1395933335014,
25.188,
5
],
[
1395933677873,
25.338,
5
],
[
1395934021010,
25.5,
5
],
[
1395934362836,
25.584,
5
],
[
1395934703079,
25.62,
5
],
[
1395935046809,
25.608,
5
],
[
1395935390224,
25.61,
5
],
[
1395935730768,
25.752,
5
],
[
1395936097243,
25.388,
5
],
[
1395936444112,
25.148,
5
],
[
1395936790525,
25.11,
5
],
[
1395937133853,
25.086,
5
],
[
1395937478911,
24.876,
5
],
[
1395937820111,
24.762,
5
],
[
1395938165093,
24.838,
5
],
[
1395938511865,
24.988,
5
],
[
1395938855774,
25.096,
5
],
[
1395939198735,
25.462,
5
],
[
1395939540686,
25.438,
5
],
[
1395939893943,
25.05,
5
],
[
1395940236733,
24.988,
5
],
[
1395940577254,
24.904,
5
],
[
1395940923190,
24.786,
5
],
[
1395941266889,
24.714,
5
],
[
1395941606785,
24.622,
5
],
[
1395941948455,
24.512,
5
],
[
1395942291666,
24.61,
5
],
[
1395942638436,
24.572,
5
],
[
1395942982103,
24.426,
5
],
[
1395943333189,
24.414,
5
],
[
1395943678996,
24.188,
5
],
[
1395944025468,
24.12,
5
],
[
1395944371212,
24.2,
5
],
[
1395944716162,
24.364,
5
],
[
1395945061404,
24.488,
5
],
[
1395945404833,
24.56,
5
],
[
1395945745959,
24.572,
5
],
[
1395946087903,
24.56,
5
],
[
1395946432023,
24.56,
5
],
[
1395946774159,
24.5,
5
],
[
1395947131033,
24.44,
5
],
[
1395947475172,
24.38,
5
],
[
1395947819657,
24.238,
5
],
[
1395948163198,
24.19,
5
],
[
1395948507054,
24.288,
5
],
[
1395948853511,
24.662,
5
],
[
1395949198999,
24.548,
5
],
[
1395949542999,
24.452,
5
],
[
1395949889227,
24.31,
5
],
[
1395950234433,
24.324,
5
],
[
1395950586339,
24.5,
5
],
[
1395950931499,
24.724,
5
],
[
1395951273231,
24.89,
5
],
[
1395951615323,
25,
5
],
[
1395951958942,
25.06,
5
],
[
1395952300746,
25.024,
5
],
[
1395952642773,
25.026,
5
],
[
1395952988129,
25.174,
5
],
[
1395953125834,
25.03,
2
]
]
},
{
"uuid": "3c391a00-8a11-11e2-92ec-0d9f1daff99d",
"from": 1395866533560,
"to": 1395953131300,
"min": [
1395894022163,
20.94
],
"max": [
1395903659770,
36.464
],
"average": 26.556,
"rows": 475,
"tuples": [
[
1395866879332,
27.788,
5
],
[
1395867224031,
27.274,
5
],
[
1395867567743,
26.862,
5
],
[
1395867921937,
26.89,
5
],
[
1395868264233,
27.012,
5
],
[
1395868606449,
27.036,
5
],
[
1395868950377,
26.376,
5
],
[
1395869293319,
26,
5
],
[
1395869634178,
25.686,
5
],
[
1395869976965,
25.414,
5
],
[
1395870319979,
25.186,
5
],
[
1395870663536,
24.976,
5
],
[
1395871006545,
24.8,
5
],
[
1395871362098,
24.61,
5
],
[
1395871700396,
24.452,
5
],
[
1395872040104,
24.314,
5
],
[
1395872383613,
24.148,
5
],
[
1395872726029,
24,
5
],
[
1395873065804,
23.89,
5
],
[
1395873403431,
23.75,
5
],
[
1395873743832,
23.636,
5
],
[
1395874082036,
23.536,
5
],
[
1395874420729,
23.404,
5
],
[
1395874760497,
23.312,
5
],
[
1395875112588,
23.214,
5
],
[
1395875453461,
23.108,
5
],
[
1395875791426,
23.024,
5
],
[
1395876132044,
22.928,
5
],
[
1395876476596,
22.852,
5
],
[
1395876820615,
22.75,
5
],
[
1395877162876,
22.688,
5
],
[
1395877509831,
22.596,
5
],
[
1395877857782,
22.548,
5
],
[
1395878200457,
22.464,
5
],
[
1395878550184,
22.416,
5
],
[
1395878888313,
22.338,
5
],
[
1395879227914,
22.286,
5
],
[
1395879567983,
22.226,
5
],
[
1395879911655,
22.162,
5
],
[
1395880257049,
22.108,
5
],
[
1395880598004,
22.06,
5
],
[
1395880944116,
22,
5
],
[
1395881291642,
21.964,
5
],
[
1395881630292,
21.904,
5
],
[
1395881970618,
21.88,
5
],
[
1395882317778,
21.824,
5
],
[
1395882661923,
21.798,
5
],
[
1395883004040,
21.75,
5
],
[
1395883345370,
21.726,
5
],
[
1395883684858,
21.69,
5
],
[
1395884025130,
21.62,
5
],
[
1395884366485,
21.62,
5
],
[
1395884704325,
21.56,
5
],
[
1395885043251,
21.548,
5
],
[
1395885382449,
21.5,
5
],
[
1395885730338,
21.488,
5
],
[
1395886075076,
21.452,
5
],
[
1395886415855,
21.428,
5
],
[
1395886759808,
21.38,
5
],
[
1395887103329,
21.38,
5
],
[
1395887449869,
21.324,
5
],
[
1395887815654,
21.31,
5
],
[
1395888179407,
21.286,
5
],
[
1395888549195,
21.25,
5
],
[
1395888915756,
21.25,
5
],
[
1395889286616,
21.202,
5
],
[
1395889660311,
21.19,
5
],
[
1395890040543,
21.176,
5
],
[
1395890421200,
21.12,
5
],
[
1395890800316,
21.12,
5
],
[
1395891170930,
21.072,
5
],
[
1395891545163,
21.072,
5
],
[
1395891922439,
21.06,
5
],
[
1395892299589,
21.036,
5
],
[
1395892655393,
21,
5
],
[
1395893004494,
21,
5
],
[
1395893345237,
20.988,
5
],
[
1395893683816,
20.952,
5
],
[
1395894022163,
20.94,
5
],
[
1395894365783,
20.94,
5
],
[
1395894704990,
20.94,
5
],
[
1395895044349,
21.474,
5
],
[
1395895390997,
23.286,
5
],
[
1395895737066,
23.852,
5
],
[
1395896080998,
25.698,
5
],
[
1395896438787,
29.048,
5
],
[
1395896782515,
26.114,
5
],
[
1395897124223,
33.288,
5
],
[
1395897467059,
35.4,
5
],
[
1395897810419,
26.462,
5
],
[
1395898158002,
25.098,
5
],
[
1395898499496,
25.266,
5
],
[
1395898857269,
30.674,
5
],
[
1395899201272,
27.212,
5
],
[
1395899545869,
26.574,
5
],
[
1395899891125,
25.612,
5
],
[
1395900246950,
25.762,
5
],
[
1395900587011,
30.816,
5
],
[
1395900928802,
26.462,
5
],
[
1395901271094,
23.974,
5
],
[
1395901612279,
25.824,
5
],
[
1395901952699,
27.876,
5
],
[
1395902292106,
27.788,
5
],
[
1395902636819,
35.126,
5
],
[
1395902976627,
36.038,
5
],
[
1395903315279,
36.462,
5
],
[
1395903659770,
36.464,
5
],
[
1395904003598,
36.374,
5
],
[
1395904344680,
34.598,
5
],
[
1395904690800,
29.288,
5
],
[
1395905031563,
27.488,
5
],
[
1395905379666,
34.35,
5
],
[
1395905722021,
29.174,
5
],
[
1395906062537,
31.388,
5
],
[
1395906402759,
31.588,
5
],
[
1395906743209,
33.274,
5
],
[
1395907102026,
30.162,
5
],
[
1395907450944,
33.998,
5
],
[
1395907793429,
30.35,
5
],
[
1395908136667,
28.962,
5
],
[
1395908476112,
32,
5
],
[
1395908815390,
29.924,
5
],
[
1395909154778,
27.052,
5
],
[
1395909494881,
27.274,
5
],
[
1395909835069,
26.826,
5
],
[
1395910173719,
28.212,
5
],
[
1395910513580,
33.95,
5
],
[
1395910857748,
35.364,
5
],
[
1395911199848,
32.598,
5
],
[
1395911541636,
33.836,
5
],
[
1395911883059,
32.25,
5
],
[
1395912223583,
32.338,
5
],
[
1395912562099,
34.586,
5
],
[
1395912905439,
30.974,
5
],
[
1395913249022,
28.89,
5
],
[
1395913599092,
27.774,
5
],
[
1395913942726,
27.388,
5
],
[
1395914292251,
32.176,
5
],
[
1395914638660,
31.736,
5
],
[
1395914979281,
26.56,
5
],
[
1395915321697,
25.736,
5
],
[
1395915662906,
25.45,
5
],
[
1395916007301,
27.402,
5
],
[
1395916349922,
34.036,
5
],
[
1395916690504,
31.04,
5
],
[
1395917030647,
28.038,
5
],
[
1395917374106,
27.452,
5
],
[
1395917717566,
27.314,
5
],
[
1395918078561,
30.726,
5
],
[
1395918428849,
33.652,
5
],
[
1395918780307,
32.55,
5
],
[
1395919123148,
31.038,
5
],
[
1395919475629,
31.448,
5
],
[
1395919817137,
33.438,
5
],
[
1395920157641,
32.324,
5
],
[
1395920500556,
33.174,
5
],
[
1395920845360,
28.95,
5
],
[
1395921188633,
30.226,
5
],
[
1395921533776,
27.012,
5
],
[
1395921894153,
30.224,
5
],
[
1395922246425,
29.526,
5
],
[
1395922596609,
29.014,
5
],
[
1395922943900,
32.024,
5
],
[
1395923289309,
31.464,
5
],
[
1395923634127,
32.412,
5
],
[
1395923987850,
29.128,
5
],
[
1395924341458,
32.236,
5
],
[
1395924686650,
28.088,
5
],
[
1395925027696,
26.862,
5
],
[
1395925380916,
26.56,
5
],
[
1395925723789,
30.788,
5
],
[
1395926068424,
31.362,
5
],
[
1395926411989,
27.588,
5
],
[
1395926753841,
26.576,
5
],
[
1395927098131,
26.448,
5
],
[
1395927443066,
31.212,
5
],
[
1395927811157,
31.262,
5
],
[
1395928155128,
28.188,
5
],
[
1395928499379,
29.776,
5
],
[
1395928855210,
27.488,
5
],
[
1395929203437,
26.974,
5
],
[
1395929546671,
26.726,
5
],
[
1395929900386,
29.55,
5
],
[
1395930251364,
31.236,
5
],
[
1395930593053,
27.736,
5
],
[
1395930936775,
26.486,
5
],
[
1395931280553,
25.95,
5
],
[
1395931624190,
25.674,
5
],
[
1395931965330,
25.734,
5
],
[
1395932307059,
27.25,
5
],
[
1395932654229,
30.66,
5
],
[
1395932996578,
30.512,
5
],
[
1395933339792,
27.964,
5
],
[
1395933683156,
27.598,
5
],
[
1395934026044,
27.352,
5
],
[
1395934367321,
27.136,
5
],
[
1395934707311,
26.902,
5
],
[
1395935052027,
26.662,
5
],
[
1395935394663,
26.564,
5
],
[
1395935735577,
29.224,
5
],
[
1395936104796,
30.648,
5
],
[
1395936448765,
27.6,
5
],
[
1395936796126,
26.752,
5
],
[
1395937138919,
26.388,
5
],
[
1395937483802,
25.95,
5
],
[
1395937825249,
25.674,
5
],
[
1395938170758,
25.634,
5
],
[
1395938516339,
25.714,
5
],
[
1395938861384,
25.75,
5
],
[
1395939203232,
28.812,
5
],
[
1395939545437,
29.176,
5
],
[
1395939899108,
29.924,
5
],
[
1395940241372,
27.15,
5
],
[
1395940582450,
26.6,
5
],
[
1395940927781,
26.2,
5
],
[
1395941271418,
25.876,
5
],
[
1395941611721,
25.562,
5
],
[
1395941953917,
25.314,
5
],
[
1395942297108,
26.738,
5
],
[
1395942643142,
30.388,
5
],
[
1395942987806,
27.164,
5
],
[
1395943340025,
25.986,
5
],
[
1395943684740,
25.364,
5
],
[
1395944031154,
25.098,
5
],
[
1395944376090,
25.024,
5
],
[
1395944720920,
25.072,
5
],
[
1395945066507,
25.12,
5
],
[
1395945409462,
25.12,
5
],
[
1395945750641,
25.096,
5
],
[
1395946093104,
25.024,
5
],
[
1395946437029,
24.964,
5
],
[
1395946779196,
24.878,
5
],
[
1395947135846,
24.786,
5
],
[
1395947480942,
24.7,
5
],
[
1395947824559,
24.488,
5
],
[
1395948168206,
24.44,
5
],
[
1395948512611,
24.74,
5
],
[
1395948858395,
25.314,
5
],
[
1395949203777,
25.06,
5
],
[
1395949548718,
24.852,
5
],
[
1395949894062,
24.662,
5
],
[
1395950239840,
24.674,
5
],
[
1395950592007,
24.888,
5
],
[
1395950936010,
25.162,
5
],
[
1395951277836,
25.364,
5
],
[
1395951620981,
25.464,
5
],
[
1395951963959,
25.5,
5
],
[
1395952305789,
25.488,
5
],
[
1395952647839,
25.564,
5
],
[
1395952993042,
25.876,
5
],
[
1395953131300,
25.59,
2
]
]
},
{
"uuid": "1e6e25a0-8a11-11e2-96be-cd4b755a40c6",
"from": 1392463222669,
"to": 1392463262294,
"min": [
1392463262294,
37.81
],
"max": [
1392463262294,
37.81
],
"average": 37.81,
"rows": 150,
"tuples": [
[
1392463262294,
37.81,
1
]
]
},
{
"uuid": "2414a2e0-8a11-11e2-8319-eb6370d8f760",
"from": 1395866532315,
"to": 1395953129956,
"min": [
1395894364705,
20.94
],
"max": [
1395904002485,
36.65
],
"average": 26.659,
"rows": 475,
"tuples": [
[
1395866878304,
27.7,
5
],
[
1395867222922,
27.174,
5
],
[
1395867566371,
26.648,
5
],
[
1395867920596,
26.724,
5
],
[
1395868262968,
27.276,
5
],
[
1395868605151,
28.15,
5
],
[
1395868949122,
26.924,
5
],
[
1395869292262,
26.312,
5
],
[
1395869633081,
25.902,
5
],
[
1395869975660,
25.574,
5
],
[
1395870318744,
25.338,
5
],
[
1395870662221,
25.098,
5
],
[
1395871005520,
24.902,
5
],
[
1395871360006,
24.714,
5
],
[
1395871699359,
24.548,
5
],
[
1395872038925,
24.378,
5
],
[
1395872382285,
24.238,
5
],
[
1395872724907,
24.098,
5
],
[
1395873064774,
23.952,
5
],
[
1395873402408,
23.838,
5
],
[
1395873742808,
23.702,
5
],
[
1395874080947,
23.584,
5
],
[
1395874419482,
23.476,
5
],
[
1395874759159,
23.39,
5
],
[
1395875111381,
23.274,
5
],
[
1395875452243,
23.188,
5
],
[
1395875790294,
23.096,
5
],
[
1395876130641,
22.988,
5
],
[
1395876475204,
22.916,
5
],
[
1395876819277,
22.838,
5
],
[
1395877161665,
22.762,
5
],
[
1395877508472,
22.688,
5
],
[
1395877856365,
22.608,
5
],
[
1395878199251,
22.548,
5
],
[
1395878548083,
22.476,
5
],
[
1395878887280,
22.428,
5
],
[
1395879226856,
22.352,
5
],
[
1395879566936,
22.286,
5
],
[
1395879910269,
22.238,
5
],
[
1395880255767,
22.19,
5
],
[
1395880596964,
22.134,
5
],
[
1395880942556,
22.072,
5
],
[
1395881290270,
22.036,
5
],
[
1395881629262,
22,
5
],
[
1395881969384,
21.94,
5
],
[
1395882316422,
21.892,
5
],
[
1395882660558,
21.866,
5
],
[
1395883002653,
21.81,
5
],
[
1395883344109,
21.774,
5
],
[
1395883683722,
21.738,
5
],
[
1395884024048,
21.69,
5
],
[
1395884365139,
21.662,
5
],
[
1395884703290,
21.622,
5
],
[
1395885042129,
21.572,
5
],
[
1395885381430,
21.56,
5
],
[
1395885728664,
21.536,
5
],
[
1395886073733,
21.5,
5
],
[
1395886414548,
21.464,
5
],
[
1395886758445,
21.44,
5
],
[
1395887102075,
21.416,
5
],
[
1395887447655,
21.38,
5
],
[
1395887814207,
21.352,
5
],
[
1395888177359,
21.31,
5
],
[
1395888547521,
21.31,
5
],
[
1395888914126,
21.262,
5
],
[
1395889283516,
21.25,
5
],
[
1395889658665,
21.238,
5
],
[
1395890038183,
21.19,
5
],
[
1395890418660,
21.19,
5
],
[
1395890798050,
21.12,
5
],
[
1395891168369,
21.12,
5
],
[
1395891542780,
21.108,
5
],
[
1395891920874,
21.06,
5
],
[
1395892297332,
21.06,
5
],
[
1395892654019,
21.048,
5
],
[
1395893003377,
21.012,
5
],
[
1395893344098,
21,
5
],
[
1395893682790,
21,
5
],
[
1395894020989,
20.988,
5
],
[
1395894364705,
20.94,
5
],
[
1395894703660,
20.976,
5
],
[
1395895043315,
21.45,
5
],
[
1395895389536,
23.212,
5
],
[
1395895735914,
23.814,
5
],
[
1395896079970,
25.524,
5
],
[
1395896437382,
29.174,
5
],
[
1395896781467,
26.024,
5
],
[
1395897123197,
32.948,
5
],
[
1395897465746,
35.248,
5
],
[
1395897809064,
26.738,
5
],
[
1395898156808,
25.564,
5
],
[
1395898498401,
27.852,
5
],
[
1395898856028,
30.574,
5
],
[
1395899199899,
27.374,
5
],
[
1395899544463,
26.488,
5
],
[
1395899889799,
25.424,
5
],
[
1395900245643,
28.15,
5
],
[
1395900585558,
32.888,
5
],
[
1395900927745,
26.75,
5
],
[
1395901270057,
24.012,
5
],
[
1395901611014,
25.748,
5
],
[
1395901951325,
30.476,
5
],
[
1395902290738,
34.176,
5
],
[
1395902635787,
35.65,
5
],
[
1395902975251,
35.938,
5
],
[
1395903314150,
36.186,
5
],
[
1395903658419,
36.19,
5
],
[
1395904002485,
36.65,
5
],
[
1395904343501,
35.5,
5
],
[
1395904689772,
29.786,
5
],
[
1395905030369,
27.374,
5
],
[
1395905378601,
34.062,
5
],
[
1395905720932,
29.002,
5
],
[
1395906061493,
32.95,
5
],
[
1395906401670,
34.998,
5
],
[
1395906742114,
33.464,
5
],
[
1395907100915,
30.01,
5
],
[
1395907449891,
33.886,
5
],
[
1395907792404,
30.264,
5
],
[
1395908135272,
28.636,
5
],
[
1395908474924,
32.114,
5
],
[
1395908814370,
30.112,
5
],
[
1395909153489,
27.002,
5
],
[
1395909493532,
27.25,
5
],
[
1395909834050,
26.56,
5
],
[
1395910172484,
27.8,
5
],
[
1395910512524,
33.562,
5
],
[
1395910856014,
35.212,
5
],
[
1395911198828,
32.514,
5
],
[
1395911540543,
34.112,
5
],
[
1395911881964,
32.89,
5
],
[
1395912222467,
32.39,
5
],
[
1395912560937,
34.252,
5
],
[
1395912904410,
31.026,
5
],
[
1395913247996,
28.902,
5
],
[
1395913597911,
27.7,
5
],
[
1395913941670,
27.336,
5
],
[
1395914291171,
31.764,
5
],
[
1395914637594,
31.79,
5
],
[
1395914978233,
26.652,
5
],
[
1395915320244,
25.788,
5
],
[
1395915661680,
25.552,
5
],
[
1395916005934,
27.272,
5
],
[
1395916348414,
33.788,
5
],
[
1395916689210,
31.112,
5
],
[
1395917029370,
27.922,
5
],
[
1395917372932,
27.25,
5
],
[
1395917716090,
27.312,
5
],
[
1395918076381,
30.626,
5
],
[
1395918427491,
33.564,
5
],
[
1395918779100,
32.062,
5
],
[
1395919121863,
31.124,
5
],
[
1395919474589,
31.212,
5
],
[
1395919815654,
34.026,
5
],
[
1395920156611,
32.624,
5
],
[
1395920499191,
33.01,
5
],
[
1395920844090,
29.088,
5
],
[
1395921187462,
30.238,
5
],
[
1395921532461,
27,
5
],
[
1395921892858,
29.988,
5
],
[
1395922245257,
29.674,
5
],
[
1395922595247,
28.774,
5
],
[
1395922942609,
33.812,
5
],
[
1395923287912,
32.338,
5
],
[
1395923632778,
32.3,
5
],
[
1395923986403,
29.1,
5
],
[
1395924340120,
32.152,
5
],
[
1395924685459,
28.126,
5
],
[
1395925026621,
26.812,
5
],
[
1395925378742,
26.564,
5
],
[
1395925722425,
30.448,
5
],
[
1395926067094,
31.3,
5
],
[
1395926410957,
27.578,
5
],
[
1395926752605,
26.5,
5
],
[
1395927096850,
26.562,
5
],
[
1395927441641,
31.048,
5
],
[
1395927809682,
31.162,
5
],
[
1395928154031,
28.264,
5
],
[
1395928497923,
29.624,
5
],
[
1395928853768,
27.338,
5
],
[
1395929202117,
26.776,
5
],
[
1395929545346,
26.624,
5
],
[
1395929899058,
29.312,
5
],
[
1395930250270,
31.126,
5
],
[
1395930591741,
27.672,
5
],
[
1395930935376,
26.374,
5
],
[
1395931279527,
25.888,
5
],
[
1395931623047,
25.648,
5
],
[
1395931963927,
25.812,
5
],
[
1395932305785,
27.486,
5
],
[
1395932652975,
30.114,
5
],
[
1395932995390,
30.51,
5
],
[
1395933338765,
27.614,
5
],
[
1395933681959,
27.288,
5
],
[
1395934024778,
27.124,
5
],
[
1395934366219,
26.964,
5
],
[
1395934706283,
26.8,
5
],
[
1395935050756,
26.598,
5
],
[
1395935393630,
26.602,
5
],
[
1395935734242,
29.1,
5
],
[
1395936102604,
30.486,
5
],
[
1395936447733,
27.462,
5
],
[
1395936794683,
26.662,
5
],
[
1395937137673,
26.424,
5
],
[
1395937482693,
26.012,
5
],
[
1395937823964,
25.726,
5
],
[
1395938169342,
25.648,
5
],
[
1395938515308,
25.726,
5
],
[
1395938860080,
25.798,
5
],
[
1395939202205,
28.626,
5
],
[
1395939544146,
29.026,
5
],
[
1395939897695,
29.826,
5
],
[
1395940240238,
26.95,
5
],
[
1395940581414,
26.438,
5
],
[
1395940926683,
26.074,
5
],
[
1395941270278,
25.776,
5
],
[
1395941610452,
25.524,
5
],
[
1395941952548,
25.276,
5
],
[
1395942295693,
26.65,
5
],
[
1395942642112,
30.188,
5
],
[
1395942986744,
27.26,
5
],
[
1395943337733,
26.012,
5
],
[
1395943683292,
25.474,
5
],
[
1395944029712,
25.148,
5
],
[
1395944374811,
25.06,
5
],
[
1395944719892,
25.108,
5
],
[
1395945065243,
25.19,
5
],
[
1395945408429,
25.162,
5
],
[
1395945749526,
25.12,
5
],
[
1395946091807,
25.072,
5
],
[
1395946435769,
25.012,
5
],
[
1395946778124,
24.916,
5
],
[
1395947134729,
24.826,
5
],
[
1395947479427,
24.726,
5
],
[
1395947823203,
24.502,
5
],
[
1395948166936,
24.44,
5
],
[
1395948511247,
24.824,
5
],
[
1395948857129,
25.612,
5
],
[
1395949202401,
25.25,
5
],
[
1395949547227,
25.012,
5
],
[
1395949892818,
24.8,
5
],
[
1395950238492,
24.702,
5
],
[
1395950590661,
24.876,
5
],
[
1395950934990,
25.174,
5
],
[
1395951276546,
25.364,
5
],
[
1395951619630,
25.488,
5
],
[
1395951962700,
25.56,
5
],
[
1395952304676,
25.536,
5
],
[
1395952646553,
25.702,
5
],
[
1395952991618,
26.2,
5
],
[
1395953129956,
25.845,
2
]
]
},
{
"uuid": "27fd1e00-89c9-11e2-bc92-c922d3bff0dc",
"from": 1395866531070,
"to": 1395953128626,
"min": [
1395894363570,
21.488
],
"max": [
1395899888452,
50.45
],
"average": 32.105,
"rows": 475,
"tuples": [
[
1395866877193,
38.45,
5
],
[
1395867221640,
42.174,
5
],
[
1395867564949,
44.762,
5
],
[
1395867919249,
43.566,
5
],
[
1395868261718,
41.502,
5
],
[
1395868604103,
34.512,
5
],
[
1395868947641,
32.3,
5
],
[
1395869291126,
32.366,
5
],
[
1395869631809,
32.3,
5
],
[
1395869974632,
32.074,
5
],
[
1395870317448,
31.724,
5
],
[
1395870660921,
31.326,
5
],
[
1395871004189,
30.876,
5
],
[
1395871358068,
30.424,
5
],
[
1395871698339,
29.962,
5
],
[
1395872037531,
29.538,
5
],
[
1395872380966,
29.112,
5
],
[
1395872723834,
28.686,
5
],
[
1395873063661,
28.3,
5
],
[
1395873401305,
27.936,
5
],
[
1395873741570,
27.562,
5
],
[
1395874079861,
27.224,
5
],
[
1395874418440,
26.9,
5
],
[
1395874758125,
26.612,
5
],
[
1395875110360,
26.314,
5
],
[
1395875451208,
26.024,
5
],
[
1395875788978,
25.788,
5
],
[
1395876129272,
25.536,
5
],
[
1395876473861,
25.314,
5
],
[
1395876817955,
25.11,
5
],
[
1395877160117,
24.914,
5
],
[
1395877507025,
24.712,
5
],
[
1395877855017,
24.536,
5
],
[
1395878198222,
24.378,
5
],
[
1395878546291,
24.212,
5
],
[
1395878886246,
24.048,
5
],
[
1395879225672,
23.916,
5
],
[
1395879565642,
23.786,
5
],
[
1395879908922,
23.688,
5
],
[
1395880254411,
23.548,
5
],
[
1395880595931,
23.464,
5
],
[
1395880941193,
23.352,
5
],
[
1395881288975,
23.262,
5
],
[
1395881628152,
23.148,
5
],
[
1395881968358,
23.084,
5
],
[
1395882315064,
23,
5
],
[
1395882659191,
22.928,
5
],
[
1395883001270,
22.838,
5
],
[
1395883343071,
22.774,
5
],
[
1395883682692,
22.702,
5
],
[
1395884023019,
22.62,
5
],
[
1395884364121,
22.572,
5
],
[
1395884702263,
22.512,
5
],
[
1395885040794,
22.452,
5
],
[
1395885380409,
22.404,
5
],
[
1395885727268,
22.366,
5
],
[
1395886072391,
22.31,
5
],
[
1395886413000,
22.25,
5
],
[
1395886757182,
22.214,
5
],
[
1395887100615,
22.162,
5
],
[
1395887445749,
22.12,
5
],
[
1395887812469,
22.06,
5
],
[
1395888175736,
22.024,
5
],
[
1395888545920,
22,
5
],
[
1395888912534,
21.928,
5
],
[
1395889281034,
21.904,
5
],
[
1395889657035,
21.88,
5
],
[
1395890035788,
21.81,
5
],
[
1395890416447,
21.81,
5
],
[
1395890795400,
21.75,
5
],
[
1395891166249,
21.726,
5
],
[
1395891540347,
21.69,
5
],
[
1395891918295,
21.648,
5
],
[
1395892294773,
21.62,
5
],
[
1395892652602,
21.608,
5
],
[
1395893002349,
21.56,
5
],
[
1395893343078,
21.56,
5
],
[
1395893681641,
21.524,
5
],
[
1395894019964,
21.5,
5
],
[
1395894363570,
21.488,
5
],
[
1395894702577,
21.5,
5
],
[
1395895042289,
22.2,
5
],
[
1395895388418,
23.676,
5
],
[
1395895734790,
24.236,
5
],
[
1395896078942,
26.54,
5
],
[
1395896435870,
28.848,
5
],
[
1395896780434,
26.928,
5
],
[
1395897122086,
35.75,
5
],
[
1395897464331,
37.26,
5
],
[
1395897807798,
26.424,
5
],
[
1395898155689,
32.886,
5
],
[
1395898497337,
31.426,
5
],
[
1395898855004,
31.628,
5
],
[
1395899198556,
27.14,
5
],
[
1395899543044,
34.936,
5
],
[
1395899888452,
50.45,
5
],
[
1395900244339,
47.012,
5
],
[
1395900584270,
36.25,
5
],
[
1395900926215,
26.252,
5
],
[
1395901268713,
24.138,
5
],
[
1395901609961,
26.536,
5
],
[
1395901950056,
41.8,
5
],
[
1395902289391,
37.452,
5
],
[
1395902634667,
38.326,
5
],
[
1395902974140,
38.05,
5
],
[
1395903312830,
38.462,
5
],
[
1395903657012,
38.314,
5
],
[
1395904001119,
41.41,
5
],
[
1395904342255,
43.024,
5
],
[
1395904688645,
31.214,
5
],
[
1395905029348,
28.038,
5
],
[
1395905377498,
35.274,
5
],
[
1395905719874,
32.25,
5
],
[
1395906060375,
41.148,
5
],
[
1395906400321,
39.46,
5
],
[
1395906740940,
33.862,
5
],
[
1395907099764,
31.248,
5
],
[
1395907448646,
39.538,
5
],
[
1395907791070,
45.876,
5
],
[
1395908134246,
44.452,
5
],
[
1395908473883,
39.026,
5
],
[
1395908813350,
30.262,
5
],
[
1395909152467,
27.5,
5
],
[
1395909492217,
45.374,
5
],
[
1395909832810,
46.94,
5
],
[
1395910171449,
44.586,
5
],
[
1395910511434,
36.04,
5
],
[
1395910854581,
36.988,
5
],
[
1395911197593,
33.774,
5
],
[
1395911539465,
39.952,
5
],
[
1395911880747,
42.288,
5
],
[
1395912221236,
38.436,
5
],
[
1395912559653,
36.64,
5
],
[
1395912903381,
31.626,
5
],
[
1395913246920,
42.424,
5
],
[
1395913596575,
41.412,
5
],
[
1395913940332,
39.902,
5
],
[
1395914289730,
34.962,
5
],
[
1395914636542,
32.626,
5
],
[
1395914977141,
27.05,
5
],
[
1395915318816,
37.588,
5
],
[
1395915660272,
43.01,
5
],
[
1395916004577,
36.374,
5
],
[
1395916347280,
36.26,
5
],
[
1395916687960,
35.99,
5
],
[
1395917028055,
41.336,
5
],
[
1395917371456,
40.438,
5
],
[
1395917714729,
39.448,
5
],
[
1395918075065,
34.502,
5
],
[
1395918426178,
35.036,
5
],
[
1395918777740,
34.062,
5
],
[
1395919120606,
31.124,
5
],
[
1395919473012,
33.348,
5
],
[
1395919814331,
38.084,
5
],
[
1395920155501,
35.414,
5
],
[
1395920497815,
34.664,
5
],
[
1395920842848,
29.402,
5
],
[
1395921186078,
31.414,
5
],
[
1395921531132,
27.4,
5
],
[
1395921891519,
31.012,
5
],
[
1395922243938,
29.626,
5
],
[
1395922594001,
30.926,
5
],
[
1395922941408,
37.924,
5
],
[
1395923286538,
34.776,
5
],
[
1395923631384,
34.062,
5
],
[
1395923984932,
29.562,
5
],
[
1395924338908,
33.462,
5
],
[
1395924684006,
33.624,
5
],
[
1395925025592,
38.726,
5
],
[
1395925376800,
37.812,
5
],
[
1395925721076,
32.374,
5
],
[
1395926065734,
32.05,
5
],
[
1395926409926,
33.814,
5
],
[
1395926751276,
37.452,
5
],
[
1395927095511,
35.386,
5
],
[
1395927440262,
33.412,
5
],
[
1395927808653,
32.39,
5
],
[
1395928152720,
28.462,
5
],
[
1395928496581,
36.138,
5
],
[
1395928852373,
37.126,
5
],
[
1395929200885,
36.526,
5
],
[
1395929543943,
35.848,
5
],
[
1395929897522,
32.238,
5
],
[
1395930249232,
32.5,
5
],
[
1395930590529,
30.7,
5
],
[
1395930934029,
33.814,
5
],
[
1395931278407,
38.026,
5
],
[
1395931621773,
37.088,
5
],
[
1395931962569,
36.164,
5
],
[
1395932304687,
31.014,
5
],
[
1395932651926,
34.574,
5
],
[
1395932994036,
40.3,
5
],
[
1395933337648,
40.086,
5
],
[
1395933680605,
39.412,
5
],
[
1395934023522,
38.636,
5
],
[
1395934364891,
37.864,
5
],
[
1395934705252,
37.138,
5
],
[
1395935049426,
36.5,
5
],
[
1395935392523,
35.836,
5
],
[
1395935733214,
31.538,
5
],
[
1395936100801,
33.028,
5
],
[
1395936446353,
33.464,
5
],
[
1395936793308,
33.038,
5
],
[
1395937136414,
32,
5
],
[
1395937481474,
39.012,
5
],
[
1395937822631,
39.862,
5
],
[
1395938167960,
39.25,
5
],
[
1395938514003,
38.526,
5
],
[
1395938858526,
37.812,
5
],
[
1395939201170,
35.4,
5
],
[
1395939543073,
29.888,
5
],
[
1395939896331,
34.838,
5
],
[
1395940238878,
34.5,
5
],
[
1395940580303,
34.024,
5
],
[
1395940925430,
33.536,
5
],
[
1395941269022,
33.024,
5
],
[
1395941609330,
32.536,
5
],
[
1395941951187,
32.076,
5
],
[
1395942294292,
30.76,
5
],
[
1395942640991,
31.824,
5
],
[
1395942985120,
29.238,
5
],
[
1395943336228,
28.65,
5
],
[
1395943681909,
35.59,
5
],
[
1395944028270,
38.086,
5
],
[
1395944373539,
37.6,
5
],
[
1395944718706,
37.024,
5
],
[
1395945063955,
36.438,
5
],
[
1395945407314,
35.836,
5
],
[
1395945748347,
35.274,
5
],
[
1395946090525,
34.75,
5
],
[
1395946434527,
34.224,
5
],
[
1395946776684,
33.736,
5
],
[
1395947133624,
33.25,
5
],
[
1395947477980,
32.812,
5
],
[
1395947821792,
35.548,
5
],
[
1395948165816,
37.074,
5
],
[
1395948509860,
35.188,
5
],
[
1395948855868,
34.026,
5
],
[
1395949201062,
33.052,
5
],
[
1395949545834,
34.236,
5
],
[
1395949891619,
41.14,
5
],
[
1395950237130,
40.638,
5
],
[
1395950589240,
39.976,
5
],
[
1395950933848,
39.176,
5
],
[
1395951275456,
38.4,
5
],
[
1395951618059,
37.636,
5
],
[
1395951961464,
36.912,
5
],
[
1395952303450,
36.214,
5
],
[
1395952645459,
35.5,
5
],
[
1395952990430,
34.402,
5
],
[
1395953128626,
33.715,
2
]
]
},
{
"uuid": "635481a0-6fcd-11e2-8587-eda25228f8bf",
"from": 1395866653964,
"to": 1395953057869,
"min": [
1395911894080,
247.576
],
"max": [
1395927672430,
3815.202
],
"average": 744.075,
"consumption": 17858.61,
"rows": 434,
"tuples": [
[
1395866829151,
1262.711,
127
],
[
1395867020108,
964.709,
127
],
[
1395867213501,
945.448,
127
],
[
1395867408941,
935.988,
127
],
[
1395867600191,
961.046,
127
],
[
1395867781152,
1015.051,
127
],
[
1395867948200,
1089.948,
127
],
[
1395868117023,
1227.589,
127
],
[
1395868278634,
861.886,
127
],
[
1395868458335,
897.813,
127
],
[
1395868649407,
879.726,
127
],
[
1395868834075,
967.95,
127
],
[
1395869018081,
1001.205,
127
],
[
1395869209647,
954.527,
127
],
[
1395869404593,
938.04,
127
],
[
1395869600369,
933.913,
127
],
[
1395869796334,
933.143,
127
],
[
1395869983552,
978.603,
127
],
[
1395870167758,
921.428,
127
],
[
1395870330827,
840.972,
127
],
[
1395870494327,
838.975,
127
],
[
1395870661607,
819.913,
127
],
[
1395870829769,
815.478,
127
],
[
1395871028968,
701.475,
127
],
[
1395871217720,
570.059,
127
],
[
1395871432993,
433.539,
127
],
[
1395871684649,
363.365,
127
],
[
1395871938288,
360.357,
127
],
[
1395872164586,
408.117,
127
],
[
1395872348434,
506.421,
127
],
[
1395872523410,
531.647,
127
],
[
1395872735262,
432.562,
127
],
[
1395872951953,
421.977,
127
],
[
1395873187827,
393.106,
127
],
[
1395873437255,
372.231,
127
],
[
1395873644182,
442.003,
127
],
[
1395873931640,
318.04,
127
],
[
1395874222448,
314.296,
127
],
[
1395874512269,
315.425,
127
],
[
1395874736541,
413.329,
127
],
[
1395874941094,
328.487,
127
],
[
1395875127683,
271.469,
127
],
[
1395875410375,
323.371,
127
],
[
1395875695334,
320.688,
127
],
[
1395875911280,
428.746,
127
],
[
1395876138324,
341.767,
127
],
[
1395876313614,
260.66,
127
],
[
1395876488381,
261.431,
127
],
[
1395876662527,
262.494,
127
],
[
1395876836516,
262.636,
127
],
[
1395877051212,
344.794,
127
],
[
1395877245476,
300.461,
127
],
[
1395877419108,
263.226,
127
],
[
1395877592562,
263.475,
127
],
[
1395877765731,
263.772,
127
],
[
1395877938871,
263.851,
127
],
[
1395878136347,
313.732,
127
],
[
1395878350014,
440.513,
127
],
[
1395878585751,
387.872,
127
],
[
1395878829490,
375.013,
127
],
[
1395879073658,
374.393,
127
],
[
1395879308419,
394.598,
127
],
[
1395879545258,
394.834,
127
],
[
1395879811129,
299.513,
127
],
[
1395879985055,
262.666,
127
],
[
1395880158824,
262.957,
127
],
[
1395880328193,
269.976,
127
],
[
1395880541797,
341.837,
127
],
[
1395880738255,
306.077,
127
],
[
1395880911972,
263.086,
127
],
[
1395881085309,
263.663,
127
],
[
1395881258374,
263.978,
127
],
[
1395881505987,
310.039,
127
],
[
1395881718330,
435.095,
127
],
[
1395881985661,
347.73,
127
],
[
1395882271304,
320.08,
127
],
[
1395882456715,
268.533,
127
],
[
1395882631136,
262.05,
127
],
[
1395882854504,
358.483,
127
],
[
1395883039035,
291.634,
127
],
[
1395883249500,
284.328,
127
],
[
1395883538082,
316.779,
127
],
[
1395883823671,
322.758,
127
],
[
1395884032403,
438.056,
127
],
[
1395884324125,
314.054,
127
],
[
1395884586804,
349.791,
127
],
[
1395884857148,
339.591,
127
],
[
1395885086984,
407.48,
127
],
[
1395885335459,
377.61,
127
],
[
1395885537985,
275.057,
127
],
[
1395885712395,
262.024,
127
],
[
1395885887119,
261.523,
127
],
[
1395886062084,
261.185,
127
],
[
1395886277957,
343.906,
127
],
[
1395886470088,
293.758,
127
],
[
1395886644865,
261.461,
127
],
[
1395886819789,
261.148,
127
],
[
1395886994209,
261.982,
127
],
[
1395887168838,
261.701,
127
],
[
1395887376636,
327.211,
127
],
[
1395887608195,
331.361,
127
],
[
1395887892220,
321.862,
127
],
[
1395888162491,
340.896,
127
],
[
1395888402933,
380.611,
127
],
[
1395888597416,
471.91,
127
],
[
1395888876108,
331.95,
127
],
[
1395889168858,
312.169,
127
],
[
1395889462880,
310.854,
127
],
[
1395889704204,
384.787,
127
],
[
1395889895035,
299.403,
127
],
[
1395890071143,
259.461,
127
],
[
1395890247117,
259.784,
127
],
[
1395890423364,
259.291,
127
],
[
1395890599851,
258.902,
127
],
[
1395890807030,
376.946,
127
],
[
1395891050306,
385.276,
127
],
[
1395891334783,
321.357,
127
],
[
1395891621696,
318.59,
127
],
[
1395891805428,
267.836,
127
],
[
1395892032494,
356.648,
127
],
[
1395892218914,
274.52,
127
],
[
1395892396190,
257.753,
127
],
[
1395892573644,
257.528,
127
],
[
1395892750930,
257.769,
127
],
[
1395892923207,
265.38,
127
],
[
1395893129189,
355.009,
127
],
[
1395893385399,
365.496,
127
],
[
1395893675294,
315.296,
127
],
[
1395893941092,
347.764,
127
],
[
1395894176546,
392.974,
127
],
[
1395894361822,
493.328,
127
],
[
1395894597539,
391.943,
127
],
[
1395894809778,
433.765,
127
],
[
1395895059281,
366.396,
127
],
[
1395895308910,
366.335,
127
],
[
1395895498218,
483.435,
127
],
[
1395895734385,
393.28,
127
],
[
1395895979803,
372.891,
127
],
[
1395896245842,
344.723,
127
],
[
1395896507388,
356.688,
127
],
[
1395896695615,
491.223,
127
],
[
1395896899739,
475.379,
127
],
[
1395897100952,
616.498,
127
],
[
1395897323923,
615.07,
127
],
[
1395897513441,
545.873,
127
],
[
1395897713259,
524.337,
127
],
[
1395897894566,
1531.853,
127
],
[
1395898082488,
862.66,
127
],
[
1395898289793,
791.271,
127
],
[
1395898514359,
620.143,
127
],
[
1395898731081,
623.51,
127
],
[
1395898928380,
696.599,
127
],
[
1395899113918,
759.283,
127
],
[
1395899280515,
1851.804,
127
],
[
1395899447407,
1395.765,
127
],
[
1395899627339,
969.893,
127
],
[
1395899805822,
545.02,
127
],
[
1395899979632,
544.087,
127
],
[
1395900168479,
979.009,
127
],
[
1395900356810,
1066.68,
127
],
[
1395900560786,
585.885,
127
],
[
1395900755449,
1179.007,
127
],
[
1395900948873,
583.957,
127
],
[
1395901117350,
562.17,
127
],
[
1395901327448,
605.494,
127
],
[
1395901520031,
707.865,
127
],
[
1395901717896,
471.893,
127
],
[
1395901912454,
470.224,
127
],
[
1395902135382,
413.163,
127
],
[
1395902356451,
431.006,
127
],
[
1395902525433,
541.258,
127
],
[
1395902742113,
424.586,
127
],
[
1395902987929,
372.182,
127
],
[
1395903246766,
353.924,
127
],
[
1395903470019,
414.106,
127
],
[
1395903647579,
519.468,
127
],
[
1395903849959,
459.952,
127
],
[
1395904122056,
305.075,
127
],
[
1395904341519,
291.873,
127
],
[
1395904613426,
331.783,
127
],
[
1395904828260,
432.017,
127
],
[
1395905091695,
351.764,
127
],
[
1395905381863,
315.323,
127
],
[
1395905559369,
277.773,
127
],
[
1395905777541,
287.636,
127
],
[
1395906008889,
394.306,
127
],
[
1395906196885,
257.983,
127
],
[
1395906434018,
309.068,
127
],
[
1395906691175,
355.588,
127
],
[
1395906946683,
360.913,
127
],
[
1395907139015,
475.288,
127
],
[
1395907365428,
406.577,
127
],
[
1395907567662,
290.955,
127
],
[
1395907775355,
293.933,
127
],
[
1395907982985,
292.034,
127
],
[
1395908176733,
347.304,
127
],
[
1395908403631,
412.435,
127
],
[
1395908663873,
351.602,
127
],
[
1395908942166,
329.471,
127
],
[
1395909206074,
316.218,
127
],
[
1395909438231,
378.061,
127
],
[
1395909688332,
301.318,
127
],
[
1395909967863,
329.954,
127
],
[
1395910222962,
360.322,
127
],
[
1395910437405,
433.324,
127
],
[
1395910671873,
390.757,
127
],
[
1395910929439,
310.061,
127
],
[
1395911220656,
309.029,
127
],
[
1395911448487,
282.115,
127
],
[
1395911691816,
335.065,
127
],
[
1395911894080,
247.576,
127
],
[
1395912082234,
275.418,
127
],
[
1395912343348,
350.82,
127
],
[
1395912586699,
380.743,
127
],
[
1395912771639,
500.631,
127
],
[
1395912987458,
444.713,
127
],
[
1395913253687,
343.147,
127
],
[
1395913515380,
335.524,
127
],
[
1395913695238,
264.865,
127
],
[
1395913910049,
341.787,
127
],
[
1395914161264,
350.321,
127
],
[
1395914446287,
307.864,
127
],
[
1395914699673,
312.074,
127
],
[
1395914894861,
298.127,
127
],
[
1395915103247,
546.466,
127
],
[
1395915310153,
471.74,
127
],
[
1395915497886,
1347.981,
127
],
[
1395915662289,
2390.141,
127
],
[
1395915825873,
2410.517,
127
],
[
1395915990990,
2487.075,
127
],
[
1395916157965,
2588.075,
127
],
[
1395916325749,
2447.295,
127
],
[
1395916513809,
1431.394,
127
],
[
1395916715348,
504.86,
127
],
[
1395916927304,
459.737,
127
],
[
1395917109105,
1337.193,
127
],
[
1395917277802,
2023.567,
127
],
[
1395917445923,
2063.069,
127
],
[
1395917620941,
1744.878,
127
],
[
1395917798016,
1580.61,
127
],
[
1395917973927,
1630.904,
127
],
[
1395918151423,
1568.648,
127
],
[
1395918324047,
1572.344,
127
],
[
1395918491695,
2207.173,
127
],
[
1395918660624,
2005.696,
127
],
[
1395918827001,
2609.324,
127
],
[
1395918994123,
2729.19,
127
],
[
1395919162830,
2667.237,
127
],
[
1395919331485,
2430.091,
127
],
[
1395919500413,
2631.521,
127
],
[
1395919668691,
2460.627,
127
],
[
1395919847972,
2344.665,
127
],
[
1395920064242,
976.613,
127
],
[
1395920285218,
533.754,
127
],
[
1395920462357,
1452.577,
127
],
[
1395920636797,
1860.684,
127
],
[
1395920801819,
2804.958,
127
],
[
1395920967136,
2680.631,
127
],
[
1395921134427,
2578.735,
127
],
[
1395921304929,
858.446,
127
],
[
1395921476262,
877.183,
127
],
[
1395921653338,
905.888,
127
],
[
1395921836115,
1050.635,
127
],
[
1395922012025,
957.213,
127
],
[
1395922182602,
930.323,
127
],
[
1395922357946,
891.135,
127
],
[
1395922536439,
883.838,
127
],
[
1395922717779,
832.924,
127
],
[
1395922899684,
761.402,
127
],
[
1395923078482,
853.549,
127
],
[
1395923255778,
773.505,
127
],
[
1395923424874,
814.546,
127
],
[
1395923601888,
774.568,
127
],
[
1395923777062,
782.071,
127
],
[
1395923949067,
803.026,
127
],
[
1395924144529,
898.851,
127
],
[
1395924325952,
810.606,
127
],
[
1395924500150,
787.69,
127
],
[
1395924672712,
797.69,
127
],
[
1395924847772,
1615.365,
127
],
[
1395925019083,
1463.99,
127
],
[
1395925196894,
991.954,
127
],
[
1395925373498,
1183.006,
127
],
[
1395925537386,
1115.698,
127
],
[
1395925704351,
1099.937,
127
],
[
1395925875694,
1067.354,
127
],
[
1395926049085,
1138.534,
127
],
[
1395926226340,
1288.586,
127
],
[
1395926417485,
900.935,
127
],
[
1395926632254,
627.55,
127
],
[
1395926810580,
2281.561,
127
],
[
1395926978216,
2519.319,
127
],
[
1395927146913,
2077.215,
127
],
[
1395927342375,
707.039,
127
],
[
1395927508793,
2598.954,
127
],
[
1395927672430,
3815.202,
127
],
[
1395927835793,
2992.455,
127
],
[
1395928003262,
2120.998,
127
],
[
1395928179740,
1057.222,
127
],
[
1395928347649,
1789.231,
127
],
[
1395928510446,
2579.338,
127
],
[
1395928676235,
2758.473,
127
],
[
1395928853993,
1216.619,
127
],
[
1395929036824,
1259.541,
127
],
[
1395929201499,
2318.928,
127
],
[
1395929364012,
2643.678,
127
],
[
1395929528868,
2672.831,
127
],
[
1395929709156,
1080.795,
127
],
[
1395929894086,
779.881,
127
],
[
1395930079929,
837.599,
127
],
[
1395930270718,
746.277,
127
],
[
1395930459417,
591.758,
127
],
[
1395930621814,
565.25,
127
],
[
1395930802617,
630.686,
127
],
[
1395930986686,
749.739,
127
],
[
1395931179869,
881.549,
127
],
[
1395931366184,
736.946,
127
],
[
1395931555976,
722.433,
127
],
[
1395931746429,
720.156,
127
],
[
1395931945103,
691.423,
127
],
[
1395932131460,
843.073,
127
],
[
1395932328748,
744.042,
127
],
[
1395932527264,
690.668,
127
],
[
1395932732353,
669.491,
127
],
[
1395932931762,
599.802,
127
],
[
1395933139161,
580.177,
127
],
[
1395933334401,
509.1,
127
],
[
1395933522859,
485.002,
127
],
[
1395933711285,
485.143,
127
],
[
1395933899124,
486.554,
127
],
[
1395934073638,
589.409,
127
],
[
1395934275231,
683.854,
127
],
[
1395934502368,
602.124,
127
],
[
1395934729685,
601.56,
127
],
[
1395934941368,
590.542,
127
],
[
1395935107777,
549.387,
127
],
[
1395935298975,
656.887,
127
],
[
1395935506059,
657.889,
127
],
[
1395935722709,
597.428,
127
],
[
1395935919156,
586.818,
127
],
[
1395936103624,
499.729,
127
],
[
1395936301290,
498.762,
127
],
[
1395936517782,
594.565,
127
],
[
1395936704716,
491.435,
127
],
[
1395936882895,
513.082,
127
],
[
1395937059457,
536.524,
127
],
[
1395937224301,
565.449,
127
],
[
1395937394237,
569.498,
127
],
[
1395937594171,
685.803,
127
],
[
1395937761105,
573.009,
127
],
[
1395937925844,
554.835,
127
],
[
1395938105187,
510.902,
127
],
[
1395938288616,
498.383,
127
],
[
1395938472285,
497.723,
127
],
[
1395938683612,
590.006,
127
],
[
1395938863596,
507.961,
127
],
[
1395939033711,
544.059,
127
],
[
1395939253216,
599.875,
127
],
[
1395939469960,
603.114,
127
],
[
1395939676036,
660.003,
127
],
[
1395939861480,
557.631,
127
],
[
1395940030902,
539.879,
127
],
[
1395940243372,
597.231,
127
],
[
1395940441227,
598.47,
127
],
[
1395940633917,
712.95,
127
],
[
1395940805921,
798.288,
127
],
[
1395940992678,
1247.401,
127
],
[
1395941155085,
2313.396,
127
],
[
1395941345675,
1429.37,
127
],
[
1395941562009,
600.611,
127
],
[
1395941765113,
677.862,
127
],
[
1395941938168,
792.843,
127
],
[
1395942121428,
750.739,
127
],
[
1395942310421,
726.158,
127
],
[
1395942492643,
752.827,
127
],
[
1395942685458,
711.488,
127
],
[
1395942868623,
1171.185,
127
],
[
1395943043400,
1142.902,
127
],
[
1395943218523,
1394.462,
127
],
[
1395943409721,
956.592,
127
],
[
1395943600447,
962.551,
127
],
[
1395943781943,
1007.582,
127
],
[
1395943958190,
1041.504,
127
],
[
1395944129522,
1156.944,
127
],
[
1395944308709,
1025.694,
127
],
[
1395944477532,
1892.317,
127
],
[
1395944664016,
830.504,
127
],
[
1395944854532,
719.848,
127
],
[
1395945040018,
741.673,
127
],
[
1395945206007,
826.35,
127
],
[
1395945391283,
744.795,
127
],
[
1395945583510,
836.583,
127
],
[
1395945780587,
898.634,
127
],
[
1395945966189,
1213.102,
127
],
[
1395946130907,
2501.818,
127
],
[
1395946315364,
1289.513,
127
],
[
1395946480439,
873.043,
127
],
[
1395946640989,
856.239,
127
],
[
1395946801223,
855.864,
127
],
[
1395946961878,
853.591,
127
],
[
1395947127037,
861.3,
127
],
[
1395947311085,
995.67,
127
],
[
1395947488034,
916.108,
127
],
[
1395947675831,
969.376,
127
],
[
1395947867659,
954.226,
127
],
[
1395948032923,
1158.46,
127
],
[
1395948199615,
1157.268,
127
],
[
1395948370475,
1240.749,
127
],
[
1395948546511,
1302.057,
127
],
[
1395948729037,
1185.212,
127
],
[
1395948903655,
1687.536,
127
],
[
1395949084449,
1267.903,
127
],
[
1395949261451,
1239.905,
127
],
[
1395949441037,
1266.933,
127
],
[
1395949615855,
1236.848,
127
],
[
1395949787586,
1111.41,
127
],
[
1395949953449,
1781.707,
127
],
[
1395950128698,
1043.406,
127
],
[
1395950302488,
1052.048,
127
],
[
1395950480173,
1033.936,
127
],
[
1395950652682,
1060.397,
127
],
[
1395950847555,
939.255,
127
],
[
1395951044685,
887.38,
127
],
[
1395951239453,
885.143,
127
],
[
1395951436005,
884.461,
127
],
[
1395951623129,
972.887,
127
],
[
1395951809161,
972.693,
127
],
[
1395951982352,
869.785,
127
],
[
1395952144960,
843.526,
127
],
[
1395952327107,
878.407,
127
],
[
1395952518746,
934.009,
127
],
[
1395952692914,
1052.99,
127
],
[
1395952863448,
1073.526,
127
],
[
1395953051906,
970.317,
127
],
[
1395953057869,
966.875,
4
]
]
},
{
"uuid": "3a513760-89c9-11e2-8948-81bd1f67b0d0",
"from": 1395866527914,
"to": 1395953194282,
"min": [
1395894359500,
21.75
],
"max": [
1395905025839,
57.012
],
"average": 35.641,
"rows": 476,
"tuples": [
[
1395866873189,
40.85,
5
],
[
1395867217219,
43.674,
5
],
[
1395867560699,
46.25,
5
],
[
1395867915810,
45.036,
5
],
[
1395868258143,
44.026,
5
],
[
1395868600588,
39.376,
5
],
[
1395868944152,
36.726,
5
],
[
1395869287552,
35.912,
5
],
[
1395869628477,
35.15,
5
],
[
1395869970643,
34.388,
5
],
[
1395870313912,
33.676,
5
],
[
1395870657296,
33.012,
5
],
[
1395871000669,
32.386,
5
],
[
1395871352939,
31.788,
5
],
[
1395871695258,
31.238,
5
],
[
1395872033992,
30.724,
5
],
[
1395872376983,
30.236,
5
],
[
1395872720352,
29.788,
5
],
[
1395873060335,
29.352,
5
],
[
1395873398170,
28.962,
5
],
[
1395873738116,
28.574,
5
],
[
1395874076778,
28.186,
5
],
[
1395874415077,
27.876,
5
],
[
1395874754091,
27.562,
5
],
[
1395875107073,
27.25,
5
],
[
1395875447442,
26.952,
5
],
[
1395875785431,
26.686,
5
],
[
1395876125116,
26.45,
5
],
[
1395876470505,
26.212,
5
],
[
1395876814547,
25.976,
5
],
[
1395877156145,
25.776,
5
],
[
1395877502810,
25.572,
5
],
[
1395877850859,
25.388,
5
],
[
1395878194653,
25.2,
5
],
[
1395878541121,
25.036,
5
],
[
1395878882830,
24.878,
5
],
[
1395879222290,
24.75,
5
],
[
1395879562249,
24.596,
5
],
[
1395879904707,
24.476,
5
],
[
1395880250528,
24.338,
5
],
[
1395880592444,
24.214,
5
],
[
1395880936992,
24.084,
5
],
[
1395881284874,
23.988,
5
],
[
1395881624804,
23.878,
5
],
[
1395881964725,
23.762,
5
],
[
1395882311402,
23.662,
5
],
[
1395882655651,
23.572,
5
],
[
1395882997643,
23.488,
5
],
[
1395883339363,
23.392,
5
],
[
1395883679604,
23.298,
5
],
[
1395884019674,
23.226,
5
],
[
1395884360410,
23.148,
5
],
[
1395884699134,
23.084,
5
],
[
1395885037492,
22.988,
5
],
[
1395885376933,
22.952,
5
],
[
1395885723162,
22.866,
5
],
[
1395886068603,
22.798,
5
],
[
1395886409565,
22.75,
5
],
[
1395886753280,
22.676,
5
],
[
1395887097080,
22.622,
5
],
[
1395887440048,
22.56,
5
],
[
1395887806745,
22.512,
5
],
[
1395888170607,
22.452,
5
],
[
1395888541250,
22.404,
5
],
[
1395888907264,
22.366,
5
],
[
1395889274347,
22.31,
5
],
[
1395889651458,
22.25,
5
],
[
1395890028690,
22.202,
5
],
[
1395890409358,
22.148,
5
],
[
1395890789539,
22.096,
5
],
[
1395891159561,
22.06,
5
],
[
1395891533672,
22.024,
5
],
[
1395891912445,
21.988,
5
],
[
1395892287220,
21.94,
5
],
[
1395892648435,
21.94,
5
],
[
1395892998984,
21.88,
5
],
[
1395893339784,
21.81,
5
],
[
1395893678549,
21.81,
5
],
[
1395894016794,
21.774,
5
],
[
1395894359500,
21.75,
5
],
[
1395894698850,
21.75,
5
],
[
1395895038862,
28.474,
5
],
[
1395895384266,
55.024,
5
],
[
1395895731341,
56.438,
5
],
[
1395896075431,
54.21,
5
],
[
1395896429963,
32.872,
5
],
[
1395896777340,
29.1,
5
],
[
1395897118654,
43.574,
5
],
[
1395897460844,
49.064,
5
],
[
1395897804161,
45.55,
5
],
[
1395898152011,
45.464,
5
],
[
1395898493814,
56.25,
5
],
[
1395898851115,
50.586,
5
],
[
1395899194752,
29.65,
5
],
[
1395899539672,
36.748,
5
],
[
1395899884730,
52.488,
5
],
[
1395900240530,
49.788,
5
],
[
1395900580780,
45.172,
5
],
[
1395900922433,
28.774,
5
],
[
1395901265612,
32.6,
5
],
[
1395901606209,
51.86,
5
],
[
1395901946800,
47.488,
5
],
[
1395902286057,
39.848,
5
],
[
1395902631139,
48.81,
5
],
[
1395902970858,
49.2,
5
],
[
1395903309621,
50.576,
5
],
[
1395903651631,
52.138,
5
],
[
1395903997597,
49.674,
5
],
[
1395904338900,
49.062,
5
],
[
1395904685096,
46.572,
5
],
[
1395905025839,
57.012,
5
],
[
1395905374320,
41.988,
5
],
[
1395905716559,
33.186,
5
],
[
1395906056711,
48.098,
5
],
[
1395906396854,
44.436,
5
],
[
1395906737062,
41.502,
5
],
[
1395907095586,
35.34,
5
],
[
1395907445092,
45.462,
5
],
[
1395907787773,
47.576,
5
],
[
1395908130513,
45.8,
5
],
[
1395908470617,
44.324,
5
],
[
1395908809756,
44.538,
5
],
[
1395909149268,
50.538,
5
],
[
1395909488107,
52.326,
5
],
[
1395909829485,
48.462,
5
],
[
1395910168349,
46.988,
5
],
[
1395910508016,
43.586,
5
],
[
1395910849092,
45.726,
5
],
[
1395911194139,
40.712,
5
],
[
1395911535954,
44.138,
5
],
[
1395911876405,
43.528,
5
],
[
1395912217880,
41.44,
5
],
[
1395912556136,
43.95,
5
],
[
1395912899841,
35.436,
5
],
[
1395913243707,
43.936,
5
],
[
1395913592664,
42.55,
5
],
[
1395913936675,
40.912,
5
],
[
1395914286504,
39.624,
5
],
[
1395914633422,
43.888,
5
],
[
1395914973661,
41.05,
5
],
[
1395915315113,
44.99,
5
],
[
1395915656925,
44.238,
5
],
[
1395916000528,
40.524,
5
],
[
1395916343283,
43.974,
5
],
[
1395916684815,
38.686,
5
],
[
1395917024789,
42.538,
5
],
[
1395917368003,
41.488,
5
],
[
1395917710531,
40.388,
5
],
[
1395918070904,
38.964,
5
],
[
1395918422550,
42.188,
5
],
[
1395918773988,
38.726,
5
],
[
1395919116758,
34.6,
5
],
[
1395919469004,
39.588,
5
],
[
1395919810858,
40.352,
5
],
[
1395920151976,
37.764,
5
],
[
1395920494529,
39.962,
5
],
[
1395920838846,
31.962,
5
],
[
1395921182424,
41.59,
5
],
[
1395921527194,
46.536,
5
],
[
1395921887644,
52.874,
5
],
[
1395922240082,
32.338,
5
],
[
1395922590769,
33.574,
5
],
[
1395922937662,
39.488,
5
],
[
1395923283134,
37.05,
5
],
[
1395923627490,
38.838,
5
],
[
1395923981583,
31.714,
5
],
[
1395924334667,
37.812,
5
],
[
1395924679979,
34.938,
5
],
[
1395925022220,
39.726,
5
],
[
1395925372149,
38.688,
5
],
[
1395925717769,
35.612,
5
],
[
1395926061503,
35.752,
5
],
[
1395926406663,
34.75,
5
],
[
1395926747537,
39.888,
5
],
[
1395927091951,
38.586,
5
],
[
1395927436227,
40.65,
5
],
[
1395927804398,
37.854,
5
],
[
1395928148882,
30.762,
5
],
[
1395928493279,
38.012,
5
],
[
1395928846901,
37.976,
5
],
[
1395929197066,
37.312,
5
],
[
1395929540603,
36.576,
5
],
[
1395929893336,
34.702,
5
],
[
1395930245880,
36.114,
5
],
[
1395930586296,
31.212,
5
],
[
1395930930666,
34.59,
5
],
[
1395931274060,
38.99,
5
],
[
1395931617501,
37.912,
5
],
[
1395931958916,
36.988,
5
],
[
1395932300915,
40.576,
5
],
[
1395932648521,
55.952,
5
],
[
1395932990747,
41.49,
5
],
[
1395933333826,
41.112,
5
],
[
1395933676555,
40.376,
5
],
[
1395934019991,
39.54,
5
],
[
1395934361733,
38.75,
5
],
[
1395934701889,
37.974,
5
],
[
1395935045472,
37.238,
5
],
[
1395935389126,
36.562,
5
],
[
1395935729729,
33.602,
5
],
[
1395936095776,
35.726,
5
],
[
1395936442642,
34.1,
5
],
[
1395936789128,
33.652,
5
],
[
1395937132692,
32.888,
5
],
[
1395937477796,
40.362,
5
],
[
1395937818851,
40.912,
5
],
[
1395938163892,
40.226,
5
],
[
1395938510837,
39.462,
5
],
[
1395938854436,
38.688,
5
],
[
1395939197654,
37.3,
5
],
[
1395939539243,
32.788,
5
],
[
1395939892909,
35.688,
5
],
[
1395940235454,
35.15,
5
],
[
1395940575969,
34.664,
5
],
[
1395940922094,
34.138,
5
],
[
1395941265562,
33.6,
5
],
[
1395941605589,
33.1,
5
],
[
1395941947317,
32.588,
5
],
[
1395942290634,
31.826,
5
],
[
1395942637084,
35.912,
5
],
[
1395942980677,
29.798,
5
],
[
1395943331276,
29.236,
5
],
[
1395943677651,
36.388,
5
],
[
1395944024153,
38.988,
5
],
[
1395944370181,
38.488,
5
],
[
1395944714757,
37.862,
5
],
[
1395945060297,
37.25,
5
],
[
1395945403728,
36.614,
5
],
[
1395945744832,
36.012,
5
],
[
1395946086696,
35.438,
5
],
[
1395946430737,
34.888,
5
],
[
1395946772644,
34.362,
5
],
[
1395947130004,
33.864,
5
],
[
1395947474141,
33.4,
5
],
[
1395947818387,
36.498,
5
],
[
1395948162043,
37.902,
5
],
[
1395948505541,
35.912,
5
],
[
1395948852440,
34.888,
5
],
[
1395949197917,
34.15,
5
],
[
1395949541820,
35.486,
5
],
[
1395949888197,
42.376,
5
],
[
1395950233072,
41.712,
5
],
[
1395950584355,
40.974,
5
],
[
1395950930249,
40.162,
5
],
[
1395951272092,
39.35,
5
],
[
1395951614033,
38.552,
5
],
[
1395951957757,
37.774,
5
],
[
1395952299492,
37.026,
5
],
[
1395952641741,
36.314,
5
],
[
1395952986765,
35.35,
5
],
[
1395953194282,
34.663,
3
]
]
},
{
"uuid": "89a19f80-6fcd-11e2-be46-d7713e888ef4",
"from": 1392230586226,
"to": 1395661834052,
"min": [
1395661834052,
0.001
],
"max": [
1395661834052,
0.001
],
"average": 0.001,
"consumption": 1,
"rows": 2,
"tuples": [
[
1395661834052,
0.001,
1
]
]
}
],
"debug": {
"level": "1",
"database": "pdo_mysql",
"time": 13.39814,
"uptime": 131608170,
"load": [
2.44,
1.74,
1.3
],
"commit-hash": "ada6670ac004344f22c577f1774a8b76494a6a79\n",
"php-version": "5.4.4-14+deb7u8",
"messages": [
],
"sqlTotalTime": 10.572418928146,
"sqlWorstTime": 6.8334021568298,
"queries": [
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"fc73fdb0-831f-11e2-ab63-050a66acca61"
],
"types": [
2
],
"executionMS": 0.0023849010467529
},
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"8102dbc0-6fcd-11e2-a8b7-a1307aa80770"
],
"types": [
2
],
"executionMS": 0.0012671947479248
},
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"16a5a410-8a11-11e2-bfb5-55e9d027a1f8"
],
"types": [
2
],
"executionMS": 0.0012228488922119
},
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"2dd2cb00-8a11-11e2-b8a9-214e007465a4"
],
"types": [
2
],
"executionMS": 0.041887044906616
},
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"3c391a00-8a11-11e2-92ec-0d9f1daff99d"
],
"types": [
2
],
"executionMS": 0.018064975738525
},
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"1e6e25a0-8a11-11e2-96be-cd4b755a40c6"
],
"types": [
2
],
"executionMS": 0.0012609958648682
},
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"2414a2e0-8a11-11e2-8319-eb6370d8f760"
],
"types": [
2
],
"executionMS": 0.018017053604126
},
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"27fd1e00-89c9-11e2-bc92-c922d3bff0dc"
],
"types": [
2
],
"executionMS": 0.0043389797210693
},
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"635481a0-6fcd-11e2-8587-eda25228f8bf"
],
"types": [
2
],
"executionMS": 0.019769906997681
},
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"3a513760-89c9-11e2-8948-81bd1f67b0d0"
],
"types": [
2
],
"executionMS": 0.023268938064575
},
{
"sql": "SELECT e0_.id AS id0, e0_.uuid AS uuid1,
e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid =
?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC",
"params": [
"89a19f80-6fcd-11e2-be46-d7713e888ef4"
],
"types": [
2
],
"executionMS": 0.0060749053955078
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
13,
1395866656140
],
"types": [
],
"executionMS": 0.014295816421509
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
13,
1395953056140
],
"types": [
],
"executionMS": 0.0099010467529297
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"fc73fdb0-831f-11e2-ab63-050a66acca61"
],
"types": [
],
"executionMS": 0.0034170150756836
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
13,
3,
"1395866534886"
],
"types": [
],
"executionMS": 0.0093159675598145
},
{
"sql": "SELECT
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000,
\"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=?
AND type=? AND timestamp<?",
"params": [
13,
3,
"1395953132737"
],
"types": [
],
"executionMS": 0.0016391277313232
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS
count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp
< ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS
count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >=
? AND timestamp < ?) AS agg",
"params": [
13,
"1395866534886",
"1395788400000",
"1395874800000",
"1395953132737",
13,
3,
"1395788400000",
"1395874800000"
],
"types": [
],
"executionMS": 0.058506011962891
},
{
"sql": "SELECT MAX(agg.timestamp) AS timestamp,
SUM(agg.value) AS value, COUNT(agg.value) AS count FROM (SELECT @row:=3)
AS init, (SELECT timestamp, value, @row:=@row+1 AS row FROM data WHERE
channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY timestamp)
AS agg GROUP BY row DIV 5 ORDER BY timestamp ASC",
"params": [
13,
"1395866534886",
"1395953132737"
],
"types": [
],
"executionMS": 0.21735095977783
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
8,
1395866656140
],
"types": [
],
"executionMS": 0.0052540302276611
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
8,
1395953056140
],
"types": [
],
"executionMS": 0.004213809967041
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"8102dbc0-6fcd-11e2-a8b7-a1307aa80770"
],
"types": [
],
"executionMS": 0.0010390281677246
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
8,
3,
"1395866583474"
],
"types": [
],
"executionMS": 0.0010230541229248
},
{
"sql": "SELECT
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000,
\"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=?
AND type=? AND timestamp<?",
"params": [
8,
3,
"1395953143280"
],
"types": [
],
"executionMS": 0.00098919868469238
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS
count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp
< ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS
count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >=
? AND timestamp < ?) AS agg",
"params": [
8,
"1395866583474",
"1395788400000",
"1395874800000",
"1395953143280",
8,
3,
"1395788400000",
"1395874800000"
],
"types": [
],
"executionMS": 0.015306949615479
},
{
"sql": "SELECT MAX(agg.timestamp) AS timestamp,
SUM(agg.value) AS value, COUNT(agg.value) AS count FROM (SELECT @row:=0)
AS init, (SELECT timestamp, value, @row:=@row+1 AS row FROM data WHERE
channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY timestamp)
AS agg GROUP BY row DIV 2 ORDER BY timestamp ASC",
"params": [
8,
"1395866583474",
"1395953143280"
],
"types": [
],
"executionMS": 0.061779022216797
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
24,
1395866656140
],
"types": [
],
"executionMS": 0.0046718120574951
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
24,
1395953056140
],
"types": [
],
"executionMS": 0.0050780773162842
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"16a5a410-8a11-11e2-bfb5-55e9d027a1f8"
],
"types": [
],
"executionMS": 0.00097489356994629
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
24,
3,
"1395866530039"
],
"types": [
],
"executionMS": 0.0012879371643066
},
{
"sql": "SELECT
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000,
\"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=?
AND type=? AND timestamp<?",
"params": [
24,
3,
"1395953127213"
],
"types": [
],
"executionMS": 0.0010190010070801
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS
count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp
< ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS
count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >=
? AND timestamp < ?) AS agg",
"params": [
24,
"1395866530039",
"1395788400000",
"1395874800000",
"1395953127213",
24,
3,
"1395788400000",
"1395874800000"
],
"types": [
],
"executionMS": 0.028095006942749
},
{
"sql": "SELECT MAX(agg.timestamp) AS timestamp,
SUM(agg.value) AS value, COUNT(agg.value) AS count FROM (SELECT @row:=3)
AS init, (SELECT timestamp, value, @row:=@row+1 AS row FROM data WHERE
channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY timestamp)
AS agg GROUP BY row DIV 5 ORDER BY timestamp ASC",
"params": [
24,
"1395866530039",
"1395953127213"
],
"types": [
],
"executionMS": 0.16695284843445
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
23,
1395866656140
],
"types": [
],
"executionMS": 0.0052919387817383
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
23,
1395953056140
],
"types": [
],
"executionMS": 0.018651008605957
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"2dd2cb00-8a11-11e2-b8a9-214e007465a4"
],
"types": [
],
"executionMS": 0.0010480880737305
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
23,
3,
"1395866529012"
],
"types": [
],
"executionMS": 0.00099992752075195
},
{
"sql": "SELECT
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000,
\"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=?
AND type=? AND timestamp<?",
"params": [
23,
3,
"1395953125834"
],
"types": [
],
"executionMS": 0.0037999153137207
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS
count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp
< ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS
count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >=
? AND timestamp < ?) AS agg",
"params": [
23,
"1395866529012",
"1395788400000",
"1395874800000",
"1395953125834",
23,
3,
"1395788400000",
"1395874800000"
],
"types": [
],
"executionMS": 0.057824850082397
},
{
"sql": "SELECT MAX(agg.timestamp) AS timestamp,
SUM(agg.value) AS value, COUNT(agg.value) AS count FROM (SELECT @row:=3)
AS init, (SELECT timestamp, value, @row:=@row+1 AS row FROM data WHERE
channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY timestamp)
AS agg GROUP BY row DIV 5 ORDER BY timestamp ASC",
"params": [
23,
"1395866529012",
"1395953125834"
],
"types": [
],
"executionMS": 0.27138805389404
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
20,
1395866656140
],
"types": [
],
"executionMS": 0.012998104095459
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
20,
1395953056140
],
"types": [
],
"executionMS": 0.0047149658203125
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"3c391a00-8a11-11e2-92ec-0d9f1daff99d"
],
"types": [
],
"executionMS": 0.0046648979187012
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
20,
3,
"1395866533560"
],
"types": [
],
"executionMS": 0.0010030269622803
},
{
"sql": "SELECT
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000,
\"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=?
AND type=? AND timestamp<?",
"params": [
20,
3,
"1395953131300"
],
"types": [
],
"executionMS": 0.0010318756103516
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS
count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp
< ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS
count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >=
? AND timestamp < ?) AS agg",
"params": [
20,
"1395866533560",
"1395788400000",
"1395874800000",
"1395953131300",
20,
3,
"1395788400000",
"1395874800000"
],
"types": [
],
"executionMS": 0.054480075836182
},
{
"sql": "SELECT MAX(agg.timestamp) AS timestamp,
SUM(agg.value) AS value, COUNT(agg.value) AS count FROM (SELECT @row:=3)
AS init, (SELECT timestamp, value, @row:=@row+1 AS row FROM data WHERE
channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY timestamp)
AS agg GROUP BY row DIV 5 ORDER BY timestamp ASC",
"params": [
20,
"1395866533560",
"1395953131300"
],
"types": [
],
"executionMS": 0.14882397651672
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
21,
1395866656140
],
"types": [
],
"executionMS": 0.0051059722900391
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
21,
1395953056140
],
"types": [
],
"executionMS": 0.0039520263671875
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"1e6e25a0-8a11-11e2-96be-cd4b755a40c6"
],
"types": [
],
"executionMS": 0.00093388557434082
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
21,
3,
"1392463222669"
],
"types": [
],
"executionMS": 0.0010321140289307
},
{
"sql": "SELECT
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000,
\"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=?
AND type=? AND timestamp<?",
"params": [
21,
3,
1395953056140
],
"types": [
],
"executionMS": 0.0013070106506348
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS
count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp
< ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS
count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >=
? AND timestamp < ?) AS agg",
"params": [
21,
"1392463222669",
"1392418800000",
"1392505200000",
1395953056140,
21,
3,
"1392418800000",
"1392505200000"
],
"types": [
],
"executionMS": 0.0070080757141113
},
{
"sql": "SELECT timestamp, value, 1 AS count FROM data
WHERE channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY
timestamp ASC",
"params": [
21,
"1392463222669",
1395953056140
],
"types": [
],
"executionMS": 0.0038590431213379
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
22,
1395866656140
],
"types": [
],
"executionMS": 0.0046799182891846
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
22,
1395953056140
],
"types": [
],
"executionMS": 0.0047719478607178
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"2414a2e0-8a11-11e2-8319-eb6370d8f760"
],
"types": [
],
"executionMS": 0.0010459423065186
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
22,
3,
"1395866532315"
],
"types": [
],
"executionMS": 0.0011200904846191
},
{
"sql": "SELECT
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000,
\"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=?
AND type=? AND timestamp<?",
"params": [
22,
3,
"1395953129956"
],
"types": [
],
"executionMS": 0.00096321105957031
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS
count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp
< ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS
count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >=
? AND timestamp < ?) AS agg",
"params": [
22,
"1395866532315",
"1395788400000",
"1395874800000",
"1395953129956",
22,
3,
"1395788400000",
"1395874800000"
],
"types": [
],
"executionMS": 0.029554128646851
},
{
"sql": "SELECT MAX(agg.timestamp) AS timestamp,
SUM(agg.value) AS value, COUNT(agg.value) AS count FROM (SELECT @row:=3)
AS init, (SELECT timestamp, value, @row:=@row+1 AS row FROM data WHERE
channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY timestamp)
AS agg GROUP BY row DIV 5 ORDER BY timestamp ASC",
"params": [
22,
"1395866532315",
"1395953129956"
],
"types": [
],
"executionMS": 0.13685607910156
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
18,
1395866656140
],
"types": [
],
"executionMS": 0.016370058059692
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
18,
1395953056140
],
"types": [
],
"executionMS": 0.0047421455383301
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"27fd1e00-89c9-11e2-bc92-c922d3bff0dc"
],
"types": [
],
"executionMS": 0.0045359134674072
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
18,
3,
"1395866531070"
],
"types": [
],
"executionMS": 0.0010139942169189
},
{
"sql": "SELECT
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000,
\"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=?
AND type=? AND timestamp<?",
"params": [
18,
3,
"1395953128626"
],
"types": [
],
"executionMS": 0.0010509490966797
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS
count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp
< ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS
count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >=
? AND timestamp < ?) AS agg",
"params": [
18,
"1395866531070",
"1395788400000",
"1395874800000",
"1395953128626",
18,
3,
"1395788400000",
"1395874800000"
],
"types": [
],
"executionMS": 0.048666000366211
},
{
"sql": "SELECT MAX(agg.timestamp) AS timestamp,
SUM(agg.value) AS value, COUNT(agg.value) AS count FROM (SELECT @row:=3)
AS init, (SELECT timestamp, value, @row:=@row+1 AS row FROM data WHERE
channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY timestamp)
AS agg GROUP BY row DIV 5 ORDER BY timestamp ASC",
"params": [
18,
"1395866531070",
"1395953128626"
],
"types": [
],
"executionMS": 0.47312188148499
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
6,
1395866656140
],
"types": [
],
"executionMS": 0.0045351982116699
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
6,
1395953056140
],
"types": [
],
"executionMS": 0.0081219673156738
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"635481a0-6fcd-11e2-8587-eda25228f8bf"
],
"types": [
],
"executionMS": 0.0055570602416992
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
6,
3,
"1395866653964"
],
"types": [
],
"executionMS": 0.0010080337524414
},
{
"sql": "SELECT COUNT(1) FROM data WHERE channel_id = ?
AND timestamp >= ? AND timestamp <= ?",
"params": [
6,
"1395866653964",
"1395953057869"
],
"types": [
],
"executionMS": 1.3569760322571
},
{
"sql": "SELECT MAX(agg.timestamp) AS timestamp,
SUM(agg.value) AS value, COUNT(agg.value) AS count FROM (SELECT
@row:=125) AS init, (SELECT timestamp, value, @row:=@row+1 AS row FROM
data WHERE channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY
timestamp) AS agg GROUP BY row DIV 127 ORDER BY timestamp ASC",
"params": [
6,
"1395866653964",
"1395953057869"
],
"types": [
],
"executionMS": 6.8334021568298
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
19,
1395866656140
],
"types": [
],
"executionMS": 0.0045449733734131
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
19,
1395953056140
],
"types": [
],
"executionMS": 0.0049629211425781
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"3a513760-89c9-11e2-8948-81bd1f67b0d0"
],
"types": [
],
"executionMS": 0.0011332035064697
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
19,
3,
"1395866527914"
],
"types": [
],
"executionMS": 0.0011401176452637
},
{
"sql": "SELECT
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000,
\"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=?
AND type=? AND timestamp<?",
"params": [
19,
3,
"1395953194282"
],
"types": [
],
"executionMS": 0.0009610652923584
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS
count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp
< ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS
count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >=
? AND timestamp < ?) AS agg",
"params": [
19,
"1395866527914",
"1395788400000",
"1395874800000",
"1395953194282",
19,
3,
"1395788400000",
"1395874800000"
],
"types": [
],
"executionMS": 0.029033899307251
},
{
"sql": "SELECT MAX(agg.timestamp) AS timestamp,
SUM(agg.value) AS value, COUNT(agg.value) AS count FROM (SELECT @row:=3)
AS init, (SELECT timestamp, value, @row:=@row+1 AS row FROM data WHERE
channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY timestamp)
AS agg GROUP BY row DIV 5 ORDER BY timestamp ASC",
"params": [
19,
"1395866527914",
"1395953194282"
],
"types": [
],
"executionMS": 0.17067909240723
},
{
"sql": "SELECT MIN(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp<? ORDER BY timestamp DESC
LIMIT 2) t",
"params": [
9,
1395866656140
],
"types": [
],
"executionMS": 0.022716045379639
},
{
"sql": "SELECT MAX(timestamp) FROM (SELECT timestamp
FROM data WHERE channel_id=? AND timestamp>? ORDER BY timestamp ASC
LIMIT 2) t",
"params": [
9,
1395953056140
],
"types": [
],
"executionMS": 0.0039210319519043
},
{
"sql": "SELECT aggregate.type, COUNT(aggregate.id) AS
count FROM aggregate INNER JOIN entities ON aggregate.channel_id =
entities.id WHERE uuid = ? GROUP BY type HAVING count > 0 ORDER BY type
DESC",
"params": [
"89a19f80-6fcd-11e2-be46-d7713e888ef4"
],
"types": [
],
"executionMS": 0.0010268688201904
},
{
"sql": "SELECT
UNIX_TIMESTAMP(FROM_UNIXTIME(MIN(timestamp) \/ 1000, \"%Y-%m-%d\")) *
1000 FROM aggregate WHERE channel_id=? AND type=? AND timestamp>=?",
"params": [
9,
3,
"1392230586226"
],
"types": [
],
"executionMS": 0.0010449886322021
},
{
"sql": "SELECT
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) \/ 1000,
\"%Y-%m-%d\"), INTERVAL 1 day)) * 1000 FROM aggregate WHERE channel_id=?
AND type=? AND timestamp<?",
"params": [
9,
3,
1395953056140
],
"types": [
],
"executionMS": 0.011970996856689
},
{
"sql": "SELECT SUM(count) FROM (SELECT COUNT(1) AS
count FROM data WHERE channel_id = ? AND ( timestamp >= ? AND timestamp
< ? OR timestamp >= ? AND timestamp <= ?) UNION SELECT SUM(count) AS
count FROM aggregate WHERE channel_id = ? AND type = ? AND timestamp >=
? AND timestamp < ?) AS agg",
"params": [
9,
"1392230586226",
"1392159600000",
"1395702000000",
1395953056140,
9,
3,
"1392159600000",
"1395702000000"
],
"types": [
],
"executionMS": 0.0068728923797607
},
{
"sql": "SELECT timestamp, value, 1 AS count FROM data
WHERE channel_id=? AND timestamp >= ? AND timestamp <= ? ORDER BY
timestamp ASC",
"params": [
9,
"1392230586226",
1395953056140
],
"types": [
],
"executionMS": 0.014730930328369
}
]
}
}
> vg
> Andreas
>
> 2014-03-26 20:34 GMT+01:00 Bernd Gewehr <Bernd at gewehr.net>:
>
>> OK, ich glaube, meine Erwartung war falsch: Aggregation läuft super
>> und das Frontend lädt ein Jahr ebenso schnell wie einen Monat, eine
>> Woche oder einen Tag.
>>
>> Dauert nur eben jedesmal so 15 - 20 Sekunden - Pi halt.
>>
>> Also, Andi: Top! Super gemacht - Danke!
>>
>> Mit den besten Grüßen
>>
>> Bernd Gewehr
>>
>> FROM: Bernd Gewehr
>> SENT: Wednesday, March 26, 2014 8:10 PM
>> TO: volkszaehler.org - users
>> SUBJECT: [vz-users] Aggregation - inzwischen im Master von
>> volkszaehler.organgekommen? Was fehlt mir?
>>
>> Hallo,
>>
>> kurze Frage:
>>
>> Ich habe ein frisches Git Pull auf den Master gemacht,
>> dann chown -R www-data volkszaehler.org [1]
>> dann composer curl, move, install und update,
>> dann aggregate create und full day / full hour
>> und in der volkszaehler.conf.php aggregation true eingefügt.
>> Dann noch in die Crontab - fertig.
>>
>> Keine Beschleunigung im Frontend.
>>
>> Fehlt noch was oder muss ich in den dev-branch?
>>
>> Mit den besten Grüßen
>>
>> Bernd Gewehr
>
>
>
> Links:
> ------
> [1] http://volkszaehler.org
--
Bernd Gewehr
Burgstr. 45F
45289 Essen
02014784606
015209328236