The Indexes screen in the Couchbase Web Console enables you to see statistics for a specific primary index or global secondary index. It also enables you to see resource usage for the index service across all nodes.
To display statistics for a specific index:
Click the Indexes link in the navigation bar to display the Indexes screen.
Click an index row in the list of indexes to expand the index row.
Click the Index Stats heading in the expanded index row.
A graphical display of statistics for the index is shown.
The following statistics all apply to the selected index only.
- Index Mutations Remaining
The number of documents pending to be indexed.
- Index Drain Rate
The average number of items flushed from memory to disk storage per second.
- Index Resident Percent
The percentage of the data held in memory.
- Index RAM Used
The total memory consumed by the index.
- Indexed Items
The number of items currently indexed.
- Index Data Size
The size of indexable data that is maintained for the index.
- Index Disk Size
The total disk file size consumed by the index.
- Index Item Size
The average size of each index item.
- Index Scan Latency
The average time to serve a scan request.
- Index Request Rate
The number of requests served by the indexer per second.
- Index Scan Items
The number of index items scanned by the indexer per second.
- Index Scan Bytes
The number of bytes read by a scan per second.
- Index Fragmentation
The percentage fragmentation of the index. This indicates the percentage of disk space consumed by the index, but not utilized for items stored in the index. Note that at small index sizes of less than a hundred KBb, the static overhead of the index disk file will inflate the index fragmentation percentage.
- Index Cache Miss Ratio
The percentage of accesses made to this index from disk, rather than from RAM.
|The statistics for a specific index are also available from the Index Stats section in the Statistics screen.|
The footer of the Indexes screen displays general statistics for the index service. These show resource usage for the index service across all nodes.
The footer is always displayed — it does not scroll out of view.
The first three statistics (in the left column) apply to the index service as a whole. The other statistics (in the middle and right columns) apply to a single bucket. The selected bucket is displayed at the top right of the footer.
- Index Service RAM Quota
The buffer cache size for the index service across all nodes.
- RAM Used/Remaining
The amount of memory used by the index service, and the remaining amount of memory available to the index service.
- Index Service RAM Percent
The amount of memory used by the index service, as a percentage of the amount of memory available to the index service.
- Total Scan Rate
The number of index items scanned by the index service per second for the selected bucket.
- Indexes Fragmentation
The percentage fragmentation of all indexes for the selected bucket. This indicates the percentage of disk space consumed by the indexes, but not utilized for items stored in the indexes.
- Indexes Data Size
The actual data size consumed by all indexes for the selected bucket.
- Indexes Disk Size
The total disk file size consumed by all indexes for the selected bucket.
To display index service statistics for a different bucket:
Open the drop-down list to the right of the index service statistics.
[Optional] To filter the list of buckets, type a filter term in the text box.
Only buckets whose name contains the filter term are listed.
Select the required bucket from the list.
You can monitor some index service statistics using the CLI. Refer to server-info.
Note that there is no CLI support for statistics for a specific index.
You can monitor all index service statistics, and statistics for a specific index, using the REST API. Refer to Index Statistics API.