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;

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com