# query ```sql Summary: - Query ID: c11c5c36-bba3-11f0-bda4-2ad541ec58f5 - Start Time: 2025-11-07 06:34:04 - End Time: 2025-11-07 06:47:52 - Total: 13m48s - Query Type: Query - Query State: Finished - StarRocks Version: 3.5.2-69de616 - User: root - Default Db: historical_data - Sql Statement: with token_info as ( select address, symbol from `historical_data`.`token_data_legacy` ), tx_info as ( select distinct tx, succeeded from `historical_data`.`transaction_info` where timestamp >= (select min(timestamp) from `historical_data`.`stg_mint_initialization_data_600_610`) and timestamp <= (select max(timestamp) from `historical_data`.`stg_mint_initialization_data_600_610`) ), mint_initialization_with_tx_info as ( select e.*, coalesce(t.succeeded, 0) as succeeded from `historical_data`.`stg_mint_initialization_data_600_610` e left join tx_info t on e.transactionHash = t.tx ), mint_initialization_mapped as ( select t.*, tm.symbol as mintSymbol from mint_initialization_with_tx_info t left join token_info tm on t.mint = tm.address ) select * from mint_initialization_mapped - Variables: parallel_fragment_exec_instance_num=1,max_parallel_scan_instance_num=-1,pipeline_dop=0,enable_adaptive_sink_dop=true,enable_runtime_adaptive_dop=false,runtime_profile_report_interval=10,resource_group=default_wg - NonDefaultSessionVariables: {"big_query_log_scan_rows_threshold":{"defaultValue":1000000000,"actualValue":1500000000},"query_timeout":{"defaultValue":300,"actualValue":259200},"big_query_log_cpu_second_threshold":{"defaultValue":480,"actualValue":600},"prefer_compute_node":{"defaultValue":false,"actualValue":true},"new_planner_optimize_timeout":{"defaultValue":3000,"actualValue":30000},"enable_query_cache":{"defaultValue":false,"actualValue":true},"enable_adaptive_sink_dop":{"defaultValue":false,"actualValue":true},"enable_spill":{"defaultValue":false,"actualValue":true},"time_zone":{"defaultValue":"Europe/Berlin","actualValue":"UTC"}} - Collect Profile Time: 6ms - IsProfileAsync: true Planner: - -- Parser[1] 1ms - -- Total[1] 5s285ms - -- Analyzer[1] 1ms - -- Lock[1] 0 - -- AnalyzeDatabase[5] 0 - -- AnalyzeTemporaryTable[5] 0 - -- AnalyzeTable[5] 0 - -- Transformer[1] 1ms - -- Optimizer[1] 1s493ms - -- MVPreprocess[1] 0 - -- MVTextRewrite[1] 0 - -- RuleBaseOptimize[1] 1s226ms - -- CostBaseOptimize[1] 238ms - -- PhysicalRewrite[1] 9ms - -- DynamicRewrite[1] 0 - -- PlanValidate[1] 0 - -- InputDependenciesChecker[1] 0 - -- TypeChecker[1] 0 - -- CTEUniqueChecker[1] 0 - -- ColumnReuseChecker[1] 0 - -- ExecPlanBuild[1] 3s788ms - -- Pending[1] 2ms - -- Prepare[1] 116ms - -- Deploy[1] 960ms - -- DeployLockInternalTime[1] 960ms - -- DeploySerializeConcurrencyTime[7] 446ms - -- DeployStageByStageTime[21] 2ms - -- DeployAsyncSendTime[38] 2ms - -- DeployWaitTime[21] 508ms - DeployDataSize: 20551515 Reason: Execution: - Topology: {"rootId":30,"nodes":[{"id":30,"name":"EXCHANGE","properties":{"sinkIds":[],"displayMem":true},"children":[29]},{"id":29,"name":"DECODE","properties":{"sinkIds":[30],"displayMem":false},"children":[28]},{"id":28,"name":"PROJECT","properties":{"displayMem":false},"children":[27]},{"id":27,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[0,26]},{"id":0,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":26,"name":"EXCHANGE","properties":{"displayMem":true},"children":[25]},{"id":25,"name":"PROJECT","properties":{"sinkIds":[26],"displayMem":false},"children":[24]},{"id":24,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[21,23]},{"id":21,"name":"EXCHANGE","properties":{"displayMem":true},"children":[20]},{"id":23,"name":"EXCHANGE","properties":{"displayMem":true},"children":[22]},{"id":20,"name":"AGGREGATION","properties":{"sinkIds":[21],"displayMem":true},"children":[19]},{"id":22,"name":"OLAP_SCAN","properties":{"sinkIds":[23],"displayMem":false},"children":[]},{"id":19,"name":"EXCHANGE","properties":{"displayMem":true},"children":[18]},{"id":18,"name":"AGGREGATION","properties":{"sinkIds":[19],"displayMem":true},"children":[17]},{"id":17,"name":"PROJECT","properties":{"displayMem":false},"children":[16]},{"id":16,"name":"NEST_LOOP_JOIN","properties":{"displayMem":true},"children":[9,15]},{"id":9,"name":"PROJECT","properties":{"displayMem":false},"children":[8]},{"id":15,"name":"EXCHANGE","properties":{"displayMem":true},"children":[14]},{"id":8,"name":"NEST_LOOP_JOIN","properties":{"displayMem":true},"children":[1,7]},{"id":14,"name":"ASSERT_NUM_ROWS","properties":{"sinkIds":[15],"displayMem":false},"children":[13]},{"id":1,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":7,"name":"EXCHANGE","properties":{"displayMem":true},"children":[6]},{"id":13,"name":"PROJECT","properties":{"displayMem":false},"children":[12]},{"id":6,"name":"ASSERT_NUM_ROWS","properties":{"sinkIds":[7],"displayMem":false},"children":[5]},{"id":12,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[11]},{"id":5,"name":"PROJECT","properties":{"displayMem":false},"children":[4]},{"id":11,"name":"TOP_N","properties":{"sinkIds":[12],"displayMem":true},"children":[10]},{"id":4,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[3]},{"id":10,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":3,"name":"TOP_N","properties":{"sinkIds":[4],"displayMem":true},"children":[2]},{"id":2,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]}]} - FrontendProfileMergeTime: 15.269ms - QueryAllocatedMemoryUsage: 785.537 GB - QueryCumulativeCpuTime: 3h33m - QueryCumulativeNetworkTime: 1s15ms - QueryCumulativeOperatorTime: 14m1s - QueryCumulativeScanTime: 13m37s - QueryDeallocatedMemoryUsage: 784.811 GB - QueryExecutionWallTime: 13m43s - QueryPeakMemoryUsagePerNode: 446.377 MB - QueryPeakScheduleTime: 13m43s - QuerySpillBytes: 0.000 B - QuerySumMemoryUsage: 2.069 GB - ResultDeliverTime: 0ns Fragment 0: - BackendAddresses: fe03.starrocks.local:9060 - InstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec58f6 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 3.342ms - InitialProcessDriverCount: 1.810K (1810) - InitialProcessMem: 26.261 GB - InstanceAllocatedMemoryUsage: 2.023 MB - InstanceDeallocatedMemoryUsage: 1.584 MB - InstanceNum: 1 - InstancePeakMemoryUsage: 677.188 KB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 768.244us - __MAX_OF_ActiveTime: 2.184ms - __MIN_OF_ActiveTime: 27.120us - BlockByInputEmpty: 28 - __MAX_OF_BlockByInputEmpty: 3 - __MIN_OF_BlockByInputEmpty: 2 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 13m43s - __MAX_OF_DriverTotalTime: 13m43s - __MIN_OF_DriverTotalTime: 13m43s - PeakDriverQueueSize: 204 - __MAX_OF_PeakDriverQueueSize: 25 - __MIN_OF_PeakDriverQueueSize: 8 - PendingTime: 0ns - InputEmptyTime: 13m43s - __MAX_OF_InputEmptyTime: 13m43s - __MIN_OF_InputEmptyTime: 13m43s - FirstInputEmptyTime: 13m43s - __MAX_OF_FirstInputEmptyTime: 13m43s - __MIN_OF_FirstInputEmptyTime: 13m43s - FollowupInputEmptyTime: 38.454ms - __MAX_OF_FollowupInputEmptyTime: 44.059ms - __MIN_OF_FollowupInputEmptyTime: 11.393ms - ScheduleCount: 38 - __MAX_OF_ScheduleCount: 4 - __MIN_OF_ScheduleCount: 3 - ScheduleTime: 13m43s - __MAX_OF_ScheduleTime: 13m43s - __MIN_OF_ScheduleTime: 13m43s - TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 RESULT_SINK (plan_node_id=-1): CommonMetrics: - IsFinalSink - OperatorTotalTime: 198.668us - __MAX_OF_OperatorTotalTime: 940.200us - __MIN_OF_OperatorTotalTime: 1.040us - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 7 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 488 - __MAX_OF_PushRowNum: 154 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 189.536us - __MAX_OF_PushTotalTime: 859.120us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - SinkType: MYSQL_PROTOCAL - AppendChunkTime: 91.744us - __MAX_OF_AppendChunkTime: 320.160us - __MIN_OF_AppendChunkTime: 0ns - ResultRendTime: 93.280us - __MAX_OF_ResultRendTime: 535.880us - __MIN_OF_ResultRendTime: 0ns - TupleConvertTime: 82.872us - __MAX_OF_TupleConvertTime: 305.280us - __MIN_OF_TupleConvertTime: 0ns - NumSentRows: 488 - __MAX_OF_NumSentRows: 154 - __MIN_OF_NumSentRows: 0 CHUNK_ACCUMULATE (plan_node_id=-1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 85.732us - __MAX_OF_OperatorTotalTime: 410.040us - __MIN_OF_OperatorTotalTime: 320ns - OutputChunkBytes: 221.885K (221885) - __MAX_OF_OutputChunkBytes: 70.061K (70061) - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 7 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 488 - __MAX_OF_PullRowNum: 154 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 136ns - __MAX_OF_PullTotalTime: 320ns - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 50 - __MAX_OF_PushChunkNum: 16 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 488 - __MAX_OF_PushRowNum: 154 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 84.752us - __MAX_OF_PushTotalTime: 408.840us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: EXCHANGE_SOURCE (plan_node_id=30): CommonMetrics: - ConjunctsInputRows: 488 - __MAX_OF_ConjunctsInputRows: 154 - __MIN_OF_ConjunctsInputRows: 7 - ConjunctsOutputRows: 488 - __MAX_OF_ConjunctsOutputRows: 154 - __MIN_OF_ConjunctsOutputRows: 7 - ConjunctsTime: 8.760us - __MAX_OF_ConjunctsTime: 16.040us - __MIN_OF_ConjunctsTime: 1.440us - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 395.516us - __MAX_OF_OperatorTotalTime: 1.908ms - __MIN_OF_OperatorTotalTime: 7.720us - OutputChunkBytes: 221.885K (221885) - __MAX_OF_OutputChunkBytes: 70.061K (70061) - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 50 - __MAX_OF_PullChunkNum: 16 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 488 - __MAX_OF_PullRowNum: 154 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 384.240us - __MAX_OF_PullTotalTime: 1.903ms - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 2 - __MAX_OF_BufferUnplugCount: 2 - __MIN_OF_BufferUnplugCount: 0 - BytesPassThrough: 43.124 KB - __MAX_OF_BytesPassThrough: 37.188 KB - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 124.877 KB - __MAX_OF_BytesReceived: 16.549 KB - __MIN_OF_BytesReceived: 7.821 KB - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 17.976us - __MAX_OF_DecompressChunkTime: 60.040us - __MIN_OF_DecompressChunkTime: 0ns - DeserializeChunkTime: 237.828us - __MAX_OF_DeserializeChunkTime: 1.156ms - __MIN_OF_DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 115.845 KB - __MAX_OF_PeakBufferMemoryBytes: 35.206 KB - __MIN_OF_PeakBufferMemoryBytes: 5.900 KB - ReceiverProcessTotalTime: 104.244us - __MAX_OF_ReceiverProcessTotalTime: 451.160us - __MIN_OF_ReceiverProcessTotalTime: 43.960us - RequestReceived: 51 - __MAX_OF_RequestReceived: 6 - __MIN_OF_RequestReceived: 5 - WaitLockTime: 28ns - __MAX_OF_WaitLockTime: 280ns - __MIN_OF_WaitLockTime: 0ns Fragment 1: - BackendAddresses: fe02.starrocks.local:9060,cn01.starrocks.local:9060,cnrs01.starrocks.local:9060,cn02.starrocks.local:9060,fe03.starrocks.local:9060 - InstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec58f9,c11c5c36-bba3-11f0-bda4-2ad541ec58f8,c11c5c36-bba3-11f0-bda4-2ad541ec58f7,c11c5c36-bba3-11f0-bda4-2ad541ec58fb,c11c5c36-bba3-11f0-bda4-2ad541ec58fa - BackendNum: 5 - BackendProfileMergeTime: 7ms - __MAX_OF_BackendProfileMergeTime: 16.543ms - __MIN_OF_BackendProfileMergeTime: 3.150ms - FragmentInstancePrepareTime: 10.817ms - InitialProcessDriverCount: 9.100K (9100) - __MAX_OF_InitialProcessDriverCount: 1.850K (1850) - __MIN_OF_InitialProcessDriverCount: 1.810K (1810) - InitialProcessMem: 153.052 GB - __MAX_OF_InitialProcessMem: 42.946 GB - __MIN_OF_InitialProcessMem: 26.277 GB - InstanceAllocatedMemoryUsage: 699.414 MB - __MAX_OF_InstanceAllocatedMemoryUsage: 153.876 MB - __MIN_OF_InstanceAllocatedMemoryUsage: 135.129 MB - InstanceDeallocatedMemoryUsage: 690.344 MB - __MAX_OF_InstanceDeallocatedMemoryUsage: 151.690 MB - __MIN_OF_InstanceDeallocatedMemoryUsage: 133.554 MB - InstanceNum: 5 - InstancePeakMemoryUsage: 2.914 MB - __MAX_OF_InstancePeakMemoryUsage: 3.418 MB - __MIN_OF_InstancePeakMemoryUsage: 2.504 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 10.243us - __MAX_OF_ActiveTime: 233.441us - __MIN_OF_ActiveTime: 1.952us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 13m42s - __MAX_OF_DriverTotalTime: 13m43s - __MIN_OF_DriverTotalTime: 13m42s - PeakDriverQueueSize: 3.353K (3353) - __MAX_OF_PeakDriverQueueSize: 109 - __MIN_OF_PeakDriverQueueSize: 32 - PendingTime: 13m42s - __MAX_OF_PendingTime: 13m42s - __MIN_OF_PendingTime: 13m42s - InputEmptyTime: 13m42s - __MAX_OF_InputEmptyTime: 13m43s - __MIN_OF_InputEmptyTime: 13m42s - FirstInputEmptyTime: 13m42s - __MAX_OF_FirstInputEmptyTime: 13m43s - __MIN_OF_FirstInputEmptyTime: 13m42s - ScheduleCount: 50 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 294.714ms - __MAX_OF_ScheduleTime: 646.791ms - __MIN_OF_ScheduleTime: 69.863ms - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=27): CommonMetrics: - IsSubordinate - OperatorTotalTime: 548ns - __MAX_OF_OperatorTotalTime: 1.632us - __MIN_OF_OperatorTotalTime: 210ns - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: SPILL_PROCESS (plan_node_id=27): CommonMetrics: - IsSubordinate - OperatorTotalTime: 735ns - __MAX_OF_OperatorTotalTime: 2.564us - __MIN_OF_OperatorTotalTime: 192ns - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 381.129us - __MAX_OF_ActiveTime: 1.928ms - __MIN_OF_ActiveTime: 148.901us - BlockByInputEmpty: 46 - __MAX_OF_BlockByInputEmpty: 2 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 13m42s - __MAX_OF_DriverTotalTime: 13m43s - __MIN_OF_DriverTotalTime: 13m42s - PeakDriverQueueSize: 3.390K (3390) - __MAX_OF_PeakDriverQueueSize: 111 - __MIN_OF_PeakDriverQueueSize: 32 - PendingTime: 13m42s - __MAX_OF_PendingTime: 13m42s - __MIN_OF_PendingTime: 13m42s - InputEmptyTime: 13m42s - __MAX_OF_InputEmptyTime: 13m42s - __MIN_OF_InputEmptyTime: 13m42s - FirstInputEmptyTime: 13m42s - __MAX_OF_FirstInputEmptyTime: 13m42s - __MIN_OF_FirstInputEmptyTime: 13m42s - FollowupInputEmptyTime: 4.396ms - __MAX_OF_FollowupInputEmptyTime: 8.070ms - __MIN_OF_FollowupInputEmptyTime: 0ns - ScheduleCount: 96 - __MAX_OF_ScheduleCount: 3 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 298.876ms - __MAX_OF_ScheduleTime: 678.753ms - __MIN_OF_ScheduleTime: 68.462ms - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 SPILLABLE_HASH_JOIN_BUILD (plan_node_id=27): CommonMetrics: - OperatorTotalTime: 153.041us - __MAX_OF_OperatorTotalTime: 390.883us - __MIN_OF_OperatorTotalTime: 59.240us - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 442 - __MAX_OF_PushChunkNum: 17 - __MIN_OF_PushChunkNum: 3 - PushRowNum: 488 - __MAX_OF_PushRowNum: 20 - __MIN_OF_PushRowNum: 3 - PushTotalTime: 52.135us - __MAX_OF_PushTotalTime: 112.480us - __MIN_OF_PushTotalTime: 24.757us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: LOCAL_HASH_BUCKET - JoinPredicates: 42: address = 7: mint - JoinType: RIGHT_OUTER_JOIN - BuildBuckets: 1.000K (1000) - __MAX_OF_BuildBuckets: 32 - __MIN_OF_BuildBuckets: 8 - BuildConjunctEvaluateTime: 5.734us - __MAX_OF_BuildConjunctEvaluateTime: 14.480us - __MIN_OF_BuildConjunctEvaluateTime: 1.283us - BuildHashTableTime: 62.863us - __MAX_OF_BuildHashTableTime: 267.080us - __MIN_OF_BuildHashTableTime: 11.607us - BuildKeysPerBucket%: 6.168K (6168) - __MAX_OF_BuildKeysPerBucket%: 180 - __MIN_OF_BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 36.700us - __MAX_OF_CopyRightTableChunkTime: 77.200us - __MIN_OF_CopyRightTableChunkTime: 20.029us - HashTableMemoryUsage: 265.197 KB - __MAX_OF_HashTableMemoryUsage: 10.819 KB - __MIN_OF_HashTableMemoryUsage: 1.636 KB - PartialRuntimeMembershipFilterBytes: 640.000 B - __MAX_OF_PartialRuntimeMembershipFilterBytes: 128.000 B - __MIN_OF_PartialRuntimeMembershipFilterBytes: 0.000 B - PartitionNums: 50 - __MAX_OF_PartitionNums: 1 - __MIN_OF_PartitionNums: 1 - PeakRevocableMemoryBytes: 250.783 KB - __MAX_OF_PeakRevocableMemoryBytes: 10.284 KB - __MIN_OF_PeakRevocableMemoryBytes: 1.526 KB - RuntimeFilterBuildTime: 41.160us - __MAX_OF_RuntimeFilterBuildTime: 103.166us - __MIN_OF_RuntimeFilterBuildTime: 6.709us - RuntimeFilterNum: 50 - __MAX_OF_RuntimeFilterNum: 1 - __MIN_OF_RuntimeFilterNum: 1 - SpillStatistics: - AppendDataTime: 0ns - BlockCount: - LocalBlockCount: 0 - RemoteBlockCount: 0 - BytesFlush: 0.000 B - BytesFlushToLocalDisk: 0.000 B - BytesFlushToRemoteStorage: 0.000 B - BytesRestore: 0.000 B - BytesRestoreFromLocalDisk: 0.000 B - BytesRestoreFromRemoteStorage: 0.000 B - BytesRestoreFromMemTable: 0 - CompactBlockCount: 0 - CompactCount: 0 - DeserializeTime: 0ns - FlushIOTaskCount: 0 - FlushIOTaskYieldCount: 0 - FlushTime: 0ns - InputStreamPeakMemoryBytes: 0.000 B - MaterializeChunkTime: 0ns - MemTableFinalizeTime: 0ns - MemTablePeakMemoryBytes: 0.000 B - PartitionWriterPeakMemoryBytes: 0.000 B - PeakFlushIOTaskCount: 0 - PeakRestoreIOTaskCount: 0 - ReadIOCount: 0 - LocalReadIOCount: 0 - RemoteReadIOCount: 0 - ReadIOTime: 0ns - LocalReadIOTime: 0ns - RemoteReadIOTime: 0ns - RestoreIOTaskCount: 0 - RestoreIOTaskYieldCount: 0 - RestoreTime: 0ns - RowsRestoreFromMemTable: 0 - RowsRestored: 0 - RowsSpilled: 0 - SerializeTime: 0ns - ShuffleTime: 0ns - SkewMemTableCount: 0 - SkewMemTableInputBytes: 0.000 B - SkewMemTableInputRows: 0 - SkewMemTableMergeTime: 0ns - SkewMemTableOutputBytes: 0.000 B - SkewMemTableOutputRows: 0 - SkewMemTableSkewRatio: 1844674407370955260.000 - __MAX_OF_SkewMemTableSkewRatio: 9223372036854776000.000 - __MIN_OF_SkewMemTableSkewRatio: 9223372036854776000.000 - SortChunkTime: 0ns - SplitPartitionTime: 0ns - WriteIOTime: 0ns - LocalWriteIOTime: 0ns - RemoteWriteIOTime: 0ns EXCHANGE_SOURCE (plan_node_id=26): CommonMetrics: - ConjunctsInputRows: 488 - __MAX_OF_ConjunctsInputRows: 20 - __MIN_OF_ConjunctsInputRows: 3 - ConjunctsOutputRows: 488 - __MAX_OF_ConjunctsOutputRows: 20 - __MIN_OF_ConjunctsOutputRows: 3 - ConjunctsTime: 4.185us - __MAX_OF_ConjunctsTime: 19.230us - __MIN_OF_ConjunctsTime: 751ns - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 147.185us - __MAX_OF_OperatorTotalTime: 640.480us - __MIN_OF_OperatorTotalTime: 36.499us - OutputChunkBytes: 181.198K (181198) - __MAX_OF_OutputChunkBytes: 7.247K (7247) - __MIN_OF_OutputChunkBytes: 1.104K (1104) - PullChunkNum: 442 - __MAX_OF_PullChunkNum: 17 - __MIN_OF_PullChunkNum: 3 - PullRowNum: 488 - __MAX_OF_PullRowNum: 20 - __MIN_OF_PullRowNum: 3 - PullTotalTime: 139.435us - __MAX_OF_PullTotalTime: 638.040us - __MIN_OF_PullTotalTime: 35.827us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 1 - __MAX_OF_BufferUnplugCount: 1 - __MIN_OF_BufferUnplugCount: 0 - BytesPassThrough: 38.851 KB - __MAX_OF_BytesPassThrough: 10.171 KB - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 177.766 KB - __MAX_OF_BytesReceived: 5.960 KB - __MIN_OF_BytesReceived: 1.628 KB - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 10.285us - __MAX_OF_DecompressChunkTime: 76.840us - __MIN_OF_DecompressChunkTime: 1.863us - DeserializeChunkTime: 64.810us - __MAX_OF_DeserializeChunkTime: 159.520us - __MIN_OF_DeserializeChunkTime: 9.275us - PeakBufferMemoryBytes: 216.616 KB - __MAX_OF_PeakBufferMemoryBytes: 13.278 KB - __MIN_OF_PeakBufferMemoryBytes: 1.746 KB - ReceiverProcessTotalTime: 81.632us - __MAX_OF_ReceiverProcessTotalTime: 216.800us - __MIN_OF_ReceiverProcessTotalTime: 20.142us - RequestReceived: 181 - __MAX_OF_RequestReceived: 4 - __MIN_OF_RequestReceived: 3 - WaitLockTime: 11ns - __MAX_OF_WaitLockTime: 160ns - __MIN_OF_WaitLockTime: 0ns Pipeline (id=2): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 1.529ms - __MAX_OF_ActiveTime: 13.921ms - __MIN_OF_ActiveTime: 17.196us - BlockByInputEmpty: 26 - __MAX_OF_BlockByInputEmpty: 2 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 4 - DriverTotalTime: 13m43s - __MAX_OF_DriverTotalTime: 13m43s - __MIN_OF_DriverTotalTime: 13m42s - PeakDriverQueueSize: 1.025K (1025) - __MAX_OF_PeakDriverQueueSize: 85 - __MIN_OF_PeakDriverQueueSize: 41 - PendingTime: 13m42s - __MAX_OF_PendingTime: 13m42s - __MIN_OF_PendingTime: 13m42s - InputEmptyTime: 16.055ms - __MAX_OF_InputEmptyTime: 31.646ms - __MIN_OF_InputEmptyTime: 8.475ms - FirstInputEmptyTime: 12.113ms - __MAX_OF_FirstInputEmptyTime: 31.646ms - __MIN_OF_FirstInputEmptyTime: 5.694ms - FollowupInputEmptyTime: 3.941ms - __MAX_OF_FollowupInputEmptyTime: 13.189ms - __MIN_OF_FollowupInputEmptyTime: 0ns - PreconditionBlockTime: 13m42s - __MAX_OF_PreconditionBlockTime: 13m43s - __MIN_OF_PreconditionBlockTime: 13m42s - ScheduleCount: 42 - __MAX_OF_ScheduleCount: 3 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 292.702ms - __MAX_OF_ScheduleTime: 652.340ms - __MIN_OF_ScheduleTime: 73.076ms - TotalDegreeOfParallelism: 16 - __MAX_OF_TotalDegreeOfParallelism: 4 - __MIN_OF_TotalDegreeOfParallelism: 3 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=27): CommonMetrics: - IsSubordinate - OperatorTotalTime: 23.188us - __MAX_OF_OperatorTotalTime: 59.320us - __MIN_OF_OperatorTotalTime: 592ns - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 16 - __MAX_OF_PushChunkNum: 2 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 412 - __MAX_OF_PushRowNum: 62 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 21.601us - __MAX_OF_PushTotalTime: 58.817us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 10 - Type: Partition(BUCKET_SHUFFLE_HASH_PARTITIONED) - LocalExchangePeakMemoryUsage: 11.840 KB - __MAX_OF_LocalExchangePeakMemoryUsage: 4.093 KB - __MIN_OF_LocalExchangePeakMemoryUsage: 0.000 B CHUNK_ACCUMULATE (plan_node_id=0): CommonMetrics: - IsSubordinate - OperatorTotalTime: 2.223us - __MAX_OF_OperatorTotalTime: 4.400us - __MIN_OF_OperatorTotalTime: 800ns - OutputChunkBytes: 22.809K (22809) - __MAX_OF_OutputChunkBytes: 3.464K (3464) - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 16 - __MAX_OF_PullChunkNum: 2 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 412 - __MAX_OF_PullRowNum: 62 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 293ns - __MAX_OF_PullTotalTime: 1.011us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 16 - __MAX_OF_PushChunkNum: 2 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 412 - __MAX_OF_PushRowNum: 62 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 1.168us - __MAX_OF_PushTotalTime: 3.360us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: CONNECTOR_SCAN (plan_node_id=0): CommonMetrics: - RuntimeFilterDesc: <5: BloomFilter> - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 412 - __MAX_OF_JoinRuntimeFilterInputRows: 62 - __MIN_OF_JoinRuntimeFilterInputRows: 17 - JoinRuntimeFilterOutputRows: 412 - __MAX_OF_JoinRuntimeFilterOutputRows: 62 - __MIN_OF_JoinRuntimeFilterOutputRows: 17 - JoinRuntimeFilterTime: 1.810us - __MAX_OF_JoinRuntimeFilterTime: 3.480us - __MIN_OF_JoinRuntimeFilterTime: 691ns - OperatorTotalTime: 1.767ms - __MAX_OF_OperatorTotalTime: 14.251ms - __MIN_OF_OperatorTotalTime: 30.184us - OutputChunkBytes: 22.809K (22809) - __MAX_OF_OutputChunkBytes: 3.464K (3464) - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 16 - __MAX_OF_PullChunkNum: 2 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 412 - __MAX_OF_PullRowNum: 62 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 1.437ms - __MAX_OF_PullTotalTime: 13.866ms - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 1 UniqueMetrics: - AdaptiveIOTasks: True - MorselQueueType: dynamic_morsel_queue - SharedScan: False - DataSourceType: LakeDataSource - Rollup: token_data_legacy - Table: token_data_legacy - ChunkBufferCapacity: 256 - DefaultChunkBufferCapacity: 256 - IOTaskExecTime: 11.342ms - __MAX_OF_IOTaskExecTime: 27.885ms - __MIN_OF_IOTaskExecTime: 5.631ms - AccessPathHits: 0 - AccessPathUnhits: 0 - BytesRead: 204.128 MB - __MAX_OF_BytesRead: 21.918 MB - __MIN_OF_BytesRead: 9.774 MB - CompressedBytesRead: 0.000 B - CreateSegmentIter: 172.953us - __MAX_OF_CreateSegmentIter: 380.402us - __MIN_OF_CreateSegmentIter: 85.381us - DictDecode: 4.264us - __MAX_OF_DictDecode: 6.800us - __MIN_OF_DictDecode: 1.552us - GetDelVec: 20.484us - __MAX_OF_GetDelVec: 66.920us - __MIN_OF_GetDelVec: 7.720us - GetDeltaColumnGroup: 1.165us - __MAX_OF_GetDeltaColumnGroup: 2.640us - __MIN_OF_GetDeltaColumnGroup: 380ns - IOStatistics: - CompressedBytesReadLocalDisk: 0.000 B - CompressedBytesReadRemote: 0.000 B - CompressedBytesReadRequest: 0.000 B - CompressedBytesReadTotal: 0.000 B - IOCountLocalDisk: 0 - IOCountRemote: 0 - IOCountRequest: 0 - IOCountTotal: 0 - IOTimeLocalDisk: 0ns - IOTimeRemote: 0ns - IOTimeTotal: 0ns - PagesCountLocalDisk: 0 - PagesCountMemory: 3.527K (3527) - __MAX_OF_PagesCountMemory: 368 - __MIN_OF_PagesCountMemory: 178 - PagesCountRemote: 0 - PagesCountTotal: 3.527K (3527) - __MAX_OF_PagesCountTotal: 368 - __MIN_OF_PagesCountTotal: 178 - PrefetchHitCount: 0 - PrefetchPendingTime: 0ns - PrefetchWaitFinishTime: 0ns - IOTime: 0ns - LateMaterialize: 70.514us - __MAX_OF_LateMaterialize: 101.842us - __MIN_OF_LateMaterialize: 33.370us - MemAllocFailed: 0 - PushdownAccessPaths: 0 - PushdownPredicates: 2 - RawRowsRead: 4.465M (4465412) - __MAX_OF_RawRowsRead: 479.407K (479407) - __MIN_OF_RawRowsRead: 213.832K (213832) - ReadPKIndex: 0ns - RowsRead: 412 - __MAX_OF_RowsRead: 34 - __MIN_OF_RowsRead: 17 - SegmentInit: 2.009ms - __MAX_OF_SegmentInit: 4.656ms - __MIN_OF_SegmentInit: 1.080ms - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 19.920us - __MAX_OF_BitmapIndexIteratorInit: 74.440us - __MIN_OF_BitmapIndexIteratorInit: 5.538us - BloomFilterFilter: 3.945us - __MAX_OF_BloomFilterFilter: 9.880us - __MIN_OF_BloomFilterFilter: 922ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 172.378us - __MAX_OF_ColumnIteratorInit: 564.440us - __MIN_OF_ColumnIteratorInit: 41.250us - RemainingRowsAfterShortKeyFilter: 16.334M (16333644) - __MAX_OF_RemainingRowsAfterShortKeyFilter: 1.022M (1021885) - __MIN_OF_RemainingRowsAfterShortKeyFilter: 1.019M (1019348) - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 3.704us - __MAX_OF_ShortKeyFilter: 7.760us - __MIN_OF_ShortKeyFilter: 1.340us - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - ZoneMapIndexFilterRows: 11.868M (11867972) - __MAX_OF_ZoneMapIndexFilterRows: 807.168K (807168) - __MIN_OF_ZoneMapIndexFilterRows: 541.773K (541773) - ZoneMapIndexFiter: 1.599ms - __MAX_OF_ZoneMapIndexFiter: 3.993ms - __MIN_OF_ZoneMapIndexFiter: 896.683us - SegmentRead: 8.156ms - __MAX_OF_SegmentRead: 22.044ms - __MIN_OF_SegmentRead: 3.830ms - BlockFetch: 3.736ms - __MAX_OF_BlockFetch: 12.401ms - __MIN_OF_BlockFetch: 1.432ms - BlockFetchCount: 1.136K (1136) - __MAX_OF_BlockFetchCount: 119 - __MIN_OF_BlockFetchCount: 56 - BlockSeek: 50.972us - __MAX_OF_BlockSeek: 102.960us - __MIN_OF_BlockSeek: 22.654us - BlockSeekCount: 3.295K (3295) - __MAX_OF_BlockSeekCount: 355 - __MIN_OF_BlockSeekCount: 158 - ChunkCopy: 28.226us - __MAX_OF_ChunkCopy: 61.280us - __MIN_OF_ChunkCopy: 7.861us - DecompressT: 0ns - DelVecFilterRows: 260 - __MAX_OF_DelVecFilterRows: 260 - __MIN_OF_DelVecFilterRows: 0 - PredFilter: 4.271ms - __MAX_OF_PredFilter: 13.996ms - __MIN_OF_PredFilter: 2.097ms - PredFilterRows: 4.465M (4465000) - __MAX_OF_PredFilterRows: 479.374K (479374) - __MIN_OF_PredFilterRows: 213.805K (213805) - RowsetsReadCount: 90 - __MAX_OF_RowsetsReadCount: 7 - __MIN_OF_RowsetsReadCount: 5 - SegmentsReadCount: 90 - __MAX_OF_SegmentsReadCount: 7 - __MIN_OF_SegmentsReadCount: 5 - TotalColumnsDataPageCount: 14.355K (14355) - __MAX_OF_TotalColumnsDataPageCount: 900 - __MIN_OF_TotalColumnsDataPageCount: 884 - UncompressedBytesRead: 0.000 B - IOTaskWaitTime: 76.540us - __MAX_OF_IOTaskWaitTime: 287.814us - __MIN_OF_IOTaskWaitTime: 26.950us - MorselsCount: 16 - __MAX_OF_MorselsCount: 2 - __MIN_OF_MorselsCount: 0 - PeakChunkBufferMemoryUsage: 533.514 KB - PeakChunkBufferSize: 2 - PeakIOTasks: 1 - __MAX_OF_PeakIOTasks: 2 - __MIN_OF_PeakIOTasks: 0 - PeakScanTaskQueueSize: 9 - __MAX_OF_PeakScanTaskQueueSize: 2 - __MIN_OF_PeakScanTaskQueueSize: 0 - PrepareChunkSourceTime: 1.376ms - __MAX_OF_PrepareChunkSourceTime: 13.809ms - __MIN_OF_PrepareChunkSourceTime: 0ns - ScanTime: 11.418ms - __MAX_OF_ScanTime: 27.926ms - __MIN_OF_ScanTime: 5.680ms - SubmitTaskCount: 16 - __MAX_OF_SubmitTaskCount: 2 - __MIN_OF_SubmitTaskCount: 0 - SubmitTaskTime: 27.257us - __MAX_OF_SubmitTaskTime: 285.540us - __MIN_OF_SubmitTaskTime: 0ns - TabletCount: 16 - __MAX_OF_TabletCount: 4 - __MIN_OF_TabletCount: 3 Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 448.394us - __MAX_OF_ActiveTime: 1.462ms - __MIN_OF_ActiveTime: 80.225us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 13m43s - __MAX_OF_DriverTotalTime: 13m43s - __MIN_OF_DriverTotalTime: 13m43s - PeakDriverQueueSize: 3.348K (3348) - __MAX_OF_PeakDriverQueueSize: 107 - __MIN_OF_PeakDriverQueueSize: 32 - PendingTime: 13m42s - __MAX_OF_PendingTime: 13m42s - __MIN_OF_PendingTime: 13m42s - InputEmptyTime: 20.007ms - __MAX_OF_InputEmptyTime: 42.220ms - __MIN_OF_InputEmptyTime: 9.352ms - FirstInputEmptyTime: 20.007ms - __MAX_OF_FirstInputEmptyTime: 42.220ms - __MIN_OF_FirstInputEmptyTime: 9.352ms - PendingFinishTime: 11.413ms - __MAX_OF_PendingFinishTime: 15.967ms - __MIN_OF_PendingFinishTime: 1.670ms - PreconditionBlockTime: 13m42s - __MAX_OF_PreconditionBlockTime: 13m43s - __MIN_OF_PreconditionBlockTime: 13m42s - ScheduleCount: 50 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 301.523ms - __MAX_OF_ScheduleTime: 864.100ms - __MIN_OF_ScheduleTime: 60.514ms - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=30): CommonMetrics: - OperatorTotalTime: 226.024us - __MAX_OF_OperatorTotalTime: 1.277ms - __MIN_OF_OperatorTotalTime: 21.002us - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 50 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 488 - __MAX_OF_PushRowNum: 20 - __MIN_OF_PushRowNum: 3 - PushTotalTime: 54.125us - __MAX_OF_PushTotalTime: 355.922us - __MIN_OF_PushTotalTime: 17.798us UniqueMetrics: - ChannelNum: 1 - DestFragments: c11c5c36bba311f0-bda42ad541ec58f6 - DestID: 30 - PartType: UNPARTITIONED - BytesPassThrough: 43.124 KB - __MAX_OF_BytesPassThrough: 6.090 KB - __MIN_OF_BytesPassThrough: 0.000 B - BytesSent: 124.877 KB - __MAX_OF_BytesSent: 40.271 KB - __MIN_OF_BytesSent: 0.000 B - BytesUnsent: 0.000 B - CompressTime: 17.417us - __MAX_OF_CompressTime: 67.561us - __MIN_OF_CompressTime: 0ns - CompressedBytes: 96.179 KB - __MAX_OF_CompressedBytes: 5.435 KB - __MIN_OF_CompressedBytes: 0.000 B - NetworkBandwidth: 10.756 MB/sec - __MAX_OF_NetworkBandwidth: 3.468 MB/sec - __MIN_OF_NetworkBandwidth: 0.000 B/sec - NetworkTime: 9.725ms - __MAX_OF_NetworkTime: 13.087ms - __MIN_OF_NetworkTime: 1.918ms - OverallThroughput: 9.639 MB/sec - __MAX_OF_OverallThroughput: 3.208 MB/sec - __MIN_OF_OverallThroughput: 0.000 B/sec - OverallTime: 11.133ms - __MAX_OF_OverallTime: 15.757ms - __MIN_OF_OverallTime: 2.759ms - PassThroughBufferPeakMemoryUsage: 68.750 KB - __MAX_OF_PassThroughBufferPeakMemoryUsage: 68.750 KB - __MIN_OF_PassThroughBufferPeakMemoryUsage: 0.000 B - RawInputBytes: 175.396 KB - __MAX_OF_RawInputBytes: 8.879 KB - __MIN_OF_RawInputBytes: 0.000 B - RequestSent: 40 - __MAX_OF_RequestSent: 10 - __MIN_OF_RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 1.101ms - __MAX_OF_RpcAvgTime: 2.055ms - __MIN_OF_RpcAvgTime: 396.330us - RpcCount: 55 - __MAX_OF_RpcCount: 11 - __MIN_OF_RpcCount: 11 - SerializeChunkTime: 26.193us - __MAX_OF_SerializeChunkTime: 319.922us - __MIN_OF_SerializeChunkTime: 0ns - SerializedBytes: 173.295 KB - __MAX_OF_SerializedBytes: 7.575 KB - __MIN_OF_SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 12.767ms - __MAX_OF_WaitTime: 21.475ms - __MIN_OF_WaitTime: 1.948ms DICT_DECODE (plan_node_id=29): CommonMetrics: - OperatorTotalTime: 81.333us - __MAX_OF_OperatorTotalTime: 398.131us - __MIN_OF_OperatorTotalTime: 6.160us - OutputChunkBytes: 221.885K (221885) - __MAX_OF_OutputChunkBytes: 9.092K (9092) - __MIN_OF_OutputChunkBytes: 1.395K (1395) - PullChunkNum: 50 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 488 - __MAX_OF_PullRowNum: 20 - __MIN_OF_PullRowNum: 3 - PullTotalTime: 63.323us - __MAX_OF_PullTotalTime: 379.120us - __MIN_OF_PullTotalTime: 40ns - PushChunkNum: 50 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 488 - __MAX_OF_PushRowNum: 20 - __MIN_OF_PushRowNum: 3 - PushTotalTime: 13.045us - __MAX_OF_PushTotalTime: 105.560us - __MIN_OF_PushTotalTime: 3.365us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: PROJECT (plan_node_id=28): CommonMetrics: - OperatorTotalTime: 14.533us - __MAX_OF_OperatorTotalTime: 134.320us - __MIN_OF_OperatorTotalTime: 5.532us - OutputChunkBytes: 185.041K (185041) - __MAX_OF_OutputChunkBytes: 7.393K (7393) - __MIN_OF_OutputChunkBytes: 1.133K (1133) - PullChunkNum: 50 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 488 - __MAX_OF_PullRowNum: 20 - __MIN_OF_PullRowNum: 3 - PullTotalTime: 233ns - __MAX_OF_PullTotalTime: 792ns - __MIN_OF_PullTotalTime: 40ns - PushChunkNum: 50 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 488 - __MAX_OF_PushRowNum: 20 - __MIN_OF_PushRowNum: 3 - PushTotalTime: 8.452us - __MAX_OF_PushTotalTime: 126.760us - __MIN_OF_PushTotalTime: 1.562us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 163ns - __MAX_OF_CommonSubExprComputeTime: 591ns - __MIN_OF_CommonSubExprComputeTime: 20ns - ExprComputeTime: 3.655us - __MAX_OF_ExprComputeTime: 11.048us - __MIN_OF_ExprComputeTime: 471ns CHUNK_ACCUMULATE (plan_node_id=27): CommonMetrics: - IsSubordinate - OperatorTotalTime: 9.268us - __MAX_OF_OperatorTotalTime: 22.696us - __MIN_OF_OperatorTotalTime: 721ns - OutputChunkBytes: 185.041K (185041) - __MAX_OF_OutputChunkBytes: 7.393K (7393) - __MIN_OF_OutputChunkBytes: 1.133K (1133) - PullChunkNum: 50 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 488 - __MAX_OF_PullRowNum: 20 - __MIN_OF_PullRowNum: 3 - PullTotalTime: 86ns - __MAX_OF_PullTotalTime: 160ns - __MIN_OF_PullTotalTime: 59ns - PushChunkNum: 93 - __MAX_OF_PushChunkNum: 2 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 488 - __MAX_OF_PushRowNum: 20 - __MIN_OF_PushRowNum: 3 - PushTotalTime: 8.565us - __MAX_OF_PushTotalTime: 21.705us - __MIN_OF_PushTotalTime: 300ns UniqueMetrics: SPILLABLE_HASH_JOIN_PROBE (plan_node_id=27): CommonMetrics: - OperatorTotalTime: 105.351us - __MAX_OF_OperatorTotalTime: 303.242us - __MIN_OF_OperatorTotalTime: 45.311us - OutputChunkBytes: 185.041K (185041) - __MAX_OF_OutputChunkBytes: 7.393K (7393) - __MIN_OF_OutputChunkBytes: 1.133K (1133) - PullChunkNum: 93 - __MAX_OF_PullChunkNum: 2 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 488 - __MAX_OF_PullRowNum: 20 - __MIN_OF_PullRowNum: 3 - PullTotalTime: 59.056us - __MAX_OF_PullTotalTime: 133.480us - __MIN_OF_PullTotalTime: 23.487us - PushChunkNum: 50 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 412 - __MAX_OF_PushRowNum: 15 - __MIN_OF_PushRowNum: 3 - PushTotalTime: 9.209us - __MAX_OF_PushTotalTime: 195.361us - __MIN_OF_PushTotalTime: 1.242us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: LOCAL_HASH_BUCKET - JoinType: RIGHT_OUTER_JOIN - OtherJoinConjunctEvaluateTime: 0ns - OutputBuildColumnTime: 33.302us - __MAX_OF_OutputBuildColumnTime: 96.920us - __MIN_OF_OutputBuildColumnTime: 11.267us - OutputProbeColumnTime: 4.322us - __MAX_OF_OutputProbeColumnTime: 21.560us - __MIN_OF_OutputProbeColumnTime: 891ns - PartitionProbeOverhead: 0ns - ProbeConjunctEvaluateTime: 1.504us - __MAX_OF_ProbeConjunctEvaluateTime: 8.480us - __MIN_OF_ProbeConjunctEvaluateTime: 180ns - SearchHashTableTime: 5.838us - __MAX_OF_SearchHashTableTime: 12.979us - __MIN_OF_SearchHashTableTime: 1.952us - SpillBuildPartitionPeakMemoryUsage: 0.000 B - SpillPartitions: 0 - SpillPeakProcessingPartitionCount: 0 - SpillProberPeakMemoryUsage: 0.000 B - SpillStatistics: - AppendDataTime: 0ns - BlockCount: - LocalBlockCount: 0 - RemoteBlockCount: 0 - BytesFlush: 0.000 B - BytesFlushToLocalDisk: 0.000 B - BytesFlushToRemoteStorage: 0.000 B - BytesRestore: 0.000 B - BytesRestoreFromLocalDisk: 0.000 B - BytesRestoreFromRemoteStorage: 0.000 B - BytesRestoreFromMemTable: 0 - CompactBlockCount: 0 - CompactCount: 0 - DeserializeTime: 0ns - FlushIOTaskCount: 0 - FlushIOTaskYieldCount: 0 - FlushTime: 0ns - InputStreamPeakMemoryBytes: 0.000 B - MaterializeChunkTime: 0ns - MemTableFinalizeTime: 0ns - MemTablePeakMemoryBytes: 0.000 B - PartitionWriterPeakMemoryBytes: 0.000 B - PeakFlushIOTaskCount: 0 - PeakRestoreIOTaskCount: 0 - ReadIOCount: 0 - LocalReadIOCount: 0 - RemoteReadIOCount: 0 - ReadIOTime: 0ns - LocalReadIOTime: 0ns - RemoteReadIOTime: 0ns - RestoreIOTaskCount: 0 - RestoreIOTaskYieldCount: 0 - RestoreTime: 0ns - RowsRestoreFromMemTable: 0 - RowsRestored: 0 - RowsSpilled: 0 - SerializeTime: 0ns - ShuffleTime: 0ns - SkewMemTableCount: 0 - SkewMemTableInputBytes: 0.000 B - SkewMemTableInputRows: 0 - SkewMemTableMergeTime: 0ns - SkewMemTableOutputBytes: 0.000 B - SkewMemTableOutputRows: 0 - SkewMemTableSkewRatio: 1844674407370955260.000 - __MAX_OF_SkewMemTableSkewRatio: 9223372036854776000.000 - __MIN_OF_SkewMemTableSkewRatio: 9223372036854776000.000 - SortChunkTime: 0ns - SplitPartitionTime: 0ns - WriteIOTime: 0ns - LocalWriteIOTime: 0ns - RemoteWriteIOTime: 0ns - WhereConjunctEvaluateTime: 0ns - probeCount: 0 LOCAL_EXCHANGE_SOURCE (plan_node_id=27): CommonMetrics: - IsSubordinate - OperatorTotalTime: 20.971us - __MAX_OF_OperatorTotalTime: 55.454us - __MIN_OF_OperatorTotalTime: 4.687us - OutputChunkBytes: 22.809K (22809) - __MAX_OF_OutputChunkBytes: 826 - __MIN_OF_OutputChunkBytes: 166 - PullChunkNum: 50 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 412 - __MAX_OF_PullRowNum: 15 - __MIN_OF_PullRowNum: 3 - PullTotalTime: 18.427us - __MAX_OF_PullTotalTime: 51.067us - __MIN_OF_PullTotalTime: 2.794us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Fragment 2: - BackendAddresses: fe02.starrocks.local:9060,cn01.starrocks.local:9060,cnrs01.starrocks.local:9060,cn02.starrocks.local:9060,fe03.starrocks.local:9060 - InstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec5900,c11c5c36-bba3-11f0-bda4-2ad541ec58ff,c11c5c36-bba3-11f0-bda4-2ad541ec58fe,c11c5c36-bba3-11f0-bda4-2ad541ec58fd,c11c5c36-bba3-11f0-bda4-2ad541ec58fc - BackendNum: 5 - BackendProfileMergeTime: 7.007ms - __MAX_OF_BackendProfileMergeTime: 14.226ms - __MIN_OF_BackendProfileMergeTime: 2.528ms - FragmentInstancePrepareTime: 39.702ms - __MAX_OF_FragmentInstancePrepareTime: 67.875ms - __MIN_OF_FragmentInstancePrepareTime: 11.529ms - prepare-pipeline-driver: 38.552ms - __MAX_OF_prepare-pipeline-driver: 67.090ms - __MIN_OF_prepare-pipeline-driver: 10.014ms - InitialProcessDriverCount: 9.266K (9266) - __MAX_OF_InitialProcessDriverCount: 1.884K (1884) - __MIN_OF_InitialProcessDriverCount: 1.843K (1843) - InitialProcessMem: 153.077 GB - __MAX_OF_InitialProcessMem: 42.949 GB - __MIN_OF_InitialProcessMem: 26.287 GB - InstanceAllocatedMemoryUsage: 615.032 MB - __MAX_OF_InstanceAllocatedMemoryUsage: 123.620 MB - __MIN_OF_InstanceAllocatedMemoryUsage: 122.701 MB - InstanceDeallocatedMemoryUsage: 606.131 MB - __MAX_OF_InstanceDeallocatedMemoryUsage: 121.908 MB - __MIN_OF_InstanceDeallocatedMemoryUsage: 120.913 MB - InstanceNum: 5 - InstancePeakMemoryUsage: 5.249 MB - __MAX_OF_InstancePeakMemoryUsage: 5.781 MB - __MIN_OF_InstancePeakMemoryUsage: 4.857 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 7.019us - __MAX_OF_ActiveTime: 17.920us - __MIN_OF_ActiveTime: 3.184us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 230.311ms - __MAX_OF_DriverTotalTime: 258.037ms - __MIN_OF_DriverTotalTime: 184.355ms - PeakDriverQueueSize: 116 - __MAX_OF_PeakDriverQueueSize: 8 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 230.046ms - __MAX_OF_PendingTime: 257.635ms - __MIN_OF_PendingTime: 182.714ms - InputEmptyTime: 230.046ms - __MAX_OF_InputEmptyTime: 257.635ms - __MIN_OF_InputEmptyTime: 182.713ms - FirstInputEmptyTime: 230.046ms - __MAX_OF_FirstInputEmptyTime: 257.635ms - __MIN_OF_FirstInputEmptyTime: 182.713ms - ScheduleCount: 50 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=24): CommonMetrics: - IsSubordinate - OperatorTotalTime: 827ns - __MAX_OF_OperatorTotalTime: 2.033us - __MIN_OF_OperatorTotalTime: 192ns - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: SPILL_PROCESS (plan_node_id=24): CommonMetrics: - IsSubordinate - OperatorTotalTime: 763ns - __MAX_OF_OperatorTotalTime: 2.160us - __MIN_OF_OperatorTotalTime: 192ns - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 666.930us - __MAX_OF_ActiveTime: 2.159ms - __MIN_OF_ActiveTime: 281.046us - BlockByInputEmpty: 44 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 228.582ms - __MAX_OF_DriverTotalTime: 256.678ms - __MIN_OF_DriverTotalTime: 179.866ms - PeakDriverQueueSize: 289 - __MAX_OF_PeakDriverQueueSize: 9 - __MIN_OF_PeakDriverQueueSize: 1 - PendingTime: 227.114ms - __MAX_OF_PendingTime: 252.887ms - __MIN_OF_PendingTime: 178.216ms - InputEmptyTime: 227.117ms - __MAX_OF_InputEmptyTime: 252.893ms - __MIN_OF_InputEmptyTime: 178.215ms - FirstInputEmptyTime: 223.257ms - __MAX_OF_FirstInputEmptyTime: 240.252ms - __MIN_OF_FirstInputEmptyTime: 178.194ms - FollowupInputEmptyTime: 8.824ms - __MAX_OF_FollowupInputEmptyTime: 16.094ms - __MIN_OF_FollowupInputEmptyTime: 0ns - ScheduleCount: 94 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 1.579ms - __MAX_OF_ScheduleTime: 2.585ms - __MIN_OF_ScheduleTime: 671.644us - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 SPILLABLE_HASH_JOIN_BUILD (plan_node_id=24): CommonMetrics: - OperatorTotalTime: 493.301us - __MAX_OF_OperatorTotalTime: 2.075ms - __MIN_OF_OperatorTotalTime: 213.018us - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 264 - __MAX_OF_PushChunkNum: 8 - __MIN_OF_PushChunkNum: 3 - PushRowNum: 488 - __MAX_OF_PushRowNum: 16 - __MIN_OF_PushRowNum: 5 - PushTotalTime: 195.931us - __MAX_OF_PushTotalTime: 414.722us - __MIN_OF_PushTotalTime: 75.748us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: PARTITIONED - JoinPredicates: 12: tx = 4: transactionHash - JoinType: RIGHT_OUTER_JOIN - BuildBuckets: 1.000K (1000) - __MAX_OF_BuildBuckets: 32 - __MIN_OF_BuildBuckets: 8 - BuildConjunctEvaluateTime: 2.425us - __MAX_OF_BuildConjunctEvaluateTime: 9.605us - __MIN_OF_BuildConjunctEvaluateTime: 672ns - BuildHashTableTime: 51.117us - __MAX_OF_BuildHashTableTime: 232.560us - __MIN_OF_BuildHashTableTime: 16.454us - BuildKeysPerBucket%: 6.128K (6128) - __MAX_OF_BuildKeysPerBucket%: 166 - __MIN_OF_BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 49.409us - __MAX_OF_CopyRightTableChunkTime: 133.200us - __MIN_OF_CopyRightTableChunkTime: 16.585us - HashTableMemoryUsage: 262.746 KB - __MAX_OF_HashTableMemoryUsage: 8.980 KB - __MIN_OF_HashTableMemoryUsage: 2.816 KB - PartialRuntimeMembershipFilterBytes: 640.000 B - __MAX_OF_PartialRuntimeMembershipFilterBytes: 128.000 B - __MIN_OF_PartialRuntimeMembershipFilterBytes: 0.000 B - PartitionNums: 800 - __MAX_OF_PartitionNums: 16 - __MIN_OF_PartitionNums: 16 - PeakRevocableMemoryBytes: 288.181 KB - __MAX_OF_PeakRevocableMemoryBytes: 8.188 KB - __MIN_OF_PeakRevocableMemoryBytes: 3.757 KB - RuntimeFilterBuildTime: 10.670us - __MAX_OF_RuntimeFilterBuildTime: 50.120us - __MIN_OF_RuntimeFilterBuildTime: 1.612us - RuntimeFilterNum: 0 - SpillStatistics: - AppendDataTime: 0ns - BlockCount: - LocalBlockCount: 0 - RemoteBlockCount: 0 - BytesFlush: 0.000 B - BytesFlushToLocalDisk: 0.000 B - BytesFlushToRemoteStorage: 0.000 B - BytesRestore: 0.000 B - BytesRestoreFromLocalDisk: 0.000 B - BytesRestoreFromRemoteStorage: 0.000 B - BytesRestoreFromMemTable: 0 - CompactBlockCount: 0 - CompactCount: 0 - DeserializeTime: 0ns - FlushIOTaskCount: 0 - FlushIOTaskYieldCount: 0 - FlushTime: 0ns - InputStreamPeakMemoryBytes: 0.000 B - MaterializeChunkTime: 0ns - MemTableFinalizeTime: 0ns - MemTablePeakMemoryBytes: 0.000 B - PartitionWriterPeakMemoryBytes: 0.000 B - PeakFlushIOTaskCount: 0 - PeakRestoreIOTaskCount: 0 - ReadIOCount: 0 - LocalReadIOCount: 0 - RemoteReadIOCount: 0 - ReadIOTime: 0ns - LocalReadIOTime: 0ns - RemoteReadIOTime: 0ns - RestoreIOTaskCount: 0 - RestoreIOTaskYieldCount: 0 - RestoreTime: 0ns - RowsRestoreFromMemTable: 0 - RowsRestored: 0 - RowsSpilled: 0 - SerializeTime: 0ns - ShuffleTime: 0ns - SkewMemTableCount: 0 - SkewMemTableInputBytes: 0.000 B - SkewMemTableInputRows: 0 - SkewMemTableMergeTime: 0ns - SkewMemTableOutputBytes: 0.000 B - SkewMemTableOutputRows: 0 - SkewMemTableSkewRatio: 1844674407370955260.000 - __MAX_OF_SkewMemTableSkewRatio: 9223372036854776000.000 - __MIN_OF_SkewMemTableSkewRatio: 9223372036854776000.000 - SortChunkTime: 0ns - SplitPartitionTime: 0ns - WriteIOTime: 0ns - LocalWriteIOTime: 0ns - RemoteWriteIOTime: 0ns EXCHANGE_SOURCE (plan_node_id=23): CommonMetrics: - ConjunctsInputRows: 488 - __MAX_OF_ConjunctsInputRows: 16 - __MIN_OF_ConjunctsInputRows: 5 - ConjunctsOutputRows: 488 - __MAX_OF_ConjunctsOutputRows: 16 - __MIN_OF_ConjunctsOutputRows: 5 - ConjunctsTime: 3.614us - __MAX_OF_ConjunctsTime: 8.480us - __MIN_OF_ConjunctsTime: 522ns - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 120.272us - __MAX_OF_OperatorTotalTime: 262.720us - __MIN_OF_OperatorTotalTime: 43.994us - OutputChunkBytes: 179.246K (179246) - __MAX_OF_OutputChunkBytes: 5.795K (5795) - __MIN_OF_OutputChunkBytes: 1.799K (1799) - PullChunkNum: 264 - __MAX_OF_PullChunkNum: 8 - __MIN_OF_PullChunkNum: 3 - PullRowNum: 488 - __MAX_OF_PullRowNum: 16 - __MIN_OF_PullRowNum: 5 - PullTotalTime: 114.698us - __MAX_OF_PullTotalTime: 256.280us - __MIN_OF_PullTotalTime: 33.759us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 41.362 KB - __MAX_OF_BytesPassThrough: 11.109 KB - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 160.248 KB - __MAX_OF_BytesReceived: 10.938 KB - __MIN_OF_BytesReceived: 0.000 B - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 3.674us - __MAX_OF_DecompressChunkTime: 17.602us - __MIN_OF_DecompressChunkTime: 0ns - DeserializeChunkTime: 56.006us - __MAX_OF_DeserializeChunkTime: 147.120us - __MIN_OF_DeserializeChunkTime: 9.904us - PeakBufferMemoryBytes: 201.610 KB - __MAX_OF_PeakBufferMemoryBytes: 11.109 KB - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 31.448us - __MAX_OF_ReceiverProcessTotalTime: 243.042us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 37 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 15ns - __MAX_OF_WaitLockTime: 240ns - __MIN_OF_WaitLockTime: 0ns Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 3.365ms - __MAX_OF_ActiveTime: 13.839ms - __MIN_OF_ActiveTime: 1.098ms - BlockByInputEmpty: 177 - __MAX_OF_BlockByInputEmpty: 4 - __MIN_OF_BlockByInputEmpty: 2 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverPrepareTime: 6.399ms - __MAX_OF_DriverPrepareTime: 60.926ms - __MIN_OF_DriverPrepareTime: 178.680us - DriverTotalTime: 13m42s - __MAX_OF_DriverTotalTime: 13m42s - __MIN_OF_DriverTotalTime: 13m42s - PeakDriverQueueSize: 4.003K (4003) - __MAX_OF_PeakDriverQueueSize: 113 - __MIN_OF_PeakDriverQueueSize: 48 - PendingTime: 13m42s - __MAX_OF_PendingTime: 13m42s - __MIN_OF_PendingTime: 13m41s - InputEmptyTime: 13m42s - __MAX_OF_InputEmptyTime: 13m42s - __MIN_OF_InputEmptyTime: 13m42s - FirstInputEmptyTime: 13m42s - __MAX_OF_FirstInputEmptyTime: 13m42s - __MIN_OF_FirstInputEmptyTime: 13m42s - FollowupInputEmptyTime: 97.574ms - __MAX_OF_FollowupInputEmptyTime: 117.144ms - __MIN_OF_FollowupInputEmptyTime: 55.233ms - PendingFinishTime: 30.633ms - __MAX_OF_PendingFinishTime: 51.850ms - __MIN_OF_PendingFinishTime: 7.866ms - PreconditionBlockTime: 230.033ms - __MAX_OF_PreconditionBlockTime: 257.606ms - __MIN_OF_PreconditionBlockTime: 182.703ms - ScheduleCount: 227 - __MAX_OF_ScheduleCount: 5 - __MIN_OF_ScheduleCount: 3 - ScheduleTime: 420.086ms - __MAX_OF_ScheduleTime: 1s50ms - __MIN_OF_ScheduleTime: 116.244ms - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=26): CommonMetrics: - OperatorTotalTime: 1.119ms - __MAX_OF_OperatorTotalTime: 7.409ms - __MIN_OF_OperatorTotalTime: 198.671us - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 50 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 488 - __MAX_OF_PushRowNum: 16 - __MIN_OF_PushRowNum: 5 - PushTotalTime: 178.014us - __MAX_OF_PushTotalTime: 509.682us - __MIN_OF_PushTotalTime: 57.407us - SetFinishingTime: 1.853ms - __MAX_OF_SetFinishingTime: 7.228ms - __MIN_OF_SetFinishingTime: 343.040us UniqueMetrics: - ChannelNum: 16 - DestFragments: c11c5c36bba311f0-bda42ad541ec58f7, c11c5c36bba311f0-bda42ad541ec58f9, c11c5c36bba311f0-bda42ad541ec58f8, c11c5c36bba311f0-bda42ad541ec58fb, c11c5c36bba311f0-bda42ad541ec58fb, c11c5c36bba311f0-bda42ad541ec58f7, c11c5c36bba311f0-bda42ad541ec58fa, c11c5c36bba311f0-bda42ad541ec58f8, c11c5c36bba311f0-bda42ad541ec58fa, c11c5c36bba311f0-bda42ad541ec58f8, c11c5c36bba311f0-bda42ad541ec58f7, c11c5c36bba311f0-bda42ad541ec58f9, c11c5c36bba311f0-bda42ad541ec58f9, c11c5c36bba311f0-bda42ad541ec58fa, c11c5c36bba311f0-bda42ad541ec58fb, c11c5c36bba311f0-bda42ad541ec58f7 - DestID: 26 - PartType: BUCKET_SHUFFLE_HASH_PARTITIONED - PipelineLevelShuffle: Yes - ShuffleNumPerChannel: 10 - TotalShuffleNum: 160 - BytesPassThrough: 38.851 KB - __MAX_OF_BytesPassThrough: 2.126 KB - __MIN_OF_BytesPassThrough: 0.000 B - BytesSent: 177.766 KB - __MAX_OF_BytesSent: 37.602 KB - __MIN_OF_BytesSent: 31.905 KB - BytesUnsent: 0.000 B - CompressTime: 64.775us - __MAX_OF_CompressTime: 1.467ms - __MIN_OF_CompressTime: 11.766us - CompressedBytes: 77.104 KB - __MAX_OF_CompressedBytes: 2.281 KB - __MIN_OF_CompressedBytes: 768.000 B - NetworkBandwidth: 6.510 MB/sec - __MAX_OF_NetworkBandwidth: 2.750 MB/sec - __MIN_OF_NetworkBandwidth: 673.900 KB/sec - NetworkTime: 33.628ms - __MAX_OF_NetworkTime: 51.014ms - __MIN_OF_NetworkTime: 12.990ms - OverallThroughput: 6.084 MB/sec - __MAX_OF_OverallThroughput: 2.265 MB/sec - __MIN_OF_OverallThroughput: 664.526 KB/sec - OverallTime: 34.040ms - __MAX_OF_OverallTime: 51.734ms - __MIN_OF_OverallTime: 15.774ms - PassThroughBufferPeakMemoryUsage: 211.086 KB - __MAX_OF_PassThroughBufferPeakMemoryUsage: 55.844 KB - __MIN_OF_PassThroughBufferPeakMemoryUsage: 29.523 KB - RawInputBytes: 148.796 KB - __MAX_OF_RawInputBytes: 5.304 KB - __MIN_OF_RawInputBytes: 1.518 KB - RequestSent: 176 - __MAX_OF_RequestSent: 37 - __MIN_OF_RequestSent: 34 - RequestUnsent: 0 - RpcAvgTime: 2.372ms - __MAX_OF_RpcAvgTime: 4.720ms - __MIN_OF_RpcAvgTime: 1.308ms - RpcCount: 185 - __MAX_OF_RpcCount: 38 - __MIN_OF_RpcCount: 36 - SerializeChunkTime: 78.982us - __MAX_OF_SerializeChunkTime: 645.362us - __MIN_OF_SerializeChunkTime: 15.925us - SerializedBytes: 207.772 KB - __MAX_OF_SerializedBytes: 6.925 KB - __MIN_OF_SerializedBytes: 2.158 KB - ShuffleChunkAppendCounter: 477 - __MAX_OF_ShuffleChunkAppendCounter: 16 - __MIN_OF_ShuffleChunkAppendCounter: 5 - ShuffleChunkAppendTime: 35.280us - __MAX_OF_ShuffleChunkAppendTime: 121.600us - __MIN_OF_ShuffleChunkAppendTime: 9.093us - ShuffleHashTime: 17.210us - __MAX_OF_ShuffleHashTime: 300.506us - __MIN_OF_ShuffleHashTime: 1.793us - WaitTime: 28.377ms - __MAX_OF_WaitTime: 48.917ms - __MIN_OF_WaitTime: 5.617ms PROJECT (plan_node_id=25): CommonMetrics: - OperatorTotalTime: 23.648us - __MAX_OF_OperatorTotalTime: 72.320us - __MIN_OF_OperatorTotalTime: 9.574us - OutputChunkBytes: 181.198K (181198) - __MAX_OF_OutputChunkBytes: 5.859K (5859) - __MIN_OF_OutputChunkBytes: 1.819K (1819) - PullChunkNum: 50 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 488 - __MAX_OF_PullRowNum: 16 - __MIN_OF_PullRowNum: 5 - PullTotalTime: 187ns - __MAX_OF_PullTotalTime: 600ns - __MIN_OF_PullTotalTime: 40ns - PushChunkNum: 50 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 488 - __MAX_OF_PushRowNum: 16 - __MIN_OF_PushRowNum: 5 - PushTotalTime: 17.510us - __MAX_OF_PushTotalTime: 65.360us - __MIN_OF_PushTotalTime: 5.699us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 338ns - __MAX_OF_CommonSubExprComputeTime: 3.560us - __MIN_OF_CommonSubExprComputeTime: 20ns - ExprComputeTime: 12.200us - __MAX_OF_ExprComputeTime: 59.040us - __MIN_OF_ExprComputeTime: 3.536us CHUNK_ACCUMULATE (plan_node_id=24): CommonMetrics: - IsSubordinate - OperatorTotalTime: 80.405us - __MAX_OF_OperatorTotalTime: 616.080us - __MIN_OF_OperatorTotalTime: 26.600us - OutputChunkBytes: 180.222K (180222) - __MAX_OF_OutputChunkBytes: 5.827K (5827) - __MIN_OF_OutputChunkBytes: 1.809K (1809) - PullChunkNum: 50 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 488 - __MAX_OF_PullRowNum: 16 - __MIN_OF_PullRowNum: 5 - PullTotalTime: 149ns - __MAX_OF_PullTotalTime: 311ns - __MIN_OF_PullTotalTime: 50ns - PushChunkNum: 439 - __MAX_OF_PushChunkNum: 15 - __MIN_OF_PushChunkNum: 5 - PushRowNum: 488 - __MAX_OF_PushRowNum: 16 - __MIN_OF_PushRowNum: 5 - PushTotalTime: 79.345us - __MAX_OF_PushTotalTime: 614.920us - __MIN_OF_PushTotalTime: 26.260us UniqueMetrics: SPILLABLE_HASH_JOIN_PROBE (plan_node_id=24): CommonMetrics: - OperatorTotalTime: 936.541us - __MAX_OF_OperatorTotalTime: 4.317ms - __MIN_OF_OperatorTotalTime: 377.172us - OutputChunkBytes: 180.222K (180222) - __MAX_OF_OutputChunkBytes: 5.827K (5827) - __MIN_OF_OutputChunkBytes: 1.809K (1809) - PrepareTime: 6.184ms - __MAX_OF_PrepareTime: 60.599ms - __MIN_OF_PrepareTime: 79.880us - PullChunkNum: 439 - __MAX_OF_PullChunkNum: 15 - __MIN_OF_PullChunkNum: 5 - PullRowNum: 488 - __MAX_OF_PullRowNum: 16 - __MIN_OF_PullRowNum: 5 - PullTotalTime: 778.972us - __MAX_OF_PullTotalTime: 4.152ms - __MIN_OF_PullTotalTime: 304.372us - PushChunkNum: 2.500K (2500) - __MAX_OF_PushChunkNum: 50 - __MIN_OF_PushChunkNum: 50 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 8.931K (8931) - __MIN_OF_PushRowNum: 8.555K (8555) - PushTotalTime: 124.071us - __MAX_OF_PushTotalTime: 960.200us - __MIN_OF_PushTotalTime: 33.843us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: PARTITIONED - JoinType: RIGHT_OUTER_JOIN - OtherJoinConjunctEvaluateTime: 0ns - OutputBuildColumnTime: 205.466us - __MAX_OF_OutputBuildColumnTime: 2.151ms - __MIN_OF_OutputBuildColumnTime: 57.239us - OutputProbeColumnTime: 29.025us - __MAX_OF_OutputProbeColumnTime: 272.240us - __MIN_OF_OutputProbeColumnTime: 4.136us - PartitionProbeOverhead: 0ns - ProbeConjunctEvaluateTime: 76.212us - __MAX_OF_ProbeConjunctEvaluateTime: 356.054us - __MIN_OF_ProbeConjunctEvaluateTime: 25.519us - SearchHashTableTime: 457.011us - __MAX_OF_SearchHashTableTime: 3.721ms - __MIN_OF_SearchHashTableTime: 198.400us - SpillBuildPartitionPeakMemoryUsage: 0.000 B - SpillPartitions: 0 - SpillPeakProcessingPartitionCount: 0 - SpillProberPeakMemoryUsage: 0.000 B - SpillStatistics: - AppendDataTime: 0ns - BlockCount: - LocalBlockCount: 0 - RemoteBlockCount: 0 - BytesFlush: 0.000 B - BytesFlushToLocalDisk: 0.000 B - BytesFlushToRemoteStorage: 0.000 B - BytesRestore: 0.000 B - BytesRestoreFromLocalDisk: 0.000 B - BytesRestoreFromRemoteStorage: 0.000 B - BytesRestoreFromMemTable: 0 - CompactBlockCount: 0 - CompactCount: 0 - DeserializeTime: 0ns - FlushIOTaskCount: 0 - FlushIOTaskYieldCount: 0 - FlushTime: 0ns - InputStreamPeakMemoryBytes: 0.000 B - MaterializeChunkTime: 0ns - MemTableFinalizeTime: 0ns - MemTablePeakMemoryBytes: 0.000 B - PartitionWriterPeakMemoryBytes: 0.000 B - PeakFlushIOTaskCount: 0 - PeakRestoreIOTaskCount: 0 - ReadIOCount: 0 - LocalReadIOCount: 0 - RemoteReadIOCount: 0 - ReadIOTime: 0ns - LocalReadIOTime: 0ns - RemoteReadIOTime: 0ns - RestoreIOTaskCount: 0 - RestoreIOTaskYieldCount: 0 - RestoreTime: 0ns - RowsRestoreFromMemTable: 0 - RowsRestored: 0 - RowsSpilled: 0 - SerializeTime: 0ns - ShuffleTime: 0ns - SkewMemTableCount: 0 - SkewMemTableInputBytes: 0.000 B - SkewMemTableInputRows: 0 - SkewMemTableMergeTime: 0ns - SkewMemTableOutputBytes: 0.000 B - SkewMemTableOutputRows: 0 - SkewMemTableSkewRatio: 1844674407370955260.000 - __MAX_OF_SkewMemTableSkewRatio: 9223372036854776000.000 - __MIN_OF_SkewMemTableSkewRatio: 9223372036854776000.000 - SortChunkTime: 0ns - SplitPartitionTime: 0ns - WriteIOTime: 0ns - LocalWriteIOTime: 0ns - RemoteWriteIOTime: 0ns - WhereConjunctEvaluateTime: 0ns - probeCount: 0 EXCHANGE_SOURCE (plan_node_id=21): CommonMetrics: - ConjunctsInputRows: 435.942K (435942) - __MAX_OF_ConjunctsInputRows: 8.931K (8931) - __MIN_OF_ConjunctsInputRows: 8.555K (8555) - ConjunctsOutputRows: 435.942K (435942) - __MAX_OF_ConjunctsOutputRows: 8.931K (8931) - __MIN_OF_ConjunctsOutputRows: 8.555K (8555) - ConjunctsTime: 17.272us - __MAX_OF_ConjunctsTime: 85.880us - __MIN_OF_ConjunctsTime: 4.979us - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 838.971us - __MAX_OF_OperatorTotalTime: 3.930ms - __MIN_OF_OperatorTotalTime: 288.646us - OutputChunkBytes: 40.894M (40893988) - __MAX_OF_OutputChunkBytes: 837.748K (837748) - __MIN_OF_OutputChunkBytes: 802.475K (802475) - PullChunkNum: 2.500K (2500) - __MAX_OF_PullChunkNum: 50 - __MIN_OF_PullChunkNum: 50 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 8.931K (8931) - __MIN_OF_PullRowNum: 8.555K (8555) - PullTotalTime: 822.914us - __MAX_OF_PullTotalTime: 3.866ms - __MIN_OF_PullTotalTime: 285.551us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 135 - __MAX_OF_BufferUnplugCount: 3 - __MIN_OF_BufferUnplugCount: 2 - BytesPassThrough: 7.842 MB - __MAX_OF_BytesPassThrough: 1.591 MB - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 30.854 MB - __MAX_OF_BytesReceived: 798.510 KB - __MIN_OF_BytesReceived: 457.724 KB - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 0ns - DeserializeChunkTime: 528.187us - __MAX_OF_DeserializeChunkTime: 3.520ms - __MIN_OF_DeserializeChunkTime: 155.712us - PeakBufferMemoryBytes: 16.857 MB - __MAX_OF_PeakBufferMemoryBytes: 1.745 MB - __MIN_OF_PeakBufferMemoryBytes: 51.896 KB - ReceiverProcessTotalTime: 1.792ms - __MAX_OF_ReceiverProcessTotalTime: 67.548ms - __MIN_OF_ReceiverProcessTotalTime: 206.582us - RequestReceived: 205 - __MAX_OF_RequestReceived: 5 - __MIN_OF_RequestReceived: 4 - WaitLockTime: 14ns - __MAX_OF_WaitLockTime: 211ns - __MIN_OF_WaitLockTime: 0ns Fragment 3: - BackendAddresses: fe02.starrocks.local:9060,cn01.starrocks.local:9060,cnrs01.starrocks.local:9060,cn02.starrocks.local:9060,fe03.starrocks.local:9060 - InstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec5904,c11c5c36-bba3-11f0-bda4-2ad541ec5903,c11c5c36-bba3-11f0-bda4-2ad541ec5902,c11c5c36-bba3-11f0-bda4-2ad541ec5901,c11c5c36-bba3-11f0-bda4-2ad541ec5905 - MissingInstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec5904,c11c5c36-bba3-11f0-bda4-2ad541ec5903,c11c5c36-bba3-11f0-bda4-2ad541ec5902,c11c5c36-bba3-11f0-bda4-2ad541ec5901,c11c5c36-bba3-11f0-bda4-2ad541ec5905 - BackendNum: 5 - InstanceNum: 5 Fragment 4: - BackendAddresses: fe02.starrocks.local:9060,cn01.starrocks.local:9060,cnrs01.starrocks.local:9060,cn02.starrocks.local:9060,fe03.starrocks.local:9060 - InstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec590a,c11c5c36-bba3-11f0-bda4-2ad541ec5909,c11c5c36-bba3-11f0-bda4-2ad541ec5908,c11c5c36-bba3-11f0-bda4-2ad541ec5907,c11c5c36-bba3-11f0-bda4-2ad541ec5906 - BackendNum: 5 - BackendProfileMergeTime: 2.624ms - __MAX_OF_BackendProfileMergeTime: 3.637ms - __MIN_OF_BackendProfileMergeTime: 1.850ms - InitialProcessDriverCount: 9.416K (9416) - __MAX_OF_InitialProcessDriverCount: 1.914K (1914) - __MIN_OF_InitialProcessDriverCount: 1.873K (1873) - InitialProcessMem: 153.137 GB - __MAX_OF_InitialProcessMem: 42.954 GB - __MIN_OF_InitialProcessMem: 26.285 GB - InstanceAllocatedMemoryUsage: 818.191 MB - __MAX_OF_InstanceAllocatedMemoryUsage: 164.997 MB - __MIN_OF_InstanceAllocatedMemoryUsage: 162.822 MB - InstanceDeallocatedMemoryUsage: 697.412 MB - __MAX_OF_InstanceDeallocatedMemoryUsage: 140.994 MB - __MIN_OF_InstanceDeallocatedMemoryUsage: 138.251 MB - InstanceNum: 5 - InstancePeakMemoryUsage: 46.814 MB - __MAX_OF_InstancePeakMemoryUsage: 50.156 MB - __MIN_OF_InstancePeakMemoryUsage: 40.250 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 7.117us - __MAX_OF_ActiveTime: 26.080us - __MIN_OF_ActiveTime: 2.654us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 13m42s - __MAX_OF_DriverTotalTime: 13m42s - __MIN_OF_DriverTotalTime: 13m42s - PeakDriverQueueSize: 3.970K (3970) - __MAX_OF_PeakDriverQueueSize: 104 - __MIN_OF_PeakDriverQueueSize: 64 - PendingTime: 13m42s - __MAX_OF_PendingTime: 13m42s - __MIN_OF_PendingTime: 13m41s - InputEmptyTime: 13m42s - __MAX_OF_InputEmptyTime: 13m42s - __MIN_OF_InputEmptyTime: 13m42s - FirstInputEmptyTime: 13m42s - __MAX_OF_FirstInputEmptyTime: 13m42s - __MIN_OF_FirstInputEmptyTime: 13m42s - ScheduleCount: 50 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 382.239ms - __MAX_OF_ScheduleTime: 738.376ms - __MIN_OF_ScheduleTime: 75.171ms - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=20): CommonMetrics: - IsSubordinate - OperatorTotalTime: 819ns - __MAX_OF_OperatorTotalTime: 2.480us - __MIN_OF_OperatorTotalTime: 191ns - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: SPILL_PROCESS (plan_node_id=20): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.185us - __MAX_OF_OperatorTotalTime: 11.960us - __MIN_OF_OperatorTotalTime: 220ns - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 2.874ms - __MAX_OF_ActiveTime: 13.070ms - __MIN_OF_ActiveTime: 1.406ms - BlockByInputEmpty: 152 - __MAX_OF_BlockByInputEmpty: 4 - __MIN_OF_BlockByInputEmpty: 2 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 13m42s - __MAX_OF_DriverTotalTime: 13m42s - __MIN_OF_DriverTotalTime: 13m42s - OverheadTime: 1.624ms - __MAX_OF_OverheadTime: 2.665ms - __MIN_OF_OverheadTime: 892.564us - PeakDriverQueueSize: 4.505K (4505) - __MAX_OF_PeakDriverQueueSize: 111 - __MIN_OF_PeakDriverQueueSize: 63 - PendingTime: 13m42s - __MAX_OF_PendingTime: 13m42s - __MIN_OF_PendingTime: 13m41s - InputEmptyTime: 13m42s - __MAX_OF_InputEmptyTime: 13m42s - __MIN_OF_InputEmptyTime: 13m42s - FirstInputEmptyTime: 12m7s - __MAX_OF_FirstInputEmptyTime: 12m7s - __MIN_OF_FirstInputEmptyTime: 12m7s - FollowupInputEmptyTime: 1m35s - __MAX_OF_FollowupInputEmptyTime: 1m35s - __MIN_OF_FollowupInputEmptyTime: 1m35s - ScheduleCount: 202 - __MAX_OF_ScheduleCount: 5 - __MIN_OF_ScheduleCount: 3 - ScheduleTime: 378.551ms - __MAX_OF_ScheduleTime: 1s19ms - __MIN_OF_ScheduleTime: 72.593ms - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 SPILLABLE_AGGREGATE_DISTINCT_BLOCKING_SINK (plan_node_id=20): CommonMetrics: - OperatorTotalTime: 1.976ms - __MAX_OF_OperatorTotalTime: 10.562ms - __MIN_OF_OperatorTotalTime: 1.031ms - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 2.500K (2500) - __MAX_OF_PushChunkNum: 50 - __MIN_OF_PushChunkNum: 50 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 8.914K (8914) - __MIN_OF_PushRowNum: 8.458K (8458) - PushTotalTime: 1.958ms - __MAX_OF_PushTotalTime: 10.540ms - __MIN_OF_PushTotalTime: 1.019ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - GroupingKeys: 12: tx, 14: succeeded - AggComputeTime: 1.933ms - __MAX_OF_AggComputeTime: 10.498ms - __MIN_OF_AggComputeTime: 1.011ms - AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 30.523us - __MAX_OF_ExprComputeTime: 250.041us - __MIN_OF_ExprComputeTime: 13.270us - ExprReleaseTime: 92.194us - __MAX_OF_ExprReleaseTime: 1.998ms - __MIN_OF_ExprReleaseTime: 29.038us - GetResultsTime: 3.015ms - __MAX_OF_GetResultsTime: 11.963ms - __MIN_OF_GetResultsTime: 980.682us - HashTableMemoryUsage: 69.336 MB - __MAX_OF_HashTableMemoryUsage: 1.387 MB - __MIN_OF_HashTableMemoryUsage: 1.387 MB - HashTableSize: 435.942K (435942) - __MAX_OF_HashTableSize: 8.914K (8914) - __MIN_OF_HashTableSize: 8.458K (8458) - InputRowCount: 435.942K (435942) - __MAX_OF_InputRowCount: 8.914K (8914) - __MIN_OF_InputRowCount: 8.458K (8458) - PassThroughRowCount: 0 - PeakRevocableMemoryBytes: 69.336 MB - __MAX_OF_PeakRevocableMemoryBytes: 1.387 MB - __MIN_OF_PeakRevocableMemoryBytes: 1.387 MB - ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 2.882ms - __MAX_OF_ResultGroupByAppendTime: 11.755ms - __MIN_OF_ResultGroupByAppendTime: 918.537us - ResultIteratorTime: 0ns - RowsReturned: 0 - SpillStatistics: - AppendDataTime: 0ns - BlockCount: - LocalBlockCount: 0 - RemoteBlockCount: 0 - BytesFlush: 0.000 B - BytesFlushToLocalDisk: 0.000 B - BytesFlushToRemoteStorage: 0.000 B - BytesRestore: 0.000 B - BytesRestoreFromLocalDisk: 0.000 B - BytesRestoreFromRemoteStorage: 0.000 B - BytesRestoreFromMemTable: 0 - CompactBlockCount: 0 - CompactCount: 0 - DeserializeTime: 0ns - FlushIOTaskCount: 0 - FlushIOTaskYieldCount: 0 - FlushTime: 0ns - InputStreamPeakMemoryBytes: 0.000 B - MaterializeChunkTime: 0ns - MemTableFinalizeTime: 0ns - MemTablePeakMemoryBytes: 0.000 B - PartitionWriterPeakMemoryBytes: 0.000 B - PeakFlushIOTaskCount: 0 - PeakRestoreIOTaskCount: 0 - ReadIOCount: 0 - LocalReadIOCount: 0 - RemoteReadIOCount: 0 - ReadIOTime: 0ns - LocalReadIOTime: 0ns - RemoteReadIOTime: 0ns - RestoreIOTaskCount: 0 - RestoreIOTaskYieldCount: 0 - RestoreTime: 0ns - RowsRestoreFromMemTable: 0 - RowsRestored: 0 - RowsSpilled: 0 - SerializeTime: 0ns - ShuffleTime: 0ns - SkewMemTableCount: 0 - SkewMemTableInputBytes: 0.000 B - SkewMemTableInputRows: 0 - SkewMemTableMergeTime: 0ns - SkewMemTableOutputBytes: 0.000 B - SkewMemTableOutputRows: 0 - SkewMemTableSkewRatio: 1844674407370955260.000 - __MAX_OF_SkewMemTableSkewRatio: 9223372036854776000.000 - __MIN_OF_SkewMemTableSkewRatio: 9223372036854776000.000 - SortChunkTime: 0ns - SplitPartitionTime: 0ns - WriteIOTime: 0ns - LocalWriteIOTime: 0ns - RemoteWriteIOTime: 0ns - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns EXCHANGE_SOURCE (plan_node_id=19): CommonMetrics: - ConjunctsInputRows: 435.942K (435942) - __MAX_OF_ConjunctsInputRows: 8.914K (8914) - __MIN_OF_ConjunctsInputRows: 8.458K (8458) - ConjunctsOutputRows: 435.942K (435942) - __MAX_OF_ConjunctsOutputRows: 8.914K (8914) - __MIN_OF_ConjunctsOutputRows: 8.458K (8458) - ConjunctsTime: 19.391us - __MAX_OF_ConjunctsTime: 67.360us - __MIN_OF_ConjunctsTime: 6.665us - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 689.293us - __MAX_OF_OperatorTotalTime: 3.369ms - __MIN_OF_OperatorTotalTime: 298.934us - OutputChunkBytes: 40.894M (40893988) - __MAX_OF_OutputChunkBytes: 836.146K (836146) - __MIN_OF_OutputChunkBytes: 793.376K (793376) - PullChunkNum: 2.500K (2500) - __MAX_OF_PullChunkNum: 50 - __MIN_OF_PullChunkNum: 50 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 8.914K (8914) - __MIN_OF_PullRowNum: 8.458K (8458) - PullTotalTime: 671.525us - __MAX_OF_PullTotalTime: 3.333ms - __MIN_OF_PullTotalTime: 293.145us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 110 - __MAX_OF_BufferUnplugCount: 3 - __MIN_OF_BufferUnplugCount: 2 - BytesPassThrough: 7.789 MB - __MAX_OF_BytesPassThrough: 1.930 MB - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 30.876 MB - __MAX_OF_BytesReceived: 880.058 KB - __MIN_OF_BytesReceived: 402.480 KB - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 0ns - DeserializeChunkTime: 440.050us - __MAX_OF_DeserializeChunkTime: 2.916ms - __MIN_OF_DeserializeChunkTime: 158.126us - PeakBufferMemoryBytes: 19.395 MB - __MAX_OF_PeakBufferMemoryBytes: 1.946 MB - __MIN_OF_PeakBufferMemoryBytes: 42.578 KB - ReceiverProcessTotalTime: 444.740us - __MAX_OF_ReceiverProcessTotalTime: 771.882us - __MIN_OF_ReceiverProcessTotalTime: 247.202us - RequestReceived: 210 - __MAX_OF_RequestReceived: 5 - __MIN_OF_RequestReceived: 4 - WaitLockTime: 8ns - __MAX_OF_WaitLockTime: 150ns - __MIN_OF_WaitLockTime: 0ns Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 11.255ms - __MAX_OF_ActiveTime: 93.350ms - __MIN_OF_ActiveTime: 3.147ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 13m42s - __MAX_OF_DriverTotalTime: 13m42s - __MIN_OF_DriverTotalTime: 13m42s - PeakDriverQueueSize: 4.044K (4044) - __MAX_OF_PeakDriverQueueSize: 110 - __MIN_OF_PeakDriverQueueSize: 69 - PendingTime: 13m42s - __MAX_OF_PendingTime: 13m42s - __MIN_OF_PendingTime: 13m42s - InputEmptyTime: 13m42s - __MAX_OF_InputEmptyTime: 13m42s - __MIN_OF_InputEmptyTime: 13m42s - FirstInputEmptyTime: 13m42s - __MAX_OF_FirstInputEmptyTime: 13m42s - __MIN_OF_FirstInputEmptyTime: 13m42s - PendingFinishTime: 129.467ms - __MAX_OF_PendingFinishTime: 161.646ms - __MIN_OF_PendingFinishTime: 35.713ms - ScheduleCount: 50 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 380.126ms - __MAX_OF_ScheduleTime: 719.066ms - __MIN_OF_ScheduleTime: 71.805ms - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=21): CommonMetrics: - OperatorTotalTime: 8.140ms - __MAX_OF_OperatorTotalTime: 90.959ms - __MIN_OF_OperatorTotalTime: 1.908ms - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 150 - __MAX_OF_PushChunkNum: 3 - __MIN_OF_PushChunkNum: 3 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 8.914K (8914) - __MIN_OF_PushRowNum: 8.458K (8458) - PushTotalTime: 5.454ms - __MAX_OF_PushTotalTime: 77.539ms - __MIN_OF_PushTotalTime: 1.141ms - SetFinishingTime: 3.159ms - __MAX_OF_SetFinishingTime: 38.092ms - __MIN_OF_SetFinishingTime: 649.655us UniqueMetrics: - ChannelNum: 5 - DestFragments: c11c5c36bba311f0-bda42ad541ec58fc, c11c5c36bba311f0-bda42ad541ec58fd, c11c5c36bba311f0-bda42ad541ec58fe, c11c5c36bba311f0-bda42ad541ec58ff, c11c5c36bba311f0-bda42ad541ec5900 - DestID: 21 - PartType: HASH_PARTITIONED - PipelineLevelShuffle: Yes - ShuffleNumPerChannel: 10 - TotalShuffleNum: 50 - BytesPassThrough: 7.842 MB - __MAX_OF_BytesPassThrough: 169.296 KB - __MIN_OF_BytesPassThrough: 150.309 KB - BytesSent: 30.854 MB - __MAX_OF_BytesSent: 6.185 MB - __MIN_OF_BytesSent: 6.159 MB - BytesUnsent: 0.000 B - CompressTime: 250.524us - __MAX_OF_CompressTime: 2.402ms - __MIN_OF_CompressTime: 78.993us - CompressedBytes: 15.472 MB - __MAX_OF_CompressedBytes: 624.364 KB - __MIN_OF_CompressedBytes: 73.378 KB - NetworkBandwidth: 243.445 MB/sec - __MAX_OF_NetworkBandwidth: 74.855 MB/sec - __MIN_OF_NetworkBandwidth: 21.717 MB/sec - NetworkTime: 152.903ms - __MAX_OF_NetworkTime: 283.639ms - __MIN_OF_NetworkTime: 82.629ms - OverallThroughput: 205.213 MB/sec - __MAX_OF_OverallThroughput: 43.482 MB/sec - __MIN_OF_OverallThroughput: 38.016 MB/sec - OverallTime: 150.626ms - __MAX_OF_OverallTime: 162.013ms - __MIN_OF_OverallTime: 142.249ms - PassThroughBufferPeakMemoryUsage: 5.234 MB - __MAX_OF_PassThroughBufferPeakMemoryUsage: 1.761 MB - __MIN_OF_PassThroughBufferPeakMemoryUsage: 539.531 KB - RawInputBytes: 31.171 MB - __MAX_OF_RawInputBytes: 653.087 KB - __MIN_OF_RawInputBytes: 624.746 KB - RequestSent: 200 - __MAX_OF_RequestSent: 40 - __MIN_OF_RequestSent: 40 - RequestUnsent: 0 - RpcAvgTime: 11.563ms - __MAX_OF_RpcAvgTime: 20.703ms - __MIN_OF_RpcAvgTime: 5.375ms - RpcCount: 205 - __MAX_OF_RpcCount: 41 - __MIN_OF_RpcCount: 41 - SerializeChunkTime: 669.358us - __MAX_OF_SerializeChunkTime: 7.027ms - __MIN_OF_SerializeChunkTime: 92.273us - SerializedBytes: 30.854 MB - __MAX_OF_SerializedBytes: 646.375 KB - __MIN_OF_SerializedBytes: 618.593 KB - ShuffleChunkAppendCounter: 7.500K (7500) - __MAX_OF_ShuffleChunkAppendCounter: 150 - __MIN_OF_ShuffleChunkAppendCounter: 150 - ShuffleChunkAppendTime: 4.174ms - __MAX_OF_ShuffleChunkAppendTime: 76.182ms - __MIN_OF_ShuffleChunkAppendTime: 363.498us - ShuffleHashTime: 893.049us - __MAX_OF_ShuffleHashTime: 1.998ms - __MIN_OF_ShuffleHashTime: 593.532us - WaitTime: 116.049ms - __MAX_OF_WaitTime: 156.681ms - __MIN_OF_WaitTime: 38.895ms SPILLABLE_AGGREGATE_DISTINCT_BLOCKING_SOURCE (plan_node_id=20): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 3.109ms - __MAX_OF_OperatorTotalTime: 12.118ms - __MIN_OF_OperatorTotalTime: 1.045ms - OutputChunkBytes: 40.894M (40893988) - __MAX_OF_OutputChunkBytes: 836.146K (836146) - __MIN_OF_OutputChunkBytes: 793.376K (793376) - PullChunkNum: 150 - __MAX_OF_PullChunkNum: 3 - __MIN_OF_PullChunkNum: 3 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 8.914K (8914) - __MIN_OF_PullRowNum: 8.458K (8458) - PullTotalTime: 3.057ms - __MAX_OF_PullTotalTime: 12.081ms - __MIN_OF_PullTotalTime: 995.304us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - GroupingKeys: 12: tx, 14: succeeded - AggComputeTime: 0ns - AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 0ns - ExprReleaseTime: 0ns - GetResultsTime: 0ns - HashTableSize: 0 - InputRowCount: 0 - PassThroughRowCount: 0 - ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 0ns - ResultIteratorTime: 0ns - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns Fragment 5: - BackendAddresses: fe02.starrocks.local:9060,cn01.starrocks.local:9060,cnrs01.starrocks.local:9060,cn02.starrocks.local:9060,fe03.starrocks.local:9060 - InstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec590d,c11c5c36-bba3-11f0-bda4-2ad541ec590c,c11c5c36-bba3-11f0-bda4-2ad541ec590b,c11c5c36-bba3-11f0-bda4-2ad541ec590f,c11c5c36-bba3-11f0-bda4-2ad541ec590e - EnableEventScheduler: true - BackendNum: 5 - BackendProfileMergeTime: 6.277ms - __MAX_OF_BackendProfileMergeTime: 14.601ms - __MIN_OF_BackendProfileMergeTime: 3.175ms - FragmentInstancePrepareTime: 109.475ms - __MAX_OF_FragmentInstancePrepareTime: 164.888ms - __MIN_OF_FragmentInstancePrepareTime: 59.278ms - prepare-runtime-state: 104.609ms - __MAX_OF_prepare-runtime-state: 158.982ms - __MIN_OF_prepare-runtime-state: 56.152ms - InitialProcessDriverCount: 9.566K (9566) - __MAX_OF_InitialProcessDriverCount: 1.944K (1944) - __MIN_OF_InitialProcessDriverCount: 1.903K (1903) - InitialProcessMem: 153.631 GB - __MAX_OF_InitialProcessMem: 43.067 GB - __MIN_OF_InitialProcessMem: 26.385 GB - InstanceAllocatedMemoryUsage: 783.453 GB - __MAX_OF_InstanceAllocatedMemoryUsage: 222.517 GB - __MIN_OF_InstanceAllocatedMemoryUsage: 103.371 GB - InstanceDeallocatedMemoryUsage: 782.862 GB - __MAX_OF_InstanceDeallocatedMemoryUsage: 222.378 GB - __MIN_OF_InstanceDeallocatedMemoryUsage: 103.272 GB - InstanceNum: 5 - InstancePeakMemoryUsage: 420.233 MB - __MAX_OF_InstancePeakMemoryUsage: 442.802 MB - __MIN_OF_InstancePeakMemoryUsage: 390.825 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 50.487us - __MAX_OF_ActiveTime: 1.072ms - __MIN_OF_ActiveTime: 2.814us - BlockByInputEmpty: 8 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 556.973ms - __MAX_OF_DriverTotalTime: 679.582ms - __MIN_OF_DriverTotalTime: 426.112ms - PeakDriverQueueSize: 239 - __MAX_OF_PeakDriverQueueSize: 13 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 553.357ms - __MAX_OF_InputEmptyTime: 663.125ms - __MIN_OF_InputEmptyTime: 425.717ms - FirstInputEmptyTime: 553.347ms - __MAX_OF_FirstInputEmptyTime: 663.125ms - __MIN_OF_FirstInputEmptyTime: 425.717ms - ScheduleCount: 58 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 556.923ms - __MAX_OF_ScheduleTime: 679.552ms - __MIN_OF_ScheduleTime: 425.991ms - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NESTLOOP_JOIN_BUILD (plan_node_id=16): CommonMetrics: - OperatorTotalTime: 25.214us - __MAX_OF_OperatorTotalTime: 71.960us - __MIN_OF_OperatorTotalTime: 5.498us - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 5 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 5 - __MAX_OF_PushRowNum: 1 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 1.400us - __MAX_OF_PushTotalTime: 16.144us - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - NumBuilders: 10 - BuildChunks: 12 - __MAX_OF_BuildChunks: 1 - __MIN_OF_BuildChunks: 0 - BuildRows: 16 - __MAX_OF_BuildRows: 1 - __MIN_OF_BuildRows: 0 EXCHANGE_SOURCE (plan_node_id=15): CommonMetrics: - ConjunctsInputRows: 5 - __MAX_OF_ConjunctsInputRows: 1 - __MIN_OF_ConjunctsInputRows: 1 - ConjunctsOutputRows: 5 - __MAX_OF_ConjunctsOutputRows: 1 - __MIN_OF_ConjunctsOutputRows: 1 - ConjunctsTime: 1.505us - __MAX_OF_ConjunctsTime: 1.813us - __MIN_OF_ConjunctsTime: 1.192us - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 38.330us - __MAX_OF_OperatorTotalTime: 1.064ms - __MIN_OF_OperatorTotalTime: 3.565us - OutputChunkBytes: 45 - __MAX_OF_OutputChunkBytes: 9 - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 5 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 5 - __MAX_OF_PullRowNum: 1 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 5.923us - __MAX_OF_PullTotalTime: 83.041us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 25.000 B - __MAX_OF_BytesPassThrough: 25.000 B - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 120.000 B - __MAX_OF_BytesReceived: 30.000 B - __MIN_OF_BytesReceived: 0.000 B - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 304ns - __MAX_OF_DecompressChunkTime: 4.240us - __MIN_OF_DecompressChunkTime: 0ns - DeserializeChunkTime: 1.941us - __MAX_OF_DeserializeChunkTime: 31.680us - __MIN_OF_DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 145.000 B - __MAX_OF_PeakBufferMemoryBytes: 30.000 B - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 3.146us - __MAX_OF_ReceiverProcessTotalTime: 41.720us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 6 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 3ns - __MAX_OF_WaitLockTime: 40ns - __MIN_OF_WaitLockTime: 0ns Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 570.049us - __MAX_OF_ActiveTime: 16.712ms - __MIN_OF_ActiveTime: 2.904us - BlockByInputEmpty: 1 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 562.588ms - __MAX_OF_DriverTotalTime: 680.026ms - __MIN_OF_DriverTotalTime: 433.307ms - PeakDriverQueueSize: 320 - __MAX_OF_PeakDriverQueueSize: 24 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 560.556ms - __MAX_OF_InputEmptyTime: 673.375ms - __MIN_OF_InputEmptyTime: 432.934ms - FirstInputEmptyTime: 560.556ms - __MAX_OF_FirstInputEmptyTime: 673.375ms - __MIN_OF_FirstInputEmptyTime: 432.934ms - ScheduleCount: 51 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 562.018ms - __MAX_OF_ScheduleTime: 679.930ms - __MIN_OF_ScheduleTime: 433.149ms - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NESTLOOP_JOIN_BUILD (plan_node_id=8): CommonMetrics: - OperatorTotalTime: 565.205us - __MAX_OF_OperatorTotalTime: 16.713ms - __MIN_OF_OperatorTotalTime: 4.276us - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 5 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 5 - __MAX_OF_PushRowNum: 1 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 1.227us - __MAX_OF_PushTotalTime: 16.960us - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 - SetFinishingTime: 1.350ms - __MAX_OF_SetFinishingTime: 16.682ms - __MIN_OF_SetFinishingTime: 3.235us UniqueMetrics: - NumBuilders: 10 - BuildChunks: 14 - __MAX_OF_BuildChunks: 1 - __MIN_OF_BuildChunks: 0 - BuildRows: 16 - __MAX_OF_BuildRows: 1 - __MIN_OF_BuildRows: 0 EXCHANGE_SOURCE (plan_node_id=7): CommonMetrics: - ConjunctsInputRows: 5 - __MAX_OF_ConjunctsInputRows: 1 - __MIN_OF_ConjunctsInputRows: 1 - ConjunctsOutputRows: 5 - __MAX_OF_ConjunctsOutputRows: 1 - __MIN_OF_ConjunctsOutputRows: 1 - ConjunctsTime: 1.212us - __MAX_OF_ConjunctsTime: 2.240us - __MIN_OF_ConjunctsTime: 110ns - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 17.657us - __MAX_OF_OperatorTotalTime: 103.520us - __MIN_OF_OperatorTotalTime: 3.377us - OutputChunkBytes: 45 - __MAX_OF_OutputChunkBytes: 9 - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 5 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 5 - __MAX_OF_PullRowNum: 1 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 6.140us - __MAX_OF_PullTotalTime: 85.280us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 25.000 B - __MAX_OF_BytesPassThrough: 25.000 B - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 120.000 B - __MAX_OF_BytesReceived: 30.000 B - __MIN_OF_BytesReceived: 0.000 B - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 311ns - __MAX_OF_DecompressChunkTime: 4.800us - __MIN_OF_DecompressChunkTime: 0ns - DeserializeChunkTime: 2.025us - __MAX_OF_DeserializeChunkTime: 38.200us - __MIN_OF_DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 145.000 B - __MAX_OF_PeakBufferMemoryBytes: 30.000 B - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 3.285us - __MAX_OF_ReceiverProcessTotalTime: 59.440us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 6 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 3ns - __MAX_OF_WaitLockTime: 59ns - __MIN_OF_WaitLockTime: 0ns Pipeline (id=2): - LocalRfWaitingSet: 2 - IsGroupExecution: false - ActiveTime: 2m25s - __MAX_OF_ActiveTime: 2m59s - __MIN_OF_ActiveTime: 1m58s - BlockByInputEmpty: 67.371K (67371) - __MAX_OF_BlockByInputEmpty: 1.478K (1478) - __MIN_OF_BlockByInputEmpty: 1.259K (1259) - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 12m38s - __MAX_OF_DriverTotalTime: 13m41s - __MIN_OF_DriverTotalTime: 11m29s - OverheadTime: 2m6s - __MAX_OF_OverheadTime: 2m43s - __MIN_OF_OverheadTime: 1m38s - PeakDriverQueueSize: 4.075K (4075) - __MAX_OF_PeakDriverQueueSize: 174 - __MIN_OF_PeakDriverQueueSize: 34 - PendingTime: 0ns - InputEmptyTime: 10m - __MAX_OF_InputEmptyTime: 11m18s - __MIN_OF_InputEmptyTime: 8m20s - FirstInputEmptyTime: 266.108ms - __MAX_OF_FirstInputEmptyTime: 1s123ms - __MIN_OF_FirstInputEmptyTime: 12.208ms - FollowupInputEmptyTime: 9m59s - __MAX_OF_FollowupInputEmptyTime: 11m18s - __MIN_OF_FollowupInputEmptyTime: 8m20s - PreconditionBlockTime: 562.742ms - __MAX_OF_PreconditionBlockTime: 680.008ms - __MIN_OF_PreconditionBlockTime: 433.527ms - ScheduleCount: 104.319K (104319) - __MAX_OF_ScheduleCount: 2.298K (2298) - __MIN_OF_ScheduleCount: 1.948K (1948) - ScheduleTime: 10m13s - __MAX_OF_ScheduleTime: 11m41s - __MIN_OF_ScheduleTime: 8m29s - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 104.269K (104269) - __MAX_OF_YieldByTimeLimit: 2.297K (2297) - __MIN_OF_YieldByTimeLimit: 1.947K (1947) LOCAL_EXCHANGE_SINK (plan_node_id=18): CommonMetrics: - IsSubordinate - OperatorTotalTime: 212.104us - __MAX_OF_OperatorTotalTime: 6.697ms - __MIN_OF_OperatorTotalTime: 271ns - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 136 - __MAX_OF_PushChunkNum: 34 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 108.895K (108895) - __MIN_OF_PushRowNum: 0 - PushTotalTime: 135.230us - __MAX_OF_PushTotalTime: 3.052ms - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 10 - Type: Passthrough - LocalExchangePeakMemoryUsage: 0.000 B PROJECT (plan_node_id=17): CommonMetrics: - OperatorTotalTime: 14.563us - __MAX_OF_OperatorTotalTime: 209.520us - __MIN_OF_OperatorTotalTime: 1.513us - OutputChunkBytes: 40.894M (40893988) - __MAX_OF_OutputChunkBytes: 10.215M (10214992) - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 136 - __MAX_OF_PullChunkNum: 34 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 108.895K (108895) - __MIN_OF_PullRowNum: 0 - PullTotalTime: 281ns - __MAX_OF_PullTotalTime: 6.400us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 136 - __MAX_OF_PushChunkNum: 34 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 108.895K (108895) - __MIN_OF_PushRowNum: 0 - PushTotalTime: 10.897us - __MAX_OF_PushTotalTime: 199.360us - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 762ns - __MAX_OF_CommonSubExprComputeTime: 9.080us - __MIN_OF_CommonSubExprComputeTime: 0ns - ExprComputeTime: 5.021us - __MAX_OF_ExprComputeTime: 81.400us - __MIN_OF_ExprComputeTime: 0ns NESTLOOP_JOIN_PROBE (plan_node_id=16): CommonMetrics: - ConjunctsInputRows: 435.942K (435942) - __MAX_OF_ConjunctsInputRows: 108.895K (108895) - __MIN_OF_ConjunctsInputRows: 54.271K (54271) - ConjunctsOutputRows: 435.942K (435942) - __MAX_OF_ConjunctsOutputRows: 108.895K (108895) - __MIN_OF_ConjunctsOutputRows: 54.271K (54271) - ConjunctsTime: 151.844us - __MAX_OF_ConjunctsTime: 393.520us - __MIN_OF_ConjunctsTime: 51.201us - OperatorTotalTime: 8s875ms - __MAX_OF_OperatorTotalTime: 10s235ms - __MIN_OF_OperatorTotalTime: 7s684ms - OutputChunkBytes: 48.305M (48305002) - __MAX_OF_OutputChunkBytes: 12.066M (12066207) - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 136 - __MAX_OF_PullChunkNum: 34 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 108.895K (108895) - __MIN_OF_PullRowNum: 0 - PullTotalTime: 8s875ms - __MAX_OF_PullTotalTime: 10s235ms - __MIN_OF_PullTotalTime: 7s684ms - PushChunkNum: 136 - __MAX_OF_PushChunkNum: 34 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 108.895K (108895) - __MIN_OF_PushRowNum: 0 - PushTotalTime: 5.567us - __MAX_OF_PushTotalTime: 93.160us - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - JoinConjuncts: 13: timestamp <= 39: max - JoinType: INNER_JOIN - PermuteRows: 0 PROJECT (plan_node_id=9): CommonMetrics: - OperatorTotalTime: 23.753us - __MAX_OF_OperatorTotalTime: 355.080us - __MIN_OF_OperatorTotalTime: 1.993us - OutputChunkBytes: 44.382M (44381524) - __MAX_OF_OutputChunkBytes: 11.086M (11086152) - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 136 - __MAX_OF_PullChunkNum: 34 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 108.895K (108895) - __MIN_OF_PullRowNum: 0 - PullTotalTime: 1.154us - __MAX_OF_PullTotalTime: 20.200us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 136 - __MAX_OF_PushChunkNum: 34 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 108.895K (108895) - __MIN_OF_PushRowNum: 0 - PushTotalTime: 18.979us - __MAX_OF_PushTotalTime: 329.120us - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 956ns - __MAX_OF_CommonSubExprComputeTime: 16.400us - __MIN_OF_CommonSubExprComputeTime: 0ns - ExprComputeTime: 9.262us - __MAX_OF_ExprComputeTime: 141.720us - __MIN_OF_ExprComputeTime: 0ns NESTLOOP_JOIN_PROBE (plan_node_id=8): CommonMetrics: - ConjunctsInputRows: 435.942K (435942) - __MAX_OF_ConjunctsInputRows: 108.895K (108895) - __MIN_OF_ConjunctsInputRows: 54.271K (54271) - ConjunctsOutputRows: 435.942K (435942) - __MAX_OF_ConjunctsOutputRows: 108.895K (108895) - __MIN_OF_ConjunctsOutputRows: 54.271K (54271) - ConjunctsTime: 81.159ms - __MAX_OF_ConjunctsTime: 405.043ms - __MIN_OF_ConjunctsTime: 143.007us - OperatorTotalTime: 9s843ms - __MAX_OF_OperatorTotalTime: 12s513ms - __MIN_OF_OperatorTotalTime: 7s727ms - OutputChunkBytes: 48.305M (48305002) - __MAX_OF_OutputChunkBytes: 12.066M (12066207) - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 136 - __MAX_OF_PullChunkNum: 34 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 108.895K (108895) - __MIN_OF_PullRowNum: 0 - PullTotalTime: 9s843ms - __MAX_OF_PullTotalTime: 12s513ms - __MIN_OF_PullTotalTime: 7s727ms - PushChunkNum: 136 - __MAX_OF_PushChunkNum: 34 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 108.895K (108895) - __MIN_OF_PushRowNum: 0 - PushTotalTime: 9.828us - __MAX_OF_PushTotalTime: 173.760us - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - JoinConjuncts: 13: timestamp >= 26: min - JoinType: INNER_JOIN - PermuteRows: 0 CHUNK_ACCUMULATE (plan_node_id=1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 3.832ms - __MAX_OF_OperatorTotalTime: 45.029ms - __MIN_OF_OperatorTotalTime: 1.719ms - OutputChunkBytes: 44.382M (44381524) - __MAX_OF_OutputChunkBytes: 11.086M (11086152) - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 136 - __MAX_OF_PullChunkNum: 34 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 108.895K (108895) - __MIN_OF_PullRowNum: 0 - PullTotalTime: 1.034ms - __MAX_OF_PullTotalTime: 16.304ms - __MIN_OF_PullTotalTime: 472.461us - PushChunkNum: 136 - __MAX_OF_PushChunkNum: 34 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 108.895K (108895) - __MIN_OF_PushRowNum: 0 - PushTotalTime: 2.797ms - __MAX_OF_PushTotalTime: 43.377ms - __MIN_OF_PushTotalTime: 1.193ms UniqueMetrics: CONNECTOR_SCAN (plan_node_id=1): CommonMetrics: - RuntimeFilterDesc: <1: NULL> <3: NULL> <4: BloomFilter> - CloseTime: 1.737ms - __MAX_OF_CloseTime: 5.260ms - __MIN_OF_CloseTime: 1.007ms - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 435.942K (435942) - __MAX_OF_JoinRuntimeFilterInputRows: 108.895K (108895) - __MIN_OF_JoinRuntimeFilterInputRows: 54.271K (54271) - JoinRuntimeFilterOutputRows: 435.942K (435942) - __MAX_OF_JoinRuntimeFilterOutputRows: 108.895K (108895) - __MIN_OF_JoinRuntimeFilterOutputRows: 54.271K (54271) - JoinRuntimeFilterTime: 24.530us - __MAX_OF_JoinRuntimeFilterTime: 34.400us - __MIN_OF_JoinRuntimeFilterTime: 14.681us - OperatorTotalTime: 213.798ms - __MAX_OF_OperatorTotalTime: 376.933ms - __MIN_OF_OperatorTotalTime: 124.827ms - OutputChunkBytes: 44.382M (44381524) - __MAX_OF_OutputChunkBytes: 11.086M (11086152) - __MIN_OF_OutputChunkBytes: 0 - PullChunkNum: 136 - __MAX_OF_PullChunkNum: 34 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 108.895K (108895) - __MIN_OF_PullRowNum: 0 - PullTotalTime: 212.057ms - __MAX_OF_PullTotalTime: 374.879ms - __MIN_OF_PullTotalTime: 123.352ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 3 - RuntimeInFilterNum: 2 UniqueMetrics: - AdaptiveIOTasks: True - DataSourceType: LakeDataSource - MorselQueueType: dynamic_morsel_queue - Rollup: transaction_info - SharedScan: False - Table: transaction_info - ChunkBufferCapacity: 640 - DefaultChunkBufferCapacity: 640 - IOTaskExecTime: 2m53s - __MAX_OF_IOTaskExecTime: 5m4s - __MIN_OF_IOTaskExecTime: 1m30s - AccessPathHits: 0 - AccessPathUnhits: 0 - BytesRead: 50.727 MB - __MAX_OF_BytesRead: 6.363 MB - __MIN_OF_BytesRead: 0.000 B - CompressedBytesRead: 51.318 MB - __MAX_OF_CompressedBytesRead: 6.438 MB - __MIN_OF_CompressedBytesRead: 0.000 B - CreateSegmentIter: 2m51s - __MAX_OF_CreateSegmentIter: 5m3s - __MIN_OF_CreateSegmentIter: 1m30s - DictDecode: 27.099us - __MAX_OF_DictDecode: 33.080us - __MIN_OF_DictDecode: 20.763us - GetDelVec: 0ns - GetDeltaColumnGroup: 0ns - IOStatistics: - CompressedBytesReadLocalDisk: 0.000 B - CompressedBytesReadRemote: 51.318 MB - __MAX_OF_CompressedBytesReadRemote: 6.438 MB - __MIN_OF_CompressedBytesReadRemote: 0.000 B - CompressedBytesReadRequest: 48.025 MB - __MAX_OF_CompressedBytesReadRequest: 6.024 MB - __MIN_OF_CompressedBytesReadRequest: 0.000 B - CompressedBytesReadTotal: 51.318 MB - __MAX_OF_CompressedBytesReadTotal: 6.438 MB - __MIN_OF_CompressedBytesReadTotal: 0.000 B - IOCountLocalDisk: 0 - IOCountRemote: 424 - __MAX_OF_IOCountRemote: 53 - __MIN_OF_IOCountRemote: 0 - IOCountRequest: 1.396K (1396) - __MAX_OF_IOCountRequest: 176 - __MIN_OF_IOCountRequest: 0 - IOCountTotal: 424 - __MAX_OF_IOCountTotal: 53 - __MIN_OF_IOCountTotal: 0 - IOTimeLocalDisk: 0ns - IOTimeRemote: 209.231ms - __MAX_OF_IOTimeRemote: 22s562ms - __MIN_OF_IOTimeRemote: 0ns - IOTimeTotal: 209.290ms - __MAX_OF_IOTimeTotal: 22s569ms - __MIN_OF_IOTimeTotal: 0ns - PagesCountLocalDisk: 0 - PagesCountMemory: 0 - PagesCountRemote: 1.396K (1396) - __MAX_OF_PagesCountRemote: 176 - __MIN_OF_PagesCountRemote: 0 - PagesCountTotal: 1.396K (1396) - __MAX_OF_PagesCountTotal: 176 - __MIN_OF_PagesCountTotal: 0 - PrefetchHitCount: 0 - PrefetchPendingTime: 0ns - PrefetchWaitFinishTime: 0ns - IOTime: 209.290ms - __MAX_OF_IOTime: 22s569ms - __MIN_OF_IOTime: 0ns - LateMaterialize: 3s350ms - __MAX_OF_LateMaterialize: 3s722ms - __MIN_OF_LateMaterialize: 2s849ms - MemAllocFailed: 0 - PushdownAccessPaths: 0 - PushdownPredicates: 7 - RawRowsRead: 522.462K (522462) - __MAX_OF_RawRowsRead: 65.555K (65555) - __MIN_OF_RawRowsRead: 0 - ReadPKIndex: 0ns - RowsRead: 435.942K (435942) - __MAX_OF_RowsRead: 54.739K (54739) - __MIN_OF_RowsRead: 0 - SegmentInit: 114.741ms - __MAX_OF_SegmentInit: 13s385ms - __MIN_OF_SegmentInit: 0ns - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 1.230us - __MAX_OF_BitmapIndexIteratorInit: 158.400us - __MIN_OF_BitmapIndexIteratorInit: 0ns - BloomFilterFilter: 630ns - __MAX_OF_BloomFilterFilter: 79.361us - __MIN_OF_BloomFilterFilter: 0ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 69.674ms - __MAX_OF_ColumnIteratorInit: 8s226ms - __MIN_OF_ColumnIteratorInit: 0ns - RemainingRowsAfterShortKeyFilter: 522.520K (522520) - __MAX_OF_RemainingRowsAfterShortKeyFilter: 65.555K (65555) - __MIN_OF_RemainingRowsAfterShortKeyFilter: 0 - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 31.991B (31991373830) - __MAX_OF_SegmentZoneMapFilterRows: 46.046M (46045555) - __MIN_OF_SegmentZoneMapFilterRows: 35.260M (35259639) - ShortKeyFilter: 134ns - __MAX_OF_ShortKeyFilter: 16.960us - __MIN_OF_ShortKeyFilter: 0ns - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - ZoneMapIndexFilterRows: 58 - __MAX_OF_ZoneMapIndexFilterRows: 41 - __MIN_OF_ZoneMapIndexFilterRows: 0 - ZoneMapIndexFiter: 45.055ms - __MAX_OF_ZoneMapIndexFiter: 5s157ms - __MIN_OF_ZoneMapIndexFiter: 0ns - SegmentRead: 68.747ms - __MAX_OF_SegmentRead: 8s105ms - __MIN_OF_SegmentRead: 0ns - BlockFetch: 4.282ms - __MAX_OF_BlockFetch: 604.971ms - __MIN_OF_BlockFetch: 0ns - BlockFetchCount: 176 - __MAX_OF_BlockFetchCount: 22 - __MIN_OF_BlockFetchCount: 0 - BlockSeek: 64.453ms - __MAX_OF_BlockSeek: 7s573ms - __MIN_OF_BlockSeek: 0ns - BlockSeekCount: 820 - __MAX_OF_BlockSeekCount: 104 - __MIN_OF_BlockSeekCount: 0 - ChunkCopy: 5.682us - __MAX_OF_ChunkCopy: 1.155ms - __MIN_OF_ChunkCopy: 0ns - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 3.388us - __MAX_OF_PredFilter: 510.324us - __MIN_OF_PredFilter: 0ns - PredFilterRows: 86.520K (86520) - __MAX_OF_PredFilterRows: 10.900K (10900) - __MIN_OF_PredFilterRows: 0 - RowsetsReadCount: 1.135M (1134919) - __MAX_OF_RowsetsReadCount: 1.728K (1728) - __MIN_OF_RowsetsReadCount: 1.168K (1168) - SegmentsReadCount: 1.037M (1036754) - __MAX_OF_SegmentsReadCount: 1.590K (1590) - __MIN_OF_SegmentsReadCount: 1.060K (1060) - TotalColumnsDataPageCount: 969 - __MAX_OF_TotalColumnsDataPageCount: 122 - __MIN_OF_TotalColumnsDataPageCount: 0 - UncompressedBytesRead: 47.990 MB - __MAX_OF_UncompressedBytesRead: 6.019 MB - __MIN_OF_UncompressedBytesRead: 0.000 B - IOTaskWaitTime: 9m41s - __MAX_OF_IOTaskWaitTime: 12m3s - __MIN_OF_IOTaskWaitTime: 7m23s - MorselsCount: 144.608K (144608) - __MAX_OF_MorselsCount: 2.978K (2978) - __MIN_OF_MorselsCount: 2.776K (2776) - PeakChunkBufferMemoryUsage: 608.659 KB - PeakChunkBufferSize: 41 - PeakIOTasks: 16 - PeakScanTaskQueueSize: 40.070K (40070) - __MAX_OF_PeakScanTaskQueueSize: 818 - __MIN_OF_PeakScanTaskQueueSize: 769 - PrepareChunkSourceTime: 88.594ms - __MAX_OF_PrepareChunkSourceTime: 179.167ms - __MIN_OF_PrepareChunkSourceTime: 44.694ms - ScanTime: 12m34s - __MAX_OF_ScanTime: 13m37s - __MIN_OF_ScanTime: 11m23s - SubmitTaskCount: 144.672K (144672) - __MAX_OF_SubmitTaskCount: 2.978K (2978) - __MIN_OF_SubmitTaskCount: 2.776K (2776) - SubmitTaskTime: 34.572ms - __MAX_OF_SubmitTaskTime: 99.392ms - __MIN_OF_SubmitTaskTime: 8.988ms - TabletCount: 144.608K (144608) - __MAX_OF_TabletCount: 29.240K (29240) - __MIN_OF_TabletCount: 28.754K (28754) Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 1.354ms - __MAX_OF_ActiveTime: 9.421ms - __MIN_OF_ActiveTime: 347.521us - BlockByInputEmpty: 136 - __MAX_OF_BlockByInputEmpty: 4 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 12m38s - __MAX_OF_DriverTotalTime: 13m41s - __MIN_OF_DriverTotalTime: 11m29s - OverheadTime: 1.284ms - __MAX_OF_OverheadTime: 8.547ms - __MIN_OF_OverheadTime: 9.960us - PeakDriverQueueSize: 535 - __MAX_OF_PeakDriverQueueSize: 22 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 12m38s - __MAX_OF_InputEmptyTime: 13m41s - __MIN_OF_InputEmptyTime: 11m29s - FirstInputEmptyTime: 54s210ms - __MAX_OF_FirstInputEmptyTime: 1m6s - __MIN_OF_FirstInputEmptyTime: 41s77ms - FollowupInputEmptyTime: 11m44s - __MAX_OF_FollowupInputEmptyTime: 12m50s - __MIN_OF_FollowupInputEmptyTime: 10m39s - ScheduleCount: 186 - __MAX_OF_ScheduleCount: 5 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 12m38s - __MAX_OF_ScheduleTime: 13m41s - __MIN_OF_ScheduleTime: 11m29s - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_DISTINCT_STREAMING_SINK (plan_node_id=18): CommonMetrics: - OperatorTotalTime: 1.287ms - __MAX_OF_OperatorTotalTime: 9.354ms - __MIN_OF_OperatorTotalTime: 329.601us - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 136 - __MAX_OF_PushChunkNum: 4 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 15.388K (15388) - __MIN_OF_PushRowNum: 2.331K (2331) - PushTotalTime: 1.274ms - __MAX_OF_PushTotalTime: 9.338ms - __MIN_OF_PushTotalTime: 313.001us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - GroupingKeys: 12: tx, 14: succeeded - AggComputeTime: 951.606us - __MAX_OF_AggComputeTime: 3.493ms - __MIN_OF_AggComputeTime: 301.881us - AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 262.131 KB - __MAX_OF_ChunkBufferPeakMem: 353.591 KB - __MIN_OF_ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - __MAX_OF_ChunkBufferPeakSize: 1 - __MIN_OF_ChunkBufferPeakSize: 0 - ExprComputeTime: 13.383us - __MAX_OF_ExprComputeTime: 129.881us - __MIN_OF_ExprComputeTime: 3.425us - ExprReleaseTime: 41.787us - __MAX_OF_ExprReleaseTime: 1.401ms - __MIN_OF_ExprReleaseTime: 582ns - GetResultsTime: 1.285ms - __MAX_OF_GetResultsTime: 4.103ms - __MIN_OF_GetResultsTime: 375.764us - HashTableMemoryUsage: 35.301 MB - __MAX_OF_HashTableMemoryUsage: 1.191 MB - __MIN_OF_HashTableMemoryUsage: 352.000 KB - HashTableSize: 208.505K (208505) - __MAX_OF_HashTableSize: 7.038K (7038) - __MIN_OF_HashTableSize: 2.321K (2321) - InputRowCount: 435.942K (435942) - __MAX_OF_InputRowCount: 15.388K (15388) - __MIN_OF_InputRowCount: 2.331K (2331) - PassThroughRowCount: 227.437K (227437) - __MAX_OF_PassThroughRowCount: 11.292K (11292) - __MIN_OF_PassThroughRowCount: 0 - ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 1.209ms - __MAX_OF_ResultGroupByAppendTime: 3.992ms - __MIN_OF_ResultGroupByAppendTime: 345.547us - ResultIteratorTime: 0ns - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 244.998us - __MAX_OF_StreamingTime: 8.316ms - __MIN_OF_StreamingTime: 0ns LOCAL_EXCHANGE_SOURCE (plan_node_id=18): CommonMetrics: - IsSubordinate - OperatorTotalTime: 19.116us - __MAX_OF_OperatorTotalTime: 37.236us - __MIN_OF_OperatorTotalTime: 6.680us - OutputChunkBytes: 40.894M (40893988) - __MAX_OF_OutputChunkBytes: 1.446M (1446101) - __MIN_OF_OutputChunkBytes: 217.374K (217374) - PullChunkNum: 136 - __MAX_OF_PullChunkNum: 4 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 15.388K (15388) - __MIN_OF_PullRowNum: 2.331K (2331) - PullTotalTime: 16.594us - __MAX_OF_PullTotalTime: 35.584us - __MIN_OF_PullTotalTime: 4.407us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=4): - IsGroupExecution: false - ActiveTime: 5.819ms - __MAX_OF_ActiveTime: 12.974ms - __MIN_OF_ActiveTime: 1.258ms - BlockByInputEmpty: 65 - __MAX_OF_BlockByInputEmpty: 3 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 12m39s - __MAX_OF_DriverTotalTime: 13m41s - __MIN_OF_DriverTotalTime: 11m29s - PeakDriverQueueSize: 992 - __MAX_OF_PeakDriverQueueSize: 61 - __MIN_OF_PeakDriverQueueSize: 8 - PendingTime: 0ns - InputEmptyTime: 12m38s - __MAX_OF_InputEmptyTime: 13m41s - __MIN_OF_InputEmptyTime: 11m29s - FirstInputEmptyTime: 3m41s - __MAX_OF_FirstInputEmptyTime: 13m41s - __MIN_OF_FirstInputEmptyTime: 49s624ms - FollowupInputEmptyTime: 8m57s - __MAX_OF_FollowupInputEmptyTime: 12m35s - __MIN_OF_FollowupInputEmptyTime: 0ns - PendingFinishTime: 188.745ms - __MAX_OF_PendingFinishTime: 668.663ms - __MIN_OF_PendingFinishTime: 34.448ms - ScheduleCount: 115 - __MAX_OF_ScheduleCount: 4 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 12m39s - __MAX_OF_ScheduleTime: 13m41s - __MIN_OF_ScheduleTime: 11m29s - TotalDegreeOfParallelism: 50 - __MAX_OF_TotalDegreeOfParallelism: 10 - __MIN_OF_TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=19): CommonMetrics: - OperatorTotalTime: 4.497ms - __MAX_OF_OperatorTotalTime: 11.694ms - __MIN_OF_OperatorTotalTime: 776.085us - OutputChunkBytes: 0 - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 130 - __MAX_OF_PushChunkNum: 4 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 435.942K (435942) - __MAX_OF_PushRowNum: 15.388K (15388) - __MIN_OF_PushRowNum: 2.331K (2331) - PushTotalTime: 2.647ms - __MAX_OF_PushTotalTime: 9.992ms - __MIN_OF_PushTotalTime: 478.344us - SetFinishingTime: 2.018ms - __MAX_OF_SetFinishingTime: 7.772ms - __MIN_OF_SetFinishingTime: 552.287us UniqueMetrics: - ChannelNum: 5 - DestFragments: c11c5c36bba311f0-bda42ad541ec5906, c11c5c36bba311f0-bda42ad541ec5907, c11c5c36bba311f0-bda42ad541ec5908, c11c5c36bba311f0-bda42ad541ec5909, c11c5c36bba311f0-bda42ad541ec590a - DestID: 19 - PartType: HASH_PARTITIONED - PipelineLevelShuffle: Yes - ShuffleNumPerChannel: 10 - TotalShuffleNum: 50 - BytesPassThrough: 7.789 MB - __MAX_OF_BytesPassThrough: 286.141 KB - __MIN_OF_BytesPassThrough: 43.433 KB - BytesSent: 30.876 MB - __MAX_OF_BytesSent: 7.726 MB - __MIN_OF_BytesSent: 3.867 MB - BytesUnsent: 0.000 B - CompressTime: 215.672us - __MAX_OF_CompressTime: 1.015ms - __MIN_OF_CompressTime: 51.042us - CompressedBytes: 16.612 MB - __MAX_OF_CompressedBytes: 1.002 MB - __MIN_OF_CompressedBytes: 27.071 KB - NetworkBandwidth: 320.985 MB/sec - __MAX_OF_NetworkBandwidth: 109.400 MB/sec - __MIN_OF_NetworkBandwidth: 11.577 MB/sec - NetworkTime: 205.265ms - __MAX_OF_NetworkTime: 667.374ms - __MIN_OF_NetworkTime: 35.471ms - OverallThroughput: 337.308 MB/sec - __MAX_OF_OverallThroughput: 101.961 MB/sec - __MIN_OF_OverallThroughput: 11.533 MB/sec - OverallTime: 192.359ms - __MAX_OF_OverallTime: 669.960ms - __MIN_OF_OverallTime: 38.059ms - PassThroughBufferPeakMemoryUsage: 4.020 MB - __MAX_OF_PassThroughBufferPeakMemoryUsage: 1.789 MB - __MIN_OF_PassThroughBufferPeakMemoryUsage: 228.500 KB - RawInputBytes: 31.224 MB - __MAX_OF_RawInputBytes: 1.100 MB - __MIN_OF_RawInputBytes: 169.120 KB - RequestSent: 201 - __MAX_OF_RequestSent: 41 - __MIN_OF_RequestSent: 40 - RequestUnsent: 0 - RpcAvgTime: 10.258ms - __MAX_OF_RpcAvgTime: 18.675ms - __MIN_OF_RpcAvgTime: 2.630ms - RpcCount: 210 - __MAX_OF_RpcCount: 44 - __MIN_OF_RpcCount: 41 - SerializeChunkTime: 559.112us - __MAX_OF_SerializeChunkTime: 1.167ms - __MIN_OF_SerializeChunkTime: 87.816us - SerializedBytes: 30.876 MB - __MAX_OF_SerializedBytes: 1.082 MB - __MIN_OF_SerializedBytes: 171.014 KB - ShuffleChunkAppendCounter: 6.499K (6499) - __MAX_OF_ShuffleChunkAppendCounter: 200 - __MIN_OF_ShuffleChunkAppendCounter: 50 - ShuffleChunkAppendTime: 1.322ms - __MAX_OF_ShuffleChunkAppendTime: 8.344ms - __MIN_OF_ShuffleChunkAppendTime: 82.655us - ShuffleHashTime: 1.037ms - __MAX_OF_ShuffleHashTime: 4.692ms - __MIN_OF_ShuffleHashTime: 294.986us - WaitTime: 186.984ms - __MAX_OF_WaitTime: 662.725ms - __MIN_OF_WaitTime: 34.510ms AGGREGATE_DISTINCT_STREAMING_SOURCE (plan_node_id=18): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 1.367ms - __MAX_OF_OperatorTotalTime: 4.194ms - __MIN_OF_OperatorTotalTime: 419.061us - OutputChunkBytes: 40.894M (40893988) - __MAX_OF_OutputChunkBytes: 1.446M (1446101) - __MIN_OF_OutputChunkBytes: 217.374K (217374) - PullChunkNum: 130 - __MAX_OF_PullChunkNum: 4 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 435.942K (435942) - __MAX_OF_PullRowNum: 15.388K (15388) - __MIN_OF_PullRowNum: 2.331K (2331) - PullTotalTime: 1.325ms - __MAX_OF_PullTotalTime: 4.151ms - __MIN_OF_PullTotalTime: 391.217us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Fragment 6: - BackendAddresses: cnrs01.starrocks.local:9060 - InstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec5910 - MissingInstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec5910 - BackendNum: 1 - InstanceNum: 1 Fragment 7: - BackendAddresses: fe02.starrocks.local:9060,cn01.starrocks.local:9060,cnrs01.starrocks.local:9060,cn02.starrocks.local:9060,fe03.starrocks.local:9060 - InstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec5915,c11c5c36-bba3-11f0-bda4-2ad541ec5914,c11c5c36-bba3-11f0-bda4-2ad541ec5913,c11c5c36-bba3-11f0-bda4-2ad541ec5912,c11c5c36-bba3-11f0-bda4-2ad541ec5911 - MissingInstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec5915,c11c5c36-bba3-11f0-bda4-2ad541ec5914,c11c5c36-bba3-11f0-bda4-2ad541ec5913,c11c5c36-bba3-11f0-bda4-2ad541ec5912,c11c5c36-bba3-11f0-bda4-2ad541ec5911 - BackendNum: 5 - InstanceNum: 5 Fragment 8: - BackendAddresses: cn01.starrocks.local:9060 - InstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec5916 - MissingInstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec5916 - BackendNum: 1 - InstanceNum: 1 Fragment 9: - BackendAddresses: fe02.starrocks.local:9060,cn01.starrocks.local:9060,cnrs01.starrocks.local:9060,cn02.starrocks.local:9060,fe03.starrocks.local:9060 - InstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec591b,c11c5c36-bba3-11f0-bda4-2ad541ec591a,c11c5c36-bba3-11f0-bda4-2ad541ec5919,c11c5c36-bba3-11f0-bda4-2ad541ec5918,c11c5c36-bba3-11f0-bda4-2ad541ec5917 - MissingInstanceIds: c11c5c36-bba3-11f0-bda4-2ad541ec591b,c11c5c36-bba3-11f0-bda4-2ad541ec591a,c11c5c36-bba3-11f0-bda4-2ad541ec5919,c11c5c36-bba3-11f0-bda4-2ad541ec5918,c11c5c36-bba3-11f0-bda4-2ad541ec5917 - BackendNum: 5 - InstanceNum: 5 ```