RUNNING QUERY { "view": "samples", "opts": { "dims": [], "view": "samples", "baseview": "samples", "custom_fields": [], "custom": "{\"separate_series\":\"agg\",\"fill_missing\":\"zero\"}", "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": null, "time_bucket": 1800, "cols": [], "filters": [], "agg": "$count", "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": "samples", "baseview": "samples", "custom_fields": [], "custom": "{\"separate_series\":\"agg\",\"fill_missing\":\"zero\"}", "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": null, "time_bucket": 1800, "cols": [], "filters": [], "agg": "$count", "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 [ { integer: { query_duration: 432, time: 1533065933 }, string: { end: 'Now', start: '-1 day', table: 'demo@queries', user: 'john', view: 'time' } }, { integer: { query_duration: 416, time: 1533065934 }, string: { end: '-3 hours', start: '-6 months', table: 'demo@queries', user: 'john', view: 'time' } }, { integer: { query_duration: 456, time: 1533065937 }, string: { end: 'Now', start: '-1 week', table: 'demo@queries', user: 'john', view: 'time' } }, { integer: { query_duration: 170, time: 1533065939 }, string: { end: '-6 hours', start: '-1 month', table: 'demo@queries', user: 'john', view: 'table' } }, { integer: { query_duration: 391, time: 1533065940 }, string: { end: 'Now', start: '-6 hours', table: 'demo@queries', user: 'john', view: 'time' } }, { integer: { query_duration: 450, time: 1533065941 }, string: { end: '-3 hours', start: '-1 week', table: 'demo@queries', user: 'john', view: 'time' } }, { integer: { query_duration: 442, time: 1533065942 }, string: { end: '-3 hours', start: '-6 hours', table: 'demo@queries', user: 'john', view: 'time' } }, { integer: { query_duration: 218, time: 1533065944 }, string: { end: '-6 hours', start: '-1 day', table: 'demo@queries', user: 'john', view: 'table' } }, { integer: { query_duration: 205, time: 1533065947 }, string: { end: '-6 hours', start: '-1 week', table: 'demo@queries', user: 'john', view: 'table' } }, { integer: { query_duration: 373, time: 1533065949 }, string: { end: 'Now', start: '-1 week', table: 'demo@queries', user: 'john', view: 'time' } }, { integer: { query_duration: 422, time: 1533065953 }, string: { end: '-6 hours', start: '-6 months', table: 'demo@queries', user: 'john', view: 'time' } }, { integer: { query_duration: 190, time: 1533065955 }, string: { end: '-6 hours', start: '-1 week', table: 'demo@queries', user: 'john', view: 'samples' } }, { integer: { query_duration: 210, time: 1533065957 }, string: { end: 'Now', start: '-1 month', table: 'demo@queries', user: 'john', view: 'table' } }, { integer: { query_duration: 324, time: 1533065960 }, string: { end: 'Now', start: '-6 hours', table: 'demo@queries', user: 'john', view: 'time' } }, { integer: { query_duration: 198, time: 1533065961 }, string: { end: '-6 hours', start: '-1 month', table: 'demo@queries', user: 'john', view: 'samples' } }, { integer: { query_duration: 230, time: 1533065965 }, string: { end: '-1 day', start: '-1 day', table: 'demo@queries', user: 'john', view: 'table' } }, { integer: { query_duration: 389, time: 1533065968 }, string: { end: '-1 day', start: '-1 day', table: 'demo@queries', user: 'john', view: 'time' } }, { integer: { query_duration: 232, time: 1533065971 }, string: { end: '-1 day', start: '-1 month', table: 'demo@queries', user: 'john', view: 'table' } }, { integer: { query_duration: 135, time: 1533065973 }, string: { end: 'Now', start: '-1 week', table: 'demo@queries', user: 'john', view: 'session' } }, { integer: { query_duration: 566, time: 1533072472 }, string: { end: '-6 hours', start: '-1 day', table: 'demo@nginx', user: 'jenn', view: 'time' } }, { integer: { query_duration: 408, time: 1533072473 }, string: { end: '-3 hours', start: '-1 month', table: 'demo@nginx', user: 'jenn', view: 'table' } }, { integer: { query_duration: 440, time: 1533072475 }, string: { end: 'Now', start: '-1 day', table: 'demo@nginx', user: 'jenn', view: 'table' } }, { integer: { query_duration: 413, time: 1533072480 }, string: { end: 'Now', start: '-1 month', table: 'demo@nginx', user: 'jenn', view: 'overview' } }, { integer: { query_duration: 150, time: 1533065375 }, string: { end: '-6 hours', start: '-6 hours', table: 'demo@taxi_trips', user: 'demo', view: 'samples' } }, { integer: { query_duration: 179, time: 1533065379 }, string: { end: '-3 hours', start: '-1 month', table: 'demo@taxi_trips', user: 'demo', view: 'overview' } }, { integer: { query_duration: 286, time: 1533065379 }, string: { end: '-1 day', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'time' } }, { integer: { query_duration: 378, time: 1533065382 }, string: { end: '-6 hours', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'time' } }, { integer: { query_duration: 210, time: 1533065387 }, string: { end: '-1 day', start: '-1 day', table: 'demo@taxi_trips', user: 'demo', view: 'samples' } }, { integer: { query_duration: 163, time: 1533065390 }, string: { end: '-6 hours', start: '-6 hours', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 220, time: 1533065394 }, string: { end: 'Now', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'session' } }, { integer: { query_duration: 280, time: 1533146394 }, string: { end: 'Now', start: '-6 hours', table: 'demo@taxi_trips', user: 'demo', view: 'samples' } }, { integer: { query_duration: 184, time: 1533146399 }, string: { end: 'Now', start: '-6 hours', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 236, time: 1533146401 }, string: { end: 'Now', start: '-1 day', table: 'demo@taxi_trips', user: 'demo', view: 'samples' } }, { integer: { query_duration: 350, time: 1533146403 }, string: { end: '-3 hours', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'time' } }, { integer: { query_duration: 163, time: 1533146404 }, string: { end: 'Now', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 260, time: 1533146406 }, string: { end: '-6 hours', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'session' } }, { integer: { query_duration: 200, time: 1533146410 }, string: { end: 'Now', start: '-1 day', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 210, time: 1533146411 }, string: { end: '-1 day', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'samples' } }, { integer: { query_duration: 204, time: 1533146413 }, string: { end: '-6 hours', start: '-1 day', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 165, time: 1533146415 }, string: { end: '-3 hours', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 355, time: 1533146416 }, string: { end: '-1 day', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'time' } }, { integer: { query_duration: 167, time: 1533146417 }, string: { end: 'Now', start: '-6 months', table: 'demo@taxi_trips', user: 'demo', view: 'samples' } }, { integer: { query_duration: 422, time: 1533146418 }, string: { end: '-3 hours', start: '-1 day', table: 'demo@taxi_trips', user: 'demo', view: 'time' } }, { integer: { query_duration: 361, time: 1533146421 }, string: { end: '-1 day', start: '-1 day', table: 'demo@taxi_trips', user: 'demo', view: 'time' } }, { integer: { query_duration: 180, time: 1533146424 }, string: { end: '-1 day', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 145, time: 1533146427 }, string: { end: 'Now', start: '-1 month', table: 'demo@taxi_trips', user: 'demo', view: 'samples' } }, { integer: { query_duration: 218, time: 1533146429 }, string: { end: 'Now', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 465, time: 1533146433 }, string: { end: '-1 day', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'time' } }, { integer: { query_duration: 412, time: 1533146434 }, string: { end: '-1 day', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'time' } }, { integer: { query_duration: 193, time: 1533146436 }, string: { end: 'Now', start: '-6 hours', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 209, time: 1533146437 }, string: { end: '-3 hours', start: '-1 month', table: 'demo@taxi_trips', user: 'demo', view: 'session' } }, { integer: { query_duration: 208, time: 1533146441 }, string: { end: '-3 hours', start: '-1 week', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 190, time: 1533146442 }, string: { end: '-6 hours', start: '-6 months', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 196, time: 1533146445 }, string: { end: 'Now', start: '-6 months', table: 'demo@taxi_trips', user: 'demo', view: 'table' } }, { integer: { query_duration: 399, time: 1533125246 }, string: { end: 'Now', start: '-1 day', table: 'demo@queries', user: 'anon', view: 'time' } }, { integer: { query_duration: 158, time: 1533125246 }, string: { end: '-3 hours', start: '-6 months', table: 'demo@queries', user: 'anon', view: 'table' } }, { integer: { query_duration: 207, time: 1533125247 }, string: { end: '-6 hours', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'table' } }, { integer: { query_duration: 217, time: 1533125249 }, string: { end: '-3 hours', start: '-1 day', table: 'demo@queries', user: 'anon', view: 'samples' } }, { integer: { query_duration: 192, time: 1533125251 }, string: { end: '-1 day', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'samples' } }, { integer: { query_duration: 178, time: 1533125253 }, string: { end: '-1 day', start: '-6 months', table: 'demo@queries', user: 'anon', view: 'session' } }, { integer: { query_duration: 253, time: 1533125254 }, string: { end: 'Now', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'session' } }, { integer: { query_duration: 176, time: 1533125257 }, string: { end: '-3 hours', start: '-6 hours', table: 'demo@queries', user: 'anon', view: 'session' } }, { integer: { query_duration: 181, time: 1533125261 }, string: { end: 'Now', start: '-1 day', table: 'demo@queries', user: 'anon', view: 'session' } }, { integer: { query_duration: 191, time: 1533125266 }, string: { end: '-1 day', start: '-1 month', table: 'demo@queries', user: 'anon', view: 'overview' } }, { integer: { query_duration: 176, time: 1533125270 }, string: { end: 'Now', start: '-1 day', table: 'demo@queries', user: 'anon', view: 'overview' } }, { integer: { query_duration: 243, time: 1533125272 }, string: { end: '-3 hours', start: '-1 month', table: 'demo@queries', user: 'anon', view: 'samples' } }, { integer: { query_duration: 372, time: 1533125272 }, string: { end: '-3 hours', start: '-1 day', table: 'demo@queries', user: 'anon', view: 'time' } }, { integer: { query_duration: 473, time: 1533125276 }, string: { end: 'Now', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'time' } }, { integer: { query_duration: 441, time: 1533125278 }, string: { end: '-3 hours', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'time' } }, { integer: { query_duration: 171, time: 1533125280 }, string: { end: '-6 hours', start: '-1 day', table: 'demo@queries', user: 'anon', view: 'table' } }, { integer: { query_duration: 452, time: 1533125280 }, string: { end: '-3 hours', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'time' } }, { integer: { query_duration: 144, time: 1533125282 }, string: { end: 'Now', start: '-1 day', table: 'demo@queries', user: 'anon', view: 'table' } }, { integer: { query_duration: 240, time: 1533125285 }, string: { end: '-1 day', start: '-1 month', table: 'demo@queries', user: 'anon', view: 'session' } }, { integer: { query_duration: 436, time: 1533125290 }, string: { end: '-6 hours', start: '-1 day', table: 'demo@queries', user: 'anon', view: 'time' } }, { integer: { query_duration: 169, time: 1533125290 }, string: { end: '-6 hours', start: '-1 month', table: 'demo@queries', user: 'anon', view: 'overview' } }, { integer: { query_duration: 287, time: 1533125293 }, string: { end: 'Now', start: '-1 day', table: 'demo@queries', user: 'anon', view: 'samples' } }, { integer: { query_duration: 210, time: 1533125297 }, string: { end: '-6 hours', start: '-6 hours', table: 'demo@queries', user: 'anon', view: 'table' } }, { integer: { query_duration: 401, time: 1533125301 }, string: { end: '-1 day', start: '-6 hours', table: 'demo@queries', user: 'anon', view: 'time' } }, { integer: { query_duration: 188, time: 1533125305 }, string: { end: 'Now', start: '-6 hours', table: 'demo@queries', user: 'anon', view: 'table' } }, { integer: { query_duration: 214, time: 1533125308 }, string: { end: 'Now', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'table' } }, { integer: { query_duration: 425, time: 1533125309 }, string: { end: '-1 day', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'time' } }, { integer: { query_duration: 237, time: 1533125313 }, string: { end: '-3 hours', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'samples' } }, { integer: { query_duration: 409, time: 1533125313 }, string: { end: '-6 hours', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'time' } }, { integer: { query_duration: 376, time: 1533125317 }, string: { end: 'Now', start: '-6 hours', table: 'demo@queries', user: 'anon', view: 'time' } }, { integer: { query_duration: 179, time: 1533125320 }, string: { end: '-6 hours', start: '-1 day', table: 'demo@queries', user: 'anon', view: 'session' } }, { integer: { query_duration: 173, time: 1533125323 }, string: { end: 'Now', start: '-1 week', table: 'demo@queries', user: 'anon', view: 'table' } }, { integer: { query_duration: 637, time: 1533064055 }, string: { end: '-3 hours', start: '-1 day', table: 'demo@nginx', user: 'jenn', view: 'time' } }, { integer: { query_duration: 409, time: 1533064058 }, string: { end: '-1 day', start: '-1 day', table: 'demo@nginx', user: 'jenn', view: 'overview' } }, { integer: { query_duration: 376, time: 1533064059 }, string: { end: '-6 hours', start: '-1 day', table: 'demo@nginx', user: 'jenn', view: 'table' } }, { integer: { query_duration: 445, time: 1533064062 }, string: { end: 'Now', start: '-1 week', table: 'demo@nginx', user: 'jenn', view: 'session' } }, { integer: { query_duration: 425, time: 1533064065 }, string: { end: '-6 hours', start: '-6 hours', table: 'demo@nginx', user: 'jenn', view: 'table' } }, { integer: { query_duration: 378, time: 1533064069 }, string: { end: '-1 day', start: '-6 hours', table: 'demo@nginx', user: 'jenn', view: 'table' } }, { integer: { query_duration: 380, time: 1533064070 }, string: { end: '-3 hours', start: '-1 week', table: 'demo@nginx', user: 'jenn', view: 'table' } }, { integer: { query_duration: 608, time: 1533064073 }, string: { end: '-3 hours', start: '-1 week', table: 'demo@nginx', user: 'jenn', view: 'time' } }, { integer: { query_duration: 441, time: 1533064077 }, string: { end: '-3 hours', start: '-6 hours', table: 'demo@nginx', user: 'jenn', view: 'session' } }, { integer: { query_duration: 369, time: 1533064082 }, string: { end: '-1 day', start: '-1 day', table: 'demo@nginx', user: 'jenn', view: 'overview' } }, { integer: { query_duration: 611, time: 1533064086 }, string: { end: 'Now', start: '-1 week', table: 'demo@nginx', user: 'jenn', view: 'time' } }, { integer: { query_duration: 405, time: 1533064090 }, string: { end: '-6 hours', start: '-1 week', table: 'demo@nginx', user: 'jenn', view: 'table' } }, { integer: { query_duration: 447, time: 1533064090 }, string: { end: '-1 day', start: '-1 week', table: 'demo@nginx', user: 'jenn', view: 'session' } }, { integer: { query_duration: 588, time: 1533064092 }, string: { end: 'Now', start: '-6 hours', table: 'demo@nginx', user: 'jenn', view: 'time' } } ]