slow_query: nav_title: Slow Queries fields: instance: TiDB Instance instance_tooltip: The TiDB address that handles the query connection_id: Connection ID connection_id_tooltip: Unique connection ID of the query sql: Query query: Query timestamp: Finish Time timestamp_tooltip: The time this query finished execution query_time: Latency query_time_tooltip: Execution time of the query memory_max: Max Memory memory_max_tooltip: Maximum memory usage of the query disk_max: Max Disk disk_max_tooltip: Maximum disk usage of the query digest: Query Template ID digest_tooltip: a.k.a. Query digest is_internal: Is Internal? is_internal_tooltip: Whether this is an internal query is_success: Is Success? is_success_tooltip: Whether query is executed successfully result: Result result_tooltip: Whether query is executed successfully index_names: Index Names index_names_tooltip: The name of the used index stats: Used Statistics backoff_types: Backoff Types user: Execution User user_tooltip: The user that executes the query host: Client Address host_tooltip: The address of the client that sends the query db: Execution Database db_tooltip: The database used to execute the query query_time2: Query Time query_time2_tooltip: The elapsed wall time when execution the query parse_time: Parse Time parse_time_tooltip: Time consumed when parsing the query compile_time: Generate Plan Time rewrite_time: Rewrite Plan Time preproc_subqueries_time: Preprocess Sub-Query Time preproc_subqueries_time_tooltip: Time consumed when pre-processing the subquery during the rewrite plan phase optimize_time: Optimize Plan Time wait_ts: Get Start Ts Time wait_ts_tooltip: Time consumed when getting a start timestamp when transaction begins cop_time: Coprocessor Executor Time cop_time_tooltip: 'The elapsed wall time when TiDB Coprocessor executor waiting all Coprocessor requests to finish (note: when there are JOIN in SQL statement, multiple TiDB Coprocessor executors may be running in parallel, which may cause this time not being a wall time)' wait_time: Coprocessor Wait Time wait_time_tooltip: 'The total time of Coprocessor request is prepared and wait to execute in TiKV, which may happen when retrieving a snapshot though Raft concensus protocol (note: TiKV waits requests in parallel so that this is not a wall time)' process_time: Coprocessor Process Time process_time_tooltip: 'The total time of Coprocessor request being executed in TiKV (note: TiKV executes requests in parallel so that this is not a wall time)' backoff_time: Execution Backoff Time backoff_time_tooltip: 'The total backoff waiting time before retry when a query encounters errors (note: there may be multiple backoffs in parallel so that this may not be a wall time)' lock_keys_time: Lock Keys Time lock_keys_time_tooltip: Time consumed when locking keys in pessimistic transaction get_commit_ts_time: Get Commit Ts Time get_commit_ts_time_tooltip: Time consumed when getting a commit timestamp for 2PC commit phase when transaction commits local_latch_wait_time: Local Latch Wait Time local_latch_wait_time_tooltip: Time consumed when TiDB waits for the lock in the current TiDB instance before 2PC commit phase when transaction commits resolve_lock_time: Resolve Lock Time resolve_lock_time_tooltip: Time consumed when TiDB resolves locks from other transactions in 2PC prewrite phase when transaction commits prewrite_time: Prewrite Time prewrite_time_tooltip: Time consumed in 2PC prewrite phase when transaction commits wait_prewrite_binlog_time: Wait Binlog Prewrite Time wait_prewrite_binlog_time_tooltip: Time consumed when waiting Binlog prewrite to finish commit_time: Commit Time commit_time_tooltip: Time consumed in 2PC commit phase when transaction commits commit_backoff_time: Commit Backoff Time commit_backoff_time_tooltip: 'The total backoff waiting time when 2PC commit encounters errors (note: there may be multiple backoffs in parallel so that this may not be a wall time)' write_sql_response_total: Send response Time write_sql_response_total_tooltip: Time consumed when sending response to the SQL client exec_retry_time: Retried execution Time exec_retry_time_tooltip: Wall time consumed when SQL statement is retried and executed again, except for the last exection request_count: Request Count process_keys: Process Keys total_keys: Total Keys cop_proc_addr: Copr Address (Process) cop_proc_addr_tooltip: The address of the TiKV that takes most time process the Coprocessor request cop_wait_addr: Copr Address (Wait) cop_wait_addr_tooltip: The address of the TiKV that takes most time wait the Coprocessor request txn_start_ts: Start Timestamp txn_start_ts_tooltip: Transaction start timestamp, a.k.a. Transaction ID write_keys: Write Keys write_size: Write Size prewrite_region: Prewrite Regions txn_retry: Transaction Retries prev_stmt: Previous Query plan: Execution Plan cop_proc_avg: Mean Cop Proc # ? cop_wait_avg: Mean Cop Wait # ? rocksdb_delete_skipped_count: RocksDB Skipped Deletions rocksdb_delete_skipped_count_tooltip: Total number of deleted (a.k.a. tombstone) key versions that are skipped during iteration (RocksDB delete_skipped_count) rocksdb_key_skipped_count: RocksDB Skipped Keys rocksdb_key_skipped_count_tooltip: Total number of keys skipped during iteration (RocksDB key_skipped_count) rocksdb_block_cache_hit_count: RocksDB Block Cache Hits rocksdb_block_cache_hit_count_tooltip: Total number of hits from the block cache (RocksDB block_cache_hit_count) rocksdb_block_read_count: RocksDB Block Reads rocksdb_block_read_count_tooltip: Total number of blocks RocksDB read from file (RocksDB block_read_count) rocksdb_block_read_byte: RocksDB Read Size rocksdb_block_read_byte_tooltip: Total number of bytes RocksDB read from file (RocksDB block_read_byte) common: status: success: Success error: Failed detail: head: title: Slow Query Detail back: List sql: Query previous_sql: Previous Query plan: Plan tabs: basic: Basic time: Time copr: Coprocessor txn: Transaction toolbar: schemas: placeholder: Execution Databases selected: '{{ n }} Databases' columnTitle: Database Name select_columns: show_full_sql: Show Full Query Text refresh: Refresh export: Export exporting: Exporting statement: nav_title: SQL Statements pages: detail: head: back: List title: Statement Information desc: time_range: Selected Time Range plans: note: There are multiple execution plans for this kind of SQL statement. You can choose to view one or multiple of them. title: one_for_all: Execution Detail all: Execution Detail of All Plans some: 'Execution Detail of Selected {{n}} Plans' tabs: basic: Basic time: Time copr: Coprocessor Read txn: Transaction slow_query: Slow Query overview: toolbar: schemas: placeholder: All Databases selected: '{{ n }} Databases' columnTitle: Database Name statement_types: placeholder: All Kinds selected: '{{ n }} Kinds' columnTitle: Statement Kind select_columns: show_full_sql: Show Full Query Text refresh: Refresh time_range_selector: name: Select Time Range recent: Recent usual_time_ranges: Common custom_time_ranges: Custom export: Export exporting: Exporting settings: title: Settings disabled_result: title: Feature Not Enabled sub_title: | Statement feature is not enabled so that statement history cannot be viewed. You can modify settings to enable the feature and wait for new data being collected. open_setting: Open Settings close_statement: Disable Statement Feature close_statement_warning: Are you sure want to disable this feature? Current statement history will be cleared. switch: Enable Feature switch_tooltip: Whether Statement feature is enabled. When enabled, there will be a small SQL statement execution overhead. max_size: 'Max # Statement' max_size_tooltip: Max number of statement to collect. After exceeding, old statement information will be dropped. You may enlarge this setting when memory is sufficient and you discovered that data displayed in UI is incomplete. refresh_interval: Window Size (min) refresh_interval_tooltip: By reducing this setting you can select time range more precisely. history_size: '# Windows' history_size_tooltip: By enlarging this setting more statement history will be preserved, with larger memory cost. keep_duration: SQL Statement History Size keep_duration_tooltip: Window Size × Number of Windows internal_query: Collect Internal Queries internal_query_tooltip: After enabled, TiDB internal queries will be collected as well. actions: save: Save close: Close cancel: Cancel fields: table_names: Table Names related_schemas: Database related_schemas_tooltip: Related databases of the statement plan_digest: Plan ID plan_digest_tooltip: Different execution plans have different plan ID digest_text: Statement Template digest_text_tooltip: Similar queries have same statement template even for different query parameters sum_latency: Total Latency sum_latency_tooltip: Total execution time for this kind of statement exec_count: '# Exec' exec_count_tooltip: Total execution count for this kind of statement plan_count: '# Plans' plan_count_tooltip: Number of distinct execution plans of this statement in current time range avg_latency: Mean Latency avg_latency_tooltip: Execution time of single query avg_mem: Mean Memory avg_mem_tooltip: Memory usage of single query max_mem: Max Memory max_mem_tooltip: Maximum memory usage of single query avg_disk: Mean Disk avg_disk_tooltip: Disk usage of single query max_disk: Max Disk max_disk_tooltip: Maximum disk usage of single query index_names: Index Name index_names_tooltip: The name of the used index first_seen: First Seen last_seen: Last Seen sample_user: Execution User sample_user_tooltip: The user that executes the query (sampled) sum_errors: Total Errors sum_warnings: Total Warnings errors_warnings: Errors / Warnings errors_warnings_tooltip: Total Errors and Total Warnings parse_latency: Parse Time parse_latency_tooltip: Time consumed when parsing the query compile_latency: Compile compile_latency_tooltip: Time consumed when optimizing the query wait_time: Coprocessor Wait Time process_time: Coprocessor Execution Time total_process_time: Total Execution Time total_wait_time: Total Wait Time backoff_time: Backoff Retry Time backoff_time_tooltip: The waiting time before retry when a query encounters errors that require a retry get_commit_ts_time: Get Commit Ts Time local_latch_wait_time: Local Latch Wait Time resolve_lock_time: Resolve Lock Time prewrite_time: Prewrite Time commit_time: Commit Time commit_backoff_time: Commit Backoff Retry Time latency: Query query_time2: Query Time query_time2_tooltip: The execution time of a query (due to the parallel execution, it may be significantly smaller than the above time) sum_cop_task_num: Total Coprocessor Tasks avg_processed_keys: Mean Visible Versions Per Query max_processed_keys: Max Visible Versions Per Query avg_total_keys: Mean Meet Versions Per Query avg_total_keys_tooltip: Meet versions contains overwritten or deleted versions max_total_keys: Max Meet Versions Per Query avg_affected_rows: Mean Affected Rows sum_backoff_times: Total Backoff Count avg_write_keys: Mean Written Keys max_write_keys: Max Written Keys avg_write_size: Mean Written Data Size max_write_size: Max Written Data Size avg_prewrite_regions: Mean Prewrite Regions max_prewrite_regions: Max Prewrite Regions avg_txn_retry: Mean Transaction Retries max_txn_retry: Max Transaction Retries digest: Query Template ID digest_tooltip: a.k.a. Query digest schema_name: Execution Database schema_name_tooltip: The database used to execute the query query_sample_text: Query Sample prev_sample_text: Previous Query Sample plan: Execution Plan avg_rocksdb_delete_skipped_count: Mean RocksDB Skipped Deletions avg_rocksdb_delete_skipped_count_tooltip: Total number of deleted (a.k.a. tombstone) key versions that are skipped during iteration (RocksDB delete_skipped_count) max_rocksdb_delete_skipped_count: Max RocksDB Skipped Deletions avg_rocksdb_key_skipped_count: Mean RocksDB Skipped Keys avg_rocksdb_key_skipped_count_tooltip: Total number of keys skipped during iteration (RocksDB key_skipped_count) max_rocksdb_key_skipped_count: Max RocksDB Skipped Keys avg_rocksdb_block_cache_hit_count: Mean RocksDB Block Cache Hits avg_rocksdb_block_cache_hit_count_tooltip: Total number of hits from the block cache (RocksDB block_cache_hit_count) max_rocksdb_block_cache_hit_count: Max RocksDB Block Cache Hits avg_rocksdb_block_read_count: Mean RocksDB Block Reads avg_rocksdb_block_read_count_tooltip: Total number of blocks RocksDB read from file (RocksDB block_read_count) max_rocksdb_block_read_count: Max RocksDB Block Reads avg_rocksdb_block_read_byte: Mean RocksDB FS Read Size avg_rocksdb_block_read_byte_tooltip: Total number of bytes RocksDB read from file (RocksDB block_read_byte) max_rocksdb_block_read_byte: Max RocksDB FS Read Size