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 purpose
Field	Type	Purpose
`node_ip`	inet	Node IP address.
core	text	Search index name, such as `keyspace_name.table_name`.
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;

Index statistics

JMX analog

Schema

Was this helpful?

Give Feedback