3.0.5 UNIQUE KEY sql 超级慢 WaitForData0: avg 6sec474ms

表 dws.dws_pop 一共有93067条数据

表结构如下：

CREATE TABLE `dws_pop` (
  `pop_id` bigint NULL COMMENT "POPID",
  `tag` varchar(100) NULL COMMENT "标签,pop_new:新入住卖家,pop_revival:当前月1号的前三个月没有销量卖家,pop_common:当前月1号的前三个月有销量卖家"
) ENGINE = OLAP UNIQUE KEY(`pop_id`) DISTRIBUTED BY HASH(`pop_id`) BUCKETS 1 PROPERTIES (
  "file_cache_ttl_seconds" = "86400",
  "is_being_synced" = "false",
  "storage_medium" = "hdd",
  "storage_format" = "V2",
  "inverted_index_storage_format" = "V2",
  "enable_unique_key_merge_on_write" = "true",
  "light_schema_change" = "true",
  "storage_vault_id" = "1",
  "storage_vault_name" = "s3_vault",
  "disable_auto_compaction" = "false",
  "enable_single_replica_compaction" = "false",
  "group_commit_interval_ms" = "10000",
  "group_commit_data_bytes" = "134217728",
  "enable_mow_light_delete" = "false"
);

SELECT pop_id,tag FROM dws.dws_pop WHERE pop_id IN (12550,138737,1...,150724)

in 查询 222条数据