Sign in
DiagnosisService

GetTopSqlDetail retrieves the details of a specific top sql

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

Request

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

Path parameters

clusterIdstring required

Cluster ID

digeststring required

Query digest

Query parameters

beginTimestring int64 required

Begin time

endTimestring int64 required

End time

planDigeststring[]

Plan digest list

Response

A successful response.

summary_begin_timenumber double
summary_end_timenumber double
digest_textstring
digeststring
exec_countnumber double
stmt_typestring
sum_errorsnumber double
sum_warningsnumber double
sum_latencynumber double
max_latencynumber double
min_latencynumber double
avg_latencynumber double
avg_parse_latencynumber double
max_parse_latencynumber double
avg_compile_latencynumber double
max_compile_latencynumber double
sum_cop_task_numnumber double
avg_cop_process_timenumber double
max_cop_process_timenumber double
avg_cop_wait_timenumber double
max_cop_wait_timenumber double
avg_process_timenumber double
max_process_timenumber double
avg_wait_timenumber double
max_wait_timenumber double
avg_backoff_timenumber double
max_backoff_timenumber double
avg_total_keysnumber double
max_total_keysnumber double
avg_processed_keysnumber double
max_processed_keysnumber double
avg_prewrite_timenumber double
max_prewrite_timenumber double
avg_commit_timenumber double
max_commit_timenumber double
avg_get_commit_ts_timenumber double
max_get_commit_ts_timenumber double
avg_commit_backoff_timenumber double
max_commit_backoff_timenumber double
avg_resolve_lock_timenumber double
max_resolve_lock_timenumber double
avg_local_latch_wait_timenumber double
max_local_latch_wait_timenumber double
avg_write_keysnumber double
max_write_keysnumber double
avg_write_sizenumber double
max_write_sizenumber double
avg_prewrite_regionsnumber double
max_prewrite_regionsnumber double
avg_txn_retrynumber double
max_txn_retrynumber double
sum_backoff_timesnumber double
avg_memnumber double
max_memnumber double
avg_disknumber double
max_disknumber double
avg_affected_rowsnumber double
first_seennumber double
last_seennumber double
sample_userstring
query_sample_textstring
prev_sample_textstring
schema_namestring
table_namesstring
index_namesstring
plan_countnumber double
planstring
binary_planstring
plan_digeststring
plan_hintstring
max_rocksdb_delete_skipped_countnumber double
avg_rocksdb_delete_skipped_countnumber double
max_rocksdb_key_skipped_countnumber double
avg_rocksdb_key_skipped_countnumber double
max_rocksdb_block_cache_hit_countnumber double
avg_rocksdb_block_cache_hit_countnumber double
max_rocksdb_block_read_countnumber double
avg_rocksdb_block_read_countnumber double
max_rocksdb_block_read_bytenumber double
avg_rocksdb_block_read_bytenumber double
related_schemasstring
plan_can_be_boundboolean
binary_plan_textstring
resource_groupstring
avg_runumber double
max_runumber double
sum_runumber double
avg_time_queued_by_rcnumber double
max_time_queued_by_rcnumber double
avg_tidb_cpu_timenumber double
avg_tikv_cpu_timenumber double

Changes

  • 29de18ce47c6Revision changes
    • ○

      added the new optional query request parameter planDigest

  • fe37b3417b93Revision changes
    • ○

      api operation id ClusterService_GetTopSqlDetail removed and replaced with DiagnosisService_GetTopSqlDetail

    • ○

      api tag DiagnosisService added

    • ○

      api tag ClusterService removed