【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
【复现路径】做过哪些操作出现的问题
【遇到的问题：问题现象及影响】
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件：截图/日志/监控】
主键查询语句为啥会这么慢
SELECT
cast(
aes_decrypt(xxx
from_base64(xxx),
'xxx',
'xxx'
) AS char
) AS contact1,
还有三个字段...
resident_city,
resident_address,
company_name,
company_city,
company_address
FROM
a
WHERE
account_id = 220812010051109359
LIMIT
1;
表结构
执行计划：
id task estRows operator info actRows execution info memory disk
Projection_7 root 1 cast函数加解处理 1 time:358.8ms, loops:2, Concurrency:OFF 45.0 KB N/A
└─Limit_8 root 1 offset:0, count:1 1 time:358.8ms, loops:2 N/A N/A
└─Point_Get_10 root 1 table:a, handle:220812010051109359 1 time:358.8ms, loops:1, Get:{num_rpc:1, total_time:358.7ms}, total_wait_time: 357ms, tikv_wall_time: 358.5ms, scan_detail: {total_process_keys: 1, total_process_keys_size: 462, total_keys: 1, get_snapshot_time: 9.16µs, rocksdb: {block: {cache_hit_count: 14}}} N/A N/A
