missing mongodb indexes in the metrics collection

[Junien F]

Hi,

The following mongodb requests could be optimized by adding indexes :

command juju.metrics command: count { count: "metrics", query: { sent: false, model-uuid: "<uuid>" } } planSummary: COLLSCAN keyUpdates:0 writeConflicts:0 numYields:960 reslen:62 locks:{ Global: { acquireCount: { r: 1922 } }, Database: { acquireCount: { r: 961 } }, Collection: { acquireCount: { r: 961 } } } protocol:op_query 105ms

command juju.metrics command: find { find: "metrics", filter: { model-uuid: "<uuid>", sent: false }, skip: 0, limit: 1000, batchSize: 1000 } planSummary: COLLSCAN keysExamined:0 docsExamined:122947 cursorExhausted:1 keyUpdates:0 writeConflicts:0 numYields:960 nreturned:0 reslen:118 locks:{ Global: { acquireCount: { r: 1922 } }, Database: { acquireCount: { r: 961 } }, Collection: { acquireCount: { r: 961 } } } protocol:op_query 101ms

Thanks

[Achilleas Anagnostopoulos (achilleasa)]

https://github.com/juju/juju/pull/10221 is a PR against the 2.6 branch for addressing this issue