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

When slow 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 purpose
Field Type Purpose

core

text

Name of the search index (keyspace_name.table_name) 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

maptext, text

Solr query parameters.

elapsed_millis

bigint

How long the slow sub-query took.

component_prepare_millis

maptext, bigint

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

component_process_millis

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

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