同一个SQL,执行速度忽快忽慢

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】完全一样的一个SQL,执行两次为啥查询时间相差很多? 其实也就是一个SQL一会儿查询很快,一会儿又查询很慢。

Summary: Summary:
- Query ID: 9a691460-9982-11ee-a307-6cfe5438c9b1 - Query ID: 17062256-9982-11ee-a307-6cfe5438c9b1
- Start Time: 2023-12-13 14:41:11 - Start Time: 2023-12-13 14:37:30
- End Time: 2023-12-13 14:41:40 - End Time: 2023-12-13 14:37:39
- Total: 29s219ms - Total: 8s472ms
- Query Type: Query - Query Type: Query
- Query State: EOF - Query State: EOF
- StarRocks Version: 2.5.4-1021a92 - StarRocks Version: 2.5.4-1021a92
- QueryCpuCost: 807ms - QueryCpuCost: 3s77ms
- QueryMemCost: 385.795MB - QueryMemCost: 842.978MB
- ExecutionTotalTime: 29s176ms - ExecutionTotalTime: 9s42ms
- InputEmptyTime: 29s142ms - InputEmptyTime: 7s385ms
- FirstInputEmptyTime: 10s111ms - FirstInputEmptyTime: 5s616ms
- FollowupInputEmptyTime: 19s30ms - FollowupInputEmptyTime: 1s769ms
- PeakMemoryUsage: 1.66 GB ? 内存不够用???? - PeakMemoryUsage: 3.50 GB
- NetworkBandwidth: 174.60803985595703 MB/sec - NetworkBandwidth: 199.72179317474365 MB/sec
- BytesRead: 349.59 MB - BytesRead: 367.97 MB

估计是plan不一样,弄俩完整profile看看

用时29秒的Query:
Summary:
- Query ID: 9a691460-9982-11ee-a307-6cfe5438c9b1
- Start Time: 2023-12-13 14:41:11
- End Time: 2023-12-13 14:41:40
- Total: 29s219ms
- Query Type: Query
- Query State: EOF
- StarRocks Version: 2.5.4-1021a92
- User: root
- Default Db: ODS
- Sql Statement: /* ApplicationName=DBeaver 23.2.5 - SQLEditor / select /+SET_VAR(is_report_success=true)*/ *
from ODS.TEST
where TRADE_TYPE not in (30, 33, 34, 40, 41)
and MNO =‘3992211053’
and STORE_NO = ‘3992211053’
and PAY_TIME >=‘2023-10-01’ and PAY_TIME <‘2023-10-11’
LIMIT 0, 200
- QueryCpuCost: 807ms
- QueryMemCost: 385.795MB
- Variables: parallel_fragment_exec_instance_num=1,max_parallel_scan_instance_num=-1,pipeline_dop=0,enable_adaptive_sink_dop=true
- Collect Profile Time: 21ms
Planner:
- Analyzer: 0ms / 1
- CoordDeliverExec: 12ms / 1
- CoordPrepareExec: 0ms / 1
- ExecPlanBuild: 0ms / 1
- Optimizer: 67ms / 1
- Total: 67ms / 1
Optimizer:
- CostBaseOptimize: 0ms / 1
- PhysicalRewrite: 0ms / 1
- RuleBaseOptimize: 1ms / 1
- preprocessMvs: 65ms / 1
Execution Profile 9a691460-9982-11ee-a307-6cfe5438c9b1:
- ExecutionTotalTime: 29s176ms
Fragment 0:
- BackendAddresses: 10.3.138.106:9060
- BackendNum: 1
- FragmentInstancePrepareTime: 783.970us
- prepare-fragment-ctx: 16.604us
- prepare-pipeline-driver: 107.161us
- prepare-query-ctx: 14.120us
- prepare-runtime-state: 107.161us
- InstanceNum: 1
- PeakMemoryUsage: 1.27 MB
- QueryMemoryLimit: 183.22 GB
Pipeline (id=0):
- ActiveTime: 690.380us
- __MAX_OF_ActiveTime: 2.535ms
- __MIN_OF_ActiveTime: 354.39us
- BlockByInputEmpty: 96
- __MAX_OF_BlockByInputEmpty: 3
- __MIN_OF_BlockByInputEmpty: 3
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 32
- DriverPrepareTime: 56.204us
- __MAX_OF_DriverPrepareTime: 307.735us
- __MIN_OF_DriverPrepareTime: 32.628us
- DriverTotalTime: 29s145ms
- __MAX_OF_DriverTotalTime: 29s147ms
- __MIN_OF_DriverTotalTime: 29s144ms
- OverheadTime: 141.433us
- __MAX_OF_OverheadTime: 353.55us
- __MIN_OF_OverheadTime: 67.885us
- PendingTime: 29s142ms
- __MAX_OF_PendingTime: 29s142ms
- __MIN_OF_PendingTime: 29s141ms
- InputEmptyTime: 29s142ms
- __MAX_OF_InputEmptyTime: 29s142ms
- __MIN_OF_InputEmptyTime: 29s141ms
- FirstInputEmptyTime: 10s111ms
- __MAX_OF_FirstInputEmptyTime: 10s111ms
- __MIN_OF_FirstInputEmptyTime: 10s111ms
- FollowupInputEmptyTime: 19s30ms
- __MAX_OF_FollowupInputEmptyTime: 19s30ms
- __MIN_OF_FollowupInputEmptyTime: 19s30ms
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 128
- __MAX_OF_ScheduleCount: 4
- __MIN_OF_ScheduleCount: 4
- ScheduleTime: 2.674ms
- __MAX_OF_ScheduleTime: 3.495ms
- __MIN_OF_ScheduleTime: 1.980ms
- TotalDegreeOfParallelism: 32
- YieldByPreempt: 0
- YieldByTimeLimit: 0
RESULT_SINK:
CommonMetrics:
- CloseTime: 1.314us
- __MAX_OF_CloseTime: 7.871us
- __MIN_OF_CloseTime: 367ns
- OperatorTotalTime: 156.119us
- __MAX_OF_OperatorTotalTime: 306.440us
- __MIN_OF_OperatorTotalTime: 44.674us
- PeakMemoryUsage: 0.00
- PrepareTime: 12.537us
- __MAX_OF_PrepareTime: 33.85us
- __MIN_OF_PrepareTime: 8.331us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 85
- __MAX_OF_PushChunkNum: 4
- __MIN_OF_PushChunkNum: 2
- PushRowNum: 200
- __MAX_OF_PushRowNum: 16
- __MIN_OF_PushRowNum: 2
- PushTotalTime: 154.652us
- __MAX_OF_PushTotalTime: 305.753us
- __MIN_OF_PushTotalTime: 42.543us
- SetFinishedTime: 27ns
- __MAX_OF_SetFinishedTime: 45ns
- __MIN_OF_SetFinishedTime: 22ns
- SetFinishingTime: 125ns
- __MAX_OF_SetFinishingTime: 255ns
- __MIN_OF_SetFinishingTime: 35ns
UniqueMetrics:
LIMIT (plan_node_id=1):
CommonMetrics:
- CloseTime: 251ns
- __MAX_OF_CloseTime: 574ns
- __MIN_OF_CloseTime: 136ns
- OperatorTotalTime: 2.772us
- __MAX_OF_OperatorTotalTime: 32.765us
- __MIN_OF_OperatorTotalTime: 1.233us
- PeakMemoryUsage: 0.00
- PrepareTime: 11.645us
- __MAX_OF_PrepareTime: 65.898us
- __MIN_OF_PrepareTime: 5.933us
- PullChunkNum: 85
- __MAX_OF_PullChunkNum: 4
- __MIN_OF_PullChunkNum: 2
- PullRowNum: 200
- __MAX_OF_PullRowNum: 16
- __MIN_OF_PullRowNum: 2
- PullTotalTime: 377ns
- __MAX_OF_PullTotalTime: 670ns
- __MIN_OF_PullTotalTime: 212ns
- PushChunkNum: 85
- __MAX_OF_PushChunkNum: 4
- __MIN_OF_PushChunkNum: 2
- PushRowNum: 203
- __MAX_OF_PushRowNum: 16
- __MIN_OF_PushRowNum: 2
- PushTotalTime: 1.995us
- __MAX_OF_PushTotalTime: 32.105us
- __MIN_OF_PushTotalTime: 633ns
- SetFinishedTime: 82ns
- __MAX_OF_SetFinishedTime: 1.877us
- __MIN_OF_SetFinishedTime: 23ns
- SetFinishingTime: 64ns
- __MAX_OF_SetFinishingTime: 195ns
- __MIN_OF_SetFinishingTime: 24ns
UniqueMetrics:
EXCHANGE_SOURCE (plan_node_id=1):
CommonMetrics:
- CloseTime: 990ns
- __MAX_OF_CloseTime: 4.455us
- __MIN_OF_CloseTime: 320ns
- JoinRuntimeFilterEvaluate: 0
- JoinRuntimeFilterHashTime: 0ns
- JoinRuntimeFilterInputRows: 0
- JoinRuntimeFilterOutputRows: 0
- JoinRuntimeFilterTime: 0ns
- OperatorTotalTime: 390.55us
- __MAX_OF_OperatorTotalTime: 2.174ms
- __MIN_OF_OperatorTotalTime: 143.476us
- PeakMemoryUsage: 0.00
- PrepareTime: 15.732us
- __MAX_OF_PrepareTime: 255.400us
- __MIN_OF_PrepareTime: 5.862us
- PullChunkNum: 85
- __MAX_OF_PullChunkNum: 4
- __MIN_OF_PullChunkNum: 2
- PullRowNum: 203
- __MAX_OF_PullRowNum: 16
- __MIN_OF_PullRowNum: 2
- PullTotalTime: 326.630us
- __MAX_OF_PullTotalTime: 675.685us
- __MIN_OF_PullTotalTime: 142.40us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 68ns
- __MAX_OF_SetFinishedTime: 145ns
- __MIN_OF_SetFinishedTime: 23ns
- SetFinishingTime: 62.365us
- __MAX_OF_SetFinishingTime: 1.966ms
- __MIN_OF_SetFinishingTime: 293ns
UniqueMetrics:
- BufferUnplugCount: 4
- BytesPassThrough: 73.13 KB
- BytesReceived: 148.45 KB
- ClosureBlockCount: 0
- ClosureBlockTime: 0ns
- DecompressChunkTime: 0ns
- DeserializeChunkTime: 8.882ms
- ReceiverProcessTotalTime: 906.149us
- RequestReceived: 100
- SenderTotalTime: 889.509us
- SenderWaitLockTime: 62.605us
Fragment 1:
- BackendAddresses: 10.30.138.6:9060,10.30.138.1:9060,10.30.138.5:9060,10.30.138.4:9060,10.30.138.2:9060
- BackendNum: 5
- FragmentInstancePrepareTime: 1.456ms
- __MAX_OF_FragmentInstancePrepareTime: 1.791ms
- __MIN_OF_FragmentInstancePrepareTime: 1.187ms
- prepare-fragment-ctx: 27.762us
- prepare-pipeline-driver: 235.243us
- prepare-query-ctx: 14.684us
- prepare-runtime-state: 235.243us
- InstanceNum: 5
- PeakMemoryUsage: 1.66 GB
- __MAX_OF_PeakMemoryUsage: 554.39 MB
- __MIN_OF_PeakMemoryUsage: 194.70 MB
- QueryMemoryLimit: 916.12 GB
- __MAX_OF_QueryMemoryLimit: 183.22 GB
- __MIN_OF_QueryMemoryLimit: 183.22 GB
Pipeline (id=1):
- ActiveTime: 8.365ms
- __MAX_OF_ActiveTime: 39.920ms
- __MIN_OF_ActiveTime: 3.462ms
- BlockByInputEmpty: 989
- __MAX_OF_BlockByInputEmpty: 9
- __MIN_OF_BlockByInputEmpty: 5
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 32
- DriverPrepareTime: 109.620us
- __MAX_OF_DriverPrepareTime: 290.776us
- __MIN_OF_DriverPrepareTime: 67.898us
- DriverTotalTime: 20s375ms
- __MAX_OF_DriverTotalTime: 29s152ms
- __MIN_OF_DriverTotalTime: 10s107ms
- OverheadTime: 99.54us
- __MAX_OF_OverheadTime: 2.808ms
- __MIN_OF_OverheadTime: 0ns
- PendingTime: 20s362ms
- __MAX_OF_PendingTime: 29s142ms
- __MIN_OF_PendingTime: 10s96ms
- InputEmptyTime: 20s360ms
- __MAX_OF_InputEmptyTime: 29s141ms
- __MIN_OF_InputEmptyTime: 10s95ms
- FirstInputEmptyTime: 427.732us
- __MAX_OF_FirstInputEmptyTime: 813.166us
- __MIN_OF_FirstInputEmptyTime: 218.57us
- FollowupInputEmptyTime: 20s360ms
- __MAX_OF_FollowupInputEmptyTime: 29s140ms
- __MIN_OF_FollowupInputEmptyTime: 10s95ms
- OutputFullTime: 0ns
- PendingFinishTime: 1.889ms
- __MAX_OF_PendingFinishTime: 5.753ms
- __MIN_OF_PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 1.119K (1119)
- __MAX_OF_ScheduleCount: 10
- __MIN_OF_ScheduleCount: 5
- ScheduleTime: 4.409ms
- __MAX_OF_ScheduleTime: 8.636ms
- __MIN_OF_ScheduleTime: 2.438ms
- TotalDegreeOfParallelism: 160
- __MAX_OF_TotalDegreeOfParallelism: 32
- __MIN_OF_TotalDegreeOfParallelism: 32
- YieldByPreempt: 0
- YieldByTimeLimit: 0
EXCHANGE_SINK (plan_node_id=1):
CommonMetrics:
- CloseTime: 1.545us
- __MAX_OF_CloseTime: 25.37us
- __MIN_OF_CloseTime: 178ns
- OperatorTotalTime: 274.458us
- __MAX_OF_OperatorTotalTime: 1.338ms
- __MIN_OF_OperatorTotalTime: 653ns
- PeakMemoryUsage: 0.00
- PrepareTime: 44.898us
- __MAX_OF_PrepareTime: 208.361us
- __MIN_OF_PrepareTime: 22.608us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 99
- __MAX_OF_PushChunkNum: 1
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 248
- __MAX_OF_PushRowNum: 9
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 104.247us
- __MAX_OF_PushTotalTime: 628.242us
- __MIN_OF_PushTotalTime: 0ns
- SetFinishedTime: 30ns
- __MAX_OF_SetFinishedTime: 63ns
- __MIN_OF_SetFinishedTime: 22ns
- SetFinishingTime: 168.633us
- __MAX_OF_SetFinishingTime: 1.212ms
- __MIN_OF_SetFinishingTime: 360ns
UniqueMetrics:
- DestID: 1
- DestFragments: 9a691460998211ee-a3076cfe5438c9b7
- PartType: UNPARTITIONED
- ChannelNum: 1
- BytesPassThrough: 73.13 KB
- __MAX_OF_BytesPassThrough: 6.19 KB
- __MIN_OF_BytesPassThrough: 0.00
- BytesSent: 148.45 KB
- __MAX_OF_BytesSent: 55.75 KB
- __MIN_OF_BytesSent: 0.00
- CompressTime: 0ns
- NetworkBandwidth: 174.60803985595703 MB/sec
- __MAX_OF_NetworkBandwidth: 73.07645893096924 MB/sec
- __MIN_OF_NetworkBandwidth: 0.0 /sec
- NetworkTime: 674.513us
- __MAX_OF_NetworkTime: 1.115ms
- __MIN_OF_NetworkTime: 0ns
- OverallThroughput: 78.84839916229248 MB/sec
- __MAX_OF_OverallThroughput: 31.217472076416016 MB/sec
- __MIN_OF_OverallThroughput: 0.0 /sec
- OverallTime: 1.395ms
- __MAX_OF_OverallTime: 2.80ms
- __MIN_OF_OverallTime: 0ns
- RequestSent: 73
- __MAX_OF_RequestSent: 26
- __MIN_OF_RequestSent: 0
- RpcAvgTime: 132.1us
- __MAX_OF_RpcAvgTime: 213.988us
- __MIN_OF_RpcAvgTime: 0ns
- RpcCount: 103
- __MAX_OF_RpcCount: 27
- __MIN_OF_RpcCount: 0
- SerializeChunkTime: 47.174us
- __MAX_OF_SerializeChunkTime: 249.718us
- __MIN_OF_SerializeChunkTime: 0ns
- ShuffleHashTime: 0ns
- UncompressedBytes: 148.45 KB
- __MAX_OF_UncompressedBytes: 3.78 KB
- __MIN_OF_UncompressedBytes: 0.00
- WaitTime: 1.665ms
- __MAX_OF_WaitTime: 2.38ms
- __MIN_OF_WaitTime: 1.31ms
CHUNK_ACCUMULATE (plan_node_id=0):
CommonMetrics:
- CloseTime: 678ns
- __MAX_OF_CloseTime: 6.793us
- __MIN_OF_CloseTime: 42ns
- OperatorTotalTime: 79.190us
- __MAX_OF_OperatorTotalTime: 421.952us
- __MIN_OF_OperatorTotalTime: 188ns
- PeakMemoryUsage: 0.00
- PrepareTime: 12.276us
- __MAX_OF_PrepareTime: 31.794us
- __MIN_OF_PrepareTime: 5.542us
- PullChunkNum: 99
- __MAX_OF_PullChunkNum: 1
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 248
- __MAX_OF_PullRowNum: 9
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 290ns
- __MAX_OF_PullTotalTime: 1.95us
- __MIN_OF_PullTotalTime: 0ns
- PushChunkNum: 203
- __MAX_OF_PushChunkNum: 4
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 314
- __MAX_OF_PushRowNum: 9
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 46.846us
- __MAX_OF_PushTotalTime: 420.419us
- __MIN_OF_PushTotalTime: 0ns
- SetFinishedTime: 31.224us
- __MAX_OF_SetFinishedTime: 264.775us
- __MIN_OF_SetFinishedTime: 43ns
- SetFinishingTime: 149ns
- __MAX_OF_SetFinishingTime: 1.157us
- __MIN_OF_SetFinishingTime: 23ns
UniqueMetrics:
OLAP_SCAN (plan_node_id=0):
CommonMetrics:
- CloseTime: 1.122ms
- __MAX_OF_CloseTime: 2.329ms
- __MIN_OF_CloseTime: 663.576us
- JoinRuntimeFilterEvaluate: 0
- JoinRuntimeFilterHashTime: 0ns
- JoinRuntimeFilterInputRows: 0
- JoinRuntimeFilterOutputRows: 0
- JoinRuntimeFilterTime: 0ns
- OperatorTotalTime: 8.225ms
- __MAX_OF_OperatorTotalTime: 38.449ms
- __MIN_OF_OperatorTotalTime: 3.562ms
- PeakMemoryUsage: 0.00
- PrepareTime: 18.987us
- __MAX_OF_PrepareTime: 48.987us
- __MIN_OF_PrepareTime: 9.130us
- PullChunkNum: 203
- __MAX_OF_PullChunkNum: 4
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 314
- __MAX_OF_PullRowNum: 9
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 7.101ms
- __MAX_OF_PullTotalTime: 37.206ms
- __MIN_OF_PullTotalTime: 2.526ms
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 102ns
- __MAX_OF_SetFinishedTime: 226ns
- __MIN_OF_SetFinishedTime: 22ns
- SetFinishingTime: 1.136us
- __MAX_OF_SetFinishingTime: 15.821us
- __MIN_OF_SetFinishingTime: 265ns
UniqueMetrics:
- MorselQueueType: physical_split_morsel_queue
- BufferUnplugThreshold: 18
- SharedScan: False
- Predicates: 25: TRADE_TYPE NOT IN (30, 33, 34, 40, 41), 4: MNO = ‘3992211053’, 31: STORE_NO = ‘3992211053’
- Rollup: TEST
- Table: TEST
- BufferUnplugCount: 0
- BytesRead: 349.59 MB
- __MAX_OF_BytesRead: 8.11 MB
- __MIN_OF_BytesRead: 0.00
- CachedPagesNum: 4.856K (4856)
- __MAX_OF_CachedPagesNum: 112
- __MIN_OF_CachedPagesNum: 0
- ChunkBufferCapacity: 2.048K (2048)
- CompressedBytesRead: 1012.00 MB
- __MAX_OF_CompressedBytesRead: 5.93 MB
- __MIN_OF_CompressedBytesRead: 0.00
- CreateSegmentIter: 142.81us
- __MAX_OF_CreateSegmentIter: 930.784us
- __MIN_OF_CreateSegmentIter: 0ns
- DefaultChunkBufferCapacity: 1.178K (1178)
- DictDecode: 7.347us
- __MAX_OF_DictDecode: 149.57us
- __MIN_OF_DictDecode: 2.664us
- GetDelVec: 4.507us
- __MAX_OF_GetDelVec: 702.322us
- __MIN_OF_GetDelVec: 0ns
- GetRowsets: 2.111us
- __MAX_OF_GetRowsets: 10.110us
- __MIN_OF_GetRowsets: 0ns
- IOTaskExecTime: 830.753ms
- __MAX_OF_IOTaskExecTime: 5s1ms
- __MIN_OF_IOTaskExecTime: 1.60ms
- IOTaskWaitTime: 9s146ms
- __MAX_OF_IOTaskWaitTime: 29s64ms
- __MIN_OF_IOTaskWaitTime: 168.628ms
- IOTime: 753.210ms
- __MAX_OF_IOTime: 4s980ms
- __MIN_OF_IOTime: 0ns
- LateMaterialize: 720.693ms
- __MAX_OF_LateMaterialize: 4s114ms
- __MIN_OF_LateMaterialize: 437.202us
- MorselsCount: 732
- __MAX_OF_MorselsCount: 6
- __MIN_OF_MorselsCount: 4
- PeakChunkBufferSize: 128
- PushdownPredicates: 3
- RawRowsRead: 34.302642M (34302642)
- __MAX_OF_RawRowsRead: 349.965K (349965)
- __MIN_OF_RawRowsRead: 0
- ReadPagesNum: 41.217K (41217)
- __MAX_OF_ReadPagesNum: 279
- __MIN_OF_ReadPagesNum: 0
- RowsRead: 288
- __MAX_OF_RowsRead: 5
- __MIN_OF_RowsRead: 0
- ScanTime: 9s977ms
- __MAX_OF_ScanTime: 29s132ms
- __MIN_OF_ScanTime: 212.598ms
- SegmentInit: 533.387ms
- __MAX_OF_SegmentInit: 4s79ms
- __MIN_OF_SegmentInit: 0ns
- BitmapIndexFilter: 0ns
- BitmapIndexFilterRows: 0
- BloomFilterFilterRows: 0
- SegmentRuntimeZoneMapFilterRows: 0
- SegmentZoneMapFilterRows: 0
- ShortKeyFilterRows: 0
- ZoneMapIndexFilterRows: 0
- SegmentRead: 26.790ms
- __MAX_OF_SegmentRead: 1s724ms
- __MIN_OF_SegmentRead: 0ns
- BlockFetch: 12.387ms
- __MAX_OF_BlockFetch: 656.537ms
- __MIN_OF_BlockFetch: 0ns
- BlockFetchCount: 8.493K (8493)
- __MAX_OF_BlockFetchCount: 87
- __MIN_OF_BlockFetchCount: 0
- BlockSeek: 41.720ms
- __MAX_OF_BlockSeek: 1s999ms
- __MIN_OF_BlockSeek: 0ns
- BlockSeekCount: 8.458K (8458)
- __MAX_OF_BlockSeekCount: 87
- __MIN_OF_BlockSeekCount: 0
- ChunkCopy: 3.273us
- __MAX_OF_ChunkCopy: 31.775us
- __MIN_OF_ChunkCopy: 0ns
- DecompressT: 1.356ms
- __MAX_OF_DecompressT: 7.51ms
- __MIN_OF_DecompressT: 0ns
- DelVecFilterRows: 420.265K (420265)
- __MAX_OF_DelVecFilterRows: 2.523K (2523)
- __MIN_OF_DelVecFilterRows: 0
- IndexLoad: 0ns
- PredFilter: 81.153us
- __MAX_OF_PredFilter: 1.549ms
- __MIN_OF_PredFilter: 0ns
- PredFilterRows: 34.302354M (34302354)
- __MAX_OF_PredFilterRows: 349.963K (349963)
- __MIN_OF_PredFilterRows: 0
- RowsetsReadCount: 20.715K (20715)
- __MAX_OF_RowsetsReadCount: 59
- __MIN_OF_RowsetsReadCount: 0
- SegmentsReadCount: 713
- __MAX_OF_SegmentsReadCount: 2
- __MIN_OF_SegmentsReadCount: 0
- TotalColumnsDataPageCount: 961.382K (961382)
- __MAX_OF_TotalColumnsDataPageCount: 5.091K (5091)
- __MIN_OF_TotalColumnsDataPageCount: 0
- SubmitTaskCount: 852
- __MAX_OF_SubmitTaskCount: 9
- __MIN_OF_SubmitTaskCount: 4
- TabletCount: 4
- UncompressedBytesRead: 1.24 GB
- __MAX_OF_UncompressedBytesRead: 7.88 MB
- __MIN_OF_UncompressedBytesRead: 0.00
Pipeline (id=0):
- ActiveTime: 247.333us
- __MAX_OF_ActiveTime: 453.895us
- __MIN_OF_ActiveTime: 159.562us
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 249.674us
- __MAX_OF_DriverPrepareTime: 430.443us
- __MIN_OF_DriverPrepareTime: 138.459us
- DriverTotalTime: 3.889ms
- __MAX_OF_DriverTotalTime: 6.202ms
- __MIN_OF_DriverTotalTime: 2.864ms
- OverheadTime: 0ns
- PendingTime: 0ns
- InputEmptyTime: 0ns
- FirstInputEmptyTime: 0ns
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 5
- __MAX_OF_ScheduleCount: 1
- __MIN_OF_ScheduleCount: 1
- ScheduleTime: 3.642ms
- __MAX_OF_ScheduleTime: 5.748ms
- __MIN_OF_ScheduleTime: 2.704ms
- TotalDegreeOfParallelism: 5
- __MAX_OF_TotalDegreeOfParallelism: 1
- __MIN_OF_TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
NOOP_SINK (plan_node_id=0):
CommonMetrics:
- CloseTime: 478ns
- __MAX_OF_CloseTime: 914ns
- __MIN_OF_CloseTime: 193ns
- OperatorTotalTime: 669ns
- __MAX_OF_OperatorTotalTime: 1.265us
- __MIN_OF_OperatorTotalTime: 315ns
- PeakMemoryUsage: 0.00
- PrepareTime: 15.269us
- __MAX_OF_PrepareTime: 22.311us
- __MIN_OF_PrepareTime: 10.109us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- SetFinishedTime: 25ns
- __MAX_OF_SetFinishedTime: 33ns
- __MIN_OF_SetFinishedTime: 22ns
- SetFinishingTime: 165ns
- __MAX_OF_SetFinishingTime: 329ns
- __MIN_OF_SetFinishingTime: 94ns
UniqueMetrics:
OLAP_SCAN_PREPARE (plan_node_id=0):
CommonMetrics:
- CloseTime: 7.463us
- __MAX_OF_CloseTime: 10.270us
- __MIN_OF_CloseTime: 5.221us
- OperatorTotalTime: 248.479us
- __MAX_OF_OperatorTotalTime: 455.127us
- __MIN_OF_OperatorTotalTime: 160.395us
- PeakMemoryUsage: 0.00
- PrepareTime: 202.942us
- __MAX_OF_PrepareTime: 367.210us
- __MIN_OF_PrepareTime: 98.874us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 240.726us
- __MAX_OF_PullTotalTime: 446.164us
- __MIN_OF_PullTotalTime: 154.965us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 94ns
- __MAX_OF_SetFinishedTime: 131ns
- __MIN_OF_SetFinishedTime: 63ns
- SetFinishingTime: 195ns
- __MAX_OF_SetFinishingTime: 319ns
- __MIN_OF_SetFinishingTime: 131ns
UniqueMetrics:

用时8秒的Query:
Summary:
- Query ID: 17062256-9982-11ee-a307-6cfe5438c9b1
- Start Time: 2023-12-13 14:37:30
- End Time: 2023-12-13 14:37:39
- Total: 8s472ms
- Query Type: Query
- Query State: EOF
- StarRocks Version: 2.5.4-1021a92
- User: root
- Default Db: ODS
- Sql Statement: /* ApplicationName=DBeaver 23.2.5 - SQLEditor / select /+SET_VAR(is_report_success=true)*/ *
from ODS.TEST
where TRADE_TYPE not in (30, 33, 34, 40, 41)
and MNO =‘3992211053’
and STORE_NO = ‘3992211053’
and PAY_TIME >=‘2023-10-01’ and PAY_TIME <‘2023-10-11’
LIMIT 0, 200
- QueryCpuCost: 3s77ms
- QueryMemCost: 842.978MB
- Variables: parallel_fragment_exec_instance_num=1,max_parallel_scan_instance_num=-1,pipeline_dop=0,enable_adaptive_sink_dop=true
- Collect Profile Time: 170ms
Planner:
- Analyzer: 0ms / 1
- CoordDeliverExec: 13ms / 1
- CoordPrepareExec: 0ms / 1
- ExecPlanBuild: 0ms / 1
- Optimizer: 75ms / 1
- Total: 76ms / 1
Optimizer:
- CostBaseOptimize: 0ms / 1
- PhysicalRewrite: 0ms / 1
- RuleBaseOptimize: 1ms / 1
- preprocessMvs: 73ms / 1
Execution Profile 17062256-9982-11ee-a307-6cfe5438c9b1:
- ExecutionTotalTime: 9s42ms
Fragment 0:
- BackendAddresses: 10.3.138.105:9060
- BackendNum: 1
- FragmentInstancePrepareTime: 1.148ms
- prepare-fragment-ctx: 15.622us
- prepare-pipeline-driver: 96.820us
- prepare-query-ctx: 6.218us
- prepare-runtime-state: 96.820us
- InstanceNum: 1
- PeakMemoryUsage: 1.18 MB
- QueryMemoryLimit: 183.22 GB
Pipeline (id=0):
- ActiveTime: 1.81ms
- __MAX_OF_ActiveTime: 2.482ms
- __MIN_OF_ActiveTime: 432.10us
- BlockByInputEmpty: 109
- __MAX_OF_BlockByInputEmpty: 4
- __MIN_OF_BlockByInputEmpty: 3
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 32
- DriverPrepareTime: 76.685us
- __MAX_OF_DriverPrepareTime: 216.319us
- __MIN_OF_DriverPrepareTime: 56.987us
- DriverTotalTime: 7s388ms
- __MAX_OF_DriverTotalTime: 8s390ms
- __MIN_OF_DriverTotalTime: 6s703ms
- OverheadTime: 219.713us
- __MAX_OF_OverheadTime: 445.90us
- __MIN_OF_OverheadTime: 108.651us
- PendingTime: 7s385ms
- __MAX_OF_PendingTime: 8s386ms
- __MIN_OF_PendingTime: 6s699ms
- InputEmptyTime: 7s385ms
- __MAX_OF_InputEmptyTime: 8s386ms
- __MIN_OF_InputEmptyTime: 6s699ms
- FirstInputEmptyTime: 5s616ms
- __MAX_OF_FirstInputEmptyTime: 5s616ms
- __MIN_OF_FirstInputEmptyTime: 5s616ms
- FollowupInputEmptyTime: 1s769ms
- __MAX_OF_FollowupInputEmptyTime: 2s770ms
- __MIN_OF_FollowupInputEmptyTime: 1s83ms
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 141
- __MAX_OF_ScheduleCount: 5
- __MIN_OF_ScheduleCount: 4
- ScheduleTime: 2.371ms
- __MAX_OF_ScheduleTime: 3.510ms
- __MIN_OF_ScheduleTime: 1.353ms
- TotalDegreeOfParallelism: 32
- YieldByPreempt: 0
- YieldByTimeLimit: 0
RESULT_SINK:
CommonMetrics:
- CloseTime: 6.350us
- __MAX_OF_CloseTime: 69.555us
- __MIN_OF_CloseTime: 794ns
- OperatorTotalTime: 237.151us
- __MAX_OF_OperatorTotalTime: 591.429us
- __MIN_OF_OperatorTotalTime: 29.158us
- PeakMemoryUsage: 0.00
- PrepareTime: 18.257us
- __MAX_OF_PrepareTime: 37.205us
- __MIN_OF_PrepareTime: 13.79us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 84
- __MAX_OF_PushChunkNum: 5
- __MIN_OF_PushChunkNum: 1
- PushRowNum: 200
- __MAX_OF_PushRowNum: 22
- __MIN_OF_PushRowNum: 1
- PushTotalTime: 230.530us
- __MAX_OF_PushTotalTime: 589.666us
- __MIN_OF_PushTotalTime: 27.488us
- SetFinishedTime: 27ns
- __MAX_OF_SetFinishedTime: 42ns
- __MIN_OF_SetFinishedTime: 22ns
- SetFinishingTime: 242ns
- __MAX_OF_SetFinishingTime: 1.319us
- __MIN_OF_SetFinishingTime: 51ns
UniqueMetrics:
LIMIT (plan_node_id=1):
CommonMetrics:
- CloseTime: 3.22us
- __MAX_OF_CloseTime: 10.145us
- __MIN_OF_CloseTime: 108ns
- OperatorTotalTime: 6.570us
- __MAX_OF_OperatorTotalTime: 23.164us
- __MIN_OF_OperatorTotalTime: 1.99us
- PeakMemoryUsage: 0.00
- PrepareTime: 13.833us
- __MAX_OF_PrepareTime: 27.77us
- __MIN_OF_PrepareTime: 8.907us
- PullChunkNum: 84
- __MAX_OF_PullChunkNum: 5
- __MIN_OF_PullChunkNum: 1
- PullRowNum: 200
- __MAX_OF_PullRowNum: 22
- __MIN_OF_PullRowNum: 1
- PullTotalTime: 436ns
- __MAX_OF_PullTotalTime: 767ns
- __MIN_OF_PullTotalTime: 199ns
- PushChunkNum: 99
- __MAX_OF_PushChunkNum: 5
- __MIN_OF_PushChunkNum: 2
- PushRowNum: 233
- __MAX_OF_PushRowNum: 22
- __MIN_OF_PushRowNum: 2
- PushTotalTime: 3.14us
- __MAX_OF_PushTotalTime: 16.533us
- __MIN_OF_PushTotalTime: 595ns
- SetFinishedTime: 27ns
- __MAX_OF_SetFinishedTime: 39ns
- __MIN_OF_SetFinishedTime: 23ns
- SetFinishingTime: 69ns
- __MAX_OF_SetFinishingTime: 128ns
- __MIN_OF_SetFinishingTime: 51ns
UniqueMetrics:
EXCHANGE_SOURCE (plan_node_id=1):
CommonMetrics:
- CloseTime: 2.482us
- __MAX_OF_CloseTime: 7.933us
- __MIN_OF_CloseTime: 637ns
- JoinRuntimeFilterEvaluate: 0
- JoinRuntimeFilterHashTime: 0ns
- JoinRuntimeFilterInputRows: 0
- JoinRuntimeFilterOutputRows: 0
- JoinRuntimeFilterTime: 0ns
- OperatorTotalTime: 618.169us
- __MAX_OF_OperatorTotalTime: 2.46ms
- __MIN_OF_OperatorTotalTime: 182.973us
- PeakMemoryUsage: 0.00
- PrepareTime: 18.12us
- __MAX_OF_PrepareTime: 132.653us
- __MIN_OF_PrepareTime: 9.627us
- PullChunkNum: 99
- __MAX_OF_PullChunkNum: 5
- __MIN_OF_PullChunkNum: 2
- PullRowNum: 233
- __MAX_OF_PullRowNum: 22
- __MIN_OF_PullRowNum: 2
- PullTotalTime: 611.533us
- __MAX_OF_PullTotalTime: 2.44ms
- __MIN_OF_PullTotalTime: 181.648us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 247ns
- __MAX_OF_SetFinishedTime: 4.464us
- __MIN_OF_SetFinishedTime: 36ns
- SetFinishingTime: 3.905us
- __MAX_OF_SetFinishingTime: 98.284us
- __MIN_OF_SetFinishingTime: 521ns
UniqueMetrics:
- BufferUnplugCount: 5
- BytesPassThrough: 60.55 KB
- BytesReceived: 183.92 KB
- ClosureBlockCount: 0
- ClosureBlockTime: 0ns
- DecompressChunkTime: 0ns
- DeserializeChunkTime: 15.844ms
- ReceiverProcessTotalTime: 1.95ms
- RequestReceived: 116
- SenderTotalTime: 1.74ms
- SenderWaitLockTime: 40.618us
Fragment 1:
- BackendAddresses: 10.30.138.6:9060,10.30.138.1:9060,10.30.138.5:9060,10.30.138.4:9060,10.30.138.2:9060
- BackendNum: 5
- FragmentInstancePrepareTime: 1.830ms
- __MAX_OF_FragmentInstancePrepareTime: 2.90ms
- __MIN_OF_FragmentInstancePrepareTime: 1.648ms
- prepare-fragment-ctx: 17.563us
- prepare-pipeline-driver: 233.114us
- prepare-query-ctx: 5.182us
- prepare-runtime-state: 233.114us
- InstanceNum: 5
- PeakMemoryUsage: 3.50 GB
- __MAX_OF_PeakMemoryUsage: 842.96 MB
- __MIN_OF_PeakMemoryUsage: 648.57 MB
- QueryMemoryLimit: 916.12 GB
- __MAX_OF_QueryMemoryLimit: 183.22 GB
- __MIN_OF_QueryMemoryLimit: 183.22 GB
Pipeline (id=1):
- ActiveTime: 261.634ms
- __MAX_OF_ActiveTime: 656.768ms
- __MIN_OF_ActiveTime: 44.250ms
- BlockByInputEmpty: 1.08K (1080)
- __MAX_OF_BlockByInputEmpty: 9
- __MIN_OF_BlockByInputEmpty: 5
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 32
- DriverPrepareTime: 104.191us
- __MAX_OF_DriverPrepareTime: 237.661us
- __MIN_OF_DriverPrepareTime: 72.261us
- DriverTotalTime: 6s475ms
- __MAX_OF_DriverTotalTime: 8s534ms
- __MIN_OF_DriverTotalTime: 5s613ms
- OverheadTime: 110.976us
- __MAX_OF_OverheadTime: 1.204ms
- __MIN_OF_OverheadTime: 0ns
- PendingTime: 6s208ms
- __MAX_OF_PendingTime: 8s133ms
- __MIN_OF_PendingTime: 4s921ms
- InputEmptyTime: 6s150ms
- __MAX_OF_InputEmptyTime: 7s858ms
- __MIN_OF_InputEmptyTime: 4s917ms
- FirstInputEmptyTime: 356.32us
- __MAX_OF_FirstInputEmptyTime: 472.193us
- __MIN_OF_FirstInputEmptyTime: 224.307us
- FollowupInputEmptyTime: 6s149ms
- __MAX_OF_FollowupInputEmptyTime: 7s858ms
- __MIN_OF_FollowupInputEmptyTime: 4s916ms
- OutputFullTime: 0ns
- PendingFinishTime: 57.952ms
- __MAX_OF_PendingFinishTime: 275.903ms
- __MIN_OF_PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 1.248K (1248)
- __MAX_OF_ScheduleCount: 10
- __MIN_OF_ScheduleCount: 6
- ScheduleTime: 5.595ms
- __MAX_OF_ScheduleTime: 72.636ms
- __MIN_OF_ScheduleTime: 2.106ms
- TotalDegreeOfParallelism: 160
- __MAX_OF_TotalDegreeOfParallelism: 32
- __MIN_OF_TotalDegreeOfParallelism: 32
- YieldByPreempt: 0
- YieldByTimeLimit: 74
- __MAX_OF_YieldByTimeLimit: 2
- __MIN_OF_YieldByTimeLimit: 0
EXCHANGE_SINK (plan_node_id=1):
CommonMetrics:
- CloseTime: 1.801us
- __MAX_OF_CloseTime: 50.354us
- __MIN_OF_CloseTime: 295ns
- OperatorTotalTime: 312.364us
- __MAX_OF_OperatorTotalTime: 1.836ms
- __MIN_OF_OperatorTotalTime: 5.61us
- PeakMemoryUsage: 0.00
- PrepareTime: 33.796us
- __MAX_OF_PrepareTime: 108.108us
- __MIN_OF_PrepareTime: 23.880us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 136
- __MAX_OF_PushChunkNum: 1
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 314
- __MAX_OF_PushRowNum: 7
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 146.429us
- __MAX_OF_PushTotalTime: 804.210us
- __MIN_OF_PushTotalTime: 0ns
- SetFinishedTime: 32ns
- __MAX_OF_SetFinishedTime: 69ns
- __MIN_OF_SetFinishedTime: 22ns
- SetFinishingTime: 164.99us
- __MAX_OF_SetFinishingTime: 1.262ms
- __MIN_OF_SetFinishingTime: 4.644us
UniqueMetrics:
- DestID: 1
- DestFragments: 17062256998211ee-a3076cfe5438c9b7
- PartType: UNPARTITIONED
- ChannelNum: 1
- BytesPassThrough: 60.55 KB
- __MAX_OF_BytesPassThrough: 4.38 KB
- __MIN_OF_BytesPassThrough: 0.00
- BytesSent: 227.63 KB
- __MAX_OF_BytesSent: 67.06 KB
- __MIN_OF_BytesSent: 0.00
- CompressTime: 0ns
- NetworkBandwidth: 199.72179317474365 MB/sec
- __MAX_OF_NetworkBandwidth: 164.14661121368408 MB/sec
- __MIN_OF_NetworkBandwidth: 0.0 /sec
- NetworkTime: 28.182ms
- __MAX_OF_NetworkTime: 134.200ms
- __MIN_OF_NetworkTime: 250.403us
- OverallThroughput: 51.31104755401611 MB/sec
- __MAX_OF_OverallThroughput: 32.4699182510376 MB/sec
- __MIN_OF_OverallThroughput: 0.0 /sec
- OverallTime: 30.645ms
- __MAX_OF_OverallTime: 137.6ms
- __MIN_OF_OverallTime: 1.922ms
- RequestSent: 107
- __MAX_OF_RequestSent: 29
- __MIN_OF_RequestSent: 0
- RpcAvgTime: 1.101ms
- __MAX_OF_RpcAvgTime: 5.161ms
- __MIN_OF_RpcAvgTime: 58.983us
- RpcCount: 141
- __MAX_OF_RpcCount: 30
- __MIN_OF_RpcCount: 25
- SerializeChunkTime: 68.50us
- __MAX_OF_SerializeChunkTime: 314.636us
- __MIN_OF_SerializeChunkTime: 0ns
- ShuffleHashTime: 0ns
- UncompressedBytes: 227.63 KB
- __MAX_OF_UncompressedBytes: 5.00 KB
- __MIN_OF_UncompressedBytes: 0.00
- WaitTime: 58.786ms
- __MAX_OF_WaitTime: 276.416ms
- __MIN_OF_WaitTime: 1.90ms
CHUNK_ACCUMULATE (plan_node_id=0):
CommonMetrics:
- CloseTime: 961ns
- __MAX_OF_CloseTime: 10.215us
- __MIN_OF_CloseTime: 83ns
- OperatorTotalTime: 44.94us
- __MAX_OF_OperatorTotalTime: 193.392us
- __MIN_OF_OperatorTotalTime: 302ns
- PeakMemoryUsage: 0.00
- PrepareTime: 12.680us
- __MAX_OF_PrepareTime: 40.395us
- __MIN_OF_PrepareTime: 8.7us
- PullChunkNum: 136
- __MAX_OF_PullChunkNum: 1
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 314
- __MAX_OF_PullRowNum: 7
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 630ns
- __MAX_OF_PullTotalTime: 7.840us
- __MIN_OF_PullTotalTime: 0ns
- PushChunkNum: 209
- __MAX_OF_PushChunkNum: 3
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 314
- __MAX_OF_PushRowNum: 7
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 42.10us
- __MAX_OF_PushTotalTime: 192.231us
- __MIN_OF_PushTotalTime: 0ns
- SetFinishedTime: 202ns
- __MAX_OF_SetFinishedTime: 530ns
- __MIN_OF_SetFinishedTime: 57ns
- SetFinishingTime: 287ns
- __MAX_OF_SetFinishingTime: 12.149us
- __MIN_OF_SetFinishingTime: 23ns
UniqueMetrics:
OLAP_SCAN (plan_node_id=0):
CommonMetrics:
- CloseTime: 1.199ms
- __MAX_OF_CloseTime: 5.488ms
- __MIN_OF_CloseTime: 582.474us
- JoinRuntimeFilterEvaluate: 0
- JoinRuntimeFilterHashTime: 0ns
- JoinRuntimeFilterInputRows: 0
- JoinRuntimeFilterOutputRows: 0
- JoinRuntimeFilterTime: 0ns
- OperatorTotalTime: 261.414ms
- __MAX_OF_OperatorTotalTime: 656.815ms
- __MIN_OF_OperatorTotalTime: 44.560ms
- PeakMemoryUsage: 0.00
- PrepareTime: 20.333us
- __MAX_OF_PrepareTime: 51.772us
- __MIN_OF_PrepareTime: 12.145us
- PullChunkNum: 209
- __MAX_OF_PullChunkNum: 3
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 314
- __MAX_OF_PullRowNum: 7
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 260.213ms
- __MAX_OF_PullTotalTime: 655.391ms
- __MIN_OF_PullTotalTime: 42.957ms
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 127ns
- __MAX_OF_SetFinishedTime: 234ns
- __MIN_OF_SetFinishedTime: 24ns
- SetFinishingTime: 1.18us
- __MAX_OF_SetFinishingTime: 9.868us
- __MIN_OF_SetFinishingTime: 436ns
UniqueMetrics:
- MorselQueueType: physical_split_morsel_queue
- BufferUnplugThreshold: 18
- SharedScan: False
- Predicates: 25: TRADE_TYPE NOT IN (30, 33, 34, 40, 41), 4: MNO = ‘3992211053’, 31: STORE_NO = ‘3992211053’
- Rollup: TEST
- Table: TEST
- BufferUnplugCount: 0
- BytesRead: 367.97 MB
- __MAX_OF_BytesRead: 9.32 MB
- __MIN_OF_BytesRead: 108.00 B
- CachedPagesNum: 2.469K (2469)
- __MAX_OF_CachedPagesNum: 52
- __MIN_OF_CachedPagesNum: 0
- ChunkBufferCapacity: 2.048K (2048)
- CompressedBytesRead: 1.16 GB
- __MAX_OF_CompressedBytesRead: 5.42 MB
- __MIN_OF_CompressedBytesRead: 0.00
- CreateSegmentIter: 12.711ms
- __MAX_OF_CreateSegmentIter: 251.662ms
- __MIN_OF_CreateSegmentIter: 58.619us
- DefaultChunkBufferCapacity: 1.178K (1178)
- DictDecode: 6.828us
- __MAX_OF_DictDecode: 21.273us
- __MIN_OF_DictDecode: 3.276us
- GetDelVec: 12.548ms
- __MAX_OF_GetDelVec: 251.442ms
- __MIN_OF_GetDelVec: 703ns
- GetRowsets: 2.296us
- __MAX_OF_GetRowsets: 13.773us
- __MIN_OF_GetRowsets: 600ns
- IOTaskExecTime: 2s137ms
- __MAX_OF_IOTaskExecTime: 7s334ms
- __MIN_OF_IOTaskExecTime: 1.813ms
- IOTaskWaitTime: 1s467ms
- __MAX_OF_IOTaskWaitTime: 4s492ms
- __MIN_OF_IOTaskWaitTime: 14.177us
- IOTime: 1s876ms
- __MAX_OF_IOTime: 6s695ms
- __MIN_OF_IOTime: 0ns
- LateMaterialize: 1s200ms
- __MAX_OF_LateMaterialize: 4s647ms
- __MIN_OF_LateMaterialize: 79.944ms
- MorselsCount: 736
- __MAX_OF_MorselsCount: 7
- __MIN_OF_MorselsCount: 4
- PeakChunkBufferSize: 109
- PushdownPredicates: 3
- RawRowsRead: 37.537396M (37537396)
- __MAX_OF_RawRowsRead: 317.179K (317179)
- __MIN_OF_RawRowsRead: 0
- ReadPagesNum: 44.036K (44036)
- __MAX_OF_ReadPagesNum: 219
- __MIN_OF_ReadPagesNum: 26
- RowsRead: 314
- __MAX_OF_RowsRead: 5
- __MIN_OF_RowsRead: 0
- ScanTime: 3s605ms
- __MAX_OF_ScanTime: 8s245ms
- __MIN_OF_ScanTime: 1s143ms
- SegmentInit: 1s695ms
- __MAX_OF_SegmentInit: 6s580ms
- __MIN_OF_SegmentInit: 1.8ms
- BitmapIndexFilter: 0ns
- BitmapIndexFilterRows: 0
- BloomFilterFilterRows: 0
- SegmentRuntimeZoneMapFilterRows: 0
- SegmentZoneMapFilterRows: 0
- ShortKeyFilterRows: 0
- ZoneMapIndexFilterRows: 0
- SegmentRead: 64.113ms
- __MAX_OF_SegmentRead: 1s150ms
- __MIN_OF_SegmentRead: 2.515us
- BlockFetch: 32.465ms
- __MAX_OF_BlockFetch: 885.284ms
- __MIN_OF_BlockFetch: 2.86us
- BlockFetchCount: 9.293K (9293)
- __MAX_OF_BlockFetchCount: 78
- __MIN_OF_BlockFetchCount: 0
- BlockSeek: 95.550ms
- __MAX_OF_BlockSeek: 2s333ms
- __MIN_OF_BlockSeek: 3.906us
- BlockSeekCount: 9.24K (9240)
- __MAX_OF_BlockSeekCount: 82
- __MIN_OF_BlockSeekCount: 0
- ChunkCopy: 3.624us
- __MAX_OF_ChunkCopy: 24.863us
- __MIN_OF_ChunkCopy: 0ns
- DecompressT: 1.470ms
- __MAX_OF_DecompressT: 5.61ms
- __MIN_OF_DecompressT: 0ns
- DelVecFilterRows: 423.179K (423179)
- __MAX_OF_DelVecFilterRows: 2.698K (2698)
- __MIN_OF_DelVecFilterRows: 0
- IndexLoad: 0ns
- PredFilter: 83.169us
- __MAX_OF_PredFilter: 1.854ms
- __MIN_OF_PredFilter: 0ns
- PredFilterRows: 37.537082M (37537082)
- __MAX_OF_PredFilterRows: 317.178K (317178)
- __MIN_OF_PredFilterRows: 0
- RowsetsReadCount: 21.1K (21100)
- __MAX_OF_RowsetsReadCount: 59
- __MIN_OF_RowsetsReadCount: 24
- SegmentsReadCount: 736
- __MAX_OF_SegmentsReadCount: 2
- __MIN_OF_SegmentsReadCount: 1
- TotalColumnsDataPageCount: 1.008604M (1008604)
- __MAX_OF_TotalColumnsDataPageCount: 4.26K (4260)
- __MIN_OF_TotalColumnsDataPageCount: 124
- SubmitTaskCount: 945
- __MAX_OF_SubmitTaskCount: 8
- __MIN_OF_SubmitTaskCount: 4
- TabletCount: 4
- UncompressedBytesRead: 1.46 GB
- __MAX_OF_UncompressedBytesRead: 6.99 MB
- __MIN_OF_UncompressedBytesRead: 0.00
Pipeline (id=0):
- ActiveTime: 284.428us
- __MAX_OF_ActiveTime: 352.787us
- __MIN_OF_ActiveTime: 246.968us
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 408.355us
- __MAX_OF_DriverPrepareTime: 631.91us
- __MIN_OF_DriverPrepareTime: 318.993us
- DriverTotalTime: 3.788ms
- __MAX_OF_DriverTotalTime: 4.334ms
- __MIN_OF_DriverTotalTime: 3.311ms
- OverheadTime: 0ns
- PendingTime: 0ns
- InputEmptyTime: 0ns
- FirstInputEmptyTime: 0ns
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 5
- __MAX_OF_ScheduleCount: 1
- __MIN_OF_ScheduleCount: 1
- ScheduleTime: 3.503ms
- __MAX_OF_ScheduleTime: 3.982ms
- __MIN_OF_ScheduleTime: 3.64ms
- TotalDegreeOfParallelism: 5
- __MAX_OF_TotalDegreeOfParallelism: 1
- __MIN_OF_TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
NOOP_SINK (plan_node_id=0):
CommonMetrics:
- CloseTime: 528ns
- __MAX_OF_CloseTime: 840ns
- __MIN_OF_CloseTime: 284ns
- OperatorTotalTime: 718ns
- __MAX_OF_OperatorTotalTime: 1.93us
- __MIN_OF_OperatorTotalTime: 408ns
- PeakMemoryUsage: 0.00
- PrepareTime: 16.35us
- __MAX_OF_PrepareTime: 21.75us
- __MIN_OF_PrepareTime: 12.876us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- SetFinishedTime: 25ns
- __MAX_OF_SetFinishedTime: 33ns
- __MIN_OF_SetFinishedTime: 22ns
- SetFinishingTime: 164ns
- __MAX_OF_SetFinishingTime: 231ns
- __MIN_OF_SetFinishingTime: 102ns
UniqueMetrics:
OLAP_SCAN_PREPARE (plan_node_id=0):
CommonMetrics:
- CloseTime: 36.553us
- __MAX_OF_CloseTime: 125.102us
- __MIN_OF_CloseTime: 7.454us
- OperatorTotalTime: 314.64us
- __MAX_OF_OperatorTotalTime: 471.916us
- __MIN_OF_OperatorTotalTime: 251.673us
- PeakMemoryUsage: 0.00
- PrepareTime: 362.261us
- __MAX_OF_PrepareTime: 594.441us
- __MIN_OF_PrepareTime: 276.786us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 277.238us
- __MAX_OF_PullTotalTime: 346.589us
- __MIN_OF_PullTotalTime: 241.531us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 104ns
- __MAX_OF_SetFinishedTime: 150ns
- __MIN_OF_SetFinishedTime: 72ns
- SetFinishingTime: 167ns
- __MAX_OF_SetFinishingTime: 224ns
- __MIN_OF_SetFinishingTime: 76ns
UniqueMetrics:

弄个文件吧,结构都没了