【 TiDB 使用环境】 压力测试环境
【 TiDB 版本】 8.5.1
【复现路径】 业务1会频繁更新表A,业务2会频繁查询表A
【遇到的问题：问题现象及影响】
目前遇到的问题，查询表A的时间会从原来的100ms 增加到5s左右才完成。
表A总共不到1000行数据，但是数据会被业务1频繁更新。
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件：截图/日志/监控】
有设置gc时间是吗，sql执行计划有没有变呢
看看5s时的执行计划
| id | estRows | estCost | actRows | task | access object | execution info | operator info | memory | disk |
| Union_42 | 9.68 | 5463.12 | 27 | root | | time:2.33ms, loops:11 | | N/A | N/A |
| ├─Projection_43 | 0.97 | 2731.56 | 3 | root | | time:1.26ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 51.3 KB | N/A |
| │ └─Projection_50 | 0.97 | 2711.18 | 3 | root | | time:1.24ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.name, runtime_r9d.lot_running_info.batch_id, runtime_r9d.lot_running_info.carrier_name, runtime_r9d.lot_running_info.equipment_name, runtime_r9d.lot_running_info.job_in_txn_time, runtime_r9d.lot_running_info.process_end_time, runtime_r9d.lot_running_info.process_start_time, runtime_r9d.lot_running_info.process_type, runtime_r9d.lot_running_info.processed_wafer_cnt, runtime_r9d.lot_running_info.qty, runtime_r9d.lot_running_info.remaining_wafer_cnt, runtime_r9d.lot_running_info.run_wafer_infos, runtime_r9d.lot_running_info.wafer_chamber_infos | 51.9 KB | N/A |
| │ └─IndexLookUp_49 | 0.97 | 2709.92 | 3 | root | | time:1.23ms, loops:2, index_task: {total_time: 415µs, fetch_handle: 413µs, build: 383ns, wait: 1.65µs}, table_task: {total_time: 700.3µs, num: 1, concurrency: 5}, next: {wait_index: 489.9µs, wait_table_lookup_build: 35.9µs, wait_table_lookup_resp: 668.5µs} | | 64.8 KB | N/A |
| │ ├─IndexRangeScan_47(Build) | 0.97 | 230.54 | 3 | cop[tikv] | table:lot_running_info, index:idx_equipment_name(equipment_name) | time:403.9µs, loops:3, cop_task: {num: 1, max: 358.6µs, proc_keys: 3, tot_proc: 104.5µs, tot_wait: 24µs, copr_cache_hit_ratio: 0.00, build_task_duration: 18.4µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:346.7µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 3, total_process_keys_size: 375, total_keys: 60, get_snapshot_time: 10µs, rocksdb: {delete_skipped_count: 1, key_skipped_count: 60, block: {cache_hit_count: 13}}}, time_detail: {total_process_time: 104.5µs, total_wait_time: 24µs, tikv_wall_time: 195.3µs} | range:[“ST-PVD018”,“ST-PVD018”], keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| │ └─TableRowIDScan_48(Probe) | 0.97 | 550.80 | 3 | cop[tikv] | table:lot_running_info | time:651.8µs, loops:2, cop_task: {num: 2, max: 593µs, min: 0s, avg: 296.5µs, p95: 593µs, max_proc_keys: 2, p95_proc_keys: 2, tot_proc: 397.1µs, tot_wait: 37.2µs, copr_cache_hit_ratio: 0.00, build_task_duration: 16.5µs, max_distsql_concurrency: 1, max_extra_concurrency: 1, store_batch_num: 1}, rpc_info:{Cop:{num_rpc:1, total_time:584.1µs}}, tikv_task:{proc max:1ms, min:1ms, avg: 1ms, p80:1ms, p95:1ms, iters:2, tasks:2}, scan_detail: {total_process_keys: 3, total_process_keys_size: 40913, total_keys: 9, get_snapshot_time: 9.99µs, rocksdb: {key_skipped_count: 6, block: {cache_hit_count: 72}}}, time_detail: {total_process_time: 397.1µs, total_wait_time: 37.2µs, total_kv_read_wall_time: 2ms, tikv_wall_time: 361.7µs} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_51 | 0.97 | 2731.56 | 1 | root | | time:983.2µs, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 14.3 KB | N/A |
| │ └─Projection_58 | 0.97 | 2711.18 | 1 | root | | time:973.2µs, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.name, runtime_r9d.lot_running_info.batch_id, runtime_r9d.lot_running_info.carrier_name, runtime_r9d.lot_running_info.equipment_name, runtime_r9d.lot_running_info.job_in_txn_time, runtime_r9d.lot_running_info.process_end_time, runtime_r9d.lot_running_info.process_start_time, runtime_r9d.lot_running_info.process_type, runtime_r9d.lot_running_info.processed_wafer_cnt, runtime_r9d.lot_running_info.qty, runtime_r9d.lot_running_info.remaining_wafer_cnt, runtime_r9d.lot_running_info.run_wafer_infos, runtime_r9d.lot_running_info.wafer_chamber_infos | 14.9 KB | N/A |
| │ └─IndexLookUp_57 | 0.97 | 2709.92 | 1 | root | | time:959.9µs, loops:2, index_task: {total_time: 374.3µs, fetch_handle: 372.5µs, build: 424ns, wait: 1.42µs}, table_task: {total_time: 513.4µs, num: 1, concurrency: 5}, next: {wait_index: 435µs, wait_table_lookup_build: 36.8µs, wait_table_lookup_resp: 471.7µs} | | 32.4 KB | N/A |
| │ ├─IndexRangeScan_55(Build) | 0.97 | 230.54 | 1 | cop[tikv] | table:lot_running_info, index:idx_equipment_name(equipment_name) | time:365.2µs, loops:3, cop_task: {num: 1, max: 322.8µs, proc_keys: 1, tot_proc: 83.2µs, tot_wait: 31.5µs, copr_cache_hit_ratio: 0.00, build_task_duration: 15.8µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:311.1µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 1, total_process_keys_size: 125, total_keys: 32, get_snapshot_time: 6.59µs, rocksdb: {key_skipped_count: 31, block: {cache_hit_count: 13}}}, time_detail: {total_process_time: 83.2µs, total_wait_time: 31.5µs, tikv_wall_time: 173.8µs} | range:[“ST-PVD017”,“ST-PVD017”], keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| │ └─TableRowIDScan_56(Probe) | 0.97 | 550.80 | 1 | cop[tikv] | table:lot_running_info | time:454.8µs, loops:2, cop_task: {num: 1, max: 417.1µs, proc_keys: 1, tot_proc: 139.1µs, tot_wait: 20.2µs, copr_cache_hit_ratio: 0.00, build_task_duration: 19.1µs, max_distsql_concurrency: 1, max_extra_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:409.8µs}}, tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 1, total_process_keys_size: 8327, total_keys: 3, get_snapshot_time: 7.53µs, rocksdb: {key_skipped_count: 2, block: {cache_hit_count: 24}}}, time_detail: {total_process_time: 139.1µs, total_wait_time: 20.2µs, total_kv_read_wall_time: 1ms, tikv_wall_time: 228.4µs} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_59 | 0.97 | 2731.56 | 1 | root | | time:990.5µs, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 28.1 KB | N/A |
| │ └─Projection_66 | 0.97 | 2711.18 | 1 | root | | time:978.8µs, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.name, runtime_r9d.lot_running_info.batch_id, runtime_r9d.lot_running_info.carrier_name, runtime_r9d.lot_running_info.equipment_name, runtime_r9d.lot_running_info.job_in_txn_time, runtime_r9d.lot_running_info.process_end_time, runtime_r9d.lot_running_info.process_start_time, runtime_r9d.lot_running_info.process_type, runtime_r9d.lot_running_info.processed_wafer_cnt, runtime_r9d.lot_running_info.qty, runtime_r9d.lot_running_info.remaining_wafer_cnt, runtime_r9d.lot_running_info.run_wafer_infos, runtime_r9d.lot_running_info.wafer_chamber_infos | 28.7 KB | N/A |
| │ └─IndexLookUp_65 | 0.97 | 2709.92 | 1 | root | | time:966.5µs, loops:2, index_task: {total_time: 355.6µs, fetch_handle: 353.8µs, build: 565ns, wait: 1.24µs}, table_task: {total_time: 547.8µs, num: 1, concurrency: 5}, next: {wait_index: 411.9µs, wait_table_lookup_build: 33.2µs, wait_table_lookup_resp: 502.2µs} | | 46.1 KB | N/A |
| │ ├─IndexRangeScan_63(Build) | 0.97 | 230.54 | 1 | cop[tikv] | table:lot_running_info, index:idx_equipment_name(equipment_name) | time:348.7µs, loops:3, cop_task: {num: 1, max: 299µs, proc_keys: 1, tot_proc: 66.1µs, tot_wait: 51.6µs, copr_cache_hit_ratio: 0.00, build_task_duration: 18µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:290.6µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 1, total_process_keys_size: 125, total_keys: 40, get_snapshot_time: 6.29µs, rocksdb: {key_skipped_count: 39, block: {cache_hit_count: 13}}}, time_detail: {total_process_time: 66.1µs, total_wait_time: 51.6µs, tikv_wall_time: 167.1µs} | range:[“ST-PVD019”,“ST-PVD019”], keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| │ └─TableRowIDScan_64(Probe) | 0.97 | 550.80 | 1 | cop[tikv] | table:lot_running_info | time:483.8µs, loops:2, cop_task: {num: 1, max: 441µs, proc_keys: 1, tot_proc: 148.7µs, tot_wait: 17.2µs, copr_cache_hit_ratio: 0.00, build_task_duration: 20.5µs, max_distsql_concurrency: 1, max_extra_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:435.2µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 1, total_process_keys_size: 22597, total_keys: 3, get_snapshot_time: 3.66µs, rocksdb: {key_skipped_count: 2, block: {cache_hit_count: 24}}}, time_detail: {total_process_time: 148.7µs, total_wait_time: 17.2µs, tikv_wall_time: 239.5µs} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_67 | 0.97 | 2731.56 | 3 | root | | time:1.72ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 80.1 KB | N/A |
| │ └─Projection_74 | 0.97 | 2711.18 | 3 | root | | time:1.7ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.name, runtime_r9d.lot_running_info.batch_id, runtime_r9d.lot_running_info.carrier_name, runtime_r9d.lot_running_info.equipment_name, runtime_r9d.lot_running_info.job_in_txn_time, runtime_r9d.lot_running_info.process_end_time, runtime_r9d.lot_running_info.process_start_time, runtime_r9d.lot_running_info.process_type, runtime_r9d.lot_running_info.processed_wafer_cnt, runtime_r9d.lot_running_info.qty, runtime_r9d.lot_running_info.remaining_wafer_cnt, runtime_r9d.lot_running_info.run_wafer_infos, runtime_r9d.lot_running_info.wafer_chamber_infos | 80.7 KB | N/A |
| │ └─IndexLookUp_73 | 0.97 | 2709.92 | 3 | root | | time:1.69ms, loops:2, index_task: {total_time: 306.2µs, fetch_handle: 304.7µs, build: 531ns, wait: 1.01µs}, table_task: {total_time: 1.31ms, num: 1, concurrency: 5}, next: {wait_index: 375.9µs, wait_table_lookup_build: 18.7µs, wait_table_lookup_resp: 1.26ms} | | 98.8 KB | N/A |
| │ ├─IndexRangeScan_71(Build) | 0.97 | 230.54 | 3 | cop[tikv] | table:lot_running_info, index:idx_equipment_name(equipment_name) | time:298.2µs, loops:3, cop_task: {num: 1, max: 262µs, proc_keys: 3, tot_proc: 85.8µs, tot_wait: 24.6µs, copr_cache_hit_ratio: 0.00, build_task_duration: 9.02µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:255.1µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 3, total_process_keys_size: 375, total_keys: 48, get_snapshot_time: 5.15µs, rocksdb: {key_skipped_count: 47, block: {cache_hit_count: 13}}}, time_detail: {total_process_time: 85.8µs, total_wait_time: 24.6µs, tikv_wall_time: 162.7µs} | range:[“ST-PVD020”,“ST-PVD020”], keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| │ └─TableRowIDScan_72(Probe) | 0.97 | 550.80 | 3 | cop[tikv] | table:lot_running_info | time:1.24ms, loops:2, cop_task: {num: 3, max: 592.6µs, min: 0s, avg: 381.5µs, p95: 592.6µs, max_proc_keys: 1, p95_proc_keys: 1, tot_proc: 539.2µs, tot_wait: 70.9µs, copr_cache_hit_ratio: 0.00, build_task_duration: 28µs, max_distsql_concurrency: 1, max_extra_concurrency: 1, store_batch_num: 1}, rpc_info:{Cop:{num_rpc:2, total_time:1.13ms}}, tikv_task:{proc max:1ms, min:0s, avg: 333.3µs, p80:1ms, p95:1ms, iters:3, tasks:3}, scan_detail: {total_process_keys: 3, total_process_keys_size: 61165, total_keys: 22, get_snapshot_time: 21.8µs, rocksdb: {key_skipped_count: 17, block: {cache_hit_count: 72}}}, time_detail: {total_process_time: 539.2µs, total_wait_time: 70.9µs, total_kv_read_wall_time: 1ms, tikv_wall_time: 639.6µs} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_75 | 0.97 | 2731.56 | 1 | root | | time:1.03ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 20.1 KB | N/A |
| │ └─Projection_82 | 0.97 | 2711.18 | 1 | root | | time:1.02ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.name, runtime_r9d.lot_running_info.batch_id, runtime_r9d.lot_running_info.carrier_name, runtime_r9d.lot_running_info.equipment_name, runtime_r9d.lot_running_info.job_in_txn_time, runtime_r9d.lot_running_info.process_end_time, runtime_r9d.lot_running_info.process_start_time, runtime_r9d.lot_running_info.process_type, runtime_r9d.lot_running_info.processed_wafer_cnt, runtime_r9d.lot_running_info.qty, runtime_r9d.lot_running_info.remaining_wafer_cnt, runtime_r9d.lot_running_info.run_wafer_infos, runtime_r9d.lot_running_info.wafer_chamber_infos | 20.7 KB | N/A |
| │ └─IndexLookUp_81 | 0.97 | 2709.92 | 1 | root | | time:1ms, loops:2, index_task: {total_time: 316.7µs, fetch_handle: 315.4µs, build: 457ns, wait: 851ns}, table_task: {total_time: 628.4µs, num: 1, concurrency: 5}, next: {wait_index: 388.1µs, wait_table_lookup_build: 5.15µs, wait_table_lookup_resp: 594.6µs} | | 38.1 KB | N/A |
| │ ├─IndexRangeScan_79(Build) | 0.97 | 230.54 | 1 | cop[tikv] | table:lot_running_info, index:idx_equipment_name(equipment_name) | time:311µs, loops:3, cop_task: {num: 1, max: 273.8µs, proc_keys: 1, tot_proc: 75.2µs, tot_wait: 18.9µs, copr_cache_hit_ratio: 0.00, build_task_duration: 14.2µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:263µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 1, total_process_keys_size: 125, total_keys: 38, get_snapshot_time: 3.96µs, rocksdb: {key_skipped_count: 37, block: {cache_hit_count: 14}}}, time_detail: {total_process_time: 75.2µs, total_wait_time: 18.9µs, tikv_wall_time: 141µs} | range:[“ST-PVD023”,“ST-PVD023”], keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| │ └─TableRowIDScan_80(Probe) | 0.97 | 550.80 | 1 | cop[tikv] | table:lot_running_info | time:579.1µs, loops:2, cop_task: {num: 1, max: 537.1µs, proc_keys: 1, tot_proc: 163µs, tot_wait: 16.4µs, copr_cache_hit_ratio: 0.00, build_task_duration: 16.6µs, max_distsql_concurrency: 1, max_extra_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:526.8µs}}, tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 1, total_process_keys_size: 14097, total_keys: 3, get_snapshot_time: 3.76µs, rocksdb: {key_skipped_count: 2, block: {cache_hit_count: 24}}}, time_detail: {total_process_time: 163µs, total_wait_time: 16.4µs, total_kv_read_wall_time: 1ms, tikv_wall_time: 239.7µs} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_83 | 0.97 | 2731.56 | 6 | root | | time:1.61ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 72.1 KB | N/A |
| │ └─Projection_90 | 0.97 | 2711.18 | 6 | root | | time:1.59ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.name, runtime_r9d.lot_running_info.batch_id, runtime_r9d.lot_running_info.carrier_name, runtime_r9d.lot_running_info.equipment_name, runtime_r9d.lot_running_info.job_in_txn_time, runtime_r9d.lot_running_info.process_end_time, runtime_r9d.lot_running_info.process_start_time, runtime_r9d.lot_running_info.process_type, runtime_r9d.lot_running_info.processed_wafer_cnt, runtime_r9d.lot_running_info.qty, runtime_r9d.lot_running_info.remaining_wafer_cnt, runtime_r9d.lot_running_info.run_wafer_infos, runtime_r9d.lot_running_info.wafer_chamber_infos | 72.7 KB | N/A |
| │ └─IndexLookUp_89 | 0.97 | 2709.92 | 6 | root | | time:1.58ms, loops:2, index_task: {total_time: 302.2µs, fetch_handle: 300.9µs, build: 451ns, wait: 834ns}, table_task: {total_time: 1.21ms, num: 1, concurrency: 5}, next: {wait_index: 327.3µs, wait_table_lookup_build: 33.7µs, wait_table_lookup_resp: 1.17ms} | | 91.8 KB | N/A |
| │ ├─IndexRangeScan_87(Build) | 0.97 | 230.54 | 6 | cop[tikv] | table:lot_running_info, index:idx_equipment_name(equipment_name) | time:294.5µs, loops:3, cop_task: {num: 1, max: 258.9µs, proc_keys: 6, tot_proc: 92.7µs, tot_wait: 20.1µs, copr_cache_hit_ratio: 0.00, build_task_duration: 7.32µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:249µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 6, total_process_keys_size: 750, total_keys: 71, get_snapshot_time: 7.2µs, rocksdb: {key_skipped_count: 70, block: {cache_hit_count: 14}}}, time_detail: {total_process_time: 92.7µs, total_wait_time: 20.1µs, tikv_wall_time: 165µs} | range:[“ST-PVD014”,“ST-PVD014”], keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| │ └─TableRowIDScan_88(Probe) | 0.97 | 550.80 | 6 | cop[tikv] | table:lot_running_info | time:1.16ms, loops:2, cop_task: {num: 3, max: 675.5µs, min: 0s, avg: 360.4µs, p95: 675.5µs, max_proc_keys: 4, p95_proc_keys: 4, tot_proc: 673.4µs, tot_wait: 63.9µs, copr_cache_hit_ratio: 0.00, build_task_duration: 19.6µs, max_distsql_concurrency: 1, max_extra_concurrency: 1, store_batch_num: 1}, rpc_info:{Cop:{num_rpc:2, total_time:1.07ms}}, tikv_task:{proc max:1ms, min:0s, avg: 333.3µs, p80:1ms, p95:1ms, iters:3, tasks:3}, scan_detail: {total_process_keys: 6, total_process_keys_size: 56842, total_keys: 25, get_snapshot_time: 18.3µs, rocksdb: {key_skipped_count: 18, block: {cache_hit_count: 144}}}, time_detail: {total_process_time: 673.4µs, total_wait_time: 63.9µs, total_kv_read_wall_time: 1ms, tikv_wall_time: 775.5µs} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_91 | 0.97 | 2731.56 | 4 | root | | time:1.96ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 43.3 KB | N/A |
| │ └─Projection_98 | 0.97 | 2711.18 | 4 | root | | time:1.95ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.name, runtime_r9d.lot_running_info.batch_id, runtime_r9d.lot_running_info.carrier_name, runtime_r9d.lot_running_info.equipment_name, runtime_r9d.lot_running_info.job_in_txn_time, runtime_r9d.lot_running_info.process_end_time, runtime_r9d.lot_running_info.process_start_time, runtime_r9d.lot_running_info.process_type, runtime_r9d.lot_running_info.processed_wafer_cnt, runtime_r9d.lot_running_info.qty, runtime_r9d.lot_running_info.remaining_wafer_cnt, runtime_r9d.lot_running_info.run_wafer_infos, runtime_r9d.lot_running_info.wafer_chamber_infos | 43.9 KB | N/A |
| │ └─IndexLookUp_97 | 0.97 | 2709.92 | 4 | root | | time:1.94ms, loops:2, index_task: {total_time: 270.3µs, fetch_handle: 269µs, build: 344ns, wait: 972ns}, table_task: {total_time: 1.61ms, num: 1, concurrency: 5}, next: {wait_index: 292.8µs, wait_table_lookup_build: 42.9µs, wait_table_lookup_resp: 1.56ms} | | 61.1 KB | N/A |
| │ ├─IndexRangeScan_95(Build) | 0.97 | 230.54 | 4 | cop[tikv] | table:lot_running_info, index:idx_equipment_name(equipment_name) | time:263.6µs, loops:3, cop_task: {num: 1, max: 236.7µs, proc_keys: 4, tot_proc: 65.2µs, tot_wait: 20µs, copr_cache_hit_ratio: 0.00, build_task_duration: 5.91µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:231.7µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 4, total_process_keys_size: 500, total_keys: 41, get_snapshot_time: 5.01µs, rocksdb: {key_skipped_count: 40, block: {cache_hit_count: 13}}}, time_detail: {total_process_time: 65.2µs, total_wait_time: 20µs, tikv_wall_time: 136.2µs} | range:[“ST-PVD024”,“ST-PVD024”], keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| │ └─TableRowIDScan_96(Probe) | 0.97 | 550.80 | 4 | cop[tikv] | table:lot_running_info | time:1.55ms, loops:2, cop_task: {num: 3, max: 765.5µs, min: 335.5µs, avg: 490µs, p95: 765.5µs, max_proc_keys: 2, p95_proc_keys: 2, tot_proc: 693.1µs, tot_wait: 89.3µs, copr_cache_hit_ratio: 0.00, build_task_duration: 24.1µs, max_distsql_concurrency: 1, max_extra_concurrency: 1}, rpc_info:{Cop:{num_rpc:3, total_time:1.45ms}}, tikv_task:{proc max:1ms, min:0s, avg: 333.3µs, p80:1ms, p95:1ms, iters:3, tasks:3}, scan_detail: {total_process_keys: 4, total_process_keys_size: 35354, total_keys: 12, get_snapshot_time: 31.6µs, rocksdb: {key_skipped_count: 8, block: {cache_hit_count: 92}}}, time_detail: {total_process_time: 693.1µs, total_wait_time: 89.3µs, total_kv_read_wall_time: 1ms, tikv_wall_time: 1.06ms} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_99 | 0.97 | 2731.56 | 3 | root | | time:1.65ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 83.3 KB | N/A |
| │ └─Projection_106 | 0.97 | 2711.18 | 3 | root | | time:1.64ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.name, runtime_r9d.lot_running_info.batch_id, runtime_r9d.lot_running_info.carrier_name, runtime_r9d.lot_running_info.equipment_name, runtime_r9d.lot_running_info.job_in_txn_time, runtime_r9d.lot_running_info.process_end_time, runtime_r9d.lot_running_info.process_start_time, runtime_r9d.lot_running_info.process_type, runtime_r9d.lot_running_info.processed_wafer_cnt, runtime_r9d.lot_running_info.qty, runtime_r9d.lot_running_info.remaining_wafer_cnt, runtime_r9d.lot_running_info.run_wafer_infos, runtime_r9d.lot_running_info.wafer_chamber_infos | 83.9 KB | N/A |
| │ └─IndexLookUp_105 | 0.97 | 2709.92 | 3 | root | | time:1.63ms, loops:2, index_task: {total_time: 386.2µs, fetch_handle: 383.9µs, build: 484ns, wait: 1.89µs}, table_task: {total_time: 1.16ms, num: 1, concurrency: 5}, next: {wait_index: 420.8µs, wait_table_lookup_build: 81.6µs, wait_table_lookup_resp: 1.08ms} | | 102.1 KB | N/A |
| │ ├─IndexRangeScan_103(Build) | 0.97 | 230.54 | 3 | cop[tikv] | table:lot_running_info, index:idx_equipment_name(equipment_name) | time:375.1µs, loops:3, cop_task: {num: 1, max: 310.4µs, proc_keys: 3, tot_proc: 113.9µs, tot_wait: 21.7µs, copr_cache_hit_ratio: 0.00, build_task_duration: 9.99µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:300µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 3, total_process_keys_size: 375, total_keys: 48, get_snapshot_time: 9.58µs, rocksdb: {key_skipped_count: 47, block: {cache_hit_count: 13}}}, time_detail: {total_process_time: 113.9µs, total_wait_time: 21.7µs, tikv_wall_time: 192.6µs} | range:[“ST-PVD013”,“ST-PVD013”], keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| │ └─TableRowIDScan_104(Probe) | 0.97 | 550.80 | 3 | cop[tikv] | table:lot_running_info | time:1.05ms, loops:2, cop_task: {num: 3, max: 548.9µs, min: 0s, avg: 312.1µs, p95: 548.9µs, max_proc_keys: 1, p95_proc_keys: 1, tot_proc: 547.5µs, tot_wait: 67.9µs, copr_cache_hit_ratio: 0.00, build_task_duration: 43.6µs, max_distsql_concurrency: 1, max_extra_concurrency: 1, store_batch_num: 1}, rpc_info:{Cop:{num_rpc:2, total_time:917.5µs}}, tikv_task:{proc max:0s, min:0s, avg: 0s, p80:0s, p95:0s, iters:3, tasks:3}, scan_detail: {total_process_keys: 3, total_process_keys_size: 68130, total_keys: 23, get_snapshot_time: 24.2µs, rocksdb: {key_skipped_count: 18, block: {cache_hit_count: 72}}}, time_detail: {total_process_time: 547.5µs, total_wait_time: 67.9µs, tikv_wall_time: 540µs} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_107 | 0.97 | 2731.56 | 3 | root | | time:1.37ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 51.3 KB | N/A |
| │ └─Projection_114 | 0.97 | 2711.18 | 3 | root | | time:1.36ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.name, runtime_r9d.lot_running_info.batch_id, runtime_r9d.lot_running_info.carrier_name, runtime_r9d.lot_running_info.equipment_name, runtime_r9d.lot_running_info.job_in_txn_time, runtime_r9d.lot_running_info.process_end_time, runtime_r9d.lot_running_info.process_start_time, runtime_r9d.lot_running_info.process_type, runtime_r9d.lot_running_info.processed_wafer_cnt, runtime_r9d.lot_running_info.qty, runtime_r9d.lot_running_info.remaining_wafer_cnt, runtime_r9d.lot_running_info.run_wafer_infos, runtime_r9d.lot_running_info.wafer_chamber_infos | 51.9 KB | N/A |
| │ └─IndexLookUp_113 | 0.97 | 2709.92 | 3 | root | | time:1.35ms, loops:2, index_task: {total_time: 236.2µs, fetch_handle: 234.6µs, build: 368ns, wait: 1.16µs}, table_task: {total_time: 1.05ms, num: 1, concurrency: 5}, next: {wait_index: 267.7µs, wait_table_lookup_build: 34.6µs, wait_table_lookup_resp: 1.02ms} | | 70.1 KB | N/A |
| │ ├─IndexRangeScan_111(Build) | 0.97 | 230.54 | 3 | cop[tikv] | table:lot_running_info, index:idx_equipment_name(equipment_name) | time:229.9µs, loops:3, cop_task: {num: 1, max: 198.5µs, proc_keys: 3, tot_proc: 64.9µs, tot_wait: 16.3µs, copr_cache_hit_ratio: 0.00, build_task_duration: 6.87µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:193.4µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 3, total_process_keys_size: 375, total_keys: 56, get_snapshot_time: 4.21µs, rocksdb: {key_skipped_count: 55, block: {cache_hit_count: 13}}}, time_detail: {total_process_time: 64.9µs, total_wait_time: 16.3µs, tikv_wall_time: 115.1µs} | range:[“ST-PVD016”,“ST-PVD016”], keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| │ └─TableRowIDScan_112(Probe) | 0.97 | 550.80 | 3 | cop[tikv] | table:lot_running_info | time:998.1µs, loops:2, cop_task: {num: 3, max: 528.5µs, min: 0s, avg: 306.4µs, p95: 528.5µs, max_proc_keys: 1, p95_proc_keys: 1, tot_proc: 450.3µs, tot_wait: 69.1µs, copr_cache_hit_ratio: 0.00, build_task_duration: 17.2µs, max_distsql_concurrency: 1, max_extra_concurrency: 1, store_batch_num: 1}, rpc_info:{Cop:{num_rpc:2, total_time:901.5µs}}, tikv_task:{proc max:0s, min:0s, avg: 0s, p80:0s, p95:0s, iters:3, tasks:3}, scan_detail: {total_process_keys: 3, total_process_keys_size: 45702, total_keys: 16, get_snapshot_time: 20.2µs, rocksdb: {key_skipped_count: 12, block: {cache_hit_count: 64}}}, time_detail: {total_process_time: 450.3µs, total_wait_time: 69.1µs, tikv_wall_time: 492.8µs} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| └─Projection_115 | 0.97 | 2731.56 | 2 | root | | time:1.25ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 41.9 KB | N/A |
| └─Projection_122 | 0.97 | 2711.18 | 2 | root | | time:1.24ms, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.name, runtime_r9d.lot_running_info.batch_id, runtime_r9d.lot_running_info.carrier_name, runtime_r9d.lot_running_info.equipment_name, runtime_r9d.lot_running_info.job_in_txn_time, runtime_r9d.lot_running_info.process_end_time, runtime_r9d.lot_running_info.process_start_time, runtime_r9d.lot_running_info.process_type, runtime_r9d.lot_running_info.processed_wafer_cnt, runtime_r9d.lot_running_info.qty, runtime_r9d.lot_running_info.remaining_wafer_cnt, runtime_r9d.lot_running_info.run_wafer_infos, runtime_r9d.lot_running_info.wafer_chamber_infos | 42.6 KB | N/A |
| └─IndexLookUp_121 | 0.97 | 2709.92 | 2 | root | | time:1.23ms, loops:2, index_task: {total_time: 361.1µs, fetch_handle: 359.9µs, build: 387ns, wait: 821ns}, table_task: {total_time: 816.1µs, num: 1, concurrency: 5}, next: {wait_index: 385.5µs, wait_table_lookup_build: 47.3µs, wait_table_lookup_resp: 769µs} | | 60.3 KB | N/A |
| ├─IndexRangeScan_119(Build) | 0.97 | 230.54 | 2 | cop[tikv] | table:lot_running_info, index:idx_equipment_name(equipment_name) | time:355.3µs, loops:3, cop_task: {num: 1, max: 322.8µs, proc_keys: 2, tot_proc: 66.1µs, tot_wait: 23.6µs, copr_cache_hit_ratio: 0.00, build_task_duration: 5.46µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:1, total_time:313.2µs}}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 2, total_process_keys_size: 250, total_keys: 57, get_snapshot_time: 3.45µs, rocksdb: {key_skipped_count: 56, block: {cache_hit_count: 13}}}, time_detail: {total_process_time: 66.1µs, total_wait_time: 23.6µs, tikv_wall_time: 150.8µs} | range:[“ST-PVD015”,“ST-PVD015”], keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
| └─TableRowIDScan_120(Probe) | 0.97 | 550.80 | 2 | cop[tikv] | table:lot_running_info | time:753µs, loops:2, cop_task: {num: 2, max: 356.3µs, min: 332.2µs, avg: 344.2µs, p95: 356.3µs, max_proc_keys: 1, p95_proc_keys: 1, tot_proc: 301.9µs, tot_wait: 37.4µs, copr_cache_hit_ratio: 0.00, build_task_duration: 22.7µs, max_distsql_concurrency: 1, max_extra_concurrency: 1}, rpc_info:{Cop:{num_rpc:2, total_time:677µs}}, tikv_task:{proc max:0s, min:0s, avg: 0s, p80:0s, p95:0s, iters:2, tasks:2}, scan_detail: {total_process_keys: 2, total_process_keys_size: 33789, total_keys: 12, get_snapshot_time: 10.2µs, rocksdb: {delete_skipped_count: 1, key_skipped_count: 18, block: {cache_hit_count: 48}}}, time_detail: {total_process_time: 301.9µs, total_wait_time: 37.4µs, tikv_wall_time: 445.1µs} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, idx_equipment_name:missing, equipment_name:unInitialized] | N/A | N/A |
时间长的
| id | estRows | estCost | actRows | task | access object | execution info | operator info | memory | disk |
| Union_42 | 9.47 | 162115.84 | 29 | root | | time:17.1s, loops:11 | | N/A | N/A |
| ├─Projection_43 | 0.95 | 81057.92 | 4 | root | | time:7.53s, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 83.3 KB | N/A |
| │ └─TableReader_46 | 0.95 | 81037.98 | 4 | root | | time:7.53s, loops:2, cop_task: {num: 2073, max: 0s, min: 0s, avg: 51.4ms, p95: 182.3ms, tot_proc: 6.85s, tot_wait: 1m36.7s, copr_cache_hit_ratio: 0.03, build_task_duration: 1.88ms, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:2073, total_time:1m46.5s}}, backoff{regionMiss: 2ms} | data:Selection_45 | 39.8 KB | N/A |
| │ └─Selection_45 | 0.95 | 1156059.00 | 4 | cop[tikv] | | tikv_task:{proc max:738ms, min:1ms, avg: 4.27ms, p80:5ms, p95:6ms, iters:2082, tasks:2073}, scan_detail: {total_process_keys: 446, total_process_keys_size: 6148811, total_keys: 6023444, get_snapshot_time: 21.7ms, rocksdb: {delete_skipped_count: 45, key_skipped_count: 5291387, block: {cache_hit_count: 63324}}}, time_detail: {total_process_time: 6.85s, total_suspend_time: 1.11s, total_wait_time: 1m36.7s, total_kv_read_wall_time: 7.94s, tikv_wall_time: 1m45.3s} | eq(runtime_r9d.lot_running_info.equipment_name, “ST-PVD018”) | N/A | N/A |
| │ └─TableFullScan_44 | 947.00 | 1108803.70 | 1067 | cop[tikv] | table:lot_running_info | tikv_task:{proc max:738ms, min:1ms, avg: 4.27ms, p80:5ms, p95:6ms, iters:2082, tasks:2073} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_47 | 0.95 | 81057.92 | 1 | root | | time:7.52s, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 14.3 KB | N/A |
| │ └─TableReader_50 | 0.95 | 81037.98 | 1 | root | | time:7.52s, loops:2, cop_task: {num: 2073, max: 0s, min: 0s, avg: 51.4ms, p95: 182.8ms, tot_proc: 6.95s, tot_wait: 1m36.7s, copr_cache_hit_ratio: 0.03, build_task_duration: 1.82ms, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:2073, total_time:1m46.5s}}, backoff{regionMiss: 2ms} | data:Selection_49 | 8.39 KB | N/A |
| │ └─Selection_49 | 0.95 | 1156059.00 | 1 | cop[tikv] | | tikv_task:{proc max:233ms, min:1ms, avg: 3.98ms, p80:5ms, p95:6ms, iters:2082, tasks:2073}, scan_detail: {total_process_keys: 446, total_process_keys_size: 6148811, total_keys: 6019369, get_snapshot_time: 20.4ms, rocksdb: {delete_skipped_count: 45, key_skipped_count: 5287807, block: {cache_hit_count: 63289}}}, time_detail: {total_process_time: 6.95s, total_suspend_time: 1.11s, total_wait_time: 1m36.7s, total_kv_read_wall_time: 8.05s, tikv_wall_time: 1m45.4s} | eq(runtime_r9d.lot_running_info.equipment_name, “ST-PVD017”) | N/A | N/A |
| │ └─TableFullScan_48 | 947.00 | 1108803.70 | 1067 | cop[tikv] | table:lot_running_info | tikv_task:{proc max:233ms, min:1ms, avg: 3.98ms, p80:5ms, p95:6ms, iters:2082, tasks:2073} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_51 | 0.95 | 81057.92 | 1 | root | | time:7.51s, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 28.1 KB | N/A |
| │ └─TableReader_54 | 0.95 | 81037.98 | 1 | root | | time:7.51s, loops:2, cop_task: {num: 2073, max: 0s, min: 0s, avg: 51.2ms, p95: 182.7ms, tot_proc: 6.88s, tot_wait: 1m36.6s, copr_cache_hit_ratio: 0.03, build_task_duration: 1.76ms, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:2073, total_time:1m46.1s}}, backoff{regionMiss: 2ms} | data:Selection_53 | 22.9 KB | N/A |
| │ └─Selection_53 | 0.95 | 1156059.00 | 1 | cop[tikv] | | tikv_task:{proc max:825ms, min:1ms, avg: 4.33ms, p80:5ms, p95:6ms, iters:2082, tasks:2073}, scan_detail: {total_process_keys: 446, total_process_keys_size: 6148811, total_keys: 6019294, get_snapshot_time: 24.4ms, rocksdb: {delete_skipped_count: 45, key_skipped_count: 5287745, block: {cache_hit_count: 63286}}}, time_detail: {total_process_time: 6.88s, total_suspend_time: 1.1s, total_wait_time: 1m36.6s, total_kv_read_wall_time: 7.96s, tikv_wall_time: 1m45.1s} | eq(runtime_r9d.lot_running_info.equipment_name, “ST-PVD019”) | N/A | N/A |
| │ └─TableFullScan_52 | 947.00 | 1108803.70 | 1067 | cop[tikv] | table:lot_running_info | tikv_task:{proc max:825ms, min:1ms, avg: 4.33ms, p80:5ms, p95:6ms, iters:2082, tasks:2073} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_55 | 0.95 | 81057.92 | 2 | root | | time:7.53s, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 48.1 KB | N/A |
| │ └─TableReader_58 | 0.95 | 81037.98 | 2 | root | | time:7.53s, loops:2, cop_task: {num: 2073, max: 0s, min: 0s, avg: 51.4ms, p95: 183ms, tot_proc: 6.94s, tot_wait: 1m36.7s, copr_cache_hit_ratio: 0.03, build_task_duration: 1.83ms, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:2073, total_time:1m46.6s}}, backoff{regionMiss: 2ms} | data:Selection_57 | 21.9 KB | N/A |
| │ └─Selection_57 | 0.95 | 1156059.00 | 2 | cop[tikv] | | tikv_task:{proc max:806ms, min:1ms, avg: 4.36ms, p80:5ms, p95:6ms, iters:2082, tasks:2073}, scan_detail: {total_process_keys: 446, total_process_keys_size: 6148811, total_keys: 6027051, get_snapshot_time: 45.4ms, rocksdb: {delete_skipped_count: 45, key_skipped_count: 5294546, block: {cache_hit_count: 63355}}}, time_detail: {total_process_time: 6.94s, total_suspend_time: 1.11s, total_wait_time: 1m36.7s, total_kv_read_wall_time: 8.04s, tikv_wall_time: 1m45.4s} | eq(runtime_r9d.lot_running_info.equipment_name, “ST-PVD020”) | N/A | N/A |
| │ └─TableFullScan_56 | 947.00 | 1108803.70 | 1067 | cop[tikv] | table:lot_running_info | tikv_task:{proc max:806ms, min:1ms, avg: 4.36ms, p80:5ms, p95:6ms, iters:2082, tasks:2073} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_59 | 0.95 | 81057.92 | 1 | root | | time:7.51s, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 20.1 KB | N/A |
| │ └─TableReader_62 | 0.95 | 81037.98 | 1 | root | | time:7.51s, loops:2, cop_task: {num: 2073, max: 0s, min: 0s, avg: 51.2ms, p95: 182.5ms, tot_proc: 6.85s, tot_wait: 1m36.6s, copr_cache_hit_ratio: 0.03, build_task_duration: 1.59ms, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:2073, total_time:1m46.2s}}, backoff{regionMiss: 2ms} | data:Selection_61 | 14.3 KB | N/A |
| │ └─Selection_61 | 0.95 | 1156059.00 | 1 | cop[tikv] | | tikv_task:{proc max:750ms, min:1ms, avg: 4.26ms, p80:5ms, p95:6ms, iters:2082, tasks:2073}, scan_detail: {total_process_keys: 446, total_process_keys_size: 6148811, total_keys: 6031133, get_snapshot_time: 15.9ms, rocksdb: {delete_skipped_count: 45, key_skipped_count: 5298146, block: {cache_hit_count: 63384}}}, time_detail: {total_process_time: 6.85s, total_suspend_time: 1.1s, total_wait_time: 1m36.6s, total_kv_read_wall_time: 7.9s, tikv_wall_time: 1m45.1s} | eq(runtime_r9d.lot_running_info.equipment_name, “ST-PVD023”) | N/A | N/A |
| │ └─TableFullScan_60 | 947.00 | 1108803.70 | 1067 | cop[tikv] | table:lot_running_info | tikv_task:{proc max:749ms, min:1ms, avg: 4.26ms, p80:5ms, p95:6ms, iters:2082, tasks:2073} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_63 | 0.95 | 81057.92 | 6 | root | | time:9.58s, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 72.1 KB | N/A |
| │ └─TableReader_66 | 0.95 | 81037.98 | 6 | root | | time:9.58s, loops:2, cop_task: {num: 2073, max: 0s, min: 0s, avg: 67.3ms, p95: 207.8ms, tot_proc: 7.14s, tot_wait: 2m9.6s, copr_cache_hit_ratio: 0.03, build_task_duration: 2.36ms, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:2073, total_time:2m19.4s}} | data:Selection_65 | 39.6 KB | N/A |
| │ └─Selection_65 | 0.95 | 1156059.00 | 6 | cop[tikv] | | tikv_task:{proc max:408ms, min:0s, avg: 4.34ms, p80:5ms, p95:6ms, iters:2082, tasks:2073}, scan_detail: {total_process_keys: 446, total_process_keys_size: 6148811, total_keys: 6031154, get_snapshot_time: 18ms, rocksdb: {delete_skipped_count: 14, key_skipped_count: 5298045, block: {cache_hit_count: 63397}}}, time_detail: {total_process_time: 7.14s, total_suspend_time: 1.29s, total_wait_time: 2m9.6s, total_kv_read_wall_time: 8.41s, tikv_wall_time: 2m18.6s} | eq(runtime_r9d.lot_running_info.equipment_name, “ST-PVD014”) | N/A | N/A |
| │ └─TableFullScan_64 | 947.00 | 1108803.70 | 1067 | cop[tikv] | table:lot_running_info | tikv_task:{proc max:408ms, min:0s, avg: 4.34ms, p80:5ms, p95:6ms, iters:2082, tasks:2073} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_67 | 0.95 | 81057.92 | 5 | root | | time:9.59s, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 72.1 KB | N/A |
| │ └─TableReader_70 | 0.95 | 81037.98 | 5 | root | | time:9.59s, loops:2, cop_task: {num: 2073, max: 0s, min: 0s, avg: 67.4ms, p95: 207.8ms, tot_proc: 7.08s, tot_wait: 2m9.6s, copr_cache_hit_ratio: 0.03, build_task_duration: 2.15ms, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:2073, total_time:2m19.8s}} | data:Selection_69 | 34.1 KB | N/A |
| │ └─Selection_69 | 0.95 | 1156059.00 | 5 | cop[tikv] | | tikv_task:{proc max:448ms, min:1ms, avg: 4.42ms, p80:5ms, p95:6ms, iters:2082, tasks:2073}, scan_detail: {total_process_keys: 446, total_process_keys_size: 6148811, total_keys: 6030943, get_snapshot_time: 14.8ms, rocksdb: {delete_skipped_count: 19, key_skipped_count: 5297855, block: {cache_hit_count: 63400}}}, time_detail: {total_process_time: 7.08s, total_suspend_time: 1.46s, total_wait_time: 2m9.6s, total_kv_read_wall_time: 8.54s, tikv_wall_time: 2m18.7s} | eq(runtime_r9d.lot_running_info.equipment_name, “ST-PVD024”) | N/A | N/A |
| │ └─TableFullScan_68 | 947.00 | 1108803.70 | 1067 | cop[tikv] | table:lot_running_info | tikv_task:{proc max:448ms, min:1ms, avg: 4.42ms, p80:5ms, p95:6ms, iters:2082, tasks:2073} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_71 | 0.95 | 81057.92 | 3 | root | | time:9.58s, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 83.3 KB | N/A |
| │ └─TableReader_74 | 0.95 | 81037.98 | 3 | root | | time:9.58s, loops:2, cop_task: {num: 2073, max: 0s, min: 0s, avg: 67.3ms, p95: 207.9ms, tot_proc: 7.07s, tot_wait: 2m9.7s, copr_cache_hit_ratio: 0.03, build_task_duration: 1.79ms, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:2073, total_time:2m19.6s}} | data:Selection_73 | 24.0 KB | N/A |
| │ └─Selection_73 | 0.95 | 1156059.00 | 3 | cop[tikv] | | tikv_task:{proc max:473ms, min:1ms, avg: 4.42ms, p80:5ms, p95:6ms, iters:2082, tasks:2073}, scan_detail: {total_process_keys: 446, total_process_keys_size: 6148811, total_keys: 6035046, get_snapshot_time: 27.4ms, rocksdb: {delete_skipped_count: 19, key_skipped_count: 5301465, block: {cache_hit_count: 63433}}}, time_detail: {total_process_time: 7.07s, total_suspend_time: 1.46s, total_wait_time: 2m9.7s, total_kv_read_wall_time: 8.52s, tikv_wall_time: 2m18.7s} | eq(runtime_r9d.lot_running_info.equipment_name, “ST-PVD013”) | N/A | N/A |
| │ └─TableFullScan_72 | 947.00 | 1108803.70 | 1067 | cop[tikv] | table:lot_running_info | tikv_task:{proc max:473ms, min:1ms, avg: 4.42ms, p80:5ms, p95:6ms, iters:2082, tasks:2073} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, equipment_name:unInitialized] | N/A | N/A |
| ├─Projection_75 | 0.95 | 81057.92 | 5 | root | | time:9.59s, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 104.7 KB | N/A |
| │ └─TableReader_78 | 0.95 | 81037.98 | 5 | root | | time:9.59s, loops:2, cop_task: {num: 2073, max: 0s, min: 0s, avg: 67.3ms, p95: 207.7ms, tot_proc: 7.04s, tot_wait: 2m9.8s, copr_cache_hit_ratio: 0.03, build_task_duration: 1.97ms, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:2073, total_time:2m19.5s}} | data:Selection_77 | 44.5 KB | N/A |
| │ └─Selection_77 | 0.95 | 1156059.00 | 5 | cop[tikv] | | tikv_task:{proc max:386ms, min:1ms, avg: 4.36ms, p80:5ms, p95:6ms, iters:2082, tasks:2073}, scan_detail: {total_process_keys: 446, total_process_keys_size: 6148811, total_keys: 6015622, get_snapshot_time: 24.2ms, rocksdb: {delete_skipped_count: 19, key_skipped_count: 5284407, block: {cache_hit_count: 63271}}}, time_detail: {total_process_time: 7.04s, total_suspend_time: 1.46s, total_wait_time: 2m9.8s, total_kv_read_wall_time: 8.47s, tikv_wall_time: 2m18.7s} | eq(runtime_r9d.lot_running_info.equipment_name, “ST-PVD016”) | N/A | N/A |
| │ └─TableFullScan_76 | 947.00 | 1108803.70 | 1067 | cop[tikv] | table:lot_running_info | tikv_task:{proc max:386ms, min:1ms, avg: 4.36ms, p80:5ms, p95:6ms, iters:2082, tasks:2073} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, equipment_name:unInitialized] | N/A | N/A |
| └─Projection_79 | 0.95 | 81057.92 | 1 | root | | time:9.59s, loops:2, Concurrency:OFF | runtime_r9d.lot_running_info.equipment_name->Column#281, runtime_r9d.lot_running_info.name->Column#282, runtime_r9d.lot_running_info.carrier_name->Column#283, runtime_r9d.lot_running_info.batch_id->Column#284, runtime_r9d.lot_running_info.job_in_txn_time->Column#285, runtime_r9d.lot_running_info.process_start_time->Column#286, runtime_r9d.lot_running_info.process_end_time->Column#287, runtime_r9d.lot_running_info.process_type->Column#288, runtime_r9d.lot_running_info.processed_wafer_cnt->Column#289, runtime_r9d.lot_running_info.qty->Column#290, runtime_r9d.lot_running_info.remaining_wafer_cnt->Column#291, cast(runtime_r9d.lot_running_info.run_wafer_infos, json BINARY)->Column#292, cast(runtime_r9d.lot_running_info.wafer_chamber_infos, json BINARY)->Column#293 | 27.3 KB | N/A |
| └─TableReader_82 | 0.95 | 81037.98 | 1 | root | | time:9.59s, loops:2, cop_task: {num: 2073, max: 0s, min: 0s, avg: 67.4ms, p95: 208.3ms, tot_proc: 7.11s, tot_wait: 2m9.7s, copr_cache_hit_ratio: 0.03, build_task_duration: 2.02ms, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:2073, total_time:2m19.7s}} | data:Selection_81 | 20.4 KB | N/A |
| └─Selection_81 | 0.95 | 1156059.00 | 1 | cop[tikv] | | tikv_task:{proc max:391ms, min:1ms, avg: 4.41ms, p80:5ms, p95:6ms, iters:2082, tasks:2073}, scan_detail: {total_process_keys: 446, total_process_keys_size: 6148811, total_keys: 6035046, get_snapshot_time: 17.4ms, rocksdb: {delete_skipped_count: 19, key_skipped_count: 5301465, block: {cache_hit_count: 63434}}}, time_detail: {total_process_time: 7.11s, total_suspend_time: 1.46s, total_wait_time: 2m9.7s, total_kv_read_wall_time: 8.56s, tikv_wall_time: 2m18.8s} | eq(runtime_r9d.lot_running_info.equipment_name, “ST-PVD015”) | N/A | N/A |
| └─TableFullScan_80 | 947.00 | 1108803.70 | 1067 | cop[tikv] | table:lot_running_info | tikv_task:{proc max:391ms, min:1ms, avg: 4.41ms, p80:5ms, p95:6ms, iters:2082, tasks:2073} | keep order:false, stats:partial[idx_name_equipment_name_carrier_name:unInitialized, equipment_name:unInitialized] | N/A | N/A |
1 个赞
这个异常的好像全走的全表扫描，没用到索引。
试试固定下执行计划加个hint。
感觉上是读写热点的问题，参考这个排查看看
https://docs.pingcap.com/zh/tidb/stable/troubleshoot-hot-spot-issues/#tidb-热点问题处理
就是执行计划变了，lot_running_info这个表虽然行数不多，但是自关联了很多次，建议你收集下统计信息先
内存使用率有点高了。
可能是因为缓存命中率太差了
现有的分布式数据库，其实写还好。读的路径有点长。若不能在cache命中，性能就会下滑
读慢：先看执行计划
再做统计信息收集
再看缓存命中
感谢 各位大哥分享经验
很奇怪的一点就是我啥都没操作。 这个执行计划似乎被系统删除了。
之后又生成了新的任务计划。
昨天开始的压测，目前为止之前查询慢的问题又不见了。
这个是不是和GC回收有关系
想要再去看这个计划任务发现已经被删除了。
是的。慢的那个计划任务，执行了几十次的全表扫描
感谢，一直不知道这个可视图居然是这样使用。
