边城元元:
explain analyze。
不带order by,0.018秒,我上面描述不带orderby写错了
‘Limit_9’, ‘1.00’, ‘1’, ‘root’, ‘’, ‘time:4.01ms, loops:2’, ‘offset:0, count:1’, ‘N/A’, ‘N/A’
‘└─IndexLookUp_21’, ‘1.00’, ‘1’, ‘root’, ‘’, ‘time:4.01ms, loops:1, index_task: {total_time: 3.89ms, fetch_handle: 1.85ms, build: 7.66µs, wait: 2.03ms}, table_task: {total_time: 13.8ms, num: 8, concurrency: 5}’, ‘’, ‘214.9 KB’, ‘N/A’
’ ├─IndexRangeScan_14(Build)’, ‘1.00’, ‘19729’, ‘cop[tikv]’, ‘table:s, index:adas_gpsdata_deviceSn(deviceSn)’, ‘time:1.49ms, loops:9, cop_task: {num: 1, max: 1.32ms, proc_keys: 0, rpc_num: 1, rpc_time: 1.3ms, copr_cache_hit_ratio: 1.00}, tikv_task:{time:11ms, loops:24}’, ‘range:[“89860621260050021369”,“89860621260050021369”], keep order:false’, ‘N/A’, ‘N/A’
’ └─Limit_20(Probe)’, ‘1.00’, ‘4’, ‘cop[tikv]’, ‘’, ‘time:9.52ms, loops:12, cop_task: {num: 4, max: 1.94ms, min: 1.65ms, avg: 1.82ms, p95: 1.94ms, max_proc_keys: 32, p95_proc_keys: 32, rpc_num: 4, rpc_time: 7.23ms, copr_cache_hit_ratio: 0.00}, tikv_task:{proc max:0s, min:0s, p80:0s, p95:0s, iters:4, tasks:4}, scan_detail: {total_process_keys: 128, total_process_keys_size: 20506, total_keys: 256, rocksdb: {delete_skipped_count: 0, key_skipped_count: 128, block: {cache_hit_count: 274, read_count: 0, read_byte: 0 Bytes}}}’, ‘offset:0, count:1’, ‘N/A’, ‘N/A’
’ └─Selection_16’, ‘1.00’, ‘128’, ‘cop[tikv]’, ‘’, ‘tikv_task:{proc max:0s, min:0s, p80:0s, p95:0s, iters:4, tasks:4}’, ‘lt(eplate.eplate_gpsdata.occurtime, 2022-03-07 17:35:54.000000)’, ‘N/A’, ‘N/A’
’ └─TableRowIDScan_15’, ‘1.00’, ‘128’, ‘cop[tikv]’, ‘table:s’, ‘tikv_task:{proc max:0s, min:0s, p80:0s, p95:0s, iters:4, tasks:4}’, ‘keep order:false’, ‘N/A’, ‘N/A’