2018-03-21 05:12:39 |
Parth Sarupria |
bug |
|
|
added bug |
2018-03-21 05:12:49 |
Parth Sarupria |
information type |
Proprietary |
Public |
|
2018-03-21 05:14:49 |
Prashanth Nageshappa |
description |
In a setup with UVE pushed for 5 days, we have observed that when the query is made for last 7 days ("start_time": "now-7d"), we see time take around 5 secs (returning around 208 samples).
When we do for last 31 days ("start_time": "now-31d"), we see time take around 25 secs (returning same 208 samples).
Query used:
{"select_fields": ["app_metrics_diff_link_1d.value.session_duration", "app_metrics_diff_link_1d.value.session_count", "app_metrics_diff_link_1d.value.total_bytes", "app_metrics_diff_link_1d.value.input_bytes", "app_metrics_diff_link_1d.value.output_bytes", "app_metrics_diff_link_1d.value.sla_violation_duration", "app_metrics_diff_link_1d.value.sla_violation_count", "app_metrics_diff_link_1d.value.session_switch_count", "app_metrics_diff_link_1d.value.jitter_violation_count", "app_metrics_diff_link_1d.value.rtt_violation_count", "app_metrics_diff_link_1d.value.pkt_loss_violation_count", "app_metrics_diff_link_1d.__key", "T", "name"], "start_time": "now-7d", "where": [[{"name": "name", "value": "", "op": 7}]], "end_time": "now", "table": "StatTable.SDWANMetricsRecord.app_metrics_diff_link_1d.value"} |
Contrail analytics api query response time increase when the duration is increased, even though the number of samples returned is the same.
In a setup with UVE pushed for 5 days, we have observed that when the query is made for last 7 days ("start_time": "now-7d"), we see time take around 5 secs (returning around 208 samples).
When we do for last 31 days ("start_time": "now-31d"), we see time take around 25 secs (returning same 208 samples).
Query used:
{"select_fields": ["app_metrics_diff_link_1d.value.session_duration", "app_metrics_diff_link_1d.value.session_count", "app_metrics_diff_link_1d.value.total_bytes", "app_metrics_diff_link_1d.value.input_bytes", "app_metrics_diff_link_1d.value.output_bytes", "app_metrics_diff_link_1d.value.sla_violation_duration", "app_metrics_diff_link_1d.value.sla_violation_count", "app_metrics_diff_link_1d.value.session_switch_count", "app_metrics_diff_link_1d.value.jitter_violation_count", "app_metrics_diff_link_1d.value.rtt_violation_count", "app_metrics_diff_link_1d.value.pkt_loss_violation_count", "app_metrics_diff_link_1d.__key", "T", "name"], "start_time": "now-7d", "where": [[{"name": "name", "value": "", "op": 7}]], "end_time": "now", "table": "StatTable.SDWANMetricsRecord.app_metrics_diff_link_1d.value"} |
|
2018-03-21 07:22:57 |
Jeba Paulaiyan |
nominated for series |
|
juniperopenstack/trunk |
|
2018-03-21 07:22:57 |
Jeba Paulaiyan |
bug task added |
|
juniperopenstack/trunk |
|
2018-03-21 07:23:24 |
Jeba Paulaiyan |
nominated for series |
|
juniperopenstack/r4.0 |
|
2018-03-21 07:23:24 |
Jeba Paulaiyan |
bug task added |
|
juniperopenstack/r4.0 |
|
2018-03-21 07:23:24 |
Jeba Paulaiyan |
nominated for series |
|
juniperopenstack/r3.2 |
|
2018-03-21 07:23:24 |
Jeba Paulaiyan |
bug task added |
|
juniperopenstack/r3.2 |
|
2018-03-21 07:23:24 |
Jeba Paulaiyan |
nominated for series |
|
juniperopenstack/r4.1 |
|
2018-03-21 07:23:24 |
Jeba Paulaiyan |
bug task added |
|
juniperopenstack/r4.1 |
|
2018-03-21 07:23:33 |
Jeba Paulaiyan |
juniperopenstack/r3.2: milestone |
|
r3.2.11.0 |
|
2018-03-21 07:23:51 |
Jeba Paulaiyan |
juniperopenstack/r4.0: milestone |
|
r4.0.4.0 |
|
2018-03-21 07:23:54 |
Jeba Paulaiyan |
juniperopenstack/r4.1: milestone |
|
r4.1.2.0 |
|
2018-03-21 07:23:57 |
Jeba Paulaiyan |
juniperopenstack/trunk: milestone |
|
r5.0.1 |
|
2018-03-21 07:24:04 |
Jeba Paulaiyan |
bug task deleted |
juniperopenstack/r4.1 |
|
|
2018-03-21 07:24:09 |
Jeba Paulaiyan |
bug task deleted |
juniperopenstack/r4.0 |
|
|
2018-03-21 07:24:13 |
Jeba Paulaiyan |
bug task deleted |
juniperopenstack/r3.2 |
|
|
2018-03-21 07:24:17 |
Jeba Paulaiyan |
juniperopenstack/trunk: status |
New |
Incomplete |
|
2018-03-21 07:24:20 |
Jeba Paulaiyan |
juniperopenstack/trunk: importance |
Undecided |
Medium |
|
2018-03-21 07:24:31 |
Jeba Paulaiyan |
juniperopenstack/trunk: assignee |
|
Parth Sarupria (psarupria) |
|
2018-03-21 22:16:11 |
Jeba Paulaiyan |
nominated for series |
|
juniperopenstack/r4.1 |
|
2018-03-21 22:16:11 |
Jeba Paulaiyan |
bug task added |
|
juniperopenstack/r4.1 |
|
2018-03-21 22:16:35 |
Jeba Paulaiyan |
juniperopenstack/trunk: status |
Incomplete |
New |
|
2018-03-21 22:16:40 |
Jeba Paulaiyan |
juniperopenstack/r4.1: importance |
Undecided |
Medium |
|
2018-03-21 22:16:54 |
Jeba Paulaiyan |
juniperopenstack/r4.1: assignee |
|
Sundaresan Rajangam (srajanga) |
|
2018-03-21 22:17:00 |
Jeba Paulaiyan |
juniperopenstack/trunk: assignee |
Parth Sarupria (psarupria) |
Sundaresan Rajangam (srajanga) |
|
2018-03-21 22:17:05 |
Jeba Paulaiyan |
juniperopenstack/r4.1: milestone |
|
r4.1.2.0 |
|
2018-03-21 22:18:14 |
Jeba Paulaiyan |
nominated for series |
|
juniperopenstack/r4.0 |
|
2018-03-21 22:18:14 |
Jeba Paulaiyan |
bug task added |
|
juniperopenstack/r4.0 |
|
2018-03-21 22:18:18 |
Jeba Paulaiyan |
juniperopenstack/r4.0: importance |
Undecided |
Medium |
|
2018-03-21 22:18:30 |
Jeba Paulaiyan |
juniperopenstack/r4.0: assignee |
|
Sundaresan Rajangam (srajanga) |
|
2018-03-21 22:18:39 |
Jeba Paulaiyan |
juniperopenstack/r4.0: milestone |
|
r4.0.4.0 |
|
2018-03-22 00:56:38 |
Sundaresan Rajangam |
juniperopenstack/r4.0: status |
New |
Incomplete |
|
2018-03-22 00:56:39 |
Sundaresan Rajangam |
juniperopenstack/r4.1: status |
New |
Incomplete |
|
2018-03-22 00:56:41 |
Sundaresan Rajangam |
juniperopenstack/trunk: status |
New |
Incomplete |
|
2018-03-22 00:56:52 |
Sundaresan Rajangam |
juniperopenstack/r4.0: assignee |
Sundaresan Rajangam (srajanga) |
Parth Sarupria (psarupria) |
|
2018-03-22 00:57:00 |
Sundaresan Rajangam |
juniperopenstack/r4.1: assignee |
Sundaresan Rajangam (srajanga) |
Parth Sarupria (psarupria) |
|
2018-03-22 00:57:07 |
Sundaresan Rajangam |
juniperopenstack/trunk: assignee |
Sundaresan Rajangam (srajanga) |
Parth Sarupria (psarupria) |
|
2018-03-22 04:33:20 |
Parth Sarupria |
bug |
|
|
added subscriber Prashanth Nageshappa |
2018-03-22 22:42:24 |
Sundaresan Rajangam |
juniperopenstack/r4.0: status |
Incomplete |
Invalid |
|
2018-03-22 22:42:26 |
Sundaresan Rajangam |
juniperopenstack/r4.1: status |
Incomplete |
Invalid |
|
2018-03-22 22:42:28 |
Sundaresan Rajangam |
juniperopenstack/trunk: status |
Incomplete |
Invalid |
|