[OAK-6187] Index usage analysis (which index was used when and how)

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: query
• Assignee: Unassigned
• Reporter: Thomas Mueller
• Created: 09/May/17 08:36
• Updated: 26/May/21 14:52

Description

In order to reduce space usage, unused indexes should be removed or trimmed. Trimmed, because an index definition might contain "too much" (specially Lucene indexes, which index multiple properties and can be very large).

One solution is to

• log each query (avoiding duplicates),
• include which indexes were used,
• from that generate the minimum index definitions,
• compared with existing indexes, get the list of unused indexes and index features since day X.

Issue Links

• is related to: OAK-6807 Query Recorder
• relates to: OAK-4934 Query shapes for JCR Query