Index statistics
Record core-specific index overview statistics over time.
JMX analog
solr/<core_name>/core/<core_name> & solr/<core_name>/Searcher*Schema
CREATE TABLE dse_perf.solr_index_stats ( node_ip inet, core text, date timestamp, time timestamp, size_in_bytes bigint, num_docs int, max_doc int, docs_pending_deletion int, PRIMARY KEY ((node_ip, core, date), time) ) WITH gc_grace_seconds=0
| Field | Type | Purpose |
|---|---|---|
node_ip |
inet |
Node IP address. |
core |
text |
Search core name, such as keyspace.table. |
date |
text |
Midnight on the mm/dd/yyyy the statistics were recorded. |
time |
bigint |
The exact time the statistics were recorded. |
size_in_bytes |
bigint |
Index size on file system. |
num_docs |
int |
The number of documents inserted into index. |
max_docs |
int |
The number of documents inserted into index, plus those marked as removed, but not yet physically removed. |
docs_pending_deletion |
int |
max_docs - num_docs |
Snapshots recorded on 10/17/2014 for core keyspace.table on the node 127.0.0.1:
SELECT * FROM solr_index_stats WHERE node_ip = '127.0.0.1' AND core = 'keyspace.table' AND date = '2014-10-17';
Most recent 5 snapshots recorded on 10/17/2014 for core keyspace.table on the node 127.0.0.1:
SELECT *
FROM solr_index_stats
WHERE node_ip = '127.0.0.1'
AND core = 'keyspace.table'
AND date = '2014-10-17'
ORDER BY time DESC
LIMIT 5;
