【详述】order by+ limit offset 分页，多次查询返回结果不同
【StarRocks版本】2.5.0
确认一下集群是哪个版本的，我这边2.5.5上没有复现出来。可以提供下这两个查询对应的 profile 信息。获取profile信息可以参考这个文档。 https://docs.starrocks.io/zh-cn/latest/administration/query_profile
Query:
Summary:
- Query ID: 817ff561-f3cf-11ed-b7d8-52540022dc0b
- Start Time: 2023-05-16 17:53:27
- End Time: 2023-05-16 17:53:28
- Total: 606ms
- Query Type: Query
- Query State: EOF
- StarRocks Version: 2.5.0-6abafd3
- User: root
- Default Db: ipp
- Sql Statement: select create_time,u_id from edu_biz_data_item_plus where substr(create_time,1,10)=‘2023-04-03’ order by create_time,u_id limit 3 offset 59998
- QueryCpuCost: 8ms
- QueryMemCost: 10.920MB
- Variables: parallel_fragment_exec_instance_num=1,pipeline_dop=0,enable_adaptive_sink_dop=false
- Collect Profile Time: 9ms
Planner:
- Analyzer: 0ms / 1
- CoordDeliverExec: 2ms / 1
- CoordPrepareExec: 0ms / 1
- ExecPlanBuild: 0ms / 1
- Optimizer: 1ms / 1
- Total: 1ms / 1
Optimizer:
- CostBaseOptimize: 0ms / 1
- PhysicalRewrite: 0ms / 1
- RuleBaseOptimize: 0ms / 1
- preprocessMvs: 0ms / 1
Execution Profile 817ff561-f3cf-11ed-b7d8-52540022dc0b:
- ExecutionTotalTime: 740.277ms
Fragment 0:
- BackendAddresses: 10.120.154.7:9060
- BackendNum: 1
- FragmentInstancePrepareTime: 213.727us
- InstanceNum: 1
- PeakMemoryUsage: 1.89 MB
- QueryMemoryLimit: 10.13 GB
Pipeline (id=0):
- ActiveTime: 2.345ms
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 136.595us
- DriverTotalTime: 602.551ms
- OverheadTime: 788.830us
- PendingTime: 600.171ms
- InputEmptyTime: 600.171ms
- FirstInputEmptyTime: 600.171ms
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 1
- ScheduleTime: 33.616us
- TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
RESULT_SINK:
CommonMetrics:
- CloseTime: 5.727us
- OperatorTotalTime: 45.795us
- PeakMemoryUsage: 0.00
- PrepareTime: 15.781us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 1
- PushRowNum: 3
- PushTotalTime: 39.892us
- SetFinishedTime: 30ns
- SetFinishingTime: 146ns
UniqueMetrics:
GLOBAL_MERGE_SOURCE (plan_node_id=2):
CommonMetrics:
- CloseTime: 288ns
- JoinRuntimeFilterEvaluate: 0
- JoinRuntimeFilterHashTime: 0ns
- JoinRuntimeFilterInputRows: 0
- JoinRuntimeFilterOutputRows: 0
- JoinRuntimeFilterTime: 0ns
- OperatorTotalTime: 1.510ms
- PeakMemoryUsage: 0.00
- PrepareTime: 69.61us
- PullChunkNum: 1
- PullRowNum: 3
- PullTotalTime: 1.499ms
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 110ns
- SetFinishingTime: 10.107us
UniqueMetrics:
- BufferUnplugCount: 0
- BytesPassThrough: 438.73 KB
- BytesReceived: 0.00
- ClosureBlockCount: 0
- ClosureBlockTime: 0ns
- DecompressChunkTime: 352.341us
- DeserializeChunkTime: 1.805ms
- ReceiverProcessTotalTime: 2.193ms
- RequestReceived: 3
- SenderTotalTime: 2.192ms
- SenderWaitLockTime: 626ns
Fragment 1:
- BackendAddresses: 10.120.154.10:9060,10.120.154.7:9060,10.120.154.9:9060
- BackendNum: 3
- FragmentInstancePrepareTime: 415.859us
- __MAX_OF_FragmentInstancePrepareTime: 456.683us
- __MIN_OF_FragmentInstancePrepareTime: 383.668us
- InstanceNum: 3
- PeakMemoryUsage: 28.81 MB
- __MAX_OF_PeakMemoryUsage: 10.92 MB
- __MIN_OF_PeakMemoryUsage: 8.17 MB
- QueryMemoryLimit: 30.39 GB
- __MAX_OF_QueryMemoryLimit: 10.13 GB
- __MIN_OF_QueryMemoryLimit: 10.13 GB
Pipeline (id=2):
- ActiveTime: 32.601ms
- __MAX_OF_ActiveTime: 97.695ms
- __MIN_OF_ActiveTime: 43.896us
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 70.477us
- __MAX_OF_DriverPrepareTime: 90.806us
- __MIN_OF_DriverPrepareTime: 57.228us
- DriverTotalTime: 502.381ms
- __MAX_OF_DriverTotalTime: 600.954ms
- __MIN_OF_DriverTotalTime: 373.30ms
- OverheadTime: 17.768us
- __MAX_OF_OverheadTime: 53.306us
- __MIN_OF_OverheadTime: 0ns
- PendingTime: 468.306ms
- __MAX_OF_PendingTime: 531.834ms
- __MIN_OF_PendingTime: 372.861ms
- InputEmptyTime: 463.728ms
- __MAX_OF_InputEmptyTime: 531.779ms
- __MIN_OF_InputEmptyTime: 361.925ms
- FirstInputEmptyTime: 463.728ms
- __MAX_OF_FirstInputEmptyTime: 531.779ms
- __MIN_OF_FirstInputEmptyTime: 361.925ms
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 4.579ms
- __MAX_OF_PendingFinishTime: 10.937ms
- __MIN_OF_PendingFinishTime: 57.42us
- PreconditionBlockTime: 0ns
- ScheduleCount: 3
- __MAX_OF_ScheduleCount: 1
- __MIN_OF_ScheduleCount: 1
- ScheduleTime: 1.472ms
- __MAX_OF_ScheduleTime: 3.34ms
- __MIN_OF_ScheduleTime: 103.283us
- TotalDegreeOfParallelism: 3
- __MAX_OF_TotalDegreeOfParallelism: 1
- __MIN_OF_TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
EXCHANGE_SINK (plan_node_id=2):
CommonMetrics:
- CloseTime: 11.766us
- __MAX_OF_CloseTime: 12.583us
- __MIN_OF_CloseTime: 10.467us
- OperatorTotalTime: 32.4ms
- __MAX_OF_OperatorTotalTime: 95.903ms
- __MIN_OF_OperatorTotalTime: 45.287us
- PeakMemoryUsage: 0.00
- PrepareTime: 36.719us
- __MAX_OF_PrepareTime: 45.547us
- __MIN_OF_PrepareTime: 30.655us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 15
- __MAX_OF_PushChunkNum: 15
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 60.001K (60001)
- __MAX_OF_PushRowNum: 60.001K (60001)
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 31.932ms
- __MAX_OF_PushTotalTime: 95.798ms
- __MIN_OF_PushTotalTime: 0ns
- SetFinishedTime: 32ns
- __MAX_OF_SetFinishedTime: 35ns
- __MIN_OF_SetFinishedTime: 30ns
- SetFinishingTime: 59.754us
- __MAX_OF_SetFinishingTime: 94.203us
- __MIN_OF_SetFinishingTime: 33.6us
UniqueMetrics:
- DestID: 2
- DestFragments: 817ff561f3cf11ed-b7d852540022dc0f
- PartType: UNPARTITIONED
- ChannelNum: 1
- BytesPassThrough: 0.00
- BytesSent: 438.73 KB
- __MAX_OF_BytesSent: 438.73 KB
- __MIN_OF_BytesSent: 0.00
- CompressTime: 389.534us
- __MAX_OF_CompressTime: 1.168ms
- __MIN_OF_CompressTime: 0ns
- NetworkBandwidth: 4.5693254470825195 MB/sec
- __MAX_OF_NetworkBandwidth: 4.5693254470825195 MB/sec
- __MIN_OF_NetworkBandwidth: 0.0 /sec
- NetworkTime: 35.35ms
- __MAX_OF_NetworkTime: 93.765ms
- __MIN_OF_NetworkTime: 36.481us
- OverallThroughput: 4.473394393920898 MB/sec
- __MAX_OF_OverallThroughput: 4.473394393920898 MB/sec
- __MIN_OF_OverallThroughput: 0.0 /sec
- OverallTime: 35.609ms
- __MAX_OF_OverallTime: 95.776ms
- __MIN_OF_OverallTime: 69.986us
- RequestSent: 2
- __MAX_OF_RequestSent: 2
- __MIN_OF_RequestSent: 0
- RpcAvgTime: 14.198ms
- __MAX_OF_RpcAvgTime: 31.255ms
- __MIN_OF_RpcAvgTime: 36.481us
- RpcCount: 5
- __MAX_OF_RpcCount: 3
- __MIN_OF_RpcCount: 1
- SerializeChunkTime: 1.317ms
- __MAX_OF_SerializeChunkTime: 3.952ms
- __MIN_OF_SerializeChunkTime: 0ns
- ShuffleHashTime: 0ns
- UncompressedBytes: 978.03 KB
- __MAX_OF_UncompressedBytes: 978.03 KB
- __MIN_OF_UncompressedBytes: 0.00
- WaitTime: 4.632ms
- __MAX_OF_WaitTime: 10.994ms
- __MIN_OF_WaitTime: 96.30us
LOCAL_MERGE_SOURCE (plan_node_id=1):
CommonMetrics:
- CloseTime: 17.188us
- __MAX_OF_CloseTime: 22.973us
- __MIN_OF_CloseTime: 10.527us
- OperatorTotalTime: 593.401us
- __MAX_OF_OperatorTotalTime: 1.732ms
- __MIN_OF_OperatorTotalTime: 16.492us
- PeakMemoryUsage: 0.00
- PrepareTime: 7.780us
- __MAX_OF_PrepareTime: 10.264us
- __MIN_OF_PrepareTime: 5.673us
- PullChunkNum: 15
- __MAX_OF_PullChunkNum: 15
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 60.001K (60001)
- __MAX_OF_PullRowNum: 60.001K (60001)
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 575.886us
- __MAX_OF_PullTotalTime: 1.713ms
- __MIN_OF_PullTotalTime: 5.658us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 113ns
- __MAX_OF_SetFinishedTime: 143ns
- __MIN_OF_SetFinishedTime: 76ns
- SetFinishingTime: 212ns
- __MAX_OF_SetFinishingTime: 231ns
- __MIN_OF_SetFinishingTime: 187ns
UniqueMetrics:
Pipeline (id=1):
- ActiveTime: 7.679ms
- __MAX_OF_ActiveTime: 52.187ms
- __MIN_OF_ActiveTime: 970.57us
- BlockByInputEmpty: 121
- __MAX_OF_BlockByInputEmpty: 15
- __MIN_OF_BlockByInputEmpty: 7
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 4
- DriverPrepareTime: 61.660us
- __MAX_OF_DriverPrepareTime: 99.913us
- __MIN_OF_DriverPrepareTime: 41.9us
- DriverTotalTime: 460.164ms
- __MAX_OF_DriverTotalTime: 532.712ms
- __MIN_OF_DriverTotalTime: 362.611ms
- OverheadTime: 4.61ms
- __MAX_OF_OverheadTime: 29.810ms
- __MIN_OF_OverheadTime: 0ns
- PendingTime: 435.217ms
- __MAX_OF_PendingTime: 523.0ms
- __MIN_OF_PendingTime: 351.67ms
- InputEmptyTime: 435.232ms
- __MAX_OF_InputEmptyTime: 523.15ms
- __MIN_OF_InputEmptyTime: 351.80ms
- FirstInputEmptyTime: 50.726us
- __MAX_OF_FirstInputEmptyTime: 64.898us
- __MIN_OF_FirstInputEmptyTime: 44.715us
- FollowupInputEmptyTime: 435.181ms
- __MAX_OF_FollowupInputEmptyTime: 522.953ms
- __MIN_OF_FollowupInputEmptyTime: 351.35ms
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 133
- __MAX_OF_ScheduleCount: 16
- __MIN_OF_ScheduleCount: 8
- ScheduleTime: 17.267ms
- __MAX_OF_ScheduleTime: 35.40ms
- __MIN_OF_ScheduleTime: 3.689ms
- TotalDegreeOfParallelism: 12
- __MAX_OF_TotalDegreeOfParallelism: 4
- __MIN_OF_TotalDegreeOfParallelism: 4
- YieldByPreempt: 0
- YieldByTimeLimit: 0
LOCAL_SORT_SINK (plan_node_id=1):
CommonMetrics:
- CloseTime: 4.810us
- __MAX_OF_CloseTime: 9.726us
- __MIN_OF_CloseTime: 3.3us
- OperatorTotalTime: 1.447ms
- __MAX_OF_OperatorTotalTime: 17.290ms
- __MIN_OF_OperatorTotalTime: 4.87us
- PeakMemoryUsage: 0.00
- PrepareTime: 17.101us
- __MAX_OF_PrepareTime: 32.62us
- __MIN_OF_PrepareTime: 9.815us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 17
- __MAX_OF_PushChunkNum: 17
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 66.417K (66417)
- __MAX_OF_PushRowNum: 66.417K (66417)
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 2.861us
- __MAX_OF_PushTotalTime: 34.336us
- __MIN_OF_PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 46ns
- __MAX_OF_SetFinishedTime: 120ns
- __MIN_OF_SetFinishedTime: 30ns
- SetFinishingTime: 1.439ms
- __MAX_OF_SetFinishingTime: 17.251ms
- __MIN_OF_SetFinishingTime: 831ns
UniqueMetrics:
- SortKeys: 9: create_time ASC, 2: u_id ASC
- SortType: TopN
- BuildingTime: 38.336us
- __MAX_OF_BuildingTime: 460.37us
- __MIN_OF_BuildingTime: 0ns
- MergingTime: 108.628us
- __MAX_OF_MergingTime: 1.303ms
- __MIN_OF_MergingTime: 0ns
- OutputTime: 40.954us
- __MAX_OF_OutputTime: 490.558us
- __MIN_OF_OutputTime: 0ns
- SortFilterRows: 0
- SortFilterTime: 0ns
- SortingTime: 1.290ms
- __MAX_OF_SortingTime: 15.483ms
- __MIN_OF_SortingTime: 0ns
CHUNK_ACCUMULATE (plan_node_id=0):
CommonMetrics:
- CloseTime: 293ns
- __MAX_OF_CloseTime: 473ns
- __MIN_OF_CloseTime: 218ns
- OperatorTotalTime: 1.303us
- __MAX_OF_OperatorTotalTime: 8.291us
- __MIN_OF_OperatorTotalTime: 480ns
- PeakMemoryUsage: 0.00
- PrepareTime: 8.518us
- __MAX_OF_PrepareTime: 13.145us
- __MIN_OF_PrepareTime: 5.986us
- PullChunkNum: 17
- __MAX_OF_PullChunkNum: 17
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 66.417K (66417)
- __MAX_OF_PullRowNum: 66.417K (66417)
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 189ns
- __MAX_OF_PullTotalTime: 2.276us
- __MIN_OF_PullTotalTime: 0ns
- PushChunkNum: 17
- __MAX_OF_PushChunkNum: 17
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 66.417K (66417)
- __MAX_OF_PushRowNum: 66.417K (66417)
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 388ns
- __MAX_OF_PushTotalTime: 4.659us
- __MIN_OF_PushTotalTime: 0ns
- SetFinishedTime: 178ns
- __MAX_OF_SetFinishedTime: 534ns
- __MIN_OF_SetFinishedTime: 92ns
- SetFinishingTime: 252ns
- __MAX_OF_SetFinishingTime: 492ns
- __MIN_OF_SetFinishingTime: 97ns
UniqueMetrics:
OLAP_SCAN (plan_node_id=0):
CommonMetrics:
- CloseTime: 765.215us
- __MAX_OF_CloseTime: 999.96us
- __MIN_OF_CloseTime: 593.912us
- JoinRuntimeFilterEvaluate: 0
- JoinRuntimeFilterHashTime: 0ns
- JoinRuntimeFilterInputRows: 0
- JoinRuntimeFilterOutputRows: 0
- JoinRuntimeFilterTime: 0ns
- OperatorTotalTime: 2.705ms
- __MAX_OF_OperatorTotalTime: 5.78ms
- __MIN_OF_OperatorTotalTime: 1.538ms
- PeakMemoryUsage: 0.00
- PrepareTime: 15.635us
- __MAX_OF_PrepareTime: 26.63us
- __MIN_OF_PrepareTime: 9.574us
- PullChunkNum: 17
- __MAX_OF_PullChunkNum: 17
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 66.417K (66417)
- __MAX_OF_PullRowNum: 66.417K (66417)
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 1.938ms
- __MAX_OF_PullTotalTime: 4.309ms
- __MIN_OF_PullTotalTime: 854.851us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 79ns
- __MAX_OF_SetFinishedTime: 285ns
- __MIN_OF_SetFinishedTime: 29ns
- SetFinishingTime: 1.914us
- __MAX_OF_SetFinishingTime: 13.930us
- __MIN_OF_SetFinishingTime: 349ns
UniqueMetrics:
- MorselQueueType: fixed_morsel_queue
- BufferUnplugThreshold: 32
- SharedScan: False
- Predicates: substr(CAST(9: create_time AS VARCHAR), 1, 10) = ‘2023-04-03’
- Rollup: edu_biz_data_item_plus
- Table: edu_biz_data_item_plus
- BufferUnplugCount: 0
- BytesRead: 609.62 MB
- __MAX_OF_BytesRead: 54.90 MB
- __MIN_OF_BytesRead: 4.64 KB
- CachedPagesNum: 10.114K (10114)
- __MAX_OF_CachedPagesNum: 893
- __MIN_OF_CachedPagesNum: 5
- ChunkBufferCapacity: 256
- CompressedBytesRead: 384.00 B
- __MAX_OF_CompressedBytesRead: 384.00 B
- __MIN_OF_CompressedBytesRead: 0.00
- CreateSegmentIter: 71.907us
- __MAX_OF_CreateSegmentIter: 2.27ms
- __MIN_OF_CreateSegmentIter: 11.769us
- DefaultChunkBufferCapacity: 256
- ExprFilterTime: 122.864ms
- __MAX_OF_ExprFilterTime: 424.253ms
- __MIN_OF_ExprFilterTime: 50.62us
- GetDelVec: 44.659us
- __MAX_OF_GetDelVec: 1.882ms
- __MIN_OF_GetDelVec: 2.1us
- GetRowsets: 634ns
- __MAX_OF_GetRowsets: 1.745us
- __MIN_OF_GetRowsets: 272ns
- IOTaskExecTime: 132.760ms
- __MAX_OF_IOTaskExecTime: 450.704ms
- __MIN_OF_IOTaskExecTime: 158.857us
- IOTaskWaitTime: 62.71ms
- __MAX_OF_IOTaskWaitTime: 179.881ms
- __MIN_OF_IOTaskWaitTime: 4.720ms
- IOTime: 282ns
- __MAX_OF_IOTime: 13.573us
- __MIN_OF_IOTime: 0ns
- MorselsCount: 154
- __MAX_OF_MorselsCount: 19
- __MIN_OF_MorselsCount: 10
- PeakChunkBufferSize: 26
- PushdownPredicates: 0
- RawRowsRead: 15.11535M (15115350)
- __MAX_OF_RawRowsRead: 1.308305M (1308305)
- __MIN_OF_RawRowsRead: 108
- ReadPagesNum: 10.12K (10120)
- __MAX_OF_ReadPagesNum: 893
- __MIN_OF_ReadPagesNum: 5
- RowsRead: 66.417K (66417)
- __MAX_OF_RowsRead: 66.417K (66417)
- __MIN_OF_RowsRead: 0
- ScanTime: 194.832ms
- __MAX_OF_ScanTime: 524.873ms
- __MIN_OF_ScanTime: 67.655ms
- SegmentInit: 801.755us
- __MAX_OF_SegmentInit: 22.177ms
- __MIN_OF_SegmentInit: 26.62us
- BitmapIndexFilter: 0ns
- BitmapIndexFilterRows: 0
- BloomFilterFilterRows: 0
- SegmentRuntimeZoneMapFilterRows: 0
- SegmentZoneMapFilterRows: 0
- ShortKeyFilterRows: 0
- ZoneMapIndexFilterRows: 0
- SegmentRead: 8.278ms
- __MAX_OF_SegmentRead: 35.811ms
- __MIN_OF_SegmentRead: 35.475us
- BlockFetch: 8.140ms
- __MAX_OF_BlockFetch: 35.487ms
- __MIN_OF_BlockFetch: 8.27us
- BlockFetchCount: 3.836K (3836)
- __MAX_OF_BlockFetchCount: 325
- __MIN_OF_BlockFetchCount: 2
- BlockSeek: 43.357us
- __MAX_OF_BlockSeek: 261.662us
- __MIN_OF_BlockSeek: 12.620us
- BlockSeekCount: 9.828K (9828)
- __MAX_OF_BlockSeekCount: 880
- __MIN_OF_BlockSeekCount: 2
- ChunkCopy: 0ns
- DecompressT: 0ns
- DelVecFilterRows: 52.322K (52322)
- __MAX_OF_DelVecFilterRows: 29.542K (29542)
- __MIN_OF_DelVecFilterRows: 0
- IndexLoad: 0ns
- PredFilter: 0ns
- PredFilterRows: 0
- RowsetsReadCount: 233
- __MAX_OF_RowsetsReadCount: 30
- __MIN_OF_RowsetsReadCount: 2
- SegmentsReadCount: 230
- __MAX_OF_SegmentsReadCount: 30
- __MIN_OF_SegmentsReadCount: 2
- TotalColumnsDataPageCount: 10.093K (10093)
- __MAX_OF_TotalColumnsDataPageCount: 892
- __MIN_OF_TotalColumnsDataPageCount: 4
- SubmitTaskCount: 154
- __MAX_OF_SubmitTaskCount: 19
- __MIN_OF_SubmitTaskCount: 10
- TabletCount: 51
- UncompressedBytesRead: 252.00 B
- __MAX_OF_UncompressedBytesRead: 252.00 B
- __MIN_OF_UncompressedBytesRead: 0.00
Pipeline (id=0):
- ActiveTime: 38.53us
- __MAX_OF_ActiveTime: 39.855us
- __MIN_OF_ActiveTime: 35.679us
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 158.968us
- __MAX_OF_DriverPrepareTime: 182.121us
- __MIN_OF_DriverPrepareTime: 127.818us
- DriverTotalTime: 423.807us
- __MAX_OF_DriverTotalTime: 571.335us
- __MIN_OF_DriverTotalTime: 327.178us
- OverheadTime: 0ns
- PendingTime: 0ns
- InputEmptyTime: 0ns
- FirstInputEmptyTime: 0ns
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 3
- __MAX_OF_ScheduleCount: 1
- __MIN_OF_ScheduleCount: 1
- ScheduleTime: 385.753us
- __MAX_OF_ScheduleTime: 531.480us
- __MIN_OF_ScheduleTime: 288.552us
- TotalDegreeOfParallelism: 3
- __MAX_OF_TotalDegreeOfParallelism: 1
- __MIN_OF_TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
NOOP_SINK (plan_node_id=0):
CommonMetrics:
- CloseTime: 196ns
- __MAX_OF_CloseTime: 210ns
- __MIN_OF_CloseTime: 176ns
- OperatorTotalTime: 317ns
- __MAX_OF_OperatorTotalTime: 352ns
- __MIN_OF_OperatorTotalTime: 278ns
- PeakMemoryUsage: 0.00
- PrepareTime: 10.584us
- __MAX_OF_PrepareTime: 12.283us
- __MIN_OF_PrepareTime: 8.952us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- SetFinishedTime: 34ns
- __MAX_OF_SetFinishedTime: 44ns
- __MIN_OF_SetFinishedTime: 29ns
- SetFinishingTime: 86ns
- __MAX_OF_SetFinishingTime: 118ns
- __MIN_OF_SetFinishingTime: 69ns
UniqueMetrics:
OLAP_SCAN_PREPARE (plan_node_id=0):
CommonMetrics:
- CloseTime: 17.472us
- __MAX_OF_CloseTime: 37.48us
- __MIN_OF_CloseTime: 6.723us
- OperatorTotalTime: 51.599us
- __MAX_OF_OperatorTotalTime: 69.284us
- __MIN_OF_OperatorTotalTime: 42.338us
- PeakMemoryUsage: 0.00
- PrepareTime: 111.19us
- __MAX_OF_PrepareTime: 122.884us
- __MIN_OF_PrepareTime: 97.692us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 33.976us
- __MAX_OF_PullTotalTime: 35.470us
- __MIN_OF_PullTotalTime: 32.104us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 61ns
- __MAX_OF_SetFinishedTime: 67ns
- __MIN_OF_SetFinishedTime: 54ns
- SetFinishingTime: 89ns
- __MAX_OF_SetFinishingTime: 112ns
- __MIN_OF_SetFinishingTime: 78ns
UniqueMetrics:
Summary:
- Query ID: 817ff561-f3cf-11ed-b7d8-52540022dc0b
- Start Time: 2023-05-16 17:53:27
- End Time: 2023-05-16 17:53:28
- Total: 606ms
- Query Type: Query
- Query State: EOF
- StarRocks Version: 2.5.0-6abafd3
- User: root
- Default Db: ipp
- Sql Statement: select create_time,u_id from edu_biz_data_item_plus where substr(create_time,1,10)=‘2023-04-03’ order by create_time,u_id limit 3 offset 59998
- QueryCpuCost: 8ms
- QueryMemCost: 10.920MB
- Variables: parallel_fragment_exec_instance_num=1,pipeline_dop=0,enable_adaptive_sink_dop=false
- Collect Profile Time: 9ms
Planner:
- Analyzer: 0ms / 1
- CoordDeliverExec: 2ms / 1
- CoordPrepareExec: 0ms / 1
- ExecPlanBuild: 0ms / 1
- Optimizer: 1ms / 1
- Total: 1ms / 1
Optimizer:
- CostBaseOptimize: 0ms / 1
- PhysicalRewrite: 0ms / 1
- RuleBaseOptimize: 0ms / 1
- preprocessMvs: 0ms / 1
Execution Profile 817ff561-f3cf-11ed-b7d8-52540022dc0b:
- ExecutionTotalTime: 740.277ms
Fragment 0:
- BackendAddresses: 10.120.154.7:9060
- BackendNum: 1
- FragmentInstancePrepareTime: 213.727us
- InstanceNum: 1
- PeakMemoryUsage: 1.89 MB
- QueryMemoryLimit: 10.13 GB
Pipeline (id=0):
- ActiveTime: 2.345ms
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 136.595us
- DriverTotalTime: 602.551ms
- OverheadTime: 788.830us
- PendingTime: 600.171ms
- InputEmptyTime: 600.171ms
- FirstInputEmptyTime: 600.171ms
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 1
- ScheduleTime: 33.616us
- TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
RESULT_SINK:
CommonMetrics:
- CloseTime: 5.727us
- OperatorTotalTime: 45.795us
- PeakMemoryUsage: 0.00
- PrepareTime: 15.781us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 1
- PushRowNum: 3
- PushTotalTime: 39.892us
- SetFinishedTime: 30ns
- SetFinishingTime: 146ns
UniqueMetrics:
GLOBAL_MERGE_SOURCE (plan_node_id=2):
CommonMetrics:
- CloseTime: 288ns
- JoinRuntimeFilterEvaluate: 0
- JoinRuntimeFilterHashTime: 0ns
- JoinRuntimeFilterInputRows: 0
- JoinRuntimeFilterOutputRows: 0
- JoinRuntimeFilterTime: 0ns
- OperatorTotalTime: 1.510ms
- PeakMemoryUsage: 0.00
- PrepareTime: 69.61us
- PullChunkNum: 1
- PullRowNum: 3
- PullTotalTime: 1.499ms
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 110ns
- SetFinishingTime: 10.107us
UniqueMetrics:
- BufferUnplugCount: 0
- BytesPassThrough: 438.73 KB
- BytesReceived: 0.00
- ClosureBlockCount: 0
- ClosureBlockTime: 0ns
- DecompressChunkTime: 352.341us
- DeserializeChunkTime: 1.805ms
- ReceiverProcessTotalTime: 2.193ms
- RequestReceived: 3
- SenderTotalTime: 2.192ms
- SenderWaitLockTime: 626ns
Fragment 1:
- BackendAddresses: 10.120.154.10:9060,10.120.154.7:9060,10.120.154.9:9060
- BackendNum: 3
- FragmentInstancePrepareTime: 415.859us
- __MAX_OF_FragmentInstancePrepareTime: 456.683us
- __MIN_OF_FragmentInstancePrepareTime: 383.668us
- InstanceNum: 3
- PeakMemoryUsage: 28.81 MB
- __MAX_OF_PeakMemoryUsage: 10.92 MB
- __MIN_OF_PeakMemoryUsage: 8.17 MB
- QueryMemoryLimit: 30.39 GB
- __MAX_OF_QueryMemoryLimit: 10.13 GB
- __MIN_OF_QueryMemoryLimit: 10.13 GB
Pipeline (id=2):
- ActiveTime: 32.601ms
- __MAX_OF_ActiveTime: 97.695ms
- __MIN_OF_ActiveTime: 43.896us
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 70.477us
- __MAX_OF_DriverPrepareTime: 90.806us
- __MIN_OF_DriverPrepareTime: 57.228us
- DriverTotalTime: 502.381ms
- __MAX_OF_DriverTotalTime: 600.954ms
- __MIN_OF_DriverTotalTime: 373.30ms
- OverheadTime: 17.768us
- __MAX_OF_OverheadTime: 53.306us
- __MIN_OF_OverheadTime: 0ns
- PendingTime: 468.306ms
- __MAX_OF_PendingTime: 531.834ms
- __MIN_OF_PendingTime: 372.861ms
- InputEmptyTime: 463.728ms
- __MAX_OF_InputEmptyTime: 531.779ms
- __MIN_OF_InputEmptyTime: 361.925ms
- FirstInputEmptyTime: 463.728ms
- __MAX_OF_FirstInputEmptyTime: 531.779ms
- __MIN_OF_FirstInputEmptyTime: 361.925ms
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 4.579ms
- __MAX_OF_PendingFinishTime: 10.937ms
- __MIN_OF_PendingFinishTime: 57.42us
- PreconditionBlockTime: 0ns
- ScheduleCount: 3
- __MAX_OF_ScheduleCount: 1
- __MIN_OF_ScheduleCount: 1
- ScheduleTime: 1.472ms
- __MAX_OF_ScheduleTime: 3.34ms
- __MIN_OF_ScheduleTime: 103.283us
- TotalDegreeOfParallelism: 3
- __MAX_OF_TotalDegreeOfParallelism: 1
- __MIN_OF_TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
EXCHANGE_SINK (plan_node_id=2):
CommonMetrics:
- CloseTime: 11.766us
- __MAX_OF_CloseTime: 12.583us
- __MIN_OF_CloseTime: 10.467us
- OperatorTotalTime: 32.4ms
- __MAX_OF_OperatorTotalTime: 95.903ms
- __MIN_OF_OperatorTotalTime: 45.287us
- PeakMemoryUsage: 0.00
- PrepareTime: 36.719us
- __MAX_OF_PrepareTime: 45.547us
- __MIN_OF_PrepareTime: 30.655us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 15
- __MAX_OF_PushChunkNum: 15
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 60.001K (60001)
- __MAX_OF_PushRowNum: 60.001K (60001)
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 31.932ms
- __MAX_OF_PushTotalTime: 95.798ms
- __MIN_OF_PushTotalTime: 0ns
- SetFinishedTime: 32ns
- __MAX_OF_SetFinishedTime: 35ns
- __MIN_OF_SetFinishedTime: 30ns
- SetFinishingTime: 59.754us
- __MAX_OF_SetFinishingTime: 94.203us
- __MIN_OF_SetFinishingTime: 33.6us
UniqueMetrics:
- DestID: 2
- DestFragments: 817ff561f3cf11ed-b7d852540022dc0f
- PartType: UNPARTITIONED
- ChannelNum: 1
- BytesPassThrough: 0.00
- BytesSent: 438.73 KB
- __MAX_OF_BytesSent: 438.73 KB
- __MIN_OF_BytesSent: 0.00
- CompressTime: 389.534us
- __MAX_OF_CompressTime: 1.168ms
- __MIN_OF_CompressTime: 0ns
- NetworkBandwidth: 4.5693254470825195 MB/sec
- __MAX_OF_NetworkBandwidth: 4.5693254470825195 MB/sec
- __MIN_OF_NetworkBandwidth: 0.0 /sec
- NetworkTime: 35.35ms
- __MAX_OF_NetworkTime: 93.765ms
- __MIN_OF_NetworkTime: 36.481us
- OverallThroughput: 4.473394393920898 MB/sec
- __MAX_OF_OverallThroughput: 4.473394393920898 MB/sec
- __MIN_OF_OverallThroughput: 0.0 /sec
- OverallTime: 35.609ms
- __MAX_OF_OverallTime: 95.776ms
- __MIN_OF_OverallTime: 69.986us
- RequestSent: 2
- __MAX_OF_RequestSent: 2
- __MIN_OF_RequestSent: 0
- RpcAvgTime: 14.198ms
- __MAX_OF_RpcAvgTime: 31.255ms
- __MIN_OF_RpcAvgTime: 36.481us
- RpcCount: 5
- __MAX_OF_RpcCount: 3
- __MIN_OF_RpcCount: 1
- SerializeChunkTime: 1.317ms
- __MAX_OF_SerializeChunkTime: 3.952ms
- __MIN_OF_SerializeChunkTime: 0ns
- ShuffleHashTime: 0ns
- UncompressedBytes: 978.03 KB
- __MAX_OF_UncompressedBytes: 978.03 KB
- __MIN_OF_UncompressedBytes: 0.00
- WaitTime: 4.632ms
- __MAX_OF_WaitTime: 10.994ms
- __MIN_OF_WaitTime: 96.30us
LOCAL_MERGE_SOURCE (plan_node_id=1):
CommonMetrics:
- CloseTime: 17.188us
- __MAX_OF_CloseTime: 22.973us
- __MIN_OF_CloseTime: 10.527us
- OperatorTotalTime: 593.401us
- __MAX_OF_OperatorTotalTime: 1.732ms
- __MIN_OF_OperatorTotalTime: 16.492us
- PeakMemoryUsage: 0.00
- PrepareTime: 7.780us
- __MAX_OF_PrepareTime: 10.264us
- __MIN_OF_PrepareTime: 5.673us
- PullChunkNum: 15
- __MAX_OF_PullChunkNum: 15
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 60.001K (60001)
- __MAX_OF_PullRowNum: 60.001K (60001)
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 575.886us
- __MAX_OF_PullTotalTime: 1.713ms
- __MIN_OF_PullTotalTime: 5.658us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 113ns
- __MAX_OF_SetFinishedTime: 143ns
- __MIN_OF_SetFinishedTime: 76ns
- SetFinishingTime: 212ns
- __MAX_OF_SetFinishingTime: 231ns
- __MIN_OF_SetFinishingTime: 187ns
UniqueMetrics:
Pipeline (id=1):
- ActiveTime: 7.679ms
- __MAX_OF_ActiveTime: 52.187ms
- __MIN_OF_ActiveTime: 970.57us
- BlockByInputEmpty: 121
- __MAX_OF_BlockByInputEmpty: 15
- __MIN_OF_BlockByInputEmpty: 7
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 4
- DriverPrepareTime: 61.660us
- __MAX_OF_DriverPrepareTime: 99.913us
- __MIN_OF_DriverPrepareTime: 41.9us
- DriverTotalTime: 460.164ms
- __MAX_OF_DriverTotalTime: 532.712ms
- __MIN_OF_DriverTotalTime: 362.611ms
- OverheadTime: 4.61ms
- __MAX_OF_OverheadTime: 29.810ms
- __MIN_OF_OverheadTime: 0ns
- PendingTime: 435.217ms
- __MAX_OF_PendingTime: 523.0ms
- __MIN_OF_PendingTime: 351.67ms
- InputEmptyTime: 435.232ms
- __MAX_OF_InputEmptyTime: 523.15ms
- __MIN_OF_InputEmptyTime: 351.80ms
- FirstInputEmptyTime: 50.726us
- __MAX_OF_FirstInputEmptyTime: 64.898us
- __MIN_OF_FirstInputEmptyTime: 44.715us
- FollowupInputEmptyTime: 435.181ms
- __MAX_OF_FollowupInputEmptyTime: 522.953ms
- __MIN_OF_FollowupInputEmptyTime: 351.35ms
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 133
- __MAX_OF_ScheduleCount: 16
- __MIN_OF_ScheduleCount: 8
- ScheduleTime: 17.267ms
- __MAX_OF_ScheduleTime: 35.40ms
- __MIN_OF_ScheduleTime: 3.689ms
- TotalDegreeOfParallelism: 12
- __MAX_OF_TotalDegreeOfParallelism: 4
- __MIN_OF_TotalDegreeOfParallelism: 4
- YieldByPreempt: 0
- YieldByTimeLimit: 0
LOCAL_SORT_SINK (plan_node_id=1):
CommonMetrics:
- CloseTime: 4.810us
- __MAX_OF_CloseTime: 9.726us
- __MIN_OF_CloseTime: 3.3us
- OperatorTotalTime: 1.447ms
- __MAX_OF_OperatorTotalTime: 17.290ms
- __MIN_OF_OperatorTotalTime: 4.87us
- PeakMemoryUsage: 0.00
- PrepareTime: 17.101us
- __MAX_OF_PrepareTime: 32.62us
- __MIN_OF_PrepareTime: 9.815us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 17
- __MAX_OF_PushChunkNum: 17
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 66.417K (66417)
- __MAX_OF_PushRowNum: 66.417K (66417)
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 2.861us
- __MAX_OF_PushTotalTime: 34.336us
- __MIN_OF_PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 46ns
- __MAX_OF_SetFinishedTime: 120ns
- __MIN_OF_SetFinishedTime: 30ns
- SetFinishingTime: 1.439ms
- __MAX_OF_SetFinishingTime: 17.251ms
- __MIN_OF_SetFinishingTime: 831ns
UniqueMetrics:
- SortKeys: 9: create_time ASC, 2: u_id ASC
- SortType: TopN
- BuildingTime: 38.336us
- __MAX_OF_BuildingTime: 460.37us
- __MIN_OF_BuildingTime: 0ns
- MergingTime: 108.628us
- __MAX_OF_MergingTime: 1.303ms
- __MIN_OF_MergingTime: 0ns
- OutputTime: 40.954us
- __MAX_OF_OutputTime: 490.558us
- __MIN_OF_OutputTime: 0ns
- SortFilterRows: 0
- SortFilterTime: 0ns
- SortingTime: 1.290ms
- __MAX_OF_SortingTime: 15.483ms
- __MIN_OF_SortingTime: 0ns
CHUNK_ACCUMULATE (plan_node_id=0):
CommonMetrics:
- CloseTime: 293ns
- __MAX_OF_CloseTime: 473ns
- __MIN_OF_CloseTime: 218ns
- OperatorTotalTime: 1.303us
- __MAX_OF_OperatorTotalTime: 8.291us
- __MIN_OF_OperatorTotalTime: 480ns
- PeakMemoryUsage: 0.00
- PrepareTime: 8.518us
- __MAX_OF_PrepareTime: 13.145us
- __MIN_OF_PrepareTime: 5.986us
- PullChunkNum: 17
- __MAX_OF_PullChunkNum: 17
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 66.417K (66417)
- __MAX_OF_PullRowNum: 66.417K (66417)
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 189ns
- __MAX_OF_PullTotalTime: 2.276us
- __MIN_OF_PullTotalTime: 0ns
- PushChunkNum: 17
- __MAX_OF_PushChunkNum: 17
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 66.417K (66417)
- __MAX_OF_PushRowNum: 66.417K (66417)
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 388ns
- __MAX_OF_PushTotalTime: 4.659us
- __MIN_OF_PushTotalTime: 0ns
- SetFinishedTime: 178ns
- __MAX_OF_SetFinishedTime: 534ns
- __MIN_OF_SetFinishedTime: 92ns
- SetFinishingTime: 252ns
- __MAX_OF_SetFinishingTime: 492ns
- __MIN_OF_SetFinishingTime: 97ns
UniqueMetrics:
OLAP_SCAN (plan_node_id=0):
CommonMetrics:
- CloseTime: 765.215us
- __MAX_OF_CloseTime: 999.96us
- __MIN_OF_CloseTime: 593.912us
- JoinRuntimeFilterEvaluate: 0
- JoinRuntimeFilterHashTime: 0ns
- JoinRuntimeFilterInputRows: 0
- JoinRuntimeFilterOutputRows: 0
- JoinRuntimeFilterTime: 0ns
- OperatorTotalTime: 2.705ms
- __MAX_OF_OperatorTotalTime: 5.78ms
- __MIN_OF_OperatorTotalTime: 1.538ms
- PeakMemoryUsage: 0.00
- PrepareTime: 15.635us
- __MAX_OF_PrepareTime: 26.63us
- __MIN_OF_PrepareTime: 9.574us
- PullChunkNum: 17
- __MAX_OF_PullChunkNum: 17
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 66.417K (66417)
- __MAX_OF_PullRowNum: 66.417K (66417)
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 1.938ms
- __MAX_OF_PullTotalTime: 4.309ms
- __MIN_OF_PullTotalTime: 854.851us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 79ns
- __MAX_OF_SetFinishedTime: 285ns
- __MIN_OF_SetFinishedTime: 29ns
- SetFinishingTime: 1.914us
- __MAX_OF_SetFinishingTime: 13.930us
- __MIN_OF_SetFinishingTime: 349ns
UniqueMetrics:
- MorselQueueType: fixed_morsel_queue
- BufferUnplugThreshold: 32
- SharedScan: False
- Predicates: substr(CAST(9: create_time AS VARCHAR), 1, 10) = ‘2023-04-03’
- Rollup: edu_biz_data_item_plus
- Table: edu_biz_data_item_plus
- BufferUnplugCount: 0
- BytesRead: 609.62 MB
- __MAX_OF_BytesRead: 54.90 MB
- __MIN_OF_BytesRead: 4.64 KB
- CachedPagesNum: 10.114K (10114)
- __MAX_OF_CachedPagesNum: 893
- __MIN_OF_CachedPagesNum: 5
- ChunkBufferCapacity: 256
- CompressedBytesRead: 384.00 B
- __MAX_OF_CompressedBytesRead: 384.00 B
- __MIN_OF_CompressedBytesRead: 0.00
- CreateSegmentIter: 71.907us
- __MAX_OF_CreateSegmentIter: 2.27ms
- __MIN_OF_CreateSegmentIter: 11.769us
- DefaultChunkBufferCapacity: 256
- ExprFilterTime: 122.864ms
- __MAX_OF_ExprFilterTime: 424.253ms
- __MIN_OF_ExprFilterTime: 50.62us
- GetDelVec: 44.659us
- __MAX_OF_GetDelVec: 1.882ms
- __MIN_OF_GetDelVec: 2.1us
- GetRowsets: 634ns
- __MAX_OF_GetRowsets: 1.745us
- __MIN_OF_GetRowsets: 272ns
- IOTaskExecTime: 132.760ms
- __MAX_OF_IOTaskExecTime: 450.704ms
- __MIN_OF_IOTaskExecTime: 158.857us
- IOTaskWaitTime: 62.71ms
- __MAX_OF_IOTaskWaitTime: 179.881ms
- __MIN_OF_IOTaskWaitTime: 4.720ms
- IOTime: 282ns
- __MAX_OF_IOTime: 13.573us
- __MIN_OF_IOTime: 0ns
- MorselsCount: 154
- __MAX_OF_MorselsCount: 19
- __MIN_OF_MorselsCount: 10
- PeakChunkBufferSize: 26
- PushdownPredicates: 0
- RawRowsRead: 15.11535M (15115350)
- __MAX_OF_RawRowsRead: 1.308305M (1308305)
- __MIN_OF_RawRowsRead: 108
- ReadPagesNum: 10.12K (10120)
- __MAX_OF_ReadPagesNum: 893
- __MIN_OF_ReadPagesNum: 5
- RowsRead: 66.417K (66417)
- __MAX_OF_RowsRead: 66.417K (66417)
- __MIN_OF_RowsRead: 0
- ScanTime: 194.832ms
- __MAX_OF_ScanTime: 524.873ms
- __MIN_OF_ScanTime: 67.655ms
- SegmentInit: 801.755us
- __MAX_OF_SegmentInit: 22.177ms
- __MIN_OF_SegmentInit: 26.62us
- BitmapIndexFilter: 0ns
- BitmapIndexFilterRows: 0
- BloomFilterFilterRows: 0
- SegmentRuntimeZoneMapFilterRows: 0
- SegmentZoneMapFilterRows: 0
- ShortKeyFilterRows: 0
- ZoneMapIndexFilterRows: 0
- SegmentRead: 8.278ms
- __MAX_OF_SegmentRead: 35.811ms
- __MIN_OF_SegmentRead: 35.475us
- BlockFetch: 8.140ms
- __MAX_OF_BlockFetch: 35.487ms
- __MIN_OF_BlockFetch: 8.27us
- BlockFetchCount: 3.836K (3836)
- __MAX_OF_BlockFetchCount: 325
- __MIN_OF_BlockFetchCount: 2
- BlockSeek: 43.357us
- __MAX_OF_BlockSeek: 261.662us
- __MIN_OF_BlockSeek: 12.620us
- BlockSeekCount: 9.828K (9828)
- __MAX_OF_BlockSeekCount: 880
- __MIN_OF_BlockSeekCount: 2
- ChunkCopy: 0ns
- DecompressT: 0ns
- DelVecFilterRows: 52.322K (52322)
- __MAX_OF_DelVecFilterRows: 29.542K (29542)
- __MIN_OF_DelVecFilterRows: 0
- IndexLoad: 0ns
- PredFilter: 0ns
- PredFilterRows: 0
- RowsetsReadCount: 233
- __MAX_OF_RowsetsReadCount: 30
- __MIN_OF_RowsetsReadCount: 2
- SegmentsReadCount: 230
- __MAX_OF_SegmentsReadCount: 30
- __MIN_OF_SegmentsReadCount: 2
- TotalColumnsDataPageCount: 10.093K (10093)
- __MAX_OF_TotalColumnsDataPageCount: 892
- __MIN_OF_TotalColumnsDataPageCount: 4
- SubmitTaskCount: 154
- __MAX_OF_SubmitTaskCount: 19
- __MIN_OF_SubmitTaskCount: 10
- TabletCount: 51
- UncompressedBytesRead: 252.00 B
- __MAX_OF_UncompressedBytesRead: 252.00 B
- __MIN_OF_UncompressedBytesRead: 0.00
Pipeline (id=0):
- ActiveTime: 38.53us
- __MAX_OF_ActiveTime: 39.855us
- __MIN_OF_ActiveTime: 35.679us
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 158.968us
- __MAX_OF_DriverPrepareTime: 182.121us
- __MIN_OF_DriverPrepareTime: 127.818us
- DriverTotalTime: 423.807us
- __MAX_OF_DriverTotalTime: 571.335us
- __MIN_OF_DriverTotalTime: 327.178us
- OverheadTime: 0ns
- PendingTime: 0ns
- InputEmptyTime: 0ns
- FirstInputEmptyTime: 0ns
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 3
- __MAX_OF_ScheduleCount: 1
- __MIN_OF_ScheduleCount: 1
- ScheduleTime: 385.753us
- __MAX_OF_ScheduleTime: 531.480us
- __MIN_OF_ScheduleTime: 288.552us
- TotalDegreeOfParallelism: 3
- __MAX_OF_TotalDegreeOfParallelism: 1
- __MIN_OF_TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
NOOP_SINK (plan_node_id=0):
CommonMetrics:
- CloseTime: 196ns
- __MAX_OF_CloseTime: 210ns
- __MIN_OF_CloseTime: 176ns
- OperatorTotalTime: 317ns
- __MAX_OF_OperatorTotalTime: 352ns
- __MIN_OF_OperatorTotalTime: 278ns
- PeakMemoryUsage: 0.00
- PrepareTime: 10.584us
- __MAX_OF_PrepareTime: 12.283us
- __MIN_OF_PrepareTime: 8.952us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- SetFinishedTime: 34ns
- __MAX_OF_SetFinishedTime: 44ns
- __MIN_OF_SetFinishedTime: 29ns
- SetFinishingTime: 86ns
- __MAX_OF_SetFinishingTime: 118ns
- __MIN_OF_SetFinishingTime: 69ns
UniqueMetrics:
OLAP_SCAN_PREPARE (plan_node_id=0):
CommonMetrics:
- CloseTime: 17.472us
- __MAX_OF_CloseTime: 37.48us
- __MIN_OF_CloseTime: 6.723us
- OperatorTotalTime: 51.599us
- __MAX_OF_OperatorTotalTime: 69.284us
- __MIN_OF_OperatorTotalTime: 42.338us
- PeakMemoryUsage: 0.00
- PrepareTime: 111.19us
- __MAX_OF_PrepareTime: 122.884us
- __MIN_OF_PrepareTime: 97.692us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 33.976us
- __MAX_OF_PullTotalTime: 35.470us
- __MIN_OF_PullTotalTime: 32.104us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 61ns
- __MAX_OF_SetFinishedTime: 67ns
- __MIN_OF_SetFinishedTime: 54ns
- SetFinishingTime: 89ns
- __MAX_OF_SetFinishingTime: 112ns
- __MIN_OF_SetFinishingTime: 78ns
UniqueMetrics:
Query:
Summary:
- Query ID: 7fc8a8c1-f3cf-11ed-b7d8-52540022dc0b
- Start Time: 2023-05-16 17:53:24
- End Time: 2023-05-16 17:53:25
- Total: 419ms
- Query Type: Query
- Query State: EOF
- StarRocks Version: 2.5.0-6abafd3
- User: root
- Default Db: ipp
- Sql Statement: select create_time,u_id from edu_biz_data_item_plus where substr(create_time,1,10)=‘2023-04-03’ order by create_time,u_id limit 3 offset 59998
- QueryCpuCost: 43ms
- QueryMemCost: 9.738MB
- Variables: parallel_fragment_exec_instance_num=1,pipeline_dop=0,enable_adaptive_sink_dop=false
- Collect Profile Time: 19ms
Planner:
- Analyzer: 0ms / 1
- CoordDeliverExec: 17ms / 1
- CoordPrepareExec: 0ms / 1
- ExecPlanBuild: 0ms / 1
- Optimizer: 1ms / 1
- Total: 1ms / 1
Optimizer:
- CostBaseOptimize: 0ms / 1
- PhysicalRewrite: 0ms / 1
- RuleBaseOptimize: 0ms / 1
- preprocessMvs: 0ms / 1
Execution Profile 7fc8a8c1-f3cf-11ed-b7d8-52540022dc0b:
- ExecutionTotalTime: 422.96ms
Fragment 0:
- BackendAddresses: 10.120.154.10:9060
- BackendNum: 1
- FragmentInstancePrepareTime: 143.511us
- InstanceNum: 1
- PeakMemoryUsage: 1.89 MB
- QueryMemoryLimit: 10.13 GB
Pipeline (id=0):
- ActiveTime: 646.855us
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 146.876us
- DriverTotalTime: 415.188ms
- OverheadTime: 2.773us
- PendingTime: 414.507ms
- InputEmptyTime: 414.507ms
- FirstInputEmptyTime: 414.507ms
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 1
- ScheduleTime: 34.557us
- TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
RESULT_SINK:
CommonMetrics:
- CloseTime: 4.375us
- OperatorTotalTime: 41.135us
- PeakMemoryUsage: 0.00
- PrepareTime: 16.420us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 1
- PushRowNum: 3
- PushTotalTime: 36.603us
- SetFinishedTime: 29ns
- SetFinishingTime: 128ns
UniqueMetrics:
GLOBAL_MERGE_SOURCE (plan_node_id=2):
CommonMetrics:
- CloseTime: 607ns
- JoinRuntimeFilterEvaluate: 0
- JoinRuntimeFilterHashTime: 0ns
- JoinRuntimeFilterInputRows: 0
- JoinRuntimeFilterOutputRows: 0
- JoinRuntimeFilterTime: 0ns
- OperatorTotalTime: 601.934us
- PeakMemoryUsage: 0.00
- PrepareTime: 81.805us
- PullChunkNum: 1
- PullRowNum: 3
- PullTotalTime: 594.374us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 124ns
- SetFinishingTime: 6.829us
UniqueMetrics:
- BufferUnplugCount: 0
- BytesPassThrough: 438.73 KB
- BytesReceived: 0.00
- ClosureBlockCount: 0
- ClosureBlockTime: 0ns
- DecompressChunkTime: 254.393us
- DeserializeChunkTime: 1.105ms
- ReceiverProcessTotalTime: 1.385ms
- RequestReceived: 3
- SenderTotalTime: 1.385ms
- SenderWaitLockTime: 426ns
Fragment 1:
- BackendAddresses: 10.120.154.10:9060,10.120.154.7:9060,10.120.154.9:9060
- BackendNum: 3
- FragmentInstancePrepareTime: 5.282ms
- __MAX_OF_FragmentInstancePrepareTime: 15.90ms
- __MIN_OF_FragmentInstancePrepareTime: 351.36us
- InstanceNum: 3
- PeakMemoryUsage: 27.05 MB
- __MAX_OF_PeakMemoryUsage: 9.73 MB
- __MIN_OF_PeakMemoryUsage: 8.18 MB
- QueryMemoryLimit: 30.39 GB
- __MAX_OF_QueryMemoryLimit: 10.13 GB
- __MIN_OF_QueryMemoryLimit: 10.13 GB
Pipeline (id=2):
- ActiveTime: 2.425ms
- __MAX_OF_ActiveTime: 7.144ms
- __MIN_OF_ActiveTime: 65.195us
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 71.379us
- __MAX_OF_DriverPrepareTime: 79.33us
- __MIN_OF_DriverPrepareTime: 59.990us
- DriverTotalTime: 384.646ms
- __MAX_OF_DriverTotalTime: 397.897ms
- __MIN_OF_DriverTotalTime: 375.792ms
- OverheadTime: 16.488us
- __MAX_OF_OverheadTime: 49.466us
- __MIN_OF_OverheadTime: 0ns
- PendingTime: 382.113ms
- __MAX_OF_PendingTime: 397.747ms
- __MIN_OF_PendingTime: 368.526ms
- InputEmptyTime: 381.640ms
- __MAX_OF_InputEmptyTime: 397.543ms
- __MIN_OF_InputEmptyTime: 367.411ms
- FirstInputEmptyTime: 381.640ms
- __MAX_OF_FirstInputEmptyTime: 397.543ms
- __MIN_OF_FirstInputEmptyTime: 367.411ms
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 473.924us
- __MAX_OF_PendingFinishTime: 1.116ms
- __MIN_OF_PendingFinishTime: 99.851us
- PreconditionBlockTime: 0ns
- ScheduleCount: 3
- __MAX_OF_ScheduleCount: 1
- __MIN_OF_ScheduleCount: 1
- ScheduleTime: 107.908us
- __MAX_OF_ScheduleTime: 121.730us
- __MIN_OF_ScheduleTime: 85.188us
- TotalDegreeOfParallelism: 3
- __MAX_OF_TotalDegreeOfParallelism: 1
- __MIN_OF_TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
EXCHANGE_SINK (plan_node_id=2):
CommonMetrics:
- CloseTime: 15.909us
- __MAX_OF_CloseTime: 17.413us
- __MIN_OF_CloseTime: 12.973us
- OperatorTotalTime: 1.891ms
- __MAX_OF_OperatorTotalTime: 5.548ms
- __MIN_OF_OperatorTotalTime: 55.725us
- PeakMemoryUsage: 0.00
- PrepareTime: 37.748us
- __MAX_OF_PrepareTime: 43.641us
- __MIN_OF_PrepareTime: 32.550us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 15
- __MAX_OF_PushChunkNum: 15
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 60.001K (60001)
- __MAX_OF_PushRowNum: 60.001K (60001)
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 1.750ms
- __MAX_OF_PushTotalTime: 5.252ms
- __MIN_OF_PushTotalTime: 0ns
- SetFinishedTime: 38ns
- __MAX_OF_SetFinishedTime: 43ns
- __MIN_OF_SetFinishedTime: 30ns
- SetFinishingTime: 124.307us
- __MAX_OF_SetFinishingTime: 278.571us
- __MIN_OF_SetFinishingTime: 42.722us
UniqueMetrics:
- DestID: 2
- DestFragments: 7fc8a8c1f3cf11ed-b7d852540022dc0f
- PartType: UNPARTITIONED
- ChannelNum: 1
- BytesPassThrough: 0.00
- BytesSent: 438.73 KB
- __MAX_OF_BytesSent: 438.73 KB
- __MIN_OF_BytesSent: 0.00
- CompressTime: 399.366us
- __MAX_OF_CompressTime: 1.198ms
- __MIN_OF_CompressTime: 0ns
- NetworkBandwidth: 272.39487648010254 MB/sec
- __MAX_OF_NetworkBandwidth: 272.39487648010254 MB/sec
- __MIN_OF_NetworkBandwidth: 0.0 /sec
- NetworkTime: 550.128us
- __MAX_OF_NetworkTime: 1.572ms
- __MIN_OF_NetworkTime: 0ns
- OverallThroughput: 85.5574893951416 MB/sec
- __MAX_OF_OverallThroughput: 85.5574893951416 MB/sec
- __MIN_OF_OverallThroughput: 0.0 /sec
- OverallTime: 1.797ms
- __MAX_OF_OverallTime: 5.7ms
- __MIN_OF_OverallTime: 144.27us
- RequestSent: 2
- __MAX_OF_RequestSent: 2
- __MIN_OF_RequestSent: 0
- RpcAvgTime: 92.95us
- __MAX_OF_RpcAvgTime: 524.295us
- __MIN_OF_RpcAvgTime: -325510ns
- RpcCount: 5
- __MAX_OF_RpcCount: 3
- __MIN_OF_RpcCount: 1
- SerializeChunkTime: 1.200ms
- __MAX_OF_SerializeChunkTime: 3.601ms
- __MIN_OF_SerializeChunkTime: 0ns
- ShuffleHashTime: 0ns
- UncompressedBytes: 978.03 KB
- __MAX_OF_UncompressedBytes: 978.03 KB
- __MIN_OF_UncompressedBytes: 0.00
- WaitTime: 525.450us
- __MAX_OF_WaitTime: 1.195ms
- __MIN_OF_WaitTime: 139.731us
LOCAL_MERGE_SOURCE (plan_node_id=1):
CommonMetrics:
- CloseTime: 13.1us
- __MAX_OF_CloseTime: 23.3us
- __MIN_OF_CloseTime: 7.337us
- OperatorTotalTime: 527.785us
- __MAX_OF_OperatorTotalTime: 1.541ms
- __MIN_OF_OperatorTotalTime: 17.946us
- PeakMemoryUsage: 0.00
- PrepareTime: 7.87us
- __MAX_OF_PrepareTime: 7.942us
- __MIN_OF_PrepareTime: 5.925us
- PullChunkNum: 15
- __MAX_OF_PullChunkNum: 15
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 60.001K (60001)
- __MAX_OF_PullRowNum: 60.001K (60001)
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 514.423us
- __MAX_OF_PullTotalTime: 1.517ms
- __MIN_OF_PullTotalTime: 8.946us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 130ns
- __MAX_OF_SetFinishedTime: 233ns
- __MIN_OF_SetFinishedTime: 69ns
- SetFinishingTime: 230ns
- __MAX_OF_SetFinishingTime: 264ns
- __MIN_OF_SetFinishingTime: 180ns
UniqueMetrics:
Pipeline (id=1):
- ActiveTime: 7.191ms
- __MAX_OF_ActiveTime: 18.99ms
- __MIN_OF_ActiveTime: 986.482us
- BlockByInputEmpty: 121
- __MAX_OF_BlockByInputEmpty: 19
- __MIN_OF_BlockByInputEmpty: 4
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 4
- DriverPrepareTime: 55.219us
- __MAX_OF_DriverPrepareTime: 75.920us
- __MIN_OF_DriverPrepareTime: 46.125us
- DriverTotalTime: 379.875ms
- __MAX_OF_DriverTotalTime: 398.702ms
- __MIN_OF_DriverTotalTime: 357.317ms
- OverheadTime: 109.194us
- __MAX_OF_OverheadTime: 1.310ms
- __MIN_OF_OverheadTime: 0ns
- PendingTime: 364.408ms
- __MAX_OF_PendingTime: 392.258ms
- __MIN_OF_PendingTime: 338.8ms
- InputEmptyTime: 364.436ms
- __MAX_OF_InputEmptyTime: 392.279ms
- __MIN_OF_InputEmptyTime: 338.35ms
- FirstInputEmptyTime: 66.56us
- __MAX_OF_FirstInputEmptyTime: 89.245us
- __MIN_OF_FirstInputEmptyTime: 42.759us
- FollowupInputEmptyTime: 364.370ms
- __MAX_OF_FollowupInputEmptyTime: 392.224ms
- __MIN_OF_FollowupInputEmptyTime: 337.960ms
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 135
- __MAX_OF_ScheduleCount: 20
- __MIN_OF_ScheduleCount: 5
- ScheduleTime: 8.274ms
- __MAX_OF_ScheduleTime: 20.752ms
- __MIN_OF_ScheduleTime: 1.861ms
- TotalDegreeOfParallelism: 12
- __MAX_OF_TotalDegreeOfParallelism: 4
- __MIN_OF_TotalDegreeOfParallelism: 4
- YieldByPreempt: 0
- YieldByTimeLimit: 0
LOCAL_SORT_SINK (plan_node_id=1):
CommonMetrics:
- CloseTime: 5.868us
- __MAX_OF_CloseTime: 9.894us
- __MIN_OF_CloseTime: 3.775us
- OperatorTotalTime: 932.249us
- __MAX_OF_OperatorTotalTime: 11.67ms
- __MIN_OF_OperatorTotalTime: 5.94us
- PeakMemoryUsage: 0.00
- PrepareTime: 13.591us
- __MAX_OF_PrepareTime: 18.998us
- __MIN_OF_PrepareTime: 9.810us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 17
- __MAX_OF_PushChunkNum: 17
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 66.417K (66417)
- __MAX_OF_PushRowNum: 66.417K (66417)
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 4.246us
- __MAX_OF_PushTotalTime: 50.956us
- __MIN_OF_PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 48ns
- __MAX_OF_SetFinishedTime: 137ns
- __MIN_OF_SetFinishedTime: 32ns
- SetFinishingTime: 922.85us
- __MAX_OF_SetFinishingTime: 11.12ms
- __MIN_OF_SetFinishingTime: 826ns
UniqueMetrics:
- SortKeys: 9: create_time ASC, 2: u_id ASC
- SortType: TopN
- BuildingTime: 32.385us
- __MAX_OF_BuildingTime: 388.623us
- __MIN_OF_BuildingTime: 0ns
- MergingTime: 48.856us
- __MAX_OF_MergingTime: 586.279us
- __MIN_OF_MergingTime: 0ns
- OutputTime: 32.759us
- __MAX_OF_OutputTime: 392.295us
- __MIN_OF_OutputTime: 0ns
- SortFilterRows: 0
- SortFilterTime: 0ns
- SortingTime: 836.200us
- __MAX_OF_SortingTime: 10.34ms
- __MIN_OF_SortingTime: 0ns
CHUNK_ACCUMULATE (plan_node_id=0):
CommonMetrics:
- CloseTime: 313ns
- __MAX_OF_CloseTime: 494ns
- __MIN_OF_CloseTime: 235ns
- OperatorTotalTime: 1.315us
- __MAX_OF_OperatorTotalTime: 8.946us
- __MIN_OF_OperatorTotalTime: 413ns
- PeakMemoryUsage: 0.00
- PrepareTime: 8.717us
- __MAX_OF_PrepareTime: 14.966us
- __MIN_OF_PrepareTime: 6.329us
- PullChunkNum: 17
- __MAX_OF_PullChunkNum: 17
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 66.417K (66417)
- __MAX_OF_PullRowNum: 66.417K (66417)
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 194ns
- __MAX_OF_PullTotalTime: 2.339us
- __MIN_OF_PullTotalTime: 0ns
- PushChunkNum: 17
- __MAX_OF_PushChunkNum: 17
- __MIN_OF_PushChunkNum: 0
- PushRowNum: 66.417K (66417)
- __MAX_OF_PushRowNum: 66.417K (66417)
- __MIN_OF_PushRowNum: 0
- PushTotalTime: 453ns
- __MAX_OF_PushTotalTime: 5.447us
- __MIN_OF_PushTotalTime: 0ns
- SetFinishedTime: 171ns
- __MAX_OF_SetFinishedTime: 516ns
- __MIN_OF_SetFinishedTime: 73ns
- SetFinishingTime: 180ns
- __MAX_OF_SetFinishingTime: 371ns
- __MIN_OF_SetFinishingTime: 67ns
UniqueMetrics:
OLAP_SCAN (plan_node_id=0):
CommonMetrics:
- CloseTime: 793.985us
- __MAX_OF_CloseTime: 901.763us
- __MIN_OF_CloseTime: 604.780us
- JoinRuntimeFilterEvaluate: 0
- JoinRuntimeFilterHashTime: 0ns
- JoinRuntimeFilterInputRows: 0
- JoinRuntimeFilterOutputRows: 0
- JoinRuntimeFilterTime: 0ns
- OperatorTotalTime: 6.766ms
- __MAX_OF_OperatorTotalTime: 16.782ms
- __MIN_OF_OperatorTotalTime: 1.623ms
- PeakMemoryUsage: 0.00
- PrepareTime: 14.331us
- __MAX_OF_PrepareTime: 22.605us
- __MIN_OF_PrepareTime: 10.442us
- PullChunkNum: 17
- __MAX_OF_PullChunkNum: 17
- __MIN_OF_PullChunkNum: 0
- PullRowNum: 66.417K (66417)
- __MAX_OF_PullRowNum: 66.417K (66417)
- __MIN_OF_PullRowNum: 0
- PullTotalTime: 5.971ms
- __MAX_OF_PullTotalTime: 16.109ms
- __MIN_OF_PullTotalTime: 872.596us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 90ns
- __MAX_OF_SetFinishedTime: 234ns
- __MIN_OF_SetFinishedTime: 57ns
- SetFinishingTime: 696ns
- __MAX_OF_SetFinishingTime: 2.342us
- __MIN_OF_SetFinishingTime: 291ns
UniqueMetrics:
- MorselQueueType: fixed_morsel_queue
- BufferUnplugThreshold: 32
- SharedScan: False
- Predicates: substr(CAST(9: create_time AS VARCHAR), 1, 10) = ‘2023-04-03’
- Rollup: edu_biz_data_item_plus
- Table: edu_biz_data_item_plus
- BufferUnplugCount: 0
- BytesRead: 609.62 MB
- __MAX_OF_BytesRead: 51.08 MB
- __MIN_OF_BytesRead: 2.09 MB
- CachedPagesNum: 10.111K (10111)
- __MAX_OF_CachedPagesNum: 832
- __MIN_OF_CachedPagesNum: 36
- ChunkBufferCapacity: 256
- CompressedBytesRead: 184.00 B
- __MAX_OF_CompressedBytesRead: 184.00 B
- __MIN_OF_CompressedBytesRead: 0.00
- CreateSegmentIter: 273.341us
- __MAX_OF_CreateSegmentIter: 11.571ms
- __MIN_OF_CreateSegmentIter: 5.361us
- DefaultChunkBufferCapacity: 256
- ExprFilterTime: 104.581ms
- __MAX_OF_ExprFilterTime: 316.477ms
- __MIN_OF_ExprFilterTime: 15.374ms
- GetDelVec: 247.970us
- __MAX_OF_GetDelVec: 11.540ms
- __MIN_OF_GetDelVec: 998ns
- GetRowsets: 625ns
- __MAX_OF_GetRowsets: 1.764us
- __MIN_OF_GetRowsets: 170ns
- IOTaskExecTime: 113.491ms
- __MAX_OF_IOTaskExecTime: 341.617ms
- __MIN_OF_IOTaskExecTime: 16.722ms
- IOTaskWaitTime: 56.856ms
- __MAX_OF_IOTaskWaitTime: 205.964ms
- __MIN_OF_IOTaskWaitTime: 23.643us
- IOTime: 196ns
- __MAX_OF_IOTime: 9.412us
- __MIN_OF_IOTime: 0ns
- MorselsCount: 154
- __MAX_OF_MorselsCount: 18
- __MIN_OF_MorselsCount: 7
- PeakChunkBufferSize: 24
- PushdownPredicates: 0
- RawRowsRead: 15.115348M (15115348)
- __MAX_OF_RawRowsRead: 1.217366M (1217366)
- __MIN_OF_RawRowsRead: 49.783K (49783)
- ReadPagesNum: 10.114K (10114)
- __MAX_OF_ReadPagesNum: 832
- __MIN_OF_ReadPagesNum: 36
- RowsRead: 66.417K (66417)
- __MAX_OF_RowsRead: 66.417K (66417)
- __MIN_OF_RowsRead: 0
- ScanTime: 170.347ms
- __MAX_OF_ScanTime: 384.872ms
- __MIN_OF_ScanTime: 58.217ms
- SegmentInit: 633.3us
- __MAX_OF_SegmentInit: 14.409ms
- __MIN_OF_SegmentInit: 17.461us
- BitmapIndexFilter: 0ns
- BitmapIndexFilterRows: 0
- BloomFilterFilterRows: 0
- SegmentRuntimeZoneMapFilterRows: 0
- SegmentZoneMapFilterRows: 0
- ShortKeyFilterRows: 0
- ZoneMapIndexFilterRows: 0
- SegmentRead: 7.830ms
- __MAX_OF_SegmentRead: 55.669ms
- __MIN_OF_SegmentRead: 1.165ms
- BlockFetch: 7.695ms
- __MAX_OF_BlockFetch: 55.393ms
- __MIN_OF_BlockFetch: 1.119ms
- BlockFetchCount: 3.834K (3834)
- __MAX_OF_BlockFetchCount: 303
- __MIN_OF_BlockFetchCount: 13
- BlockSeek: 44.407us
- __MAX_OF_BlockSeek: 250.532us
- __MIN_OF_BlockSeek: 8.61us
- BlockSeekCount: 9.826K (9826)
- __MAX_OF_BlockSeekCount: 819
- __MIN_OF_BlockSeekCount: 34
- ChunkCopy: 0ns
- DecompressT: 0ns
- DelVecFilterRows: 52.322K (52322)
- __MAX_OF_DelVecFilterRows: 29.542K (29542)
- __MIN_OF_DelVecFilterRows: 0
- IndexLoad: 0ns
- PredFilter: 0ns
- PredFilterRows: 0
- RowsetsReadCount: 231
- __MAX_OF_RowsetsReadCount: 28
- __MIN_OF_RowsetsReadCount: 1
- SegmentsReadCount: 228
- __MAX_OF_SegmentsReadCount: 28
- __MIN_OF_SegmentsReadCount: 1
- TotalColumnsDataPageCount: 10.089K (10089)
- __MAX_OF_TotalColumnsDataPageCount: 831
- __MIN_OF_TotalColumnsDataPageCount: 36
- SubmitTaskCount: 154
- __MAX_OF_SubmitTaskCount: 18
- __MIN_OF_SubmitTaskCount: 7
- TabletCount: 51
- UncompressedBytesRead: 118.00 B
- __MAX_OF_UncompressedBytesRead: 118.00 B
- __MIN_OF_UncompressedBytesRead: 0.00
Pipeline (id=0):
- ActiveTime: 44.367us
- __MAX_OF_ActiveTime: 55.502us
- __MIN_OF_ActiveTime: 35.874us
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 127.411us
- __MAX_OF_DriverPrepareTime: 136.859us
- __MIN_OF_DriverPrepareTime: 118.862us
- DriverTotalTime: 381.673us
- __MAX_OF_DriverTotalTime: 404.17us
- __MIN_OF_DriverTotalTime: 370.18us
- OverheadTime: 0ns
- PendingTime: 0ns
- InputEmptyTime: 0ns
- FirstInputEmptyTime: 0ns
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
- ScheduleCount: 3
- __MAX_OF_ScheduleCount: 1
- __MIN_OF_ScheduleCount: 1
- ScheduleTime: 337.306us
- __MAX_OF_ScheduleTime: 362.292us
- __MIN_OF_ScheduleTime: 315.483us
- TotalDegreeOfParallelism: 3
- __MAX_OF_TotalDegreeOfParallelism: 1
- __MIN_OF_TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
NOOP_SINK (plan_node_id=0):
CommonMetrics:
- CloseTime: 334ns
- __MAX_OF_CloseTime: 453ns
- __MIN_OF_CloseTime: 172ns
- OperatorTotalTime: 500ns
- __MAX_OF_OperatorTotalTime: 670ns
- __MIN_OF_OperatorTotalTime: 359ns
- PeakMemoryUsage: 0.00
- PrepareTime: 10.684us
- __MAX_OF_PrepareTime: 12.200us
- __MIN_OF_PrepareTime: 8.770us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- SetFinishedTime: 36ns
- __MAX_OF_SetFinishedTime: 44ns
- __MIN_OF_SetFinishedTime: 31ns
- SetFinishingTime: 129ns
- __MAX_OF_SetFinishingTime: 173ns
- __MIN_OF_SetFinishingTime: 63ns
UniqueMetrics:
OLAP_SCAN_PREPARE (plan_node_id=0):
CommonMetrics:
- CloseTime: 6.58us
- __MAX_OF_CloseTime: 6.288us
- __MIN_OF_CloseTime: 5.720us
- OperatorTotalTime: 46.474us
- __MAX_OF_OperatorTotalTime: 58.48us
- __MIN_OF_OperatorTotalTime: 37.752us
- PeakMemoryUsage: 0.00
- PrepareTime: 94.647us
- __MAX_OF_PrepareTime: 101.349us
- __MIN_OF_PrepareTime: 87.353us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 40.254us
- __MAX_OF_PullTotalTime: 52.160us
- __MIN_OF_PullTotalTime: 31.418us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 61ns
- __MAX_OF_SetFinishedTime: 65ns
- __MIN_OF_SetFinishedTime: 58ns
- SetFinishingTime: 100ns
- __MAX_OF_SetFinishingTime: 110ns
- __MIN_OF_SetFinishingTime: 89ns
UniqueMetrics:
您好，方便的话帮忙提供下 查询的这个表，建表语句(数据模型，分区分桶列，properties相关信息)，show data from table_name; 看一下这个表的数据量，以及查询的 2023-04-03分区数据量大小， SHOW PARTITIONS FROM example_db.table_name WHERE PartitionName = “p1”;
CREATE TABLE xxx (
create_date date NOT NULL COMMENT ‘创建日期’,
u_id String NOT NULL COMMENT ‘主键’,
from_id String NULL DEFAULT NULL,
…
)ENGINE=OLAP
PRIMARY KEY (create_date,u_id)
PARTITION BY RANGE (create_date) (
START (“2019-01-01”) END (“2024-01-01”) EVERY (INTERVAL 1 week))
DISTRIBUTED BY HASH(u_id) BUCKETS 1
PROPERTIES(
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “week”,
“dynamic_partition.end” = “10”,
“dynamic_partition.prefix” = “p”,
“replication_num” = “1”
);
确认了下，这个问题目前已经修复了，可以升级到最新的2.5.5版本
好的 感谢你的帮助