List queries used by index

SQL++
1

Hi there,

I’m wondering, is there a way to know the last queries used by indexes created for N1QL ? I’d like to optimize my indexes, and delete some. I know i can trace the long queries, or show the query plan for a query, but I don’t know if I can know which queries are used by a specific index.

Thanks a lot
Jérémie

2

you can query index stats. it tells when last_known_scan_time.
It doesn’t have info which all queries used the index.

https://docs.couchbase.com/server/current/rest-api/rest-index-stats.html