The outcome of this spike has has been the decision to split metrics data into new postgres tables to improve querying and utilizing the different keys in the metrics payload ("data.app", "data.device", "data.security", and future ones) as the 'event type' for each metrics record.

See the linked PR and https://groups.google.com/forum/#!topic/aerogear/QZn65_qglSU for more information.

A follow up issue will be created to capture remaining work on this split.