RUNNING QUERY { "view": "hist", "opts": { "dims": [], "view": "dist", "baseview": "dist", "custom_fields": [], "custom": "{}", "limit": 100, "table": "demo@queries", "sort_by": "count", "stacking": "normal", "start_ms": 1533063600000, "end_ms": 1533672000000, "end_str": "Now", "start_str": "-1 week", "start_date": "2018-07-31T19:00:00.000Z", "end_date": "2018-08-07T20:00:00.000Z", "hist_bucket": null, "hist_bucket_str": "log_hist", "time_bucket": 1800, "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": "dist", "baseview": "dist", "custom_fields": [], "custom": "{}", "limit": 100, "table": "demo@queries", "sort_by": "count", "stacking": "normal", "start_ms": 1533063600000, "end_ms": 1533672000000, "end_str": "Now", "start_str": "-1 week", "start_date": "2018-07-31T19:00:00.000Z", "end_date": "2018-08-07T20:00:00.000Z", "hist_bucket": null, "hist_bucket_str": "log_hist", "time_bucket": 1800, "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" } } RUNNING DIST QUERY RESPONSE [ { _id: { query_duration: 4 }, query_duration: 4, count: 1 }, { _id: { query_duration: 11 }, query_duration: 11, count: 3 }, { _id: { query_duration: 18 }, query_duration: 18, count: 4 }, { _id: { query_duration: 25 }, query_duration: 25, count: 2 }, { _id: { query_duration: 32 }, query_duration: 32, count: 4 }, { _id: { query_duration: 39 }, query_duration: 39, count: 8 }, { _id: { query_duration: 46 }, query_duration: 46, count: 18 }, { _id: { query_duration: 53 }, query_duration: 53, count: 20 }, { _id: { query_duration: 60 }, query_duration: 60, count: 24 }, { _id: { query_duration: 67 }, query_duration: 67, count: 35 }, { _id: { query_duration: 74 }, query_duration: 74, count: 60 }, { _id: { query_duration: 81 }, query_duration: 81, count: 53 }, { _id: { query_duration: 88 }, query_duration: 88, count: 93 }, { _id: { query_duration: 95 }, query_duration: 95, count: 127 }, { _id: { query_duration: 102 }, query_duration: 102, count: 194 }, { _id: { query_duration: 109 }, query_duration: 109, count: 187 }, { _id: { query_duration: 116 }, query_duration: 116, count: 231 }, { _id: { query_duration: 123 }, query_duration: 123, count: 295 }, { _id: { query_duration: 130 }, query_duration: 130, count: 375 }, { _id: { query_duration: 137 }, query_duration: 137, count: 430 }, { _id: { query_duration: 144 }, query_duration: 144, count: 484 }, { _id: { query_duration: 151 }, query_duration: 151, count: 518 }, { _id: { query_duration: 158 }, query_duration: 158, count: 664 }, { _id: { query_duration: 165 }, query_duration: 165, count: 639 }, { _id: { query_duration: 172 }, query_duration: 172, count: 698 }, { _id: { query_duration: 179 }, query_duration: 179, count: 686 }, { _id: { query_duration: 186 }, query_duration: 186, count: 748 }, { _id: { query_duration: 193 }, query_duration: 193, count: 774 }, { _id: { query_duration: 200 }, query_duration: 200, count: 721 }, { _id: { query_duration: 207 }, query_duration: 207, count: 715 }, { _id: { query_duration: 214 }, query_duration: 214, count: 695 }, { _id: { query_duration: 221 }, query_duration: 221, count: 719 }, { _id: { query_duration: 228 }, query_duration: 228, count: 621 }, { _id: { query_duration: 235 }, query_duration: 235, count: 627 }, { _id: { query_duration: 242 }, query_duration: 242, count: 525 }, { _id: { query_duration: 249 }, query_duration: 249, count: 489 }, { _id: { query_duration: 256 }, query_duration: 256, count: 454 }, { _id: { query_duration: 263 }, query_duration: 263, count: 352 }, { _id: { query_duration: 270 }, query_duration: 270, count: 324 }, { _id: { query_duration: 277 }, query_duration: 277, count: 280 }, { _id: { query_duration: 284 }, query_duration: 284, count: 247 }, { _id: { query_duration: 291 }, query_duration: 291, count: 217 }, { _id: { query_duration: 298 }, query_duration: 298, count: 184 }, { _id: { query_duration: 305 }, query_duration: 305, count: 185 }, { _id: { query_duration: 312 }, query_duration: 312, count: 161 }, { _id: { query_duration: 319 }, query_duration: 319, count: 186 }, { _id: { query_duration: 326 }, query_duration: 326, count: 193 }, { _id: { query_duration: 333 }, query_duration: 333, count: 246 }, { _id: { query_duration: 340 }, query_duration: 340, count: 294 }, { _id: { query_duration: 347 }, query_duration: 347, count: 374 }, { _id: { query_duration: 354 }, query_duration: 354, count: 424 }, { _id: { query_duration: 361 }, query_duration: 361, count: 551 }, { _id: { query_duration: 368 }, query_duration: 368, count: 653 }, { _id: { query_duration: 375 }, query_duration: 375, count: 793 }, { _id: { query_duration: 382 }, query_duration: 382, count: 821 }, { _id: { query_duration: 389 }, query_duration: 389, count: 966 }, { _id: { query_duration: 396 }, query_duration: 396, count: 980 }, { _id: { query_duration: 403 }, query_duration: 403, count: 1044 }, { _id: { query_duration: 410 }, query_duration: 410, count: 914 }, { _id: { query_duration: 417 }, query_duration: 417, count: 788 }, { _id: { query_duration: 424 }, query_duration: 424, count: 675 }, { _id: { query_duration: 431 }, query_duration: 431, count: 550 }, { _id: { query_duration: 438 }, query_duration: 438, count: 448 }, { _id: { query_duration: 445 }, query_duration: 445, count: 346 }, { _id: { query_duration: 452 }, query_duration: 452, count: 300 }, { _id: { query_duration: 459 }, query_duration: 459, count: 211 }, { _id: { query_duration: 466 }, query_duration: 466, count: 173 }, { _id: { query_duration: 473 }, query_duration: 473, count: 124 }, { _id: { query_duration: 480 }, query_duration: 480, count: 91 }, { _id: { query_duration: 487 }, query_duration: 487, count: 69 }, { _id: { query_duration: 494 }, query_duration: 494, count: 61 }, { _id: { query_duration: 501 }, query_duration: 501, count: 48 }, { _id: { query_duration: 508 }, query_duration: 508, count: 38 }, { _id: { query_duration: 515 }, query_duration: 515, count: 27 }, { _id: { query_duration: 522 }, query_duration: 522, count: 23 }, { _id: { query_duration: 529 }, query_duration: 529, count: 31 }, { _id: { query_duration: 536 }, query_duration: 536, count: 34 }, { _id: { query_duration: 543 }, query_duration: 543, count: 54 }, { _id: { query_duration: 550 }, query_duration: 550, count: 70 }, { _id: { query_duration: 557 }, query_duration: 557, count: 75 }, { _id: { query_duration: 564 }, query_duration: 564, count: 141 }, { _id: { query_duration: 571 }, query_duration: 571, count: 173 }, { _id: { query_duration: 578 }, query_duration: 578, count: 203 }, { _id: { query_duration: 585 }, query_duration: 585, count: 244 }, { _id: { query_duration: 592 }, query_duration: 592, count: 257 }, { _id: { query_duration: 599 }, query_duration: 599, count: 237 }, { _id: { query_duration: 606 }, query_duration: 606, count: 252 }, { _id: { query_duration: 613 }, query_duration: 613, count: 235 }, { _id: { query_duration: 620 }, query_duration: 620, count: 183 }, { _id: { query_duration: 627 }, query_duration: 627, count: 160 }, { _id: { query_duration: 634 }, query_duration: 634, count: 114 }, { _id: { query_duration: 641 }, query_duration: 641, count: 74 }, { _id: { query_duration: 648 }, query_duration: 648, count: 45 }, { _id: { query_duration: 655 }, query_duration: 655, count: 30 }, { _id: { query_duration: 662 }, query_duration: 662, count: 16 }, { _id: { query_duration: 669 }, query_duration: 669, count: 9 }, { _id: { query_duration: 676 }, query_duration: 676, count: 3 }, { _id: { query_duration: 683 }, query_duration: 683, count: 4 }, { _id: { query_duration: -17 }, query_duration: -17, count: 1 }, { _id: { query_duration: -3 }, query_duration: -3, count: 3 } ]