Search request handler statistics

Records core-specific search request handler statistics over time.

Record core-specific search request handler statistics over time.

JMX analog

solr/core/search

Schema

CREATE TABLE dse_perf.solr_search_request_handler_metrics (
  node_ip inet,
  core text,
  date timestamp,
  handler_name text,
  time timestamp,
  requests bigint,
  errors bigint,
  timeouts bigint,
  total_time_seconds double,
  avg_requests_per_second double,
  five_min_rate_reqs_per_second double,
  fifteen_min_rate_reqs_per_second double,
  PRIMARY KEY ((node_ip, core, date), handler_name, time)
)
WITH CLUSTERING ORDER BY (handler_name ASC, time DESC)
AND gc_grace_seconds=0
FieldTypePurpose
node_ipinetNode IP address.
coretextSearch core name, such as keyspace.table.
datetimestampMidnight on the mm/dd/yyyy the statistics were recorded.
handler_nametextA handler name specified in the search index config.
timetimestampExact time the statistics were recorded.
requestsbigintNumber of requests processed by the handler.
errorsbigintNumber of errors encountered by the handler.
timeoutsbigintNumber of responses received with partial results.
total_time_secondsdoubleThe sum of all request processing times.
avg_requests_per_seconddoubleAverage number of requests per second.
five_min_rate_reqs_per_seconddoubleRequests per second over that past 5 minutes.
fifteen_min_rate_reqs_per_seconddoubleRequests per second over that past 15 minutes.

Snapshots recorded for all update handlers on 10/17/2014 for core keyspace.table on the node 127.0.0.1:

SELECT * 
FROM solr_search_request_handler_metrics 
WHERE node_ip = '127.0.0.1' AND core = 'keyspace.table' AND date = '2014-10-17';

Most recent 5 snapshots for handler “/update/json” recorded on 10/17/2014 for core keyspace.table on the node 127.0.0.1:

SELECT *  
FROM solr_search_request_handler_metrics
WHERE node_ip = '127.0.0.1' AND 
    core = 'keyspace.table' 
    AND date = '2014-10-17' 
    AND handler_name = '/update/json'
LIMIT 5;