Slow sub-query log for search

Report distributed sub-queries for search (query executions on individual shards) that take longer than a specified period of time.

JMX analog

None.

Schema

Whenslow query logging is enabled, this table is created automatically.

CREATE TABLE IF NOT EXISTS dse_perf.solr_slow_sub_query_log (
  core text,
  date timestamp,
  coordinator_ip inet,
  query_id timeuuid,
  node_ip inet,
  start_time timeuuid,
  parameters map <text>, <text>,
  elapsed_millis bigint,
  component_prepare_millis map<<text>, <bigint>>,
  component_process_millis map<<text>, <bigint>>,
  num_docs_found bigint,
  PRIMARY KEY ((core, date), coordinator_ip, query_id, node_ip)
)

Field	Type	Purpose
core	text	Name of the search core (keyspace.table) where the slow sub-query was executed.
date	timestamp	Midnight on the mm/dd/yyyy the slow sub-query started.
coordinator_ip	inet	Distributed query coordinator IP address.
query_id	timeuuid	ID of distributed query to which the slow sub-query belongs.
node_ip	inet	Node IP address.
start_time	timestamp	Timestamp at the start of the slow sub-query.
parameters	map<text>, <text>	Solr query parameters.
elapsed_millis	bigint	How long the slow sub-query took.
component_prepare_millis	map<text>, <bigint>	Map of (component name -> time spent in prepare phase).
component_process_millis	map<text>, <bigint>	Map of (component name -> time spent in process phase).
num_docs_found	bigint	Number of documents found by the slow sub-query.

Field

Type

Purpose

core

text

Name of the search core (keyspace.table) where the slow sub-query was executed.

date

timestamp

Midnight on the mm/dd/yyyy the slow sub-query started.

coordinator_ip

inet

Distributed query coordinator IP address.

query_id

timeuuid

ID of distributed query to which the slow sub-query belongs.

node_ip

inet

Node IP address.

start_time

timestamp

Timestamp at the start of the slow sub-query.

parameters

map<text>, <text>

Solr query parameters.

elapsed_millis

bigint

How long the slow sub-query took.

component_prepare_millis

map<text>, <bigint>

Map of (component name -> time spent in prepare phase).

component_process_millis

map<text>, <bigint>

Map of (component name -> time spent in process phase).

num_docs_found

bigint

Number of documents found by the slow sub-query.

Slow Solr sub-queries recorded on 10/17/2015 for core keyspace.table for coordinator at 127.0.0.1:

SELECT *
FROM solr_slow_sub_query_log
WHERE core = 'keyspace.table' AND date = '2015-10-17' AND coordinator_ip = '127.0.0.1';

Slow Solr sub-queries recorded on 10/17/2015 for core keyspace.table for coordinator at 127.0.0.1 for a particular distributed query with an ID of 33e56d33-4e63-11e4-9ce5-335a04d08bd4 :

SELECT *
FROM solr_slow_sub_query_log
WHERE core = 'keyspace.table'
    AND date = '2015-10-17'
    AND coordinator_ip = '127.0.0.1'
    AND query_id = 33e56d33-4e63-11e4-9ce5-335a04d08bd4;

Related information

Collecting slow search queries

Slow sub-query log for search

JMX analog

Schema

Was this helpful?

Give Feedback