Sign in
DiagnosisService

GetSlowQueryDetail retrieves the details of a specific slow query

Changed on
get/api/v2/clusters/{clusterId}/slowqueries/{digest}

Request

  • The document declares no server URL.
  • Auth: none declared

Path parameters

clusterIdstring required

Cluster ID

digeststring required

Query digest

Query parameters

timestampnumber double required

Timestamp

connectionIdstring required

Connection ID

Response

A successful response.

digeststring
querystring
instancestring
dbstring
connection_idstring
successinteger
timestampnumber double
query_timenumber double
parse_timenumber double
compile_timenumber double
rewrite_timenumber double
preproc_subqueries_timenumber double
optimize_timenumber double
wait_tsnumber double
cop_timenumber double
lock_keys_timenumber double
write_sql_response_totalnumber double
exec_retry_timenumber double
memory_maxnumber double
disk_maxnumber double
txn_start_tsstring
prev_stmtstring
planstring
binary_planstring
warningsstring
is_internalinteger
index_namesstring
statsstring
backoff_typesstring
preparedinteger
plan_from_cacheinteger
plan_from_bindinginteger
userstring
hoststring
process_timenumber double
wait_timenumber double
backoff_timenumber double
get_commit_ts_timenumber double
local_latch_wait_timenumber double
resolve_lock_timenumber double
prewrite_timenumber double
wait_prewrite_binlog_timenumber double
commit_timenumber double
commit_backoff_timenumber double
cop_proc_avgnumber double
cop_proc_p90number double
cop_proc_maxnumber double
cop_wait_avgnumber double
cop_wait_p90number double
cop_wait_maxnumber double
write_keysnumber double
write_sizenumber double
prewrite_regionnumber double
txn_retrynumber double
request_countnumber double
process_keysnumber double
total_keysnumber double
cop_proc_addrstring
cop_wait_addrstring
rocksdb_delete_skipped_countnumber double
rocksdb_key_skipped_countnumber double
rocksdb_block_cache_hit_countnumber double
rocksdb_block_read_countnumber double
rocksdb_block_read_bytenumber double
binary_plan_textstring
session_aliasstring
exec_retry_countnumber double
preproc_subqueriesnumber double
kv_totalnumber double
pd_totalnumber double
backoff_totalnumber double
time_queued_by_rcnumber double
tidb_cpu_timenumber double
tikv_cpu_timenumber double
backoff_detailstring
is_explicit_txninteger
plan_digeststring
has_more_resultsinteger
resource_groupstring
request_unit_readnumber double
request_unit_writenumber double
result_rowsnumber double
runumber double

Changes

  • fe37b3417b93Revision changes
    • ▲

      added the new required query request parameter connectionId

    • ●

      deleted the query request parameter connectId

    • ○

      api operation id ClusterService_GetSlowQueryDetail removed and replaced with DiagnosisService_GetSlowQueryDetail

    • ○

      api tag DiagnosisService added

    • ○

      api tag ClusterService removed

  • 63a3930c44aeRevision changes
    • ○

      endpoint added