I wonder if there is ways to fetch details of indexes such as
- the data that is kept in the index
- the size of the index
- fragmentation (I understand that implementation of index might vary from RDBMS, but I suspect this is very much a relevant question)
I am aware of system:indexes but the return result is quite limiting
@wai.kwang.mak, lot of these details are displayed on the UI console for every index as mini graphs e.g the data/disk size of the index, fragmentation, items count etc.
Please see if that’s sufficient for your needs.
It certainly addresses much of my needs, but I wonder if I can actually view the data in the indexes.
Thank you @deepkaran.salooja
We have a utility to view index data. But its not supported for production and can change anytime.
Its located under /opt/couchbase/install/bin
./cbindex -type=scanAll -bucket <bucket_name> -index <index_name> -server <IP:8091> -auth <user:password>
@deepkaran.salooja Sadly I received error, updateIndexerList CBAuth database is stale. In the meantime, I also need to upgrade couchbase to 4.6. Let’s see if this fixes the problem.
But the cbindex tool is not able to show size information etc.? I suspected
./cbindex -type stats -auth admin:'***' -index index_name -bucket bucket_name
would show at least some information of interest but I got
Error occured queryport.notImplemented
So the web interface is the only place where I can find information about index size at the moment?
try this to get the data that is kept in the index
./cbindex -type count -auth admin:'***' -index index_name -bucket bucket_name
and the size of index for snapshot is under