Monasca

  1. Bug #1658794
  2. Comment #2

Comment 2 for bug 1658794

Revision history for this message
Ryan Bak (ryanmbak) wrote :

Good point. Yes this is java and vertica.

I'm including both statistics and measurements below. I've narrowed the time range to make it more manageable. The statistics query (second) has period=30 seconds so I would expect that to be roughly the same as a measurements list.

monasca measurement-list rabbitmq.node.mem_used --merge 2017-01-23T19:00:00.000Z --endtime 2017-01-23T20:00:00.000Z --group_by node

{"links":[{"rel":"self","href":"https://bfd-api.os.cloud.twc.net:8070/v2.0/metrics/measurements?group_by=node&start_time=2017-01-23T19%3A00%3A00.000Z&merge_metrics=True&name=rabbitmq.node.mem_used&end_time=2017-01-23T20%3A00%3A00.000Z"}],"elements":[{"id":"rabbit@bfd02-control-001","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-control-001"},"columns":["timestamp","value","value_meta"],"measurements":[["2017-01-23T19:59:36.319Z",5.5726476E8,{}]]},{"id":"rabbit@bfd02-control-002","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-control-002"},"columns":["timestamp","value","value_meta"],"measurements":[["2017-01-23T19:59:36.319Z",1.277690352E9,{}]]},{"id":"rabbit@bfd02-control-003","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-control-003"},"columns":["timestamp","value","value_meta"],"measurements":[["2017-01-23T19:59:36.319Z",1.19411384E9,{}]]},{"id":"rabbit@bfd02-trove-001","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-trove-001"},"columns":["timestamp","value","value_meta"],"measurements":[["2017-01-23T19:59:36.398Z",9.061176E7,{}]]},{"id":"rabbit@bfd02-trove-002","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-trove-002"},"columns":["timestamp","value","value_meta"],"measurements":[["2017-01-23T19:59:36.398Z",8.7207944E7,{}]]},{"id":"rabbit@bfd02-trove-003","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-trove-003"},"columns":["timestamp","value","value_meta"],"measurements":[["2017-01-23T19:59:36.398Z",9.7235056E7,{}]]}]}

monasca metric-statistics rabbitmq.node.mem_used --merge AVG 2017-01-23T19:00:00.000Z --endtime 2017-01-23T19:10:00.000Z --group_by node --period 30

{"links":[{"rel":"self","href":"https://bfd-api.os.cloud.twc.net:8070/v2.0/metrics/statistics?merge_metrics=True&name=rabbitmq.node.mem_used&start_time=2017-01-23T19%3A00%3A00.000Z&period=30&group_by=node&end_time=2017-01-23T19%3A10%3A00.000Z&statistics=AVG"}],"elements":[{"id":"rabbit@bfd02-control-001","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-control-001"},"columns":["timestamp","value","value_meta"],"statistics":[["2017-01-23T19:00:00.000Z",5.54403944E8],["2017-01-23T19:00:30.000Z",5.478292E8],["2017-01-23T19:01:00.000Z",5.53139536E8],["2017-01-23T19:01:30.000Z",5.50919512E8],["2017-01-23T19:02:00.000Z",5.524032E8],["2017-01-23T19:02:30.000Z",5.49284856E8],["2017-01-23T19:03:00.000Z",5.55144408E8],["2017-01-23T19:03:30.000Z",5.50048784E8],["2017-01-23T19:04:00.000Z",5.5593384E8],["2017-01-23T19:04:30.000Z",5.50711552E8],["2017-01-23T19:05:00.000Z",5.5611228E8],["2017-01-23T19:05:30.000Z",5.5303204E8],["2017-01-23T19:06:00.000Z",5.5768724E8],["2017-01-23T19:06:30.000Z",5.54984576E8],["2017-01-23T19:07:00.000Z",5.55675576E8],["2017-01-23T19:07:30.000Z",5.50440176E8],["2017-01-23T19:08:00.000Z",5.55648296E8],["2017-01-23T19:08:30.000Z",5.50443008E8],["2017-01-23T19:09:00.000Z",5.54029744E8],["2017-01-23T19:09:30.000Z",5.51641312E8]]},{"id":"rabbit@bfd02-control-002","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-control-002"},"columns":["timestamp","value","value_meta"],"statistics":[["2017-01-23T19:00:00.000Z",1.246227792E9],["2017-01-23T19:00:30.000Z",1.263314752E9],["2017-01-23T19:01:00.000Z",1.249792512E9],["2017-01-23T19:01:30.000Z",1.27022004E9],["2017-01-23T19:02:00.000Z",1.266851048E9],["2017-01-23T19:02:30.000Z",1.2863186E9],["2017-01-23T19:03:00.000Z",1.266827984E9],["2017-01-23T19:03:30.000Z",1.267092488E9],["2017-01-23T19:04:00.000Z",1.260864544E9],["2017-01-23T19:04:30.000Z",1.265501008E9],["2017-01-23T19:05:00.000Z",1.274816256E9],["2017-01-23T19:05:30.000Z",1.262580736E9],["2017-01-23T19:06:00.000Z",1.263080208E9],["2017-01-23T19:06:30.000Z",1.283849056E9],["2017-01-23T19:07:00.000Z",1.28944364E9],["2017-01-23T19:07:30.000Z",1.274607032E9],["2017-01-23T19:08:00.000Z",1.260193056E9],["2017-01-23T19:08:30.000Z",1.32004752E9],["2017-01-23T19:09:00.000Z",1.290572568E9],["2017-01-23T19:09:30.000Z",1.269450144E9]]},{"id":"rabbit@bfd02-control-003","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-control-003"},"columns":["timestamp","value","value_meta"],"statistics":[["2017-01-23T19:00:00.000Z",1.188237624E9],["2017-01-23T19:00:30.000Z",1.184311712E9],["2017-01-23T19:01:00.000Z",1.19095488E9],["2017-01-23T19:01:30.000Z",1.190453112E9],["2017-01-23T19:02:00.000Z",1.189212904E9],["2017-01-23T19:02:30.000Z",1.184860312E9],["2017-01-23T19:03:00.000Z",1.214498432E9],["2017-01-23T19:03:30.000Z",1.186924352E9],["2017-01-23T19:04:00.000Z",1.192828832E9],["2017-01-23T19:04:30.000Z",1.190472768E9],["2017-01-23T19:05:00.000Z",1.198024624E9],["2017-01-23T19:05:30.000Z",1.185425392E9],["2017-01-23T19:06:00.000Z",1.190307744E9],["2017-01-23T19:06:30.000Z",1.189834664E9],["2017-01-23T19:07:00.000Z",1.198545152E9],["2017-01-23T19:07:30.000Z",1.1846172E9],["2017-01-23T19:08:00.000Z",1.198665576E9],["2017-01-23T19:08:30.000Z",1.186011872E9],["2017-01-23T19:09:00.000Z",1.19075628E9],["2017-01-23T19:09:30.000Z",1.18985856E9]]},{"id":"rabbit@bfd02-trove-001","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-trove-001"},"columns":["timestamp","value","value_meta"],"statistics":[["2017-01-23T19:00:00.000Z",9.2352256E7],["2017-01-23T19:00:30.000Z",9.3163472E7],["2017-01-23T19:01:00.000Z",9.3458648E7],["2017-01-23T19:01:30.000Z",9.3948664E7],["2017-01-23T19:02:00.000Z",9.2292872E7],["2017-01-23T19:02:30.000Z",9.2781616E7],["2017-01-23T19:03:00.000Z",9.2368016E7],["2017-01-23T19:03:30.000Z",9.3068104E7],["2017-01-23T19:04:00.000Z",9.2469504E7],["2017-01-23T19:04:30.000Z",9.2855488E7],["2017-01-23T19:05:00.000Z",9.238228E7],["2017-01-23T19:05:30.000Z",9.2894464E7],["2017-01-23T19:06:00.000Z",9.25864E7],["2017-01-23T19:06:30.000Z",9.2846424E7],["2017-01-23T19:07:00.000Z",9.2416616E7],["2017-01-23T19:07:30.000Z",9.2899176E7],["2017-01-23T19:08:00.000Z",9.2504896E7],["2017-01-23T19:08:30.000Z",9.2973488E7],["2017-01-23T19:09:00.000Z",9.2521896E7],["2017-01-23T19:09:30.000Z",9.3075912E7]]},{"id":"rabbit@bfd02-trove-002","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-trove-002"},"columns":["timestamp","value","value_meta"],"statistics":[["2017-01-23T19:00:00.000Z",8.9346264E7],["2017-01-23T19:00:30.000Z",8.9620152E7],["2017-01-23T19:01:00.000Z",8.9284376E7],["2017-01-23T19:01:30.000Z",8.9643592E7],["2017-01-23T19:02:00.000Z",8.942896E7],["2017-01-23T19:02:30.000Z",9.182384E7],["2017-01-23T19:03:00.000Z",9.1467616E7],["2017-01-23T19:03:30.000Z",9.0796408E7],["2017-01-23T19:04:00.000Z",9.0492632E7],["2017-01-23T19:04:30.000Z",9.068612E7],["2017-01-23T19:05:00.000Z",9.045124E7],["2017-01-23T19:05:30.000Z",9.0865328E7],["2017-01-23T19:06:00.000Z",9.0414456E7],["2017-01-23T19:06:30.000Z",9.187232E7],["2017-01-23T19:07:00.000Z",9.1483304E7],["2017-01-23T19:07:30.000Z",9.0754E7],["2017-01-23T19:08:00.000Z",9.0490088E7],["2017-01-23T19:08:30.000Z",9.0747E7],["2017-01-23T19:09:00.000Z",9.0687792E7],["2017-01-23T19:09:30.000Z",9.201056E7]]},{"id":"rabbit@bfd02-trove-003","name":"rabbitmq.node.mem_used","dimensions":{"node":"rabbit@bfd02-trove-003"},"columns":["timestamp","value","value_meta"],"statistics":[["2017-01-23T19:00:00.000Z",9.8420504E7],["2017-01-23T19:00:30.000Z",9.8936944E7],["2017-01-23T19:01:00.000Z",9.9519864E7],["2017-01-23T19:01:30.000Z",1.00679968E8],["2017-01-23T19:02:00.000Z",9.9210184E7],["2017-01-23T19:02:30.000Z",1.01850984E8],["2017-01-23T19:03:00.000Z",1.006574E8],["2017-01-23T19:03:30.000Z",1.01078736E8],["2017-01-23T19:04:00.000Z",9.967748E7],["2017-01-23T19:04:30.000Z",1.0006368E8],["2017-01-23T19:05:00.000Z",9.9463072E7],["2017-01-23T19:05:30.000Z",9.9974896E7],["2017-01-23T19:06:00.000Z",9.9570576E7],["2017-01-23T19:06:30.000Z",1.0022364E8],["2017-01-23T19:07:00.000Z",1.0026752E8],["2017-01-23T19:07:30.000Z",1.0116848E8],["2017-01-23T19:08:00.000Z",9.9617416E7],["2017-01-23T19:08:30.000Z",1.0008452E8],["2017-01-23T19:09:00.000Z",9.9555008E7],["2017-01-23T19:09:30.000Z",1.00221248E8]]}]}