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 | Type | Purpose |
|---|---|---|
core |
text |
Name of the search index ( |
date |
timestamp |
Midnight on the mm/dd/yyyy the slow sub-query started. |
|
inet |
Distributed query coordinator IP address. |
|
timeuuid |
ID of distributed query to which the slow sub-query belongs. |
|
inet |
Node IP address. |
|
timestamp |
Timestamp at the start of the slow sub-query. |
parameters |
maptext, text |
Solr query parameters. |
|
bigint |
How long the slow sub-query took. |
|
maptext, bigint |
Map of (component name -> time spent in prepare phase). |
|
maptext, bigint |
Map of (component name -> time spent in process phase). |
|
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;