Index statistics 

Records core-specific index overview statistics over time.

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 Solr 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;