I have a database with a plethora of inherited indices.
Is there a systematic way to tell whether an index is getting used, other than replaying “EXPLAIN” statements and using a process of elimination?
I understand how to tell, on any given query, the set of indices used. I’m hoping that there is a more systematic answer – e.g. given all queries executed by this server since some point in time, how often is a specific index used.