Doris 4.0.5 查询冷数据超级慢，查磁盘数据是1s左右，查询s3是10倍不止

PROPERTIES (
"file_cache_ttl_seconds" = "172800",
"bloom_filter_columns" = "device_sn",
"is_being_synced" = "false",
"partition.retention_count" = "3650",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V3",
"compression" = "LZ4F",
"enable_unique_key_merge_on_write" = "true",
"enable_unique_key_skip_bitmap_column" = "true",
"light_schema_change" = "true",
"storage_vault_id" = "1",
"storage_vault_name" = "prod_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"
);
Unique 表，按主键和分区建查询

把profile 给AI分析：