为了更快的定位您的问题，请提供以下信息，谢谢
【详述】模型查询比精确查询快，不知道原因，profile分别如下：
精确查询（慢）
{
"Query": {
"Summary": {
"Query ID": "c192aa5f-06f3-11f1-8d53-fa163eb635f1",
"Start Time": "2026-02-11 10:45:41",
"End Time": "2026-02-11 10:46:03",
"Total": "21s839ms",
"Query Type": "Query",
"Query State": "Finished",
"StarRocks Version": "3.3.18-UNKNOWN",
"User": "root",
"Default Db": "idata",
"Sql Statement": "SELECT `key` as `key`, `col1` as `col1`, `col2` as `col2`, `col3` as `col3`, `col4` as `col4`, `col5` as `col5`, `col6` as `col6`, `col7` as `col7`, `col8` as `col8`, `col9` as `col9`, `col10` as `col10`, `col11` as `col11`, `dt` as `dt`, `col12` as `col12`FROM `table_1` WHERE (`col6` like 'AAA' AND `dt` >= '20260101' AND `dt` <= '20260131') LIMIT 100 OFFSET 0",
"Variables": "parallel_fragment_exec_instance_num=1,max_parallel_scan_instance_num=-1,pipeline_dop=0,enable_adaptive_sink_dop=true,enable_runtime_adaptive_dop=false,runtime_profile_report_interval=10,resource_group=default_mv_wg",
"NonDefaultSessionVariables": "{\"resource_group\":{\"defaultValue\":\"\",\"actualValue\":\"default_mv_wg\"},\"enable_adaptive_sink_dop\":{\"defaultValue\":false,\"actualValue\":true},\"enable_profile\":{\"defaultValue\":false,\"actualValue\":true}}",
"Collect Profile Time": "1ms",
"IsProfileAsync": "true"
},
"Planner": {
"-- Parser[1] 0": "",
"-- Total[1] 8ms": "",
" -- Analyzer[1] 0": "",
" -- Lock[1] 0": "",
" -- AnalyzeDatabase[1] 0": "",
" -- AnalyzeTemporaryTable[1] 0": "",
" -- AnalyzeTable[1] 0": "",
" -- Transformer[1] 1ms": "",
" -- Optimizer[1] 4ms": "",
" -- MVPreprocess[1] 0": "",
" -- MVTextRewrite[1] 0": "",
" -- RuleBaseOptimize[1] 3ms": "",
" -- CostBaseOptimize[1] 0": "",
" -- PhysicalRewrite[1] 0": "",
" -- PlanValidate[1] 0": "",
" -- InputDependenciesChecker[1] 0": "",
" -- TypeChecker[1] 0": "",
" -- CTEUniqueChecker[1] 0": "",
" -- ColumnReuseChecker[1] 0": "",
" -- ExecPlanBuild[1] 0": "",
"-- Pending[1] 0": "",
"-- Prepare[1] 0": "",
"-- Deploy[1] 6ms": "",
" -- DeployLockInternalTime[1] 6ms": "",
" -- DeploySerializeConcurrencyTime[2] 0": "",
" -- DeployStageByStageTime[6] 0": "",
" -- DeployWaitTime[6] 4ms": "",
" -- DeployAsyncSendTime[2] 0": "",
"DeployDataSize": "13517",
"Reason": {}
},
"Execution": {
"Topology": "{\"rootId\":1,\"nodes\":[{\"id\":1,\"name\":\"EXCHANGE\",\"properties\":{\"sinkIds\":[],\"displayMem\":true},\"children\":[0]},{\"id\":0,\"name\":\"OLAP_SCAN\",\"properties\":{\"sinkIds\":[1],\"displayMem\":false},\"children\":[]}]}",
"FrontendProfileMergeTime": "2.042ms",
"QueryAllocatedMemoryUsage": "9.894 GB",
"QueryCumulativeCpuTime": "535.435ms",
"QueryCumulativeNetworkTime": "865.533us",
"QueryCumulativeOperatorTime": "21s818ms",
"QueryCumulativeScanTime": "21s809ms",
"QueryDeallocatedMemoryUsage": "9.892 GB",
"QueryExecutionWallTime": "21s822ms",
"QueryPeakMemoryUsagePerNode": "35.120 MB",
"QueryPeakScheduleTime": "4.663ms",
"QuerySpillBytes": "0.000 B",
"QuerySumMemoryUsage": "35.120 MB",
"ResultDeliverTime": "0ns",
"Fragment 0": {
"BackendAddresses": "host1:9060",
"InstanceIds": "c192aa5f-06f3-11f1-8d53-fa163eb635f2",
"BackendNum": "1",
"BackendProfileMergeTime": "619.386us",
"InitialProcessDriverCount": "0",
"InitialProcessMem": "219.672 MB",
"InstanceAllocatedMemoryUsage": "918.469 KB",
"InstanceDeallocatedMemoryUsage": "696.516 KB",
"InstanceNum": "1",
"InstancePeakMemoryUsage": "258.523 KB",
"QueryMemoryLimit": "-1.000 B",
"Pipeline (id=0)": {
"isGroupExecution": "false",
"ActiveTime": "53.869us",
"__MAX_OF_ActiveTime": "345.347us",
"__MIN_OF_ActiveTime": "8.230us",
"BlockByInputEmpty": "0",
"BlockByOutputFull": "0",
"BlockByPrecondition": "0",
"DegreeOfParallelism": "8",
"DriverTotalTime": "21s819ms",
"__MAX_OF_DriverTotalTime": "21s820ms",
"__MIN_OF_DriverTotalTime": "21s819ms",
"PeakDriverQueueSize": "43",
"__MAX_OF_PeakDriverQueueSize": "7",
"__MIN_OF_PeakDriverQueueSize": "2",
"PendingTime": "21s818ms",
"__MAX_OF_PendingTime": "21s819ms",
"__MIN_OF_PendingTime": "21s818ms",
"InputEmptyTime": "21s819ms",
"__MAX_OF_InputEmptyTime": "21s819ms",
"__MIN_OF_InputEmptyTime": "21s819ms",
"FirstInputEmptyTime": "21s819ms",
"__MAX_OF_FirstInputEmptyTime": "21s819ms",
"__MIN_OF_FirstInputEmptyTime": "21s819ms",
"ScheduleCount": "8",
"__MAX_OF_ScheduleCount": "1",
"__MIN_OF_ScheduleCount": "1",
"TotalDegreeOfParallelism": "8",
"YieldByLocalWait": "0",
"YieldByPreempt": "0",
"YieldByTimeLimit": "0",
"RESULT_SINK (plan_node_id=-1)": {
"CommonMetrics": {
"IsFinalSink": "",
"OperatorTotalTime": "35.191us",
"__MAX_OF_OperatorTotalTime": "261.479us",
"__MIN_OF_OperatorTotalTime": "1.461us",
"PullChunkNum": "0",
"PullRowNum": "0",
"PullTotalTime": "0ns",
"PushChunkNum": "1",
"__MAX_OF_PushChunkNum": "1",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "100",
"__MAX_OF_PushRowNum": "100",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "32.524us",
"__MAX_OF_PushTotalTime": "260.193us",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {
"result sink": {
"AppendChunkTime": "14.808us",
"__MAX_OF_AppendChunkTime": "118.464us",
"__MIN_OF_AppendChunkTime": "0ns",
"ResultRendTime": "17.281us",
"__MAX_OF_ResultRendTime": "138.248us",
"__MIN_OF_ResultRendTime": "0ns",
"TupleConvertTime": "13.308us",
"__MAX_OF_TupleConvertTime": "106.467us",
"__MIN_OF_TupleConvertTime": "0ns",
"NumSentRows": "100",
"__MAX_OF_NumSentRows": "100",
"__MIN_OF_NumSentRows": "0"
}
}
},
"CHUNK_ACCUMULATE (plan_node_id=-1)": {
"CommonMetrics": {
"IsSubordinate": "",
"OperatorTotalTime": "1.647us",
"__MAX_OF_OperatorTotalTime": "6.060us",
"__MIN_OF_OperatorTotalTime": "758ns",
"PullChunkNum": "1",
"__MAX_OF_PullChunkNum": "1",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "100",
"__MAX_OF_PullRowNum": "100",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "12ns",
"__MAX_OF_PullTotalTime": "96ns",
"__MIN_OF_PullTotalTime": "0ns",
"PushChunkNum": "1",
"__MAX_OF_PushChunkNum": "1",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "100",
"__MAX_OF_PushRowNum": "100",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "654ns",
"__MAX_OF_PushTotalTime": "5.236us",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {}
},
"LIMIT (plan_node_id=1) (operator id=1)": {
"CommonMetrics": {
"OperatorTotalTime": "741ns",
"__MAX_OF_OperatorTotalTime": "1.654us",
"__MIN_OF_OperatorTotalTime": "445ns",
"PullChunkNum": "1",
"__MAX_OF_PullChunkNum": "1",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "100",
"__MAX_OF_PullRowNum": "100",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "31ns",
"__MAX_OF_PullTotalTime": "250ns",
"__MIN_OF_PullTotalTime": "0ns",
"PushChunkNum": "1",
"__MAX_OF_PushChunkNum": "1",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "100",
"__MAX_OF_PushRowNum": "100",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "96ns",
"__MAX_OF_PushTotalTime": "772ns",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {}
},
"EXCHANGE_SOURCE (plan_node_id=1)": {
"CommonMetrics": {
"ConjunctsInputRows": "100",
"ConjunctsOutputRows": "100",
"ConjunctsTime": "2.163us",
"JoinRuntimeFilterEvaluate": "0",
"JoinRuntimeFilterHashTime": "0ns",
"JoinRuntimeFilterInputRows": "0",
"JoinRuntimeFilterOutputRows": "0",
"JoinRuntimeFilterTime": "0ns",
"OperatorTotalTime": "17.869us",
"__MAX_OF_OperatorTotalTime": "45.183us",
"__MIN_OF_OperatorTotalTime": "7.446us",
"PullChunkNum": "1",
"__MAX_OF_PullChunkNum": "1",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "100",
"__MAX_OF_PullRowNum": "100",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "5.492us",
"__MAX_OF_PullTotalTime": "43.941us",
"__MIN_OF_PullTotalTime": "0ns",
"PushChunkNum": "0",
"PushRowNum": "0",
"PushTotalTime": "0ns",
"RuntimeBloomFilterNum": "0",
"RuntimeInFilterNum": "0"
},
"UniqueMetrics": {
"BufferUnplugCount": "0",
"BytesPassThrough": "29.430 KB",
"__MAX_OF_BytesPassThrough": "29.430 KB",
"__MIN_OF_BytesPassThrough": "0.000 B",
"BytesReceived": "0.000 B",
"ClosureBlockCount": "0",
"ClosureBlockTime": "0ns",
"DecompressChunkTime": "0ns",
"DeserializeChunkTime": "0ns",
"PeakBufferMemoryBytes": "29.430 KB",
"__MAX_OF_PeakBufferMemoryBytes": "29.430 KB",
"__MIN_OF_PeakBufferMemoryBytes": "0.000 B",
"ReceiverProcessTotalTime": "3.898us",
"__MAX_OF_ReceiverProcessTotalTime": "25.106us",
"__MIN_OF_ReceiverProcessTotalTime": "0ns",
"RequestReceived": "2",
"__MAX_OF_RequestReceived": "1",
"__MIN_OF_RequestReceived": "0",
"WaitLockTime": "0ns"
}
}
}
},
"Fragment 1": {
"BackendAddresses": "host1:9060",
"InstanceIds": "c192aa5f-06f3-11f1-8d53-fa163eb635f3",
"BackendNum": "1",
"BackendProfileMergeTime": "1.172ms",
"InitialProcessDriverCount": "8",
"InitialProcessMem": "220.455 MB",
"InstanceAllocatedMemoryUsage": "9.893 GB",
"InstanceDeallocatedMemoryUsage": "9.891 GB",
"InstanceNum": "1",
"InstancePeakMemoryUsage": "34.864 MB",
"QueryMemoryLimit": "-1.000 B",
"Pipeline (id=0)": {
"isGroupExecution": "false",
"ActiveTime": "183.184us",
"BlockByInputEmpty": "0",
"BlockByOutputFull": "0",
"BlockByPrecondition": "0",
"DegreeOfParallelism": "1",
"DriverTotalTime": "255.131us",
"PeakDriverQueueSize": "0",
"ScheduleCount": "1",
"TotalDegreeOfParallelism": "1",
"YieldByLocalWait": "0",
"YieldByPreempt": "0",
"YieldByTimeLimit": "0",
"NOOP_SINK (plan_node_id=0)": {
"CommonMetrics": {
"IsSubordinate": "",
"OperatorTotalTime": "549ns",
"PullChunkNum": "0",
"PullRowNum": "0",
"PullTotalTime": "0ns",
"PushChunkNum": "0",
"PushRowNum": "0",
"PushTotalTime": "0ns"
},
"UniqueMetrics": {}
},
"OLAP_SCAN_PREPARE (plan_node_id=0)": {
"CommonMetrics": {
"IsSubordinate": "",
"OperatorTotalTime": "180.017us",
"PullChunkNum": "0",
"PullRowNum": "0",
"PullTotalTime": "173.715us",
"PushChunkNum": "0",
"PushRowNum": "0",
"PushTotalTime": "0ns",
"RuntimeBloomFilterNum": "0",
"RuntimeInFilterNum": "0"
},
"UniqueMetrics": {
"CaptureTabletRowsetsTime": "99.566us"
}
}
},
"Pipeline (id=1)": {
"isGroupExecution": "false",
"ActiveTime": "2.957ms",
"__MAX_OF_ActiveTime": "6.916ms",
"__MIN_OF_ActiveTime": "1.370ms",
"BlockByInputEmpty": "8",
"__MAX_OF_BlockByInputEmpty": "1",
"__MIN_OF_BlockByInputEmpty": "1",
"BlockByOutputFull": "0",
"BlockByPrecondition": "0",
"DegreeOfParallelism": "8",
"DriverTotalTime": "21s816ms",
"__MAX_OF_DriverTotalTime": "21s816ms",
"__MIN_OF_DriverTotalTime": "21s816ms",
"OverheadTime": "2.753ms",
"__MAX_OF_OverheadTime": "6.711ms",
"__MIN_OF_OverheadTime": "1.162ms",
"PeakDriverQueueSize": "84",
"__MAX_OF_PeakDriverQueueSize": "14",
"__MIN_OF_PeakDriverQueueSize": "7",
"PendingTime": "21s811ms",
"__MAX_OF_PendingTime": "21s814ms",
"__MIN_OF_PendingTime": "21s805ms",
"InputEmptyTime": "12s601ms",
"__MAX_OF_InputEmptyTime": "21s809ms",
"__MIN_OF_InputEmptyTime": "9s438ms",
"FollowupInputEmptyTime": "12s601ms",
"__MAX_OF_FollowupInputEmptyTime": "21s808ms",
"__MIN_OF_FollowupInputEmptyTime": "9s438ms",
"PendingFinishTime": "9s211ms",
"__MAX_OF_PendingFinishTime": "12s375ms",
"__MIN_OF_PendingFinishTime": "166.493us",
"ScheduleCount": "16",
"__MAX_OF_ScheduleCount": "2",
"__MIN_OF_ScheduleCount": "2",
"ScheduleTime": "1.628ms",
"__MAX_OF_ScheduleTime": "4.663ms",
"__MIN_OF_ScheduleTime": "587.831us",
"TotalDegreeOfParallelism": "8",
"YieldByLocalWait": "0",
"YieldByPreempt": "0",
"YieldByTimeLimit": "0",
"EXCHANGE_SINK (plan_node_id=1)": {
"CommonMetrics": {
"OperatorTotalTime": "74.049us",
"__MAX_OF_OperatorTotalTime": "283.201us",
"__MIN_OF_OperatorTotalTime": "13.548us",
"PullChunkNum": "0",
"PullRowNum": "0",
"PullTotalTime": "0ns",
"PushChunkNum": "1",
"__MAX_OF_PushChunkNum": "1",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "100",
"__MAX_OF_PushRowNum": "100",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "11.251us",
"__MAX_OF_PushTotalTime": "90.015us",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {
"ChannelNum": "1",
"DestFragments": "c192aa5f06f311f1-8d53fa163eb635f2",
"DestID": "1",
"PartType": "UNPARTITIONED",
"BytesPassThrough": "29.430 KB",
"__MAX_OF_BytesPassThrough": "29.430 KB",
"__MIN_OF_BytesPassThrough": "0.000 B",
"BytesSent": "0.000 B",
"BytesUnsent": "0.000 B",
"CompressTime": "0ns",
"CompressedBytes": "0.000 B",
"NetworkBandwidth": "0.000 B/sec",
"NetworkTime": "865.533us",
"OverallThroughput": "0.000 B/sec",
"OverallTime": "12s375ms",
"PassThroughBufferPeakMemoryUsage": "0.000 B",
"RequestSent": "0",
"RequestUnsent": "0",
"RpcAvgTime": "432.766us",
"RpcCount": "2",
"SenderInputBytes": "0.000 B",
"SerializeChunkTime": "0ns",
"SerializedBytes": "0.000 B",
"ShuffleChunkAppendCounter": "0",
"ShuffleChunkAppendTime": "0ns",
"ShuffleHashTime": "0ns",
"WaitTime": "840.747us"
}
},
"CHUNK_ACCUMULATE (plan_node_id=0)": {
"CommonMetrics": {
"IsSubordinate": "",
"OperatorTotalTime": "2.538us",
"__MAX_OF_OperatorTotalTime": "3.157us",
"__MIN_OF_OperatorTotalTime": "2.133us",
"PullChunkNum": "1",
"__MAX_OF_PullChunkNum": "1",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "100",
"__MAX_OF_PullRowNum": "100",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "12ns",
"__MAX_OF_PullTotalTime": "97ns",
"__MIN_OF_PullTotalTime": "0ns",
"PushChunkNum": "1",
"__MAX_OF_PushChunkNum": "1",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "100",
"__MAX_OF_PushRowNum": "100",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "216ns",
"__MAX_OF_PushTotalTime": "1.732us",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {}
},
"LIMIT (plan_node_id=0) (operator id=3)": {
"CommonMetrics": {
"OperatorTotalTime": "1.120us",
"__MAX_OF_OperatorTotalTime": "5.023us",
"__MIN_OF_OperatorTotalTime": "424ns",
"PullChunkNum": "1",
"__MAX_OF_PullChunkNum": "1",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "100",
"__MAX_OF_PullRowNum": "100",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "19ns",
"__MAX_OF_PullTotalTime": "157ns",
"__MIN_OF_PullTotalTime": "0ns",
"PushChunkNum": "1",
"__MAX_OF_PushChunkNum": "1",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "3.072K (3072)",
"__MAX_OF_PushRowNum": "3.072K (3072)",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "565ns",
"__MAX_OF_PushTotalTime": "4.526us",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {}
},
"OLAP_SCAN (plan_node_id=0)": {
"CommonMetrics": {
"JoinRuntimeFilterEvaluate": "0",
"JoinRuntimeFilterHashTime": "0ns",
"JoinRuntimeFilterInputRows": "0",
"JoinRuntimeFilterOutputRows": "0",
"JoinRuntimeFilterTime": "0ns",
"OperatorTotalTime": "3.260ms",
"__MAX_OF_OperatorTotalTime": "7.230ms",
"__MIN_OF_OperatorTotalTime": "1.633ms",
"PullChunkNum": "1",
"__MAX_OF_PullChunkNum": "1",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "3.072K (3072)",
"__MAX_OF_PullRowNum": "3.072K (3072)",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "2.695ms",
"__MAX_OF_PullTotalTime": "6.698ms",
"__MIN_OF_PullTotalTime": "1.149ms",
"PushChunkNum": "0",
"PushRowNum": "0",
"PushTotalTime": "0ns",
"RuntimeBloomFilterNum": "0",
"RuntimeInFilterNum": "0"
},
"UniqueMetrics": {
"MorselQueueType": "fixed_morsel_queue",
"Predicates": "9: col6 = 'AAA', 2: dt <= 20260131",
"Rollup": "tb_event_acs",
"SharedScan": "False",
"Table": "tb_event_acs",
"AccessPathHits": "0",
"AccessPathUnhits": "0",
"BytesRead": "117.040 MB",
"__MAX_OF_BytesRead": "7.028 MB",
"__MIN_OF_BytesRead": "0.000 B",
"CachedPagesNum": "0",
"ChunkBufferCapacity": "512",
"CompressedBytesRead": "4.464 GB",
"__MAX_OF_CompressedBytesRead": "273.641 MB",
"__MIN_OF_CompressedBytesRead": "0.000 B",
"DefaultChunkBufferCapacity": "172",
"IOTaskExecTime": "6s495ms",
"__MAX_OF_IOTaskExecTime": "14s926ms",
"__MIN_OF_IOTaskExecTime": "0ns",
"CreateSegmentIter": "43.992us",
"__MAX_OF_CreateSegmentIter": "140.894us",
"__MIN_OF_CreateSegmentIter": "0ns",
"DictDecode": "164.576us",
"__MAX_OF_DictDecode": "430.226us",
"__MIN_OF_DictDecode": "88.508us",
"GetDelVec": "2.822us",
"__MAX_OF_GetDelVec": "22.017us",
"__MIN_OF_GetDelVec": "0ns",
"GetDeltaColumnGroup": "4.083us",
"__MAX_OF_GetDeltaColumnGroup": "31.617us",
"__MIN_OF_GetDeltaColumnGroup": "0ns",
"GetRowsets": "243ns",
"__MAX_OF_GetRowsets": "1.251us",
"__MIN_OF_GetRowsets": "0ns",
"IOTime": "6s425ms",
"__MAX_OF_IOTime": "14s797ms",
"__MIN_OF_IOTime": "0ns",
"LateMaterialize": "12s198ms",
"__MAX_OF_LateMaterialize": "14s916ms",
"__MIN_OF_LateMaterialize": "9s424ms",
"ReadPKIndex": "0ns",
"SegmentInit": "236.763us",
"__MAX_OF_SegmentInit": "658.687us",
"__MIN_OF_SegmentInit": "0ns",
"BitmapIndexFilter": "32.494us",
"__MAX_OF_BitmapIndexFilter": "137.401us",
"__MIN_OF_BitmapIndexFilter": "0ns",
"BitmapIndexFilterRows": "46.599M (46599129)",
"__MAX_OF_BitmapIndexFilterRows": "2.746M (2745955)",
"__MIN_OF_BitmapIndexFilterRows": "0",
"BitmapIndexIteratorInit": "2.328us",
"__MAX_OF_BitmapIndexIteratorInit": "6.509us",
"__MIN_OF_BitmapIndexIteratorInit": "0ns",
"BloomFilterFilter": "290ns",
"__MAX_OF_BloomFilterFilter": "1.049us",
"__MIN_OF_BloomFilterFilter": "0ns",
"BloomFilterFilterRows": "0",
"ColumnIteratorInit": "44.052us",
"__MAX_OF_ColumnIteratorInit": "135.796us",
"__MIN_OF_ColumnIteratorInit": "0ns",
"GinFilter": "0ns",
"GinFilterRows": "0",
"RemainingRowsAfterShortKeyFilter": "46.599M (46599129)",
"__MAX_OF_RemainingRowsAfterShortKeyFilter": "2.746M (2745955)",
"__MIN_OF_RemainingRowsAfterShortKeyFilter": "0",
"SegmentRuntimeZoneMapFilterRows": "0",
"SegmentZoneMapFilterRows": "0",
"ShortKeyFilter": "67.801us",
"__MAX_OF_ShortKeyFilter": "271.762us",
"__MIN_OF_ShortKeyFilter": "0ns",
"ShortKeyFilterRows": "0",
"ShortKeyRangeNumber": "0",
"ZoneMapIndexFilterRows": "0",
"ZoneMapIndexFiter": "34.608us",
"__MAX_OF_ZoneMapIndexFiter": "109.539us",
"__MIN_OF_ZoneMapIndexFiter": "0ns",
"SegmentRead": "8.015ms",
"__MAX_OF_SegmentRead": "33.711ms",
"__MIN_OF_SegmentRead": "0ns",
"BlockFetch": "6.927ms",
"__MAX_OF_BlockFetch": "28.060ms",
"__MIN_OF_BlockFetch": "0ns",
"BlockFetchCount": "12.093K (12093)",
"__MAX_OF_BlockFetchCount": "731",
"__MIN_OF_BlockFetchCount": "0",
"BlockSeek": "186.129us",
"__MAX_OF_BlockSeek": "523.168us",
"__MIN_OF_BlockSeek": "0ns",
"BlockSeekCount": "3.275K (3275)",
"__MAX_OF_BlockSeekCount": "197",
"__MIN_OF_BlockSeekCount": "0",
"ChunkCopy": "314.954us",
"__MAX_OF_ChunkCopy": "1.739ms",
"__MIN_OF_ChunkCopy": "0ns",
"DecompressT": "16.433ms",
"__MAX_OF_DecompressT": "39.253ms",
"__MIN_OF_DecompressT": "0ns",
"DelVecFilterRows": "0",
"PredFilter": "462.555us",
"__MAX_OF_PredFilter": "3.093ms",
"__MIN_OF_PredFilter": "0ns",
"PredFilterRows": "26.760M (26759751)",
"__MAX_OF_PredFilterRows": "1.612M (1611502)",
"__MIN_OF_PredFilterRows": "0",
"RowsetsReadCount": "17",
"__MAX_OF_RowsetsReadCount": "1",
"__MIN_OF_RowsetsReadCount": "0",
"SegmentsReadCount": "34",
"__MAX_OF_SegmentsReadCount": "2",
"__MIN_OF_SegmentsReadCount": "0",
"TotalColumnsDataPageCount": "198.481K (198481)",
"__MAX_OF_TotalColumnsDataPageCount": "11.697K (11697)",
"__MIN_OF_TotalColumnsDataPageCount": "0",
"IOTaskWaitTime": "6s109ms",
"__MAX_OF_IOTaskWaitTime": "14s926ms",
"__MIN_OF_IOTaskWaitTime": "64.374us",
"MorselsCount": "32",
"__MAX_OF_MorselsCount": "4",
"__MIN_OF_MorselsCount": "4",
"PeakChunkBufferMemoryUsage": "0.000 B",
"PeakChunkBufferSize": "0",
"PeakIOTasks": "4",
"PeakScanTaskQueueSize": "88",
"__MAX_OF_PeakScanTaskQueueSize": "18",
"__MIN_OF_PeakScanTaskQueueSize": "7",
"PrepareChunkSourceTime": "1.200ms",
"__MAX_OF_PrepareChunkSourceTime": "1.514ms",
"__MIN_OF_PrepareChunkSourceTime": "900.498us",
"PushdownAccessPaths": "0",
"PushdownPredicates": "2",
"RawRowsRead": "26.812M (26811985)",
"__MAX_OF_RawRowsRead": "1.615M (1614574)",
"__MIN_OF_RawRowsRead": "0",
"ReadPagesNum": "94.498K (94498)",
"__MAX_OF_ReadPagesNum": "5.657K (5657)",
"__MIN_OF_ReadPagesNum": "0",
"RowsRead": "52.234K (52234)",
"__MAX_OF_RowsRead": "3.074K (3074)",
"__MIN_OF_RowsRead": "0",
"ScanTime": "6s790ms",
"__MAX_OF_ScanTime": "21s809ms",
"__MIN_OF_ScanTime": "0ns",
"SubmitTaskCount": "32",
"__MAX_OF_SubmitTaskCount": "4",
"__MIN_OF_SubmitTaskCount": "4",
"SubmitTaskTime": "1.471ms",
"__MAX_OF_SubmitTaskTime": "5.783ms",
"__MIN_OF_SubmitTaskTime": "19.246us",
"TabletCount": "40",
"UncompressedBytesRead": "5.019 GB",
"__MAX_OF_UncompressedBytesRead": "307.703 MB",
"__MIN_OF_UncompressedBytesRead": "0.000 B"
}
}
}
}
}
}
}
模糊查询（快）
{
"Query": {
"Summary": {
"Query ID": "d00a9589-06f3-11f1-8d53-fa163eb635f1",
"Start Time": "2026-02-11 10:46:06",
"End Time": "2026-02-11 10:46:06",
"Total": "325ms",
"Query Type": "Query",
"Query State": "Finished",
"StarRocks Version": "3.3.18-UNKNOWN",
"User": "root",
"Default Db": "xxx",
"Sql Statement": "SELECT `key` as `key`, `col1` as `col1`, `col2` as `col2`, `col3` as `col3`, `col4` as `col4`, `col5` as `col5`, `col6` as `col6`, `col7` as `col7`, `col8` as `col8`, `col9` as `col9`, `col10` as `col10`, `col11` as `col11`, `dt` as `dt`, `col12` as `col12`FROM `table_1` WHERE (`col6` like '%AAA%' AND `dt` >= '20260101' AND `dt` <= '20260131') LIMIT 100 OFFSET 0",
"Variables": "parallel_fragment_exec_instance_num=1,max_parallel_scan_instance_num=-1,pipeline_dop=0,enable_adaptive_sink_dop=true,enable_runtime_adaptive_dop=false,runtime_profile_report_interval=10,resource_group=default_mv_wg",
"NonDefaultSessionVariables": "{\"resource_group\":{\"defaultValue\":\"\",\"actualValue\":\"default_mv_wg\"},\"enable_adaptive_sink_dop\":{\"defaultValue\":false,\"actualValue\":true},\"enable_profile\":{\"defaultValue\":false,\"actualValue\":true}}",
"Collect Profile Time": "1ms",
"IsProfileAsync": "true"
},
"Planner": {
"-- Parser[1] 0": "",
"-- Total[1] 6ms": "",
" -- Analyzer[1] 0": "",
" -- Lock[1] 0": "",
" -- AnalyzeDatabase[1] 0": "",
" -- AnalyzeTemporaryTable[1] 0": "",
" -- AnalyzeTable[1] 0": "",
" -- Transformer[1] 0": "",
" -- Optimizer[1] 3ms": "",
" -- MVPreprocess[1] 0": "",
" -- MVTextRewrite[1] 0": "",
" -- RuleBaseOptimize[1] 2ms": "",
" -- CostBaseOptimize[1] 0": "",
" -- PhysicalRewrite[1] 0": "",
" -- PlanValidate[1] 0": "",
" -- InputDependenciesChecker[1] 0": "",
" -- TypeChecker[1] 0": "",
" -- CTEUniqueChecker[1] 0": "",
" -- ColumnReuseChecker[1] 0": "",
" -- ExecPlanBuild[1] 1ms": "",
"-- Pending[1] 0": "",
"-- Prepare[1] 0": "",
"-- Deploy[1] 6ms": "",
" -- DeployLockInternalTime[1] 6ms": "",
" -- DeploySerializeConcurrencyTime[2] 1ms": "",
" -- DeployStageByStageTime[6] 0": "",
" -- DeployWaitTime[6] 4ms": "",
" -- DeployAsyncSendTime[2] 0": "",
"DeployDataSize": "13687",
"Reason": {}
},
"Execution": {
"Topology": "{\"rootId\":1,\"nodes\":[{\"id\":1,\"name\":\"EXCHANGE\",\"properties\":{\"sinkIds\":[],\"displayMem\":true},\"children\":[0]},{\"id\":0,\"name\":\"OLAP_SCAN\",\"properties\":{\"sinkIds\":[1],\"displayMem\":false},\"children\":[]}]}",
"FrontendProfileMergeTime": "2.052ms",
"QueryAllocatedMemoryUsage": "252.130 MB",
"QueryCumulativeCpuTime": "62.182ms",
"QueryCumulativeNetworkTime": "1.734ms",
"QueryCumulativeOperatorTime": "306.817ms",
"QueryCumulativeScanTime": "301.407ms",
"QueryDeallocatedMemoryUsage": "251.255 MB",
"QueryExecutionWallTime": "311.117ms",
"QueryPeakMemoryUsagePerNode": "30.060 MB",
"QueryPeakScheduleTime": "0ns",
"QuerySpillBytes": "0.000 B",
"QuerySumMemoryUsage": "30.060 MB",
"ResultDeliverTime": "0ns",
"Fragment 0": {
"BackendAddresses": "host1:9060",
"InstanceIds": "d00a9589-06f3-11f1-8d53-fa163eb635f2",
"BackendNum": "1",
"BackendProfileMergeTime": "676.372us",
"InitialProcessDriverCount": "0",
"InitialProcessMem": "246.869 MB",
"InstanceAllocatedMemoryUsage": "335.508 KB",
"InstanceDeallocatedMemoryUsage": "88.375 KB",
"InstanceNum": "1",
"InstancePeakMemoryUsage": "276.617 KB",
"QueryMemoryLimit": "-1.000 B",
"Pipeline (id=0)": {
"isGroupExecution": "false",
"ActiveTime": "92.211us",
"__MAX_OF_ActiveTime": "259.155us",
"__MIN_OF_ActiveTime": "8.214us",
"BlockByInputEmpty": "0",
"BlockByOutputFull": "0",
"BlockByPrecondition": "0",
"DegreeOfParallelism": "8",
"DriverTotalTime": "307.850ms",
"__MAX_OF_DriverTotalTime": "308.331ms",
"__MIN_OF_DriverTotalTime": "307.627ms",
"PeakDriverQueueSize": "27",
"__MAX_OF_PeakDriverQueueSize": "6",
"__MIN_OF_PeakDriverQueueSize": "0",
"PendingTime": "307.516ms",
"__MAX_OF_PendingTime": "307.570ms",
"__MIN_OF_PendingTime": "307.506ms",
"InputEmptyTime": "307.516ms",
"__MAX_OF_InputEmptyTime": "307.570ms",
"__MIN_OF_InputEmptyTime": "307.506ms",
"FirstInputEmptyTime": "307.516ms",
"__MAX_OF_FirstInputEmptyTime": "307.570ms",
"__MIN_OF_FirstInputEmptyTime": "307.506ms",
"ScheduleCount": "8",
"__MAX_OF_ScheduleCount": "1",
"__MIN_OF_ScheduleCount": "1",
"TotalDegreeOfParallelism": "8",
"YieldByLocalWait": "0",
"YieldByPreempt": "0",
"YieldByTimeLimit": "0",
"RESULT_SINK (plan_node_id=-1)": {
"CommonMetrics": {
"IsFinalSink": "",
"OperatorTotalTime": "60.035us",
"__MAX_OF_OperatorTotalTime": "189.870us",
"__MIN_OF_OperatorTotalTime": "1.087us",
"PullChunkNum": "0",
"PullRowNum": "0",
"PullTotalTime": "0ns",
"PushChunkNum": "3",
"__MAX_OF_PushChunkNum": "1",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "100",
"__MAX_OF_PushRowNum": "42",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "57.762us",
"__MAX_OF_PushTotalTime": "188.822us",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {
"result sink": {
"AppendChunkTime": "32.666us",
"__MAX_OF_AppendChunkTime": "109.353us",
"__MIN_OF_AppendChunkTime": "0ns",
"ResultRendTime": "23.894us",
"__MAX_OF_ResultRendTime": "130.677us",
"__MIN_OF_ResultRendTime": "0ns",
"TupleConvertTime": "28.884us",
"__MAX_OF_TupleConvertTime": "99.418us",
"__MIN_OF_TupleConvertTime": "0ns",
"NumSentRows": "100",
"__MAX_OF_NumSentRows": "42",
"__MIN_OF_NumSentRows": "0"
}
}
},
"CHUNK_ACCUMULATE (plan_node_id=-1)": {
"CommonMetrics": {
"IsSubordinate": "",
"OperatorTotalTime": "2.149us",
"__MAX_OF_OperatorTotalTime": "4.741us",
"__MIN_OF_OperatorTotalTime": "316ns",
"PullChunkNum": "3",
"__MAX_OF_PullChunkNum": "1",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "100",
"__MAX_OF_PullRowNum": "42",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "44ns",
"__MAX_OF_PullTotalTime": "146ns",
"__MIN_OF_PullTotalTime": "0ns",
"PushChunkNum": "3",
"__MAX_OF_PushChunkNum": "1",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "100",
"__MAX_OF_PushRowNum": "42",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "1.424us",
"__MAX_OF_PushTotalTime": "4.163us",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {}
},
"LIMIT (plan_node_id=1) (operator id=1)": {
"CommonMetrics": {
"OperatorTotalTime": "718ns",
"__MAX_OF_OperatorTotalTime": "1.215us",
"__MIN_OF_OperatorTotalTime": "272ns",
"PullChunkNum": "3",
"__MAX_OF_PullChunkNum": "1",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "100",
"__MAX_OF_PullRowNum": "42",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "104ns",
"__MAX_OF_PullTotalTime": "326ns",
"__MIN_OF_PullTotalTime": "0ns",
"PushChunkNum": "3",
"__MAX_OF_PushChunkNum": "1",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "100",
"__MAX_OF_PushRowNum": "42",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "184ns",
"__MAX_OF_PushTotalTime": "541ns",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {}
},
"EXCHANGE_SOURCE (plan_node_id=1)": {
"CommonMetrics": {
"ConjunctsInputRows": "100",
"__MAX_OF_ConjunctsInputRows": "42",
"__MIN_OF_ConjunctsInputRows": "18",
"ConjunctsOutputRows": "100",
"__MAX_OF_ConjunctsOutputRows": "42",
"__MIN_OF_ConjunctsOutputRows": "18",
"ConjunctsTime": "2.499us",
"__MAX_OF_ConjunctsTime": "2.913us",
"__MIN_OF_ConjunctsTime": "1.876us",
"JoinRuntimeFilterEvaluate": "0",
"JoinRuntimeFilterHashTime": "0ns",
"JoinRuntimeFilterInputRows": "0",
"JoinRuntimeFilterOutputRows": "0",
"JoinRuntimeFilterTime": "0ns",
"OperatorTotalTime": "21.688us",
"__MAX_OF_OperatorTotalTime": "48.461us",
"__MIN_OF_OperatorTotalTime": "8.485us",
"PullChunkNum": "3",
"__MAX_OF_PullChunkNum": "1",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "100",
"__MAX_OF_PullRowNum": "42",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "15.182us",
"__MAX_OF_PullTotalTime": "47.862us",
"__MIN_OF_PullTotalTime": "0ns",
"PushChunkNum": "0",
"PushRowNum": "0",
"PushTotalTime": "0ns",
"RuntimeBloomFilterNum": "0",
"RuntimeInFilterNum": "0"
},
"UniqueMetrics": {
"BufferUnplugCount": "0",
"BytesPassThrough": "30.177 KB",
"__MAX_OF_BytesPassThrough": "12.622 KB",
"__MIN_OF_BytesPassThrough": "0.000 B",
"BytesReceived": "0.000 B",
"ClosureBlockCount": "0",
"ClosureBlockTime": "0ns",
"DecompressChunkTime": "0ns",
"DeserializeChunkTime": "0ns",
"PeakBufferMemoryBytes": "30.177 KB",
"__MAX_OF_PeakBufferMemoryBytes": "12.622 KB",
"__MIN_OF_PeakBufferMemoryBytes": "0.000 B",
"ReceiverProcessTotalTime": "8.263us",
"__MAX_OF_ReceiverProcessTotalTime": "28.360us",
"__MIN_OF_ReceiverProcessTotalTime": "0ns",
"RequestReceived": "4",
"__MAX_OF_RequestReceived": "1",
"__MIN_OF_RequestReceived": "0",
"WaitLockTime": "0ns"
}
}
}
},
"Fragment 1": {
"BackendAddresses": "host1:9060",
"InstanceIds": "d00a9589-06f3-11f1-8d53-fa163eb635f3",
"BackendNum": "1",
"BackendProfileMergeTime": "1.117ms",
"InitialProcessDriverCount": "8",
"InitialProcessMem": "247.651 MB",
"InstanceAllocatedMemoryUsage": "251.803 MB",
"InstanceDeallocatedMemoryUsage": "251.168 MB",
"InstanceNum": "1",
"InstancePeakMemoryUsage": "29.830 MB",
"QueryMemoryLimit": "-1.000 B",
"Pipeline (id=1)": {
"isGroupExecution": "false",
"ActiveTime": "1.938ms",
"__MAX_OF_ActiveTime": "2.664ms",
"__MIN_OF_ActiveTime": "1.445ms",
"BlockByInputEmpty": "10",
"__MAX_OF_BlockByInputEmpty": "2",
"__MIN_OF_BlockByInputEmpty": "1",
"BlockByOutputFull": "0",
"BlockByPrecondition": "0",
"DegreeOfParallelism": "8",
"DriverTotalTime": "304.365ms",
"__MAX_OF_DriverTotalTime": "304.686ms",
"__MIN_OF_DriverTotalTime": "304.208ms",
"PeakDriverQueueSize": "33",
"__MAX_OF_PeakDriverQueueSize": "7",
"__MIN_OF_PeakDriverQueueSize": "0",
"PendingTime": "302.056ms",
"__MAX_OF_PendingTime": "302.597ms",
"__MIN_OF_PendingTime": "301.298ms",
"InputEmptyTime": "164.806ms",
"__MAX_OF_InputEmptyTime": "301.565ms",
"__MIN_OF_InputEmptyTime": "76.838ms",
"FollowupInputEmptyTime": "164.641ms",
"__MAX_OF_FollowupInputEmptyTime": "301.399ms",
"__MIN_OF_FollowupInputEmptyTime": "76.672ms",
"PendingFinishTime": "137.258ms",
"__MAX_OF_PendingFinishTime": "225.439ms",
"__MIN_OF_PendingFinishTime": "83.546us",
"ScheduleCount": "18",
"__MAX_OF_ScheduleCount": "3",
"__MIN_OF_ScheduleCount": "2",
"TotalDegreeOfParallelism": "8",
"YieldByLocalWait": "0",
"YieldByPreempt": "0",
"YieldByTimeLimit": "0",
"EXCHANGE_SINK (plan_node_id=1)": {
"CommonMetrics": {
"OperatorTotalTime": "126.337us",
"__MAX_OF_OperatorTotalTime": "370.711us",
"__MIN_OF_OperatorTotalTime": "11.870us",
"PullChunkNum": "0",
"PullRowNum": "0",
"PullTotalTime": "0ns",
"PushChunkNum": "3",
"__MAX_OF_PushChunkNum": "1",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "100",
"__MAX_OF_PushRowNum": "42",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "27.991us",
"__MAX_OF_PushTotalTime": "115.170us",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {
"ChannelNum": "1",
"DestFragments": "d00a958906f311f1-8d53fa163eb635f2",
"DestID": "1",
"PartType": "UNPARTITIONED",
"BytesPassThrough": "30.177 KB",
"__MAX_OF_BytesPassThrough": "12.622 KB",
"__MIN_OF_BytesPassThrough": "0.000 B",
"BytesSent": "0.000 B",
"BytesUnsent": "0.000 B",
"CompressTime": "0ns",
"CompressedBytes": "0.000 B",
"NetworkBandwidth": "0.000 B/sec",
"NetworkTime": "1.734ms",
"OverallThroughput": "0.000 B/sec",
"OverallTime": "225.814ms",
"PassThroughBufferPeakMemoryUsage": "0.000 B",
"RequestSent": "0",
"RequestUnsent": "0",
"RpcAvgTime": "433.705us",
"RpcCount": "4",
"SenderInputBytes": "0.000 B",
"SerializeChunkTime": "0ns",
"SerializedBytes": "0.000 B",
"ShuffleChunkAppendCounter": "0",
"ShuffleChunkAppendTime": "0ns",
"ShuffleHashTime": "0ns",
"WaitTime": "1.080ms"
}
},
"CHUNK_ACCUMULATE (plan_node_id=0)": {
"CommonMetrics": {
"IsSubordinate": "",
"OperatorTotalTime": "16.992us",
"__MAX_OF_OperatorTotalTime": "51.609us",
"__MIN_OF_OperatorTotalTime": "1.424us",
"PullChunkNum": "3",
"__MAX_OF_PullChunkNum": "1",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "100",
"__MAX_OF_PullRowNum": "42",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "237ns",
"__MAX_OF_PullTotalTime": "1.153us",
"__MIN_OF_PullTotalTime": "0ns",
"PushChunkNum": "11",
"__MAX_OF_PushChunkNum": "4",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "100",
"__MAX_OF_PushRowNum": "42",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "14.753us",
"__MAX_OF_PushTotalTime": "46.560us",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {}
},
"LIMIT (plan_node_id=0) (operator id=3)": {
"CommonMetrics": {
"OperatorTotalTime": "1.618us",
"__MAX_OF_OperatorTotalTime": "4.818us",
"__MIN_OF_OperatorTotalTime": "421ns",
"PullChunkNum": "11",
"__MAX_OF_PullChunkNum": "4",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "100",
"__MAX_OF_PullRowNum": "42",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "177ns",
"__MAX_OF_PullTotalTime": "516ns",
"__MIN_OF_PullTotalTime": "0ns",
"PushChunkNum": "11",
"__MAX_OF_PushChunkNum": "4",
"__MIN_OF_PushChunkNum": "0",
"PushRowNum": "104",
"__MAX_OF_PushRowNum": "42",
"__MIN_OF_PushRowNum": "0",
"PushTotalTime": "930ns",
"__MAX_OF_PushTotalTime": "3.952us",
"__MIN_OF_PushTotalTime": "0ns"
},
"UniqueMetrics": {}
},
"OLAP_SCAN (plan_node_id=0)": {
"CommonMetrics": {
"JoinRuntimeFilterEvaluate": "0",
"JoinRuntimeFilterHashTime": "0ns",
"JoinRuntimeFilterInputRows": "0",
"JoinRuntimeFilterOutputRows": "0",
"JoinRuntimeFilterTime": "0ns",
"OperatorTotalTime": "2.172ms",
"__MAX_OF_OperatorTotalTime": "2.866ms",
"__MIN_OF_OperatorTotalTime": "1.648ms",
"PullChunkNum": "11",
"__MAX_OF_PullChunkNum": "4",
"__MIN_OF_PullChunkNum": "0",
"PullRowNum": "104",
"__MAX_OF_PullRowNum": "42",
"__MIN_OF_PullRowNum": "0",
"PullTotalTime": "1.368ms",
"__MAX_OF_PullTotalTime": "1.966ms",
"__MIN_OF_PullTotalTime": "1.023ms",
"PushChunkNum": "0",
"PushRowNum": "0",
"PushTotalTime": "0ns",
"RuntimeBloomFilterNum": "0",
"RuntimeInFilterNum": "0"
},
"UniqueMetrics": {
"MorselQueueType": "fixed_morsel_queue",
"Predicates": "9: col6 LIKE '%AAA%', 2: dt <= 20260131",
"Rollup": "table_1",
"SharedScan": "False",
"Table": "table_1",
"AccessPathHits": "0",
"AccessPathUnhits": "0",
"BytesRead": "2.156 MB",
"__MAX_OF_BytesRead": "262.873 KB",
"__MIN_OF_BytesRead": "0.000 B",
"CachedPagesNum": "0",
"ChunkBufferCapacity": "512",
"CompressedBytesRead": "82.336 MB",
"__MAX_OF_CompressedBytesRead": "10.242 MB",
"__MIN_OF_CompressedBytesRead": "0.000 B",
"DefaultChunkBufferCapacity": "172",
"IOTaskExecTime": "33.265ms",
"__MAX_OF_IOTaskExecTime": "274.288ms",
"__MIN_OF_IOTaskExecTime": "0ns",
"CreateSegmentIter": "26.871us",
"__MAX_OF_CreateSegmentIter": "155.637us",
"__MIN_OF_CreateSegmentIter": "0ns",
"DictDecode": "47.023us",
"__MAX_OF_DictDecode": "76.673us",
"__MIN_OF_DictDecode": "8.821us",
"GetDelVec": "5.289us",
"__MAX_OF_GetDelVec": "100.971us",
"__MIN_OF_GetDelVec": "0ns",
"GetDeltaColumnGroup": "1.946us",
"__MAX_OF_GetDeltaColumnGroup": "24.965us",
"__MIN_OF_GetDeltaColumnGroup": "0ns",
"GetRowsets": "143ns",
"__MAX_OF_GetRowsets": "524ns",
"__MIN_OF_GetRowsets": "0ns",
"IOTime": "30.952ms",
"__MAX_OF_IOTime": "265.753ms",
"__MIN_OF_IOTime": "0ns",
"LateMaterialize": "110.123ms",
"__MAX_OF_LateMaterialize": "271.614ms",
"__MIN_OF_LateMaterialize": "7.555ms",
"ReadPKIndex": "0ns",
"SegmentInit": "126.502us",
"__MAX_OF_SegmentInit": "477.991us",
"__MIN_OF_SegmentInit": "0ns",
"BitmapIndexFilter": "16.359us",
"__MAX_OF_BitmapIndexFilter": "65.607us",
"__MIN_OF_BitmapIndexFilter": "0ns",
"BitmapIndexFilterRows": "30.153M (30152831)",
"__MAX_OF_BitmapIndexFilterRows": "2.746M (2745955)",
"__MIN_OF_BitmapIndexFilterRows": "0",
"BitmapIndexIteratorInit": "2.028us",
"__MAX_OF_BitmapIndexIteratorInit": "24.498us",
"__MIN_OF_BitmapIndexIteratorInit": "0ns",
"BloomFilterFilter": "194ns",
"__MAX_OF_BloomFilterFilter": "1.021us",
"__MIN_OF_BloomFilterFilter": "0ns",
"BloomFilterFilterRows": "0",
"ColumnIteratorInit": "21.165us",
"__MAX_OF_ColumnIteratorInit": "86.353us",
"__MIN_OF_ColumnIteratorInit": "0ns",
"GinFilter": "0ns",
"GinFilterRows": "0",
"RemainingRowsAfterShortKeyFilter": "30.153M (30152831)",
"__MAX_OF_RemainingRowsAfterShortKeyFilter": "2.746M (2745955)",
"__MIN_OF_RemainingRowsAfterShortKeyFilter": "0",
"SegmentRuntimeZoneMapFilterRows": "0",
"SegmentZoneMapFilterRows": "0",
"ShortKeyFilter": "25.156us",
"__MAX_OF_ShortKeyFilter": "108.627us",
"__MIN_OF_ShortKeyFilter": "0ns",
"ShortKeyFilterRows": "0",
"ShortKeyRangeNumber": "0",
"ZoneMapIndexFilterRows": "0",
"ZoneMapIndexFiter": "22.253us",
"__MAX_OF_ZoneMapIndexFiter": "81.416us",
"__MIN_OF_ZoneMapIndexFiter": "0ns",
"SegmentRead": "331.163us",
"__MAX_OF_SegmentRead": "1.495ms",
"__MIN_OF_SegmentRead": "0ns",
"BlockFetch": "186.914us",
"__MAX_OF_BlockFetch": "922.331us",
"__MIN_OF_BlockFetch": "0ns",
"BlockFetchCount": "116",
"__MAX_OF_BlockFetchCount": "14",
"__MIN_OF_BlockFetchCount": "0",
"BlockSeek": "75.009us",
"__MAX_OF_BlockSeek": "306.344us",
"__MIN_OF_BlockSeek": "0ns",
"BlockSeekCount": "53",
"__MAX_OF_BlockSeekCount": "7",
"__MIN_OF_BlockSeekCount": "0",
"ChunkCopy": "234ns",
"__MAX_OF_ChunkCopy": "1.013us",
"__MIN_OF_ChunkCopy": "0ns",
"DecompressT": "559.349us",
"__MAX_OF_DecompressT": "2.641ms",
"__MIN_OF_DecompressT": "0ns",
"DelVecFilterRows": "0",
"PredFilter": "78.411us",
"__MAX_OF_PredFilter": "348.939us",
"__MIN_OF_PredFilter": "0ns",
"PredFilterRows": "474.179K (474179)",
"__MAX_OF_PredFilterRows": "57.245K (57245)",
"__MIN_OF_PredFilterRows": "0",
"RowsetsReadCount": "11",
"__MAX_OF_RowsetsReadCount": "1",
"__MIN_OF_RowsetsReadCount": "0",
"SegmentsReadCount": "22",
"__MAX_OF_SegmentsReadCount": "2",
"__MIN_OF_SegmentsReadCount": "0",
"TotalColumnsDataPageCount": "128.432K (128432)",
"__MAX_OF_TotalColumnsDataPageCount": "11.697K (11697)",
"__MIN_OF_TotalColumnsDataPageCount": "0",
"IOTaskWaitTime": "51.454ms",
"__MAX_OF_IOTaskWaitTime": "301.888ms",
"__MIN_OF_IOTaskWaitTime": "0ns",
"MorselsCount": "34",
"__MAX_OF_MorselsCount": "5",
"__MIN_OF_MorselsCount": "4",
"PeakChunkBufferMemoryUsage": "0.000 B",
"PeakChunkBufferSize": "0",
"PeakIOTasks": "4",
"PeakScanTaskQueueSize": "182",
"__MAX_OF_PeakScanTaskQueueSize": "27",
"__MIN_OF_PeakScanTaskQueueSize": "15",
"PrepareChunkSourceTime": "1.230ms",
"__MAX_OF_PrepareChunkSourceTime": "1.892ms",
"__MIN_OF_PrepareChunkSourceTime": "967.116us",
"PushdownAccessPaths": "0",
"PushdownPredicates": "2",
"RawRowsRead": "475.136K (475136)",
"__MAX_OF_RawRowsRead": "57.344K (57344)",
"__MIN_OF_RawRowsRead": "0",
"ReadPagesNum": "1.735K (1735)",
"__MAX_OF_ReadPagesNum": "214",
"__MIN_OF_ReadPagesNum": "0",
"RowsRead": "957",
"__MAX_OF_RowsRead": "110",
"__MIN_OF_RowsRead": "0",
"ScanTime": "51.527ms",
"__MAX_OF_ScanTime": "301.407ms",
"__MIN_OF_ScanTime": "0ns",
"SubmitTaskCount": "34",
"__MAX_OF_SubmitTaskCount": "5",
"__MIN_OF_SubmitTaskCount": "4",
"SubmitTaskTime": "105.753us",
"__MAX_OF_SubmitTaskTime": "761.342us",
"__MIN_OF_SubmitTaskTime": "6.874us",
"TabletCount": "40",
"UncompressedBytesRead": "92.980 MB",
"__MAX_OF_UncompressedBytesRead": "11.542 MB",
"__MIN_OF_UncompressedBytesRead": "0.000 B"
}
}
},
"Pipeline (id=0)": {
"isGroupExecution": "false",
"ActiveTime": "136.760us",
"BlockByInputEmpty": "0",
"BlockByOutputFull": "0",
"BlockByPrecondition": "0",
"DegreeOfParallelism": "1",
"DriverTotalTime": "185.242us",
"PeakDriverQueueSize": "0",
"ScheduleCount": "1",
"TotalDegreeOfParallelism": "1",
"YieldByLocalWait": "0",
"YieldByPreempt": "0",
"YieldByTimeLimit": "0",
"NOOP_SINK (plan_node_id=0)": {
"CommonMetrics": {
"IsSubordinate": "",
"OperatorTotalTime": "758ns",
"PullChunkNum": "0",
"PullRowNum": "0",
"PullTotalTime": "0ns",
"PushChunkNum": "0",
"PushRowNum": "0",
"PushTotalTime": "0ns"
},
"UniqueMetrics": {}
},
"OLAP_SCAN_PREPARE (plan_node_id=0)": {
"CommonMetrics": {
"IsSubordinate": "",
"OperatorTotalTime": "136.831us",
"PullChunkNum": "0",
"PullRowNum": "0",
"PullTotalTime": "127.967us",
"PushChunkNum": "0",
"PushRowNum": "0",
"PushTotalTime": "0ns",
"RuntimeBloomFilterNum": "0",
"RuntimeInFilterNum": "0"
},
"UniqueMetrics": {
"CaptureTabletRowsetsTime": "83.040us"
}
}
}
}
}
}
}
【背景】无
【业务影响】
【是否存算分离】否
【StarRocks版本】3.3.18
【集群规模】例如：1fe+1be
【机器信息】无
【联系方式】541166058@qq.com
【附件】
建表语句：
CREATE TABLE `table_1` (
`key` varchar(255) NOT NULL COMMENT "",
`dt` int(11) NOT NULL COMMENT "",
`col1` bigint(20) NULL COMMENT "",
`colcolcol` varchar(65535) NULL COMMENT "",
`col2` varchar(255) NULL COMMENT "",
`col3` bigint(20) NULL COMMENT "",
`col4` varchar(255) NULL COMMENT "",
`col5` varchar(255) NULL COMMENT "",
`col6` varchar(255) NULL COMMENT "",
`col7` varchar(255) NULL COMMENT "",
`col8` varchar(255) NULL COMMENT "",
`col9` int(11) NULL COMMENT "",
`col10` int(11) NULL COMMENT "",
`col11` int(11) NULL COMMENT "",
`col12` varchar(255) NULL COMMENT ""
) ENGINE=OLAP
PRIMARY KEY(`key`, `dt`)
COMMENT ""
PARTITION BY RANGE(`dt`)
(PARTITION p202509 VALUES [("20250901"), ("20251001")),
PARTITION p202510 VALUES [("20251001"), ("20251101")),
PARTITION p202511 VALUES [("20251101"), ("20251201")),
PARTITION p202512 VALUES [("20251201"), ("20260101")),
PARTITION p202601 VALUES [("20260101"), ("20260201")),
PARTITION p202602 VALUES [("20260201"), ("20260301")),
PARTITION p202603 VALUES [("20260301"), ("20260401")))
DISTRIBUTED BY HASH(`key`) BUCKETS 40
PROPERTIES (
"compression" = "LZ4",
"dynamic_partition.enable" = "true",
"dynamic_partition.end" = "1",
"dynamic_partition.history_partition_num" = "4",
"dynamic_partition.prefix" = "p",
"dynamic_partition.start" = "-36",
"dynamic_partition.start_day_of_month" = "1",
"dynamic_partition.time_unit" = "MONTH",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"enable_persistent_index" = "true",
"fast_schema_evolution" = "true",
"replicated_storage" = "true",
"replication_num" = "1"
);
根因揭秘：