Get indexes usage for a specific time and some sample queries (run in the past) using the indexes

Hi, is there a way to see statistics on how many times an index have been used in the last X days?

After a few years of usage, a cluster can end up with indexes which are not used anymore, or not very often, and as these indexes can consume a lot of memory, would be great to be able to see how much they are used, ideal also to see some samples of queries using the indexes.

Is it possible to get some usage statistics for a period with some N1QL sorcery?

@vsr1 any thoughts on this?

Thank you

You can query index stats and find out when is given index last time used last_known_scan_time

https://docs.couchbase.com/server/current/rest-api/rest-index-stats.html#example-http-request

1 Like