Hello, I have built a dashboard for checking completed queries using the admin/completed_queries REST API. The reason for not using the N1QL query dashboard is because we are using Couchbase 5.1.1. Community Edition so we don’t have the query monitoring dashboard yet, and also we would like to keep the data in our monitoring stack so we can do some analysis for specific time periods.
To get all queries, I used a http poller that polls the REST API every minute and filter those than happened in the past 1 minute. I have set completed-threshold to be 0 and completed-limit to be 4000 on admin/settings API
However, I noticed we are not getting all queries. I have set up a load testing tool that makes n1ql queries with 10qps. In 1 minutes, it should make about 600 queries, but in the rest admin endpoint, I only get 20 queries per minute consistently. In the Couchbase UI, I can clearly see it making 10 queries per second corresponding to my load testing tool. So why are the queries missing from the admin endpoint?
In my scenario, I am making only a simple "select * from
test-bucket". The index for this bucket is only on 1 node in a 30 node cluster. And I am reading the results from that node’s admin/rest endpoint