I am using Couchbase 6 community edition and my bucket has about 2 million documents of small sizes (< 5000 bytes)
Each document has a fields named country and I have an GSI on this field.
There are four unique values for this field, however, a query to get these unique values takes 8 to 10 seconds.
I am not sure why it is this slow.
my query is:
SELECT DISTINCT(country) FROM test_bucket USE INDEX(country_index USING GSI) WHERE country IS NOT MISSING
The memory quota on this bucket is 50 GB.
and the machine has 40 cores.
I would like to ask what is the bottleneck here or what would cause a bottleneck in this situation