Raising this to track CBSE-5276
[GSI] Document a new stat available for knowing last scan time of an index
Closing this as this is already tested in Mad-hatter and tests are automated as well.
Build couchbase-server-6.5.0-2184 contains indexing commit dff08c1 with commit message:
MB-29735: Introduce stats persistence and add stat for last query timestamp
We will need below stats to begin with
1. avg queries per second per index in the last 'N' mins/secs
2. last queried timestamp per index
In addition, it will be useful to persist some of these stats.
This will be part of Index Advisor feature for Mad-Hatter
This is a really interesting idea. It might be very helpful to the users to be able to see which of their indexes are used a lot, and which aren't used at all.