Finding unused indexes

index

#1

Hi. I am new to couchbase. is there a way to find indexes that haven’t been used in X number days?

thanks


#2

There is no easy way to find this. Only way is run EXPLAIN on each query and see which indexes are used, cc @deepkaran.salooja


#3

Thank you. Thats to bad that the information isn’t stored as meta data and easy to retrieve.


#4

@keith.j.dale, you can look up the stat “Requests/Sec” for the index on the UI mini-graphs. Once you select the graph, you can change the time duration to a week or a month etc and that would show you if a particular index got any requests or not for that duration.


#5

excellent. thank you.