RUNNING QUERY { "view": "table", "opts": { "dims": [ "table" ], "view": "table", "baseview": "table", "custom_fields": [ "avg(query_duration)", "sum(query_duration)", "p50(query_duration)" ], "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": [ "table" ], "view": "table", "baseview": "table", "custom_fields": [ "avg(query_duration)", "sum(query_duration)", "p50(query_duration)" ], "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 [ { _id: { table: 'demo@taxi_trips' }, 'avg(query_duration)': 252.1980444785276, 'sum(query_duration)': 2630930, 'p50(query_duration)': 228, count: 10432, distinct: undefined, weighted_count: 10432 }, { _id: { table: 'demo@queries' }, 'avg(query_duration)': 250.54976013065223, 'sum(query_duration)': 2454636, 'p50(query_duration)': 228, count: 9797, distinct: undefined, weighted_count: 9797 }, { _id: { table: 'demo@nginx' }, 'avg(query_duration)': 450.3164283509927, 'sum(query_duration)': 4377526, 'p50(query_duration)': 410, count: 9721, distinct: undefined, weighted_count: 9721 } ]