RUNNING QUERY { "view": "table", "opts": { "dims": [ "table", "view" ], "view": "table", "baseview": "table", "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": 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": [ "table", "view" ], "view": "table", "baseview": "table", "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": 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 [ { _id: { table: 'demo@taxi_trips', view: 'table' }, count: 3714, distinct: undefined, weighted_count: 3714 }, { _id: { table: 'demo@queries', view: 'table' }, count: 3595, distinct: undefined, weighted_count: 3595 }, { _id: { table: 'demo@nginx', view: 'table' }, count: 3519, distinct: undefined, weighted_count: 3519 }, { _id: { table: 'demo@taxi_trips', view: 'time' }, count: 2899, distinct: undefined, weighted_count: 2899 }, { _id: { table: 'demo@queries', view: 'time' }, count: 2628, distinct: undefined, weighted_count: 2628 }, { _id: { table: 'demo@nginx', view: 'time' }, count: 2605, distinct: undefined, weighted_count: 2605 }, { _id: { table: 'demo@taxi_trips', view: 'session' }, count: 1905, distinct: undefined, weighted_count: 1905 }, { _id: { table: 'demo@queries', view: 'session' }, count: 1817, distinct: undefined, weighted_count: 1817 }, { _id: { table: 'demo@nginx', view: 'session' }, count: 1745, distinct: undefined, weighted_count: 1745 }, { _id: { table: 'demo@taxi_trips', view: 'samples' }, count: 981, distinct: undefined, weighted_count: 981 }, { _id: { table: 'demo@nginx', view: 'overview' }, count: 934, distinct: undefined, weighted_count: 934 }, { _id: { table: 'demo@taxi_trips', view: 'overview' }, count: 933, distinct: undefined, weighted_count: 933 }, { _id: { table: 'demo@nginx', view: 'samples' }, count: 918, distinct: undefined, weighted_count: 918 }, { _id: { table: 'demo@queries', view: 'samples' }, count: 913, distinct: undefined, weighted_count: 913 }, { _id: { table: 'demo@queries', view: 'overview' }, count: 844, distinct: undefined, weighted_count: 844 } ]