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