RUNNING QUERY { "view": "time", "opts": { "dims": [], "view": "time", "baseview": "time", "custom_fields": [], "custom": "{\"separate_series\":\"agg\",\"fill_missing\":\"zero\"}", "limit": 100, "table": "demo@queries", "sort_by": "count", "stacking": "normal", "start_ms": 1533049200000, "end_ms": 1533686400000, "end_str": "Now", "start_str": "-1 week", "start_date": "2018-07-31T15:00:00.000Z", "end_date": "2018-08-08T00:00:00.000Z", "hist_bucket": null, "hist_bucket_str": null, "time_bucket": 10800, "cols": [ "query_duration" ], "filters": [], "agg": "$avg", "cast_cols": [] }, "col_config": { "query_duration": { "description": "", "name": "query_duration", "type_str": "integer", "display_name": "query_duration", "final_type": "integer" }, "time": { "description": "", "name": "time", "type_str": "integer", "display_name": "time", "time_col": true, "final_type": "integer" }, "end": { "description": "", "name": "end", "type_str": "string", "display_name": "end", "final_type": "string" }, "start": { "description": "", "name": "start", "type_str": "string", "display_name": "start", "final_type": "string" }, "table": { "description": "", "name": "table", "type_str": "string", "display_name": "table", "final_type": "string" }, "user": { "description": "", "name": "user", "type_str": "string", "display_name": "user", "final_type": "string" }, "view": { "description": "", "name": "view", "type_str": "string", "display_name": "view", "final_type": "string" } }, "params": { "dims": [], "view": "time", "baseview": "time", "custom_fields": [], "custom": "{\"separate_series\":\"agg\",\"fill_missing\":\"zero\"}", "limit": 100, "table": "demo@queries", "sort_by": "count", "stacking": "normal", "start_ms": 1533049200000, "end_ms": 1533686400000, "end_str": "Now", "start_str": "-1 week", "start_date": "2018-07-31T15:00:00.000Z", "end_date": "2018-08-08T00:00:00.000Z", "hist_bucket": null, "hist_bucket_str": null, "time_bucket": 10800, "cols": [ "query_duration" ], "filters": [], "agg": "$avg", "cast_cols": [] }, "meta": { "metadata": { "name": "demo@queries", "description": "", "columns": { "query_duration": { "description": "", "name": "query_duration", "type_str": "integer", "display_name": "query_duration", "final_type": "integer" }, "time": { "description": "", "name": "time", "type_str": "integer", "display_name": "time", "time_col": true, "final_type": "integer" }, "end": { "description": "", "name": "end", "type_str": "string", "display_name": "end", "final_type": "string" }, "start": { "description": "", "name": "start", "type_str": "string", "display_name": "start", "final_type": "string" }, "table": { "description": "", "name": "table", "type_str": "string", "display_name": "table", "final_type": "string" }, "user": { "description": "", "name": "user", "type_str": "string", "display_name": "user", "final_type": "string" }, "view": { "description": "", "name": "view", "type_str": "string", "display_name": "view", "final_type": "string" } }, "time_col": "time", "col_types": { "integer": [ { "name": "query_duration", "type_str": "integer", "display_name": "query_duration", "final_type": "integer" }, { "name": "time", "type_str": "integer", "display_name": "time", "time_col": true, "final_type": "integer" } ], "string": [ { "name": "end", "type_str": "string", "display_name": "end", "final_type": "string" }, { "name": "start", "type_str": "string", "display_name": "start", "final_type": "string" }, { "name": "table", "type_str": "string", "display_name": "table", "final_type": "string" }, { "name": "user", "type_str": "string", "display_name": "user", "final_type": "string" }, { "name": "view", "type_str": "string", "display_name": "view", "final_type": "string" } ] } }, "table": "demo@queries" } } RESPONSE [ { _id: { time_bucket: 1533049200 }, 'avg(query_duration)': 326.65242718446603, count: 515, weighted_count: 515, distinct: undefined }, { _id: { time_bucket: 1533060000 }, 'avg(query_duration)': 322.01334816462736, count: 899, weighted_count: 899, distinct: undefined }, { _id: { time_bucket: 1533070800 }, 'avg(query_duration)': 313.98357289527723, count: 487, weighted_count: 487, distinct: undefined }, { _id: { time_bucket: 1533081600 }, 'avg(query_duration)': 358.9620253164557, count: 474, weighted_count: 474, distinct: undefined }, { _id: { time_bucket: 1533092400 }, 'avg(query_duration)': 261.5598086124402, count: 418, weighted_count: 418, distinct: undefined }, { _id: { time_bucket: 1533103200 }, 'avg(query_duration)': 309.34138309549945, count: 911, weighted_count: 911, distinct: undefined }, { _id: { time_bucket: 1533114000 }, 'avg(query_duration)': 330.9625137816979, count: 907, weighted_count: 907, distinct: undefined }, { _id: { time_bucket: 1533124800 }, 'avg(query_duration)': 314.5121495327103, count: 535, weighted_count: 535, distinct: undefined }, { _id: { time_bucket: 1533135600 }, 'avg(query_duration)': 297.8181818181818, count: 308, weighted_count: 308, distinct: undefined }, { _id: { time_bucket: 1533146400 }, 'avg(query_duration)': 335.97097944377265, count: 827, weighted_count: 827, distinct: undefined }, { _id: { time_bucket: 1533157200 }, 'avg(query_duration)': 321.8539944903581, count: 363, weighted_count: 363, distinct: undefined }, { _id: { time_bucket: 1533168000 }, 'avg(query_duration)': 306.4702194357367, count: 319, weighted_count: 319, distinct: undefined }, { _id: { time_bucket: 1533178800 }, 'avg(query_duration)': 327.93153526970957, count: 482, weighted_count: 482, distinct: undefined }, { _id: { time_bucket: 1533189600 }, 'avg(query_duration)': 316.02081165452654, count: 961, weighted_count: 961, distinct: undefined }, { _id: { time_bucket: 1533200400 }, 'avg(query_duration)': 320.4446808510638, count: 940, weighted_count: 940, distinct: undefined }, { _id: { time_bucket: 1533211200 }, 'avg(query_duration)': 308.265690376569, count: 478, weighted_count: 478, distinct: undefined }, { _id: { time_bucket: 1533222000 }, 'avg(query_duration)': 322.4, count: 490, weighted_count: 490, distinct: undefined }, { _id: { time_bucket: 1533232800 }, 'avg(query_duration)': 338.9230769230769, count: 741, weighted_count: 741, distinct: undefined }, { _id: { time_bucket: 1533243600 }, 'avg(query_duration)': 288.2145328719723, count: 578, weighted_count: 578, distinct: undefined }, { _id: { time_bucket: 1533254400 }, 'avg(query_duration)': 297.8450184501845, count: 271, weighted_count: 271, distinct: undefined }, { _id: { time_bucket: 1533265200 }, 'avg(query_duration)': 349.5344827586207, count: 464, weighted_count: 464, distinct: undefined }, { _id: { time_bucket: 1533276000 }, 'avg(query_duration)': 313.5984848484849, count: 924, weighted_count: 924, distinct: undefined }, { _id: { time_bucket: 1533286800 }, 'avg(query_duration)': 323.7676874340021, count: 947, weighted_count: 947, distinct: undefined }, { _id: { time_bucket: 1533297600 }, 'avg(query_duration)': 294.89304812834223, count: 561, weighted_count: 561, distinct: undefined }, { _id: { time_bucket: 1533308400 }, 'avg(query_duration)': 315.03092783505156, count: 388, weighted_count: 388, distinct: undefined }, { _id: { time_bucket: 1533319200 }, 'avg(query_duration)': 335.31660692951016, count: 837, weighted_count: 837, distinct: undefined }, { _id: { time_bucket: 1533330000 }, 'avg(query_duration)': 295.42105263157896, count: 399, weighted_count: 399, distinct: undefined }, { _id: { time_bucket: 1533340800 }, 'avg(query_duration)': 300.9962121212121, count: 264, weighted_count: 264, distinct: undefined }, { _id: { time_bucket: 1533351600 }, 'avg(query_duration)': 290.9661835748792, count: 414, weighted_count: 414, distinct: undefined }, { _id: { time_bucket: 1533362400 }, 'avg(query_duration)': 322.5576131687243, count: 972, weighted_count: 972, distinct: undefined }, { _id: { time_bucket: 1533373200 }, 'avg(query_duration)': 308.0197775030902, count: 809, weighted_count: 809, distinct: undefined }, { _id: { time_bucket: 1533384000 }, 'avg(query_duration)': 311.18909710391824, count: 587, weighted_count: 587, distinct: undefined }, { _id: { time_bucket: 1533394800 }, 'avg(query_duration)': 325.16497461928935, count: 394, weighted_count: 394, distinct: undefined }, { _id: { time_bucket: 1533405600 }, 'avg(query_duration)': 331.69767441860466, count: 774, weighted_count: 774, distinct: undefined }, { _id: { time_bucket: 1533416400 }, 'avg(query_duration)': 289.8774774774775, count: 555, weighted_count: 555, distinct: undefined }, { _id: { time_bucket: 1533427200 }, 'avg(query_duration)': 306.54088050314465, count: 159, weighted_count: 159, distinct: undefined }, { _id: { time_bucket: 1533438000 }, 'avg(query_duration)': 304.9261213720317, count: 379, weighted_count: 379, distinct: undefined }, { _id: { time_bucket: 1533448800 }, 'avg(query_duration)': 324.2097186700767, count: 782, weighted_count: 782, distinct: undefined }, { _id: { time_bucket: 1533459600 }, 'avg(query_duration)': 333.5101214574899, count: 741, weighted_count: 741, distinct: undefined }, { _id: { time_bucket: 1533470400 }, 'avg(query_duration)': 312.614953271028, count: 535, weighted_count: 535, distinct: undefined }, { _id: { time_bucket: 1533481200 }, 'avg(query_duration)': 316.437908496732, count: 306, weighted_count: 306, distinct: undefined }, { _id: { time_bucket: 1533492000 }, 'avg(query_duration)': 293.4003378378378, count: 592, weighted_count: 592, distinct: undefined }, { _id: { time_bucket: 1533502800 }, 'avg(query_duration)': 336.2172701949861, count: 718, weighted_count: 718, distinct: undefined }, { _id: { time_bucket: 1533513600 }, 'avg(query_duration)': 334.1631419939577, count: 331, weighted_count: 331, distinct: undefined }, { _id: { time_bucket: 1533524400 }, 'avg(query_duration)': 315.2918215613383, count: 538, weighted_count: 538, distinct: undefined }, { _id: { time_bucket: 1533535200 }, 'avg(query_duration)': 306.19253208868145, count: 857, weighted_count: 857, distinct: undefined }, { _id: { time_bucket: 1533546000 }, 'avg(query_duration)': 292.9009324009324, count: 858, weighted_count: 858, distinct: undefined }, { _id: { time_bucket: 1533556800 }, 'avg(query_duration)': 344.94375, count: 320, weighted_count: 320, distinct: undefined }, { _id: { time_bucket: 1533567600 }, 'avg(query_duration)': 272.23668639053255, count: 338, weighted_count: 338, distinct: undefined }, { _id: { time_bucket: 1533578400 }, 'avg(query_duration)': 313.17699115044246, count: 565, weighted_count: 565, distinct: undefined }, { _id: { time_bucket: 1533589200 }, 'avg(query_duration)': 296.37453183520597, count: 534, weighted_count: 534, distinct: undefined }, { _id: { time_bucket: 1533600000 }, 'avg(query_duration)': 294.27659574468083, count: 235, weighted_count: 235, distinct: undefined }, { _id: { time_bucket: 1533610800 }, 'avg(query_duration)': 335.640350877193, count: 114, weighted_count: 114, distinct: undefined }, { _id: { time_bucket: 1533621600 }, 'avg(query_duration)': 309.1222222222222, count: 180, weighted_count: 180, distinct: undefined }, { _id: { time_bucket: 1533632400 }, 'avg(query_duration)': 370.95477386934675, count: 199, weighted_count: 199, distinct: undefined }, { _id: { time_bucket: 1533643200 }, 'avg(query_duration)': 274.3888888888889, count: 126, weighted_count: 126, distinct: undefined }, { _id: { time_bucket: 1533654000 }, 'avg(query_duration)': 290.05405405405406, count: 185, weighted_count: 185, distinct: undefined }, { _id: { time_bucket: 1533664800 }, 'avg(query_duration)': 393.9344262295082, count: 122, weighted_count: 122, distinct: undefined }, { _id: { time_bucket: 1533675600 }, 'avg(query_duration)': 342.2340425531915, count: 47, weighted_count: 47, distinct: undefined } ]