Query latency snapshot

Record phase-level cumulative percentile latency statistics for queries over time.

All statistics reset upon node restart.

This table is configured with gc_grace_seconds 0 to avoid issues with persistent tombstones as rows expire; tombstones are removed during compaction no matter how recently they were created.

JMX Analog

com.datastax.bdp/search/<core>/QueryMetrics

Schema

CREATE TABLE dse_perf.solr_query_latency_snapshot (
  node_ip inet,
  core text,
  date timestamp,
  time timestamp,
  phase text,
  count bigint,
  latency_percentiles_micros map<text>, <bigint>  PRIMARY KEY ((node_ip, core), phase, time)
)
WITH CLUSTERING ORDER BY (phase ASC, time DESC)
AND gc_grace_seconds=0
Field Type Purpose

node_ip

inet

Node IP address.

core

text

search core name, such as keyspace.table.

date

timestamp

Midnight on the mm/dd/yyyy the snapshot was recorded.

time

timestamp

Time the snapshot was recorded.

phase

text

EXECUTE, COORDINATE, RETRIEVE

count

bigint

Cumulative number of queries recorded.

latency_percentiles_micros

map<text>, <bigint>

Cumulative latency percentiles of query: 25%, 50%, 75%, 95%, 99% and 99.9%

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

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

Most recent 5 snapshots for the EXECUTE phase recorded on 10/17/2014 for core keyspace.table on the node 127.0.0.1:

SELECT *
FROM solr_query_latency_snapshot
WHERE node_ip = '127.0.0.1'
    AND core = 'keyspace.table'
    AND date = '2014-10-17'
    AND phase = 'EXECUTE'
LIMIT 5;

Related information

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