【问题】
表中只有7条数据,执行时间超过2s:
执行计算:
id task estRows operator info actRows execution info memory disk
TableReader_7 root 8000 data:Selection_6 4 time:19.844061ms, loops:2, cop_task: {num: 1, max:17.091369ms, proc_keys: 7, rpc_num: 2, rpc_time: 16.980702ms, copr_cache_hit_ratio: 0.00} 485 Bytes N/A
└─Selection_6 cop[tikv] 8000 or(or(or(eq(mqtt.mqtt_acl.ipaddr, “192.168.248.16”), eq(mqtt.mqtt_acl.username, “xzzh”)), eq(mqtt.mqtt_acl.username, “$all”)), eq(mqtt.mqtt_acl.clientid, “011_1_0000_19216824816”)) 4 time:0s, loops:1 N/A N/A
└─TableScan_5 cop[tikv] 10000 table:mqtt_acl, range:[0,+inf], keep order:false, stats:pseudo 7 time:0s, loops:1 N/A N/A
这种问题,该如何分析时间消耗在哪里呢?