Query: Summary: - Query ID: 019ae23f-6959-7fd3-9bc7-260d0d07c428 - Start Time: 2025-12-03 03:26:37 - End Time: 2025-12-03 03:26:40 - Total: 2s595ms - Query Type: Query - Query State: Finished - StarRocks Version: 4.0.1-cd9df36 - User: root - Default Db - Sql Statement: SELECT ta.tos AS tos, ta.rom_vr AS rom_vr, ta.os_vr AS os_vr, ta.device AS device, ta.brand AS brand, ta.cpu AS cpu, CONCAT(tb.cpu_name, '(', ta.cpu, ')') AS `CPU平台`, CASE WHEN ta.ram = 'tran_unk' THEN ta.ram ELSE CAST(CAST(ta.ram AS BIGINT) / 1024 AS VARCHAR) END AS `RAM大小`, ta.rom AS rom, ta.region AS region, CONCAT(ta.country, '(', ta.iso, ')') AS `国家`, ta.iso AS iso, ta.family AS family, ta.sub_family AS sub_family, ta.market_name AS market_name, DATE(ta.s_dt) AS `日期`, CONCAT( CAST(YEAR(DATE(ta.s_dt)) AS VARCHAR), 'W', LPAD(CAST(WEEK(DATE(ta.s_dt), 3) AS VARCHAR), 2, '0') ) AS iso_year_week, ta.sn_cnt AS sn_cnt, ta.lag_sn_cnt AS lag_sn_cnt, ta.launch_cnt AS launch_cnt, ta.cold_launch_cnt AS cold_launch_cnt, ta.warm_launch_cnt AS warm_launch_cnt, ta.hot_launch_cnt AS hot_launch_cnt, tb.cpu_name AS cpu_name, tb.normal_target_value AS normal_target_value, tb.normal_challenge_value AS normal_challenge_value, tb.normal_target_device AS normal_target_device, tb.normal_challenge_device AS normal_challenge_device, tb.normal_shipping_benchmark AS normal_shipping_benchmark, tb.cold_target_value AS cold_target_value, tb.cold_challenge_value AS cold_challenge_value, tb.cold_target_device AS cold_target_device, tb.cold_challenge_device AS cold_challenge_device, tb.cold_shipping_benchmark AS cold_shipping_benchmark, CASE WHEN tc.pre_generation_device = '' THEN 'tran_unk' ELSE tc.pre_generation_device END AS pre_generation_device, tc.normal_pre_generation_value AS normal_pre_generation_value, tc.cold_pre_generation_value AS cold_pre_generation_value FROM ( SELECT CONCAT_WS( '.', SPLIT_PART(REGEXP_REPLACE(os_vr, '^[a-zA-Z]+', ''), '.', 1), SPLIT_PART(REGEXP_REPLACE(os_vr, '^[a-zA-Z]+', ''), '.', 2) ) AS tos, rom_vr, os_vr, device, brand, cpu, ram, rom, iso, region, country, family, sub_family, market_name, s_dt, SUM(sn_cnt) AS sn_cnt, SUM(lag_sn_cnt) AS lag_sn_cnt, SUM(launch_cnt) AS launch_cnt, SUM(cold_launch_cnt) AS cold_launch_cnt, SUM(warm_launch_cnt) AS warm_launch_cnt, SUM(hot_launch_cnt) AS hot_launch_cnt FROM trancare_ads.ads_perf_lch_google_app_launch_stage_di WHERE s_dt >= '2025-01-01' AND rom_vr LIKE '%(%' AND rom_vr LIKE '%-%' GROUP BY rom_vr, os_vr, device, brand, cpu, ram, rom, iso, region, country, family, sub_family, market_name, s_dt ) ta JOIN ( SELECT tos, cpu, cpu_name, MAX(CASE WHEN index_name = '正常启动占比' THEN target_value ELSE NULL END) AS normal_target_value, MAX(CASE WHEN index_name = '正常启动占比' THEN challenge_value ELSE NULL END) AS normal_challenge_value, MAX(CASE WHEN index_name = '正常启动占比' THEN target_device ELSE NULL END) AS normal_target_device, MAX(CASE WHEN index_name = '正常启动占比' THEN challenge_device ELSE NULL END) AS normal_challenge_device, MAX(CASE WHEN index_name = '正常启动占比' THEN shipping_benchmark ELSE NULL END) AS normal_shipping_benchmark, MAX(CASE WHEN index_name = '冷启动占比' THEN target_value ELSE NULL END) AS cold_target_value, MAX(CASE WHEN index_name = '冷启动占比' THEN challenge_value ELSE NULL END) AS cold_challenge_value, MAX(CASE WHEN index_name = '冷启动占比' THEN target_device ELSE NULL END) AS cold_target_device, MAX(CASE WHEN index_name = '冷启动占比' THEN challenge_device ELSE NULL END) AS cold_challenge_device, MAX(CASE WHEN index_name = '冷启动占比' THEN shipping_benchmark ELSE NULL END) AS cold_shipping_benchmark FROM trancare_dim.dim_perf_cpu_target_index_value_v2 WHERE index_name IN ('正常启动占比', '冷启动占比') GROUP BY tos, cpu, cpu_name ) tb ON ta.tos = tb.tos AND ta.cpu = tb.cpu LEFT JOIN ( SELECT tos, device, MAX(pre_generation_device) AS pre_generation_device, MAX(CASE WHEN index_name = '正常启动占比' THEN index_value ELSE NULL END) AS normal_pre_generation_value, MAX(CASE WHEN index_name = '冷启动占比' THEN index_value ELSE NULL END) AS cold_pre_generation_value FROM trancare_dim.dim_perf_pre_generation_target_value WHERE index_name IN ('正常启动占比', '冷启动占比') GROUP BY tos, device ) tc ON ta.tos = tc.tos AND ta.device = tc.device - Warehouse - 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: {"broadcast_row_limit":{"defaultValue":15000000,"actualValue":1000000},"exec_mem_limit":{"defaultValue":2147483648,"actualValue":214748364800},"enable_adaptive_sink_dop":{"defaultValue":false,"actualValue":true},"enable_profile":{"defaultValue":false,"actualValue":true}} - Collect Profile Time: 0 - IsProfileAsync: true Planner: - -- Parser[1] 1ms - -- Total[1] 15ms - -- Analyzer[1] 1ms - -- Lock[1] 0 - -- AnalyzeDatabase[3] 0 - -- AnalyzeTemporaryTable[3] 0 - -- AnalyzeTable[3] 0 - -- Transformer[1] 1ms - -- Optimizer[1] 10ms - -- MVPreprocess[1] 0 - -- MVTextRewrite[1] 0 - -- RuleBaseOptimize[1] 5ms - -- CostBaseOptimize[1] 2ms - -- PhysicalRewrite[1] 1ms - -- DynamicRewrite[1] 0 - -- PlanValidate[1] 0 - -- TypeChecker[1] 0 - -- CTEUniqueChecker[1] 0 - -- InputDependenciesChecker[1] 0 - -- ColumnReuseChecker[1] 0 - -- ExecPlanBuild[1] 1ms - -- Pending[1] 0 - -- Prepare[1] 0 - -- Deploy[1] 48ms - -- DeployLockInternalTime[1] 48ms - -- DeploySerializeConcurrencyTime[3] 1ms - -- DeployStageByStageTime[9] 0 - -- DeployAsyncSendTime[5] 0 - -- DeployWaitTime[9] 46ms - -- DeployScanRanges[1] 0 - DeployDataSize: 197074 Reason: Execution: - Topology: {"rootId":18,"nodes":[{"id":18,"name":"EXCHANGE","properties":{"sinkIds":[],"displayMem":true},"children":[17]},{"id":17,"name":"DECODE","properties":{"sinkIds":[18],"displayMem":false},"children":[16]},{"id":16,"name":"PROJECT","properties":{"displayMem":false},"children":[15]},{"id":15,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[10,14]},{"id":10,"name":"PROJECT","properties":{"displayMem":false},"children":[9]},{"id":14,"name":"EXCHANGE","properties":{"displayMem":true},"children":[13]},{"id":9,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[4,8]},{"id":13,"name":"AGGREGATION","properties":{"sinkIds":[14],"displayMem":true},"children":[12]},{"id":4,"name":"PROJECT","properties":{"displayMem":false},"children":[3]},{"id":8,"name":"EXCHANGE","properties":{"displayMem":true},"children":[7]},{"id":12,"name":"PROJECT","properties":{"displayMem":false},"children":[11]},{"id":3,"name":"AGGREGATION","properties":{"displayMem":true},"children":[2]},{"id":7,"name":"AGGREGATION","properties":{"sinkIds":[8],"displayMem":true},"children":[6]},{"id":11,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":2,"name":"EXCHANGE","properties":{"displayMem":true},"children":[1]},{"id":6,"name":"PROJECT","properties":{"displayMem":false},"children":[5]},{"id":1,"name":"AGGREGATION","properties":{"sinkIds":[2],"displayMem":true},"children":[0]},{"id":5,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":0,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]}]} - FrontendProfileMergeTime: 6.156ms - QueryAllocatedMemoryUsage: 25.855 GB - QueryCumulativeCpuTime: 1m17s - QueryCumulativeNetworkTime: 129.719ms - QueryCumulativeOperatorTime: 1s101ms - QueryCumulativeScanTime: 94.452ms - QueryDeallocatedMemoryUsage: 24.119 GB - QueryExecutionWallTime: 2s337ms - QueryPeakMemoryUsagePerNode: 4.598 GB - QueryPeakScheduleTime: 2s103ms - QuerySpillBytes: 0.000 B - QuerySumMemoryUsage: 4.598 GB - ResultDeliverTime: 1s733ms Fragment 0: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019ae23f-6959-7fd3-9bc7-260d0d07c429 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 2.011ms - InitialProcessDriverCount: 0 - InitialProcessMem: 45.133 GB - InstanceAllocatedMemoryUsage: 1.503 GB - InstanceDeallocatedMemoryUsage: 1.500 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 732.446 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 240.198ms - __MAX_OF_ActiveTime: 297.308ms - __MIN_OF_ActiveTime: 188.308ms - BlockByInputEmpty: 61 - __MAX_OF_BlockByInputEmpty: 4 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 729 - __MAX_OF_BlockByOutputFull: 17 - __MIN_OF_BlockByOutputFull: 15 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 2s239ms - __MAX_OF_DriverTotalTime: 2s332ms - __MIN_OF_DriverTotalTime: 2s221ms - OverheadTime: 2.561ms - __MAX_OF_OverheadTime: 4.033ms - __MIN_OF_OverheadTime: 1.959ms - PeakDriverQueueSize: 868 - __MAX_OF_PeakDriverQueueSize: 39 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 368.236ms - __MAX_OF_InputEmptyTime: 369.547ms - __MIN_OF_InputEmptyTime: 367.540ms - FirstInputEmptyTime: 367.760ms - __MAX_OF_FirstInputEmptyTime: 367.829ms - __MIN_OF_FirstInputEmptyTime: 367.540ms - OutputFullTime: 1s628ms - __MAX_OF_OutputFullTime: 1s733ms - __MIN_OF_OutputFullTime: 1s562ms - ScheduleCount: 906 - __MAX_OF_ScheduleCount: 22 - __MIN_OF_ScheduleCount: 17 - ScheduleTime: 1s999ms - __MAX_OF_ScheduleTime: 2s103ms - __MIN_OF_ScheduleTime: 1s934ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 135 - __MAX_OF_YieldByTimeLimit: 4 - __MIN_OF_YieldByTimeLimit: 1 RESULT_SINK (plan_node_id=-1): CommonMetrics: - IsFinalSink - OperatorTotalTime: 236.842ms - __MAX_OF_OperatorTotalTime: 294.087ms - __MIN_OF_OperatorTotalTime: 183.545ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 918 - __MAX_OF_PushChunkNum: 35 - __MIN_OF_PushChunkNum: 17 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 128.688K (128688) - __MIN_OF_PushRowNum: 61.658K (61658) - PushTotalTime: 236.841ms - __MAX_OF_PushTotalTime: 294.087ms - __MIN_OF_PushTotalTime: 183.544ms UniqueMetrics: - SinkType: MYSQL_PROTOCAL - AppendChunkTime: 215.179ms - __MAX_OF_AppendChunkTime: 273.327ms - __MIN_OF_AppendChunkTime: 154.643ms - ResultRendTime: 21.617ms - __MAX_OF_ResultRendTime: 29.916ms - __MIN_OF_ResultRendTime: 16.722ms - TupleConvertTime: 214.969ms - __MAX_OF_TupleConvertTime: 273.148ms - __MIN_OF_TupleConvertTime: 154.189ms - NumSentRows: 3.362M (3362123) - __MAX_OF_NumSentRows: 128.688K (128688) - __MIN_OF_NumSentRows: 61.658K (61658) CHUNK_ACCUMULATE (plan_node_id=-1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 197.653us - __MAX_OF_OperatorTotalTime: 2.286ms - __MIN_OF_OperatorTotalTime: 20.341us - OutputChunkBytes: 1.339 GB - __MAX_OF_OutputChunkBytes: 52.457 MB - __MIN_OF_OutputChunkBytes: 25.121 MB - PullChunkNum: 918 - __MAX_OF_PullChunkNum: 35 - __MIN_OF_PullChunkNum: 17 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 128.688K (128688) - __MIN_OF_PullRowNum: 61.658K (61658) - PullTotalTime: 13.414us - __MAX_OF_PullTotalTime: 37.202us - __MIN_OF_PullTotalTime: 8.798us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 36 - __MIN_OF_PushChunkNum: 17 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 128.688K (128688) - __MIN_OF_PushRowNum: 61.658K (61658) - PushTotalTime: 183.607us - __MAX_OF_PushTotalTime: 2.263ms - __MIN_OF_PushTotalTime: 9.960us UniqueMetrics: EXCHANGE_SOURCE (plan_node_id=18): CommonMetrics: - ConjunctsInputRows: 3.362M (3362123) - __MAX_OF_ConjunctsInputRows: 128.688K (128688) - __MIN_OF_ConjunctsInputRows: 61.658K (61658) - ConjunctsOutputRows: 3.362M (3362123) - __MAX_OF_ConjunctsOutputRows: 128.688K (128688) - __MIN_OF_ConjunctsOutputRows: 61.658K (61658) - ConjunctsTime: 59.523us - __MAX_OF_ConjunctsTime: 85.204us - __MIN_OF_ConjunctsTime: 43.821us - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 597.692us - __MAX_OF_OperatorTotalTime: 1.135ms - __MIN_OF_OperatorTotalTime: 230.605us - OutputChunkBytes: 1.339 GB - __MAX_OF_OutputChunkBytes: 52.457 MB - __MIN_OF_OutputChunkBytes: 25.121 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 36 - __MIN_OF_PullChunkNum: 17 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 128.688K (128688) - __MIN_OF_PullRowNum: 61.658K (61658) - PullTotalTime: 588.149us - __MAX_OF_PullTotalTime: 1.125ms - __MIN_OF_PullTotalTime: 223.754us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 1 - __MAX_OF_BufferUnplugCount: 1 - __MIN_OF_BufferUnplugCount: 0 - BytesPassThrough: 1.339 GB - __MAX_OF_BytesPassThrough: 139.060 MB - __MIN_OF_BytesPassThrough: 1.574 MB - BytesReceived: 0.000 B - ClosureBlockCount: 228 - __MAX_OF_ClosureBlockCount: 8 - __MIN_OF_ClosureBlockCount: 1 - ClosureBlockTime: 1s763ms - __MAX_OF_ClosureBlockTime: 4s864ms - __MIN_OF_ClosureBlockTime: 0ns - DecompressChunkTime: 0ns - DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 973.806 MB - __MAX_OF_PeakBufferMemoryBytes: 127.278 MB - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 126.294us - __MAX_OF_ReceiverProcessTotalTime: 260.724us - __MIN_OF_ReceiverProcessTotalTime: 49.851us - RequestReceived: 961 - __MAX_OF_RequestReceived: 21 - __MIN_OF_RequestReceived: 20 - WaitLockTime: 0ns Fragment 1: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019ae23f-6959-7fd3-9bc7-260d0d07c42a - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 11.693ms - FragmentInstancePrepareTime: 21.311ms - prepare-pipeline-driver: 17.475ms - InitialProcessDriverCount: 48 - InitialProcessMem: 45.137 GB - InstanceAllocatedMemoryUsage: 10.650 GB - InstanceDeallocatedMemoryUsage: 10.499 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 2.567 GB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=5): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 141.385ms - __MAX_OF_ActiveTime: 155.259ms - __MIN_OF_ActiveTime: 120.314ms - BlockByInputEmpty: 0 - BlockByOutputFull: 476 - __MAX_OF_BlockByOutputFull: 15 - __MIN_OF_BlockByOutputFull: 6 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 2s195ms - __MAX_OF_DriverTotalTime: 2s196ms - __MIN_OF_DriverTotalTime: 2s195ms - OverheadTime: 3.611ms - __MAX_OF_OverheadTime: 4.936ms - __MIN_OF_OverheadTime: 2.860ms - PeakDriverQueueSize: 1.629K (1629) - __MAX_OF_PeakDriverQueueSize: 47 - __MIN_OF_PeakDriverQueueSize: 12 - PendingTime: 0ns - InputEmptyTime: 314.025ms - __MAX_OF_InputEmptyTime: 316.325ms - __MIN_OF_InputEmptyTime: 313.421ms - FirstInputEmptyTime: 314.025ms - __MAX_OF_FirstInputEmptyTime: 316.325ms - __MIN_OF_FirstInputEmptyTime: 313.421ms - OutputFullTime: 689.723ms - __MAX_OF_OutputFullTime: 880.767ms - __MIN_OF_OutputFullTime: 406.023ms - PendingFinishTime: 1s20ms - __MAX_OF_PendingFinishTime: 1s311ms - __MIN_OF_PendingFinishTime: 827.644ms - PreconditionBlockTime: 23.572ms - __MAX_OF_PreconditionBlockTime: 23.683ms - __MIN_OF_PreconditionBlockTime: 23.458ms - ScheduleCount: 572 - __MAX_OF_ScheduleCount: 17 - __MIN_OF_ScheduleCount: 8 - ScheduleTime: 2s54ms - __MAX_OF_ScheduleTime: 2s75ms - __MIN_OF_ScheduleTime: 2s40ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 89 - __MAX_OF_YieldByTimeLimit: 3 - __MIN_OF_YieldByTimeLimit: 1 EXCHANGE_SINK (plan_node_id=18): CommonMetrics: - OperatorTotalTime: 26.720ms - __MAX_OF_OperatorTotalTime: 42.791ms - __MIN_OF_OperatorTotalTime: 18.750ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 70.605K (70605) - __MIN_OF_PushRowNum: 69.409K (69409) - PushTotalTime: 26.671ms - __MAX_OF_PushTotalTime: 42.785ms - __MIN_OF_PushTotalTime: 18.741ms UniqueMetrics: - ChannelNum: 1 - DestFragments: 019ae23f69597fd3-9bc7260d0d07c429 - DestID: 18 - PartType: UNPARTITIONED - BytesPassThrough: 1.339 GB - __MAX_OF_BytesPassThrough: 28.800 MB - __MIN_OF_BytesPassThrough: 28.309 MB - BytesSent: 0.000 B - BytesUnsent: 0.000 B - CompressTime: 0ns - CompressedBytes: 0.000 B - NetworkBandwidth: 0.000 B/sec - NetworkTime: 7.483ms - OverallThroughput: 0.000 B/sec - OverallTime: 1s852ms - PassThroughBufferPeakMemoryUsage: 62.757 MB - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 437.995us - RpcCount: 961 - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 1s767ms DICT_DECODE (plan_node_id=17): CommonMetrics: - OperatorTotalTime: 1.269ms - __MAX_OF_OperatorTotalTime: 1.680ms - __MIN_OF_OperatorTotalTime: 1.035ms - OutputChunkBytes: 1.339 GB - __MAX_OF_OutputChunkBytes: 28.789 MB - __MIN_OF_OutputChunkBytes: 28.299 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 70.605K (70605) - __MIN_OF_PullRowNum: 69.409K (69409) - PullTotalTime: 8.501us - __MAX_OF_PullTotalTime: 14.803us - __MIN_OF_PullTotalTime: 5.081us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 70.605K (70605) - __MIN_OF_PushRowNum: 69.409K (69409) - PushTotalTime: 1.256ms - __MAX_OF_PushTotalTime: 1.668ms - __MIN_OF_PushTotalTime: 1.021ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: PROJECT (plan_node_id=16): CommonMetrics: - OperatorTotalTime: 18.998ms - __MAX_OF_OperatorTotalTime: 20.999ms - __MIN_OF_OperatorTotalTime: 17.078ms - OutputChunkBytes: 1.306 GB - __MAX_OF_OutputChunkBytes: 28.085 MB - __MIN_OF_OutputChunkBytes: 27.609 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 70.605K (70605) - __MIN_OF_PullRowNum: 69.409K (69409) - PullTotalTime: 4.402us - __MAX_OF_PullTotalTime: 7.558us - __MIN_OF_PullTotalTime: 3.119us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 70.605K (70605) - __MIN_OF_PushRowNum: 69.409K (69409) - PushTotalTime: 18.987ms - __MAX_OF_PushTotalTime: 20.989ms - __MIN_OF_PushTotalTime: 17.049ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 475.854us - __MAX_OF_CommonSubExprComputeTime: 709.558us - __MIN_OF_CommonSubExprComputeTime: 379.721us - ExprComputeTime: 18.390ms - __MAX_OF_ExprComputeTime: 20.185ms - __MIN_OF_ExprComputeTime: 16.480ms CHUNK_ACCUMULATE (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 19.347us - __MAX_OF_OperatorTotalTime: 27.006us - __MIN_OF_OperatorTotalTime: 14.618us - OutputChunkBytes: 1.184 GB - __MAX_OF_OutputChunkBytes: 25.460 MB - __MIN_OF_OutputChunkBytes: 25.030 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 70.605K (70605) - __MIN_OF_PullRowNum: 69.409K (69409) - PullTotalTime: 2.998us - __MAX_OF_PullTotalTime: 8.300us - __MIN_OF_PullTotalTime: 1.989us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 70.605K (70605) - __MIN_OF_PushRowNum: 69.409K (69409) - PushTotalTime: 15.709us - __MAX_OF_PushTotalTime: 21.211us - __MIN_OF_PushTotalTime: 11.889us UniqueMetrics: HASH_JOIN_PROBE (plan_node_id=15): CommonMetrics: - OperatorTotalTime: 13.866ms - __MAX_OF_OperatorTotalTime: 15.712ms - __MIN_OF_OperatorTotalTime: 11.897ms - OutputChunkBytes: 1.184 GB - __MAX_OF_OutputChunkBytes: 25.460 MB - __MIN_OF_OutputChunkBytes: 25.030 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 70.605K (70605) - __MIN_OF_PullRowNum: 69.409K (69409) - PullTotalTime: 13.703ms - __MAX_OF_PullTotalTime: 15.540ms - __MIN_OF_PullTotalTime: 11.722ms - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 78.434K (78434) - __MIN_OF_PushRowNum: 77.436K (77436) - PushTotalTime: 144.216us - __MAX_OF_PushTotalTime: 207.456us - __MIN_OF_PushTotalTime: 99.026us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - JoinType: INNER_JOIN - OtherJoinConjunctEvaluateTime: 0ns - OutputBuildColumnTime: 5.255ms - __MAX_OF_OutputBuildColumnTime: 5.921ms - __MIN_OF_OutputBuildColumnTime: 4.606ms - OutputProbeColumnTime: 5.255ms - __MAX_OF_OutputProbeColumnTime: 6.464ms - __MIN_OF_OutputProbeColumnTime: 4.305ms - PartitionProbeOverhead: 0ns - ProbeConjunctEvaluateTime: 0ns - SearchHashTableTime: 3.062ms - __MAX_OF_SearchHashTableTime: 3.447ms - __MIN_OF_SearchHashTableTime: 2.701ms - WhereConjunctEvaluateTime: 0ns - probeCount: 0 PROJECT (plan_node_id=10): CommonMetrics: - OperatorTotalTime: 107.134us - __MAX_OF_OperatorTotalTime: 147.190us - __MIN_OF_OperatorTotalTime: 85.975us - OutputChunkBytes: 988.977 MB - __MAX_OF_OutputChunkBytes: 20.736 MB - __MIN_OF_OutputChunkBytes: 20.472 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 78.434K (78434) - __MIN_OF_PullRowNum: 77.436K (77436) - PullTotalTime: 2.095us - __MAX_OF_PullTotalTime: 6.730us - __MIN_OF_PullTotalTime: 1.570us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 78.434K (78434) - __MIN_OF_PushRowNum: 77.436K (77436) - PushTotalTime: 99.979us - __MAX_OF_PushTotalTime: 139.923us - __MIN_OF_PushTotalTime: 80.166us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 1.627us - __MAX_OF_CommonSubExprComputeTime: 3.410us - __MIN_OF_CommonSubExprComputeTime: 1.024us - ExprComputeTime: 53.968us - __MAX_OF_ExprComputeTime: 89.801us - __MIN_OF_ExprComputeTime: 37.491us HASH_JOIN_PROBE (plan_node_id=9): CommonMetrics: - OperatorTotalTime: 3.984ms - __MAX_OF_OperatorTotalTime: 4.643ms - __MIN_OF_OperatorTotalTime: 3.564ms - OutputChunkBytes: 988.977 MB - __MAX_OF_OutputChunkBytes: 20.736 MB - __MIN_OF_OutputChunkBytes: 20.472 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 78.434K (78434) - __MIN_OF_PullRowNum: 77.436K (77436) - PullTotalTime: 3.863ms - __MAX_OF_PullTotalTime: 4.474ms - __MIN_OF_PullTotalTime: 3.451ms - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 78.434K (78434) - __MIN_OF_PushRowNum: 77.436K (77436) - PushTotalTime: 101.935us - __MAX_OF_PushTotalTime: 152.792us - __MIN_OF_PushTotalTime: 65.183us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - JoinType: LEFT_OUTER_JOIN - OtherJoinConjunctEvaluateTime: 0ns - OutputBuildColumnTime: 1.200ms - __MAX_OF_OutputBuildColumnTime: 1.414ms - __MIN_OF_OutputBuildColumnTime: 1.060ms - OutputProbeColumnTime: 101.051us - __MAX_OF_OutputProbeColumnTime: 158.693us - __MIN_OF_OutputProbeColumnTime: 76.822us - PartitionProbeOverhead: 0ns - ProbeConjunctEvaluateTime: 0ns - SearchHashTableTime: 2.447ms - __MAX_OF_SearchHashTableTime: 2.822ms - __MIN_OF_SearchHashTableTime: 2.177ms - WhereConjunctEvaluateTime: 0ns - probeCount: 0 PROJECT (plan_node_id=4): CommonMetrics: - OperatorTotalTime: 18.605ms - __MAX_OF_OperatorTotalTime: 21.814ms - __MIN_OF_OperatorTotalTime: 15.634ms - OutputChunkBytes: 930.824 MB - __MAX_OF_OutputChunkBytes: 19.517 MB - __MIN_OF_OutputChunkBytes: 19.269 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 78.434K (78434) - __MIN_OF_PullRowNum: 77.436K (77436) - PullTotalTime: 2.680us - __MAX_OF_PullTotalTime: 7.099us - __MIN_OF_PullTotalTime: 2.158us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 78.434K (78434) - __MIN_OF_PushRowNum: 77.436K (77436) - PushTotalTime: 18.594ms - __MAX_OF_PushTotalTime: 21.802ms - __MIN_OF_PushTotalTime: 15.625ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 1 UniqueMetrics: - CommonSubExprComputeTime: 10.443ms - __MAX_OF_CommonSubExprComputeTime: 12.632ms - __MIN_OF_CommonSubExprComputeTime: 8.800ms - ExprComputeTime: 8.066ms - __MAX_OF_ExprComputeTime: 9.326ms - __MIN_OF_ExprComputeTime: 6.741ms AGGREGATE_BLOCKING_SOURCE (plan_node_id=3): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 54.203ms - __MAX_OF_OperatorTotalTime: 60.459ms - __MIN_OF_OperatorTotalTime: 45.804ms - OutputChunkBytes: 898.720 MB - __MAX_OF_OutputChunkBytes: 18.843 MB - __MIN_OF_OutputChunkBytes: 18.605 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 78.434K (78434) - __MIN_OF_PullRowNum: 77.436K (77436) - PullTotalTime: 54.054ms - __MAX_OF_PullTotalTime: 60.343ms - __MIN_OF_PullTotalTime: 45.629ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=4): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 98.598ms - __MAX_OF_ActiveTime: 113.929ms - __MIN_OF_ActiveTime: 72.075ms - BlockByInputEmpty: 508 - __MAX_OF_BlockByInputEmpty: 20 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 337.868ms - __MAX_OF_DriverTotalTime: 339.925ms - __MIN_OF_DriverTotalTime: 337.310ms - OverheadTime: 1.641ms - __MAX_OF_OverheadTime: 2.013ms - __MIN_OF_OverheadTime: 1.179ms - PeakDriverQueueSize: 741 - __MAX_OF_PeakDriverQueueSize: 36 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 218.179ms - __MAX_OF_InputEmptyTime: 245.579ms - __MIN_OF_InputEmptyTime: 202.150ms - FirstInputEmptyTime: 170.856ms - __MAX_OF_FirstInputEmptyTime: 204.807ms - __MIN_OF_FirstInputEmptyTime: 156.547ms - FollowupInputEmptyTime: 47.323ms - __MAX_OF_FollowupInputEmptyTime: 69.007ms - __MIN_OF_FollowupInputEmptyTime: 20.646ms - PreconditionBlockTime: 19.394ms - __MAX_OF_PreconditionBlockTime: 19.402ms - __MIN_OF_PreconditionBlockTime: 19.391ms - ScheduleCount: 572 - __MAX_OF_ScheduleCount: 22 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 239.270ms - __MAX_OF_ScheduleTime: 265.978ms - __MIN_OF_ScheduleTime: 223.634ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 33 - __MAX_OF_YieldByTimeLimit: 4 - __MIN_OF_YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=3): CommonMetrics: - OperatorTotalTime: 85.902ms - __MAX_OF_OperatorTotalTime: 100.436ms - __MIN_OF_OperatorTotalTime: 63.306ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.152K (1152) - __MAX_OF_PushChunkNum: 24 - __MIN_OF_PushChunkNum: 24 - PushRowNum: 4.013M (4012848) - __MAX_OF_PushRowNum: 84.130K (84130) - __MIN_OF_PushRowNum: 83.095K (83095) - PushTotalTime: 85.871ms - __MAX_OF_PushTotalTime: 100.418ms - __MIN_OF_PushTotalTime: 63.255ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - AggregateFunctions: sum(42: sum), sum(43: sum), sum(44: sum), sum(45: sum), sum(46: sum), sum(47: sum) - GroupingKeys: 2: rom_vr, 3: os_vr, 1: device, 5: brand, 7: cpu, 8: ram, 9: rom, 6: iso, 10: region, 11: country, 12: family, 13: sub_family, 14: market_name, 4: s_dt - AggComputeTime: 84.326ms - __MAX_OF_AggComputeTime: 98.525ms - __MIN_OF_AggComputeTime: 62.236ms - AggFuncComputeTime: 3.557ms - __MAX_OF_AggFuncComputeTime: 4.964ms - __MIN_OF_AggFuncComputeTime: 2.105ms - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 334.841us - __MAX_OF_ExprComputeTime: 429.035us - __MIN_OF_ExprComputeTime: 225.966us - ExprReleaseTime: 1.333ms - __MAX_OF_ExprReleaseTime: 1.800ms - __MIN_OF_ExprReleaseTime: 880.656us - GetResultsTime: 53.993ms - __MAX_OF_GetResultsTime: 60.282ms - __MIN_OF_GetResultsTime: 45.581ms - HashTableMemoryUsage: 1.351 GB - __MAX_OF_HashTableMemoryUsage: 29.004 MB - __MIN_OF_HashTableMemoryUsage: 28.504 MB - HashTableSize: 3.740M (3740376) - __MAX_OF_HashTableSize: 78.434K (78434) - __MIN_OF_HashTableSize: 77.436K (77436) - InputRowCount: 4.013M (4012848) - __MAX_OF_InputRowCount: 84.130K (84130) - __MIN_OF_InputRowCount: 83.095K (83095) - PassThroughRowCount: 0 - ResultAggAppendTime: 11.701ms - __MAX_OF_ResultAggAppendTime: 14.308ms - __MIN_OF_ResultAggAppendTime: 9.774ms - ResultGroupByAppendTime: 39.241ms - __MAX_OF_ResultGroupByAppendTime: 44.964ms - __MIN_OF_ResultGroupByAppendTime: 32.183ms - ResultIteratorTime: 1.925ms - __MAX_OF_ResultIteratorTime: 2.413ms - __MIN_OF_ResultIteratorTime: 1.543ms - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns CHUNK_ACCUMULATE (plan_node_id=2): CommonMetrics: - IsSubordinate - OperatorTotalTime: 10.174ms - __MAX_OF_OperatorTotalTime: 12.207ms - __MIN_OF_OperatorTotalTime: 7.036ms - OutputChunkBytes: 963.366 MB - __MAX_OF_OutputChunkBytes: 20.194 MB - __MIN_OF_OutputChunkBytes: 19.949 MB - PullChunkNum: 1.152K (1152) - __MAX_OF_PullChunkNum: 24 - __MIN_OF_PullChunkNum: 24 - PullRowNum: 4.013M (4012848) - __MAX_OF_PullRowNum: 84.130K (84130) - __MIN_OF_PullRowNum: 83.095K (83095) - PullTotalTime: 4.559us - __MAX_OF_PullTotalTime: 11.880us - __MIN_OF_PullTotalTime: 2.879us - PushChunkNum: 2.304K (2304) - __MAX_OF_PushChunkNum: 48 - __MIN_OF_PushChunkNum: 48 - PushRowNum: 4.013M (4012848) - __MAX_OF_PushRowNum: 84.130K (84130) - __MIN_OF_PushRowNum: 83.095K (83095) - PushTotalTime: 10.169ms - __MAX_OF_PushTotalTime: 12.200ms - __MIN_OF_PushTotalTime: 7.033ms UniqueMetrics: EXCHANGE_SOURCE (plan_node_id=2): CommonMetrics: - RuntimeFilterDesc: <1: BloomFilter> - ConjunctsInputRows: 4.013M (4012848) - __MAX_OF_ConjunctsInputRows: 84.130K (84130) - __MIN_OF_ConjunctsInputRows: 83.095K (83095) - ConjunctsOutputRows: 4.013M (4012848) - __MAX_OF_ConjunctsOutputRows: 84.130K (84130) - __MIN_OF_ConjunctsOutputRows: 83.095K (83095) - ConjunctsTime: 160.596us - __MAX_OF_ConjunctsTime: 219.346us - __MIN_OF_ConjunctsTime: 108.635us - JoinRuntimeFilterEvaluate: 96 - __MAX_OF_JoinRuntimeFilterEvaluate: 2 - __MIN_OF_JoinRuntimeFilterEvaluate: 2 - JoinRuntimeFilterHashTime: 1.726us - __MAX_OF_JoinRuntimeFilterHashTime: 18.241us - __MIN_OF_JoinRuntimeFilterHashTime: 560ns - JoinRuntimeFilterInputRows: 4.013M (4012848) - __MAX_OF_JoinRuntimeFilterInputRows: 84.130K (84130) - __MIN_OF_JoinRuntimeFilterInputRows: 83.095K (83095) - JoinRuntimeFilterOutputRows: 4.013M (4012848) - __MAX_OF_JoinRuntimeFilterOutputRows: 84.130K (84130) - __MIN_OF_JoinRuntimeFilterOutputRows: 83.095K (83095) - JoinRuntimeFilterTime: 96.511us - __MAX_OF_JoinRuntimeFilterTime: 172.645us - __MIN_OF_JoinRuntimeFilterTime: 49.181us - OperatorTotalTime: 879.720us - __MAX_OF_OperatorTotalTime: 1.695ms - __MIN_OF_OperatorTotalTime: 541.163us - OutputChunkBytes: 963.366 MB - __MAX_OF_OutputChunkBytes: 20.194 MB - __MIN_OF_OutputChunkBytes: 19.949 MB - PullChunkNum: 2.304K (2304) - __MAX_OF_PullChunkNum: 48 - __MIN_OF_PullChunkNum: 48 - PullRowNum: 4.013M (4012848) - __MAX_OF_PullRowNum: 84.130K (84130) - __MIN_OF_PullRowNum: 83.095K (83095) - PullTotalTime: 859.402us - __MAX_OF_PullTotalTime: 1.675ms - __MIN_OF_PullTotalTime: 527.666us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 1 UniqueMetrics: - BufferUnplugCount: 48 - __MAX_OF_BufferUnplugCount: 1 - __MIN_OF_BufferUnplugCount: 1 - BytesPassThrough: 963.963 MB - __MAX_OF_BytesPassThrough: 235.327 MB - __MIN_OF_BytesPassThrough: 3.300 MB - BytesReceived: 0.000 B - ClosureBlockCount: 311 - __MAX_OF_ClosureBlockCount: 10 - __MIN_OF_ClosureBlockCount: 4 - ClosureBlockTime: 111.013ms - __MAX_OF_ClosureBlockTime: 889.463ms - __MIN_OF_ClosureBlockTime: 76.292us - DecompressChunkTime: 0ns - DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 717.247 MB - __MAX_OF_PeakBufferMemoryBytes: 225.935 MB - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 324.124us - __MAX_OF_ReceiverProcessTotalTime: 1.578ms - __MIN_OF_ReceiverProcessTotalTime: 146.843us - RequestReceived: 2.305K (2305) - __MAX_OF_RequestReceived: 49 - __MIN_OF_RequestReceived: 48 - WaitLockTime: 0ns Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 503.242us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 24.341ms - PeakDriverQueueSize: 47 - PendingTime: 0ns - InputEmptyTime: 22.747ms - FirstInputEmptyTime: 22.747ms - ScheduleCount: 1 - ScheduleTime: 23.837ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 HASH_JOIN_BUILD (plan_node_id=9): CommonMetrics: - OperatorTotalTime: 479.581us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 2 - PushRowNum: 2 - PushTotalTime: 18.340us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - HashMapType: SERIALIZED-LINEAR_CHAINED-VARCHAR:1 - JoinPredicates: 48: concat_ws = 82: tos, 1: device = 83: device - JoinType: LEFT_OUTER_JOIN - BuildBuckets: 4 - BuildConjunctEvaluateTime: 5.160us - BuildHashTableTime: 155.404us - BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 9.640us - HashTableMemoryUsage: 4.229 KB - PartialRuntimeMembershipFilterBytes: 0.000 B - PartitionNums: 1 - RuntimeFilterBuildTime: 4.801us - RuntimeFilterNum: 0 LOCAL_EXCHANGE_SOURCE (plan_node_id=9): CommonMetrics: - IsSubordinate - OperatorTotalTime: 18.582us - OutputChunkBytes: 103.000 B - PullChunkNum: 2 - PullRowNum: 2 - PullTotalTime: 6.401us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=2): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 17.274us - __MAX_OF_ActiveTime: 114.333us - __MIN_OF_ActiveTime: 6.070us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 23.421ms - __MAX_OF_DriverTotalTime: 25.011ms - __MIN_OF_DriverTotalTime: 23.041ms - PeakDriverQueueSize: 1.068K (1068) - __MAX_OF_PeakDriverQueueSize: 46 - __MIN_OF_PeakDriverQueueSize: 1 - PendingTime: 0ns - InputEmptyTime: 3.334ms - __MAX_OF_InputEmptyTime: 3.348ms - __MIN_OF_InputEmptyTime: 3.247ms - FirstInputEmptyTime: 3.334ms - __MAX_OF_FirstInputEmptyTime: 3.348ms - __MIN_OF_FirstInputEmptyTime: 3.247ms - PreconditionBlockTime: 19.412ms - __MAX_OF_PreconditionBlockTime: 19.422ms - __MIN_OF_PreconditionBlockTime: 19.400ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 23.404ms - __MAX_OF_ScheduleTime: 24.999ms - __MIN_OF_ScheduleTime: 22.997ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=9): CommonMetrics: - IsSubordinate - OperatorTotalTime: 879ns - __MAX_OF_OperatorTotalTime: 6.800us - __MIN_OF_OperatorTotalTime: 410ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 2 - __MAX_OF_PushRowNum: 1 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 174ns - __MAX_OF_PushTotalTime: 6.100us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 1 - Type: Passthrough - LocalExchangePeakMemoryUsage: 145.000 B CHUNK_ACCUMULATE (plan_node_id=8): CommonMetrics: - IsSubordinate - OperatorTotalTime: 477ns - __MAX_OF_OperatorTotalTime: 1.360us - __MIN_OF_OperatorTotalTime: 220ns - OutputChunkBytes: 103.000 B - __MAX_OF_OutputChunkBytes: 54.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 2 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 2 - __MAX_OF_PullRowNum: 1 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 5ns - __MAX_OF_PullTotalTime: 140ns - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 2 - __MAX_OF_PushRowNum: 1 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 25ns - __MAX_OF_PushTotalTime: 620ns - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: EXCHANGE_SOURCE (plan_node_id=8): CommonMetrics: - RuntimeFilterDesc: <0: BloomFilter> - ConjunctsInputRows: 2 - __MAX_OF_ConjunctsInputRows: 1 - __MIN_OF_ConjunctsInputRows: 1 - ConjunctsOutputRows: 2 - __MAX_OF_ConjunctsOutputRows: 1 - __MIN_OF_ConjunctsOutputRows: 1 - ConjunctsTime: 944ns - __MAX_OF_ConjunctsTime: 1.040us - __MIN_OF_ConjunctsTime: 849ns - JoinRuntimeFilterEvaluate: 2 - __MAX_OF_JoinRuntimeFilterEvaluate: 1 - __MIN_OF_JoinRuntimeFilterEvaluate: 1 - JoinRuntimeFilterHashTime: 260ns - __MAX_OF_JoinRuntimeFilterHashTime: 270ns - __MIN_OF_JoinRuntimeFilterHashTime: 250ns - JoinRuntimeFilterInputRows: 2 - __MAX_OF_JoinRuntimeFilterInputRows: 1 - __MIN_OF_JoinRuntimeFilterInputRows: 1 - JoinRuntimeFilterOutputRows: 2 - __MAX_OF_JoinRuntimeFilterOutputRows: 1 - __MIN_OF_JoinRuntimeFilterOutputRows: 1 - JoinRuntimeFilterTime: 4.505us - __MAX_OF_JoinRuntimeFilterTime: 4.770us - __MIN_OF_JoinRuntimeFilterTime: 4.240us - OperatorTotalTime: 20.372us - __MAX_OF_OperatorTotalTime: 100.864us - __MIN_OF_OperatorTotalTime: 9.660us - OutputChunkBytes: 103.000 B - __MAX_OF_OutputChunkBytes: 54.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 2 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 2 - __MAX_OF_PullRowNum: 1 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 1.599us - __MAX_OF_PullTotalTime: 42.061us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 263.000 B - __MAX_OF_BytesPassThrough: 263.000 B - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 0.000 B - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 0ns - DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 263.000 B - __MAX_OF_PeakBufferMemoryBytes: 263.000 B - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 718ns - __MAX_OF_ReceiverProcessTotalTime: 31.451us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 3 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 0ns Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 757.168us - BlockByInputEmpty: 2 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 19.637ms - PeakDriverQueueSize: 84 - PendingTime: 0ns - InputEmptyTime: 17.947ms - FirstInputEmptyTime: 17.612ms - ScheduleCount: 3 - ScheduleTime: 18.879ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 HASH_JOIN_BUILD (plan_node_id=15): CommonMetrics: - OperatorTotalTime: 518.992us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 24 - PushRowNum: 36 - PushTotalTime: 148.842us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - HashMapType: SERIALIZED-LINEAR_CHAINED-VARCHAR:1 - JoinPredicates: 48: concat_ws = 49: tos, 7: cpu = 50: cpu - JoinType: INNER_JOIN - BuildBuckets: 64 - BuildConjunctEvaluateTime: 48.879us - BuildHashTableTime: 108.083us - BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 90.711us - HashTableMemoryUsage: 12.013 KB - PartialRuntimeMembershipFilterBytes: 64.000 B - PartitionNums: 1 - RuntimeFilterBuildTime: 49.991us - RuntimeFilterNum: 2 LOCAL_EXCHANGE_SOURCE (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 73.344us - OutputChunkBytes: 4.425 KB - PullChunkNum: 24 - PullRowNum: 36 - PullTotalTime: 68.594us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 33.047us - __MAX_OF_ActiveTime: 429.700us - __MIN_OF_ActiveTime: 6.610us - BlockByInputEmpty: 48 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 19.020ms - __MAX_OF_DriverTotalTime: 19.310ms - __MIN_OF_DriverTotalTime: 18.865ms - PeakDriverQueueSize: 1.566K (1566) - __MAX_OF_PeakDriverQueueSize: 92 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 18.069ms - __MAX_OF_InputEmptyTime: 18.140ms - __MIN_OF_InputEmptyTime: 17.970ms - FirstInputEmptyTime: 17.360ms - __MAX_OF_FirstInputEmptyTime: 17.398ms - __MIN_OF_FirstInputEmptyTime: 17.324ms - ScheduleCount: 96 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 18.987ms - __MAX_OF_ScheduleTime: 19.287ms - __MIN_OF_ScheduleTime: 18.438ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 5.215us - __MAX_OF_OperatorTotalTime: 50.360us - __MIN_OF_OperatorTotalTime: 379ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 24 - __MAX_OF_PushChunkNum: 5 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 36 - __MAX_OF_PushRowNum: 7 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 4.705us - __MAX_OF_PushTotalTime: 49.941us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 1 - Type: Passthrough - LocalExchangePeakMemoryUsage: 4.505 KB EXCHANGE_SOURCE (plan_node_id=14): CommonMetrics: - ConjunctsInputRows: 36 - __MAX_OF_ConjunctsInputRows: 7 - __MIN_OF_ConjunctsInputRows: 1 - ConjunctsOutputRows: 36 - __MAX_OF_ConjunctsOutputRows: 7 - __MIN_OF_ConjunctsOutputRows: 1 - ConjunctsTime: 2.252us - __MAX_OF_ConjunctsTime: 4.540us - __MIN_OF_ConjunctsTime: 1.080us - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 23.271us - __MAX_OF_OperatorTotalTime: 389.440us - __MIN_OF_OperatorTotalTime: 5.190us - OutputChunkBytes: 4.425 KB - __MAX_OF_OutputChunkBytes: 874.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 24 - __MAX_OF_PullChunkNum: 5 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 36 - __MAX_OF_PullRowNum: 7 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 5.764us - __MAX_OF_PullTotalTime: 42.621us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 1 - __MAX_OF_BufferUnplugCount: 1 - __MIN_OF_BufferUnplugCount: 0 - BytesPassThrough: 9.300 KB - __MAX_OF_BytesPassThrough: 1.674 KB - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 0.000 B - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 0ns - DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 9.300 KB - __MAX_OF_PeakBufferMemoryBytes: 1.674 KB - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 2.939us - __MAX_OF_ReceiverProcessTotalTime: 21.331us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 25 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 0ns Fragment 2: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019ae23f-6959-7fd3-9bc7-260d0d07c42b - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 5.505ms - FragmentInstancePrepareTime: 10.994ms - InitialProcessDriverCount: 242 - InitialProcessMem: 45.163 GB - InstanceAllocatedMemoryUsage: 27.298 MB - InstanceDeallocatedMemoryUsage: 27.285 MB - InstanceNum: 1 - InstancePeakMemoryUsage: 20.185 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 209.522us - __MAX_OF_ActiveTime: 976.964us - __MIN_OF_ActiveTime: 6.710us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 4.976ms - __MAX_OF_DriverTotalTime: 5.202ms - __MIN_OF_DriverTotalTime: 4.917ms - PeakDriverQueueSize: 2.920K (2920) - __MAX_OF_PeakDriverQueueSize: 90 - __MIN_OF_PeakDriverQueueSize: 37 - PendingTime: 0ns - InputEmptyTime: 2.667ms - __MAX_OF_InputEmptyTime: 3.819ms - __MIN_OF_InputEmptyTime: 1.902ms - FirstInputEmptyTime: 2.667ms - __MAX_OF_FirstInputEmptyTime: 3.819ms - __MIN_OF_FirstInputEmptyTime: 1.902ms - PendingFinishTime: 1.564ms - __MAX_OF_PendingFinishTime: 2.583ms - __MIN_OF_PendingFinishTime: 505.072us - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 4.766ms - __MAX_OF_ScheduleTime: 5.025ms - __MIN_OF_ScheduleTime: 4.001ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=14): CommonMetrics: - OperatorTotalTime: 156.504us - __MAX_OF_OperatorTotalTime: 851.351us - __MIN_OF_OperatorTotalTime: 2.369us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 24 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 36 - __MAX_OF_PushRowNum: 3 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 8.207us - __MAX_OF_PushTotalTime: 22.180us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ChannelNum: 1 - DestFragments: 019ae23f69597fd3-9bc7260d0d07c42a - DestID: 14 - PartType: UNPARTITIONED - BytesPassThrough: 9.300 KB - __MAX_OF_BytesPassThrough: 583.000 B - __MIN_OF_BytesPassThrough: 0.000 B - BytesSent: 0.000 B - BytesUnsent: 0.000 B - CompressTime: 0ns - CompressedBytes: 0.000 B - NetworkBandwidth: 0.000 B/sec - NetworkTime: 3.918ms - OverallThroughput: 0.000 B/sec - OverallTime: 2.257ms - PassThroughBufferPeakMemoryUsage: 3.891 KB - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 376.196us - RpcCount: 25 - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 903.382us AGGREGATE_BLOCKING_SOURCE (plan_node_id=13): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 66.502us - __MAX_OF_OperatorTotalTime: 155.944us - __MIN_OF_OperatorTotalTime: 12.180us - OutputChunkBytes: 4.425 KB - __MAX_OF_OutputChunkBytes: 375.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 24 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 36 - __MAX_OF_PullRowNum: 3 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 45.196us - __MAX_OF_PullTotalTime: 131.204us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 52.773us - __MAX_OF_ActiveTime: 173.404us - __MIN_OF_ActiveTime: 4.430us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 2.761ms - __MAX_OF_DriverTotalTime: 3.867ms - __MIN_OF_DriverTotalTime: 1.937ms - PeakDriverQueueSize: 176 - __MAX_OF_PeakDriverQueueSize: 49 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 2.576ms - __MAX_OF_InputEmptyTime: 3.302ms - __MIN_OF_InputEmptyTime: 1.878ms - FirstInputEmptyTime: 2.576ms - __MAX_OF_FirstInputEmptyTime: 3.302ms - __MIN_OF_FirstInputEmptyTime: 1.878ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 2.709ms - __MAX_OF_ScheduleTime: 3.780ms - __MIN_OF_ScheduleTime: 1.926ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=13): CommonMetrics: - OperatorTotalTime: 39.025us - __MAX_OF_OperatorTotalTime: 153.944us - __MIN_OF_OperatorTotalTime: 6.219us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 24 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 72 - __MAX_OF_PushRowNum: 6 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 27.371us - __MAX_OF_PushTotalTime: 141.364us - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - AggregateFunctions: max(71: case), max(62: case), max(63: case), max(64: case), max(65: case), max(66: case), max(67: case), max(68: case), max(69: case), max(70: case) - GroupingKeys: 49: tos, 50: cpu, 102: cpu_name - AggComputeTime: 25.062us - __MAX_OF_AggComputeTime: 139.083us - __MIN_OF_AggComputeTime: 0ns - AggFuncComputeTime: 3.645us - __MAX_OF_AggFuncComputeTime: 15.660us - __MIN_OF_AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 2.543us - __MAX_OF_ExprComputeTime: 7.671us - __MIN_OF_ExprComputeTime: 0ns - ExprReleaseTime: 590ns - __MAX_OF_ExprReleaseTime: 2.421us - __MIN_OF_ExprReleaseTime: 0ns - GetResultsTime: 38.889us - __MAX_OF_GetResultsTime: 114.942us - __MIN_OF_GetResultsTime: 0ns - HashTableMemoryUsage: 12.096 MB - __MAX_OF_HashTableMemoryUsage: 516.105 KB - __MIN_OF_HashTableMemoryUsage: 24.000 B - HashTableSize: 36 - __MAX_OF_HashTableSize: 3 - __MIN_OF_HashTableSize: 0 - InputRowCount: 72 - __MAX_OF_InputRowCount: 6 - __MIN_OF_InputRowCount: 0 - PassThroughRowCount: 0 - ResultAggAppendTime: 2.094us - __MAX_OF_ResultAggAppendTime: 9.890us - __MIN_OF_ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 840ns - __MAX_OF_ResultGroupByAppendTime: 3.410us - __MIN_OF_ResultGroupByAppendTime: 0ns - ResultIteratorTime: 27.055us - __MAX_OF_ResultIteratorTime: 70.562us - __MIN_OF_ResultIteratorTime: 0ns - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns LOCAL_EXCHANGE_SOURCE (plan_node_id=13): CommonMetrics: - IsSubordinate - OperatorTotalTime: 16.499us - __MAX_OF_OperatorTotalTime: 98.092us - __MIN_OF_OperatorTotalTime: 879ns - OutputChunkBytes: 7.119 KB - __MAX_OF_OutputChunkBytes: 600.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 24 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 72 - __MAX_OF_PullRowNum: 6 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 14.343us - __MAX_OF_PullTotalTime: 95.912us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 934.965us - __MAX_OF_ActiveTime: 2.879ms - __MIN_OF_ActiveTime: 512.762us - BlockByInputEmpty: 8 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 8 - DriverTotalTime: 1.885ms - __MAX_OF_DriverTotalTime: 3.953ms - __MIN_OF_DriverTotalTime: 1.436ms - PeakDriverQueueSize: 23 - __MAX_OF_PeakDriverQueueSize: 6 - __MIN_OF_PeakDriverQueueSize: 1 - ScheduleCount: 16 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 2 - TotalDegreeOfParallelism: 8 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=13): CommonMetrics: - IsSubordinate - OperatorTotalTime: 284.482us - __MAX_OF_OperatorTotalTime: 2.070ms - __MIN_OF_OperatorTotalTime: 22.501us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 8 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 72 - __MAX_OF_PushRowNum: 14 - __MIN_OF_PushRowNum: 6 - PushTotalTime: 28.945us - __MAX_OF_PushTotalTime: 37.291us - __MIN_OF_PushTotalTime: 22.061us UniqueMetrics: - ShuffleNum: 48 - Type: Partition(BUCKET_SHUFFLE_HASH_PARTITIONED) - LocalExchangePeakMemoryUsage: 5.495 KB PROJECT (plan_node_id=12): CommonMetrics: - OperatorTotalTime: 62.208us - __MAX_OF_OperatorTotalTime: 81.951us - __MIN_OF_OperatorTotalTime: 45.132us - OutputChunkBytes: 7.119 KB - __MAX_OF_OutputChunkBytes: 1.354 KB - __MIN_OF_OutputChunkBytes: 594.000 B - PullChunkNum: 8 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 72 - __MAX_OF_PullRowNum: 14 - __MIN_OF_PullRowNum: 6 - PullTotalTime: 240ns - __MAX_OF_PullTotalTime: 350ns - __MIN_OF_PullTotalTime: 170ns - PushChunkNum: 8 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 72 - __MAX_OF_PushRowNum: 14 - __MIN_OF_PushRowNum: 6 - PushTotalTime: 58.937us - __MAX_OF_PushTotalTime: 80.011us - __MIN_OF_PushTotalTime: 42.381us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 10.271us - __MAX_OF_CommonSubExprComputeTime: 15.080us - __MIN_OF_CommonSubExprComputeTime: 6.220us - ExprComputeTime: 45.201us - __MAX_OF_ExprComputeTime: 59.171us - __MIN_OF_ExprComputeTime: 33.321us CHUNK_ACCUMULATE (plan_node_id=11): CommonMetrics: - IsSubordinate - OperatorTotalTime: 2.231us - __MAX_OF_OperatorTotalTime: 3.231us - __MIN_OF_OperatorTotalTime: 1.630us - OutputChunkBytes: 5.713 KB - __MAX_OF_OutputChunkBytes: 1.081 KB - __MIN_OF_OutputChunkBytes: 474.000 B - PullChunkNum: 8 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 72 - __MAX_OF_PullRowNum: 14 - __MIN_OF_PullRowNum: 6 - PullTotalTime: 224ns - __MAX_OF_PullTotalTime: 421ns - __MIN_OF_PullTotalTime: 171ns - PushChunkNum: 8 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 72 - __MAX_OF_PushRowNum: 14 - __MIN_OF_PushRowNum: 6 - PushTotalTime: 1.423us - __MAX_OF_PushTotalTime: 2.300us - __MIN_OF_PushTotalTime: 940ns UniqueMetrics: OLAP_SCAN (plan_node_id=11): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 651.979us - __MAX_OF_OperatorTotalTime: 768.350us - __MIN_OF_OperatorTotalTime: 459.011us - OutputChunkBytes: 5.713 KB - __MAX_OF_OutputChunkBytes: 1.081 KB - __MIN_OF_OutputChunkBytes: 474.000 B - PullChunkNum: 8 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 1 - PullRowNum: 72 - __MAX_OF_PullRowNum: 14 - __MIN_OF_PullRowNum: 6 - PullTotalTime: 444.770us - __MAX_OF_PullTotalTime: 565.505us - __MIN_OF_PullTotalTime: 280.616us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - MorselQueueType: fixed_morsel_queue - NumHeavyExprs: 0 - Predicates: 49: tos IS NOT NULL, 50: cpu IS NOT NULL, DictDecode(103: index_name, [ IN ('正常启动占比', '冷启动占比')]) - Rollup: dim_perf_cpu_target_index_value_v2 - SharedScan: False - Table: dim_perf_cpu_target_index_value_v2 - BytesRead: 7.708 KB - __MAX_OF_BytesRead: 1.351 KB - __MIN_OF_BytesRead: 719.000 B - CachedPagesNum: 216 - __MAX_OF_CachedPagesNum: 27 - __MIN_OF_CachedPagesNum: 27 - ChunkBufferCapacity: 512 - CompressedBytesRead: 0.000 B - DefaultChunkBufferCapacity: 512 - IOTaskExecTime: 642.193us - __MAX_OF_IOTaskExecTime: 826.670us - __MIN_OF_IOTaskExecTime: 441.520us - CreateSegmentIter: 106.265us - __MAX_OF_CreateSegmentIter: 143.914us - __MIN_OF_CreateSegmentIter: 59.462us - DictDecode: 3.366us - __MAX_OF_DictDecode: 5.020us - __MIN_OF_DictDecode: 2.560us - DictDecodeCount: 216 - __MAX_OF_DictDecodeCount: 42 - __MIN_OF_DictDecodeCount: 18 - GetDelVec: 0ns - GetDeltaColumnGroup: 36.048us - __MAX_OF_GetDeltaColumnGroup: 89.592us - __MIN_OF_GetDeltaColumnGroup: 6.400us - GetRowsets: 9.068us - __MAX_OF_GetRowsets: 10.560us - __MIN_OF_GetRowsets: 7.890us - IOTime: 0ns - LateMaterialize: 44.244us - __MAX_OF_LateMaterialize: 63.121us - __MIN_OF_LateMaterialize: 30.821us - LateMaterializeRows: 72 - __MAX_OF_LateMaterializeRows: 14 - __MIN_OF_LateMaterializeRows: 6 - ReadPKIndex: 0ns - SegmentInit: 235.289us - __MAX_OF_SegmentInit: 335.108us - __MIN_OF_SegmentInit: 169.284us - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 5.776us - __MAX_OF_BitmapIndexIteratorInit: 10.850us - __MIN_OF_BitmapIndexIteratorInit: 3.429us - BloomFilterFilter: 556ns - __MAX_OF_BloomFilterFilter: 840ns - __MIN_OF_BloomFilterFilter: 310ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 104.522us - __MAX_OF_ColumnIteratorInit: 145.664us - __MIN_OF_ColumnIteratorInit: 76.111us - GetVectorRowRangesTime: 0ns - GinFilter: 0ns - GinFilterRows: 0 - ProcessVectorDistanceAndIdTime: 0ns - RemainingRowsAfterShortKeyFilter: 288 - __MAX_OF_RemainingRowsAfterShortKeyFilter: 56 - __MIN_OF_RemainingRowsAfterShortKeyFilter: 24 - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 29.721us - __MAX_OF_ShortKeyFilter: 44.751us - __MIN_OF_ShortKeyFilter: 17.041us - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 11.501us - __MAX_OF_ZoneMapIndexFilter: 17.550us - __MIN_OF_ZoneMapIndexFilter: 7.001us - ZoneMapIndexFilterRows: 0 - SegmentRead: 20.323us - __MAX_OF_SegmentRead: 29.911us - __MIN_OF_SegmentRead: 15.731us - BlockFetch: 8.541us - __MAX_OF_BlockFetch: 13.199us - __MIN_OF_BlockFetch: 4.390us - BlockFetchCount: 8 - __MAX_OF_BlockFetchCount: 1 - __MIN_OF_BlockFetchCount: 1 - BlockSeek: 18.839us - __MAX_OF_BlockSeek: 33.462us - __MIN_OF_BlockSeek: 13.190us - BlockSeekCount: 8 - __MAX_OF_BlockSeekCount: 1 - __MIN_OF_BlockSeekCount: 1 - ChunkCopy: 2.336us - __MAX_OF_ChunkCopy: 3.700us - __MIN_OF_ChunkCopy: 920ns - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 3.033us - __MAX_OF_PredFilter: 4.310us - __MIN_OF_PredFilter: 1.840us - PredFilterRows: 216 - __MAX_OF_PredFilterRows: 42 - __MIN_OF_PredFilterRows: 18 - RowsetsReadCount: 16 - __MAX_OF_RowsetsReadCount: 2 - __MIN_OF_RowsetsReadCount: 2 - SegmentsReadCount: 8 - __MAX_OF_SegmentsReadCount: 1 - __MIN_OF_SegmentsReadCount: 1 - TotalColumnsDataPageCount: 72 - __MAX_OF_TotalColumnsDataPageCount: 9 - __MIN_OF_TotalColumnsDataPageCount: 9 - IOTaskWaitTime: 87.353us - __MAX_OF_IOTaskWaitTime: 152.333us - __MIN_OF_IOTaskWaitTime: 45.781us - MorselsCount: 8 - __MAX_OF_MorselsCount: 1 - __MIN_OF_MorselsCount: 1 - PeakChunkBufferMemoryUsage: 181.883 KB - PeakChunkBufferSize: 2 - PeakIOTasks: 1 - PeakScanTaskQueueSize: 7 - __MAX_OF_PeakScanTaskQueueSize: 2 - __MIN_OF_PeakScanTaskQueueSize: 0 - PrepareChunkSourceTime: 369.383us - __MAX_OF_PrepareChunkSourceTime: 426.301us - __MIN_OF_PrepareChunkSourceTime: 233.336us - PushdownAccessPaths: 0 - PushdownPredicates: 3 - RawRowsRead: 288 - __MAX_OF_RawRowsRead: 56 - __MIN_OF_RawRowsRead: 24 - ReadPagesNum: 216 - __MAX_OF_ReadPagesNum: 27 - __MIN_OF_ReadPagesNum: 27 - RowsRead: 72 - __MAX_OF_RowsRead: 14 - __MIN_OF_RowsRead: 6 - RuntimeFilterEvalTime: 0ns - RuntimeFilterInputRows: 0 - RuntimeFilterOutputRows: 0 - ScanTime: 729.546us - __MAX_OF_ScanTime: 958.653us - __MIN_OF_ScanTime: 517.822us - SubmitTaskCount: 8 - __MAX_OF_SubmitTaskCount: 1 - __MIN_OF_SubmitTaskCount: 1 - SubmitTaskTime: 35.195us - __MAX_OF_SubmitTaskTime: 95.632us - __MIN_OF_SubmitTaskTime: 12.550us - TabletCount: 8 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 129.100us - __MAX_OF_ActiveTime: 290.727us - __MIN_OF_ActiveTime: 79.642us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 8 - DriverTotalTime: 394.646us - __MAX_OF_DriverTotalTime: 499.382us - __MIN_OF_DriverTotalTime: 154.834us - PeakDriverQueueSize: 26 - __MAX_OF_PeakDriverQueueSize: 6 - __MIN_OF_PeakDriverQueueSize: 0 - ScheduleCount: 8 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - TotalDegreeOfParallelism: 8 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=11): CommonMetrics: - IsSubordinate - OperatorTotalTime: 730ns - __MAX_OF_OperatorTotalTime: 1.050us - __MIN_OF_OperatorTotalTime: 221ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: OLAP_SCAN_PREPARE (plan_node_id=11): CommonMetrics: - IsSubordinate - OperatorTotalTime: 127.989us - __MAX_OF_OperatorTotalTime: 291.978us - __MIN_OF_OperatorTotalTime: 77.572us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 118.541us - __MAX_OF_PullTotalTime: 277.817us - __MIN_OF_PullTotalTime: 72.092us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 4.349us - __MAX_OF_CaptureTabletRowsetsTime: 8.140us - __MIN_OF_CaptureTabletRowsetsTime: 2.791us Fragment 3: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019ae23f-6959-7fd3-9bc7-260d0d07c42c - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 8.439ms - InitialProcessDriverCount: 242 - InitialProcessMem: 45.163 GB - InstanceAllocatedMemoryUsage: 5.866 MB - InstanceDeallocatedMemoryUsage: 6.725 MB - InstanceNum: 1 - InstancePeakMemoryUsage: 2.738 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 25.347us - __MAX_OF_ActiveTime: 148.074us - __MIN_OF_ActiveTime: 4.970us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 12.443ms - __MAX_OF_DriverTotalTime: 13.331ms - __MIN_OF_DriverTotalTime: 11.555ms - PeakDriverQueueSize: 1.723K (1723) - __MAX_OF_PeakDriverQueueSize: 52 - __MIN_OF_PeakDriverQueueSize: 15 - PendingTime: 0ns - InputEmptyTime: 8.861ms - __MAX_OF_InputEmptyTime: 8.942ms - __MIN_OF_InputEmptyTime: 8.779ms - FirstInputEmptyTime: 8.861ms - __MAX_OF_FirstInputEmptyTime: 8.942ms - __MIN_OF_FirstInputEmptyTime: 8.779ms - PendingFinishTime: 2.837ms - __MAX_OF_PendingFinishTime: 3.816ms - __MIN_OF_PendingFinishTime: 1.707ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 12.418ms - __MAX_OF_ScheduleTime: 13.299ms - __MIN_OF_ScheduleTime: 11.465ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=8): CommonMetrics: - OperatorTotalTime: 17.753us - __MAX_OF_OperatorTotalTime: 123.463us - __MIN_OF_OperatorTotalTime: 1.580us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 2 - __MAX_OF_PushRowNum: 1 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 566ns - __MAX_OF_PushTotalTime: 14.261us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ChannelNum: 1 - DestFragments: 019ae23f69597fd3-9bc7260d0d07c42a - DestID: 8 - PartType: UNPARTITIONED - BytesPassThrough: 263.000 B - __MAX_OF_BytesPassThrough: 134.000 B - __MIN_OF_BytesPassThrough: 0.000 B - BytesSent: 0.000 B - BytesUnsent: 0.000 B - CompressTime: 0ns - CompressedBytes: 0.000 B - NetworkBandwidth: 0.000 B/sec - NetworkTime: 1.198ms - OverallThroughput: 0.000 B/sec - OverallTime: 1.714ms - PassThroughBufferPeakMemoryUsage: 0.000 B - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 399.553us - RpcCount: 3 - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 1.972ms AGGREGATE_BLOCKING_SOURCE (plan_node_id=7): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 21.163us - __MAX_OF_OperatorTotalTime: 76.011us - __MIN_OF_OperatorTotalTime: 12.101us - OutputChunkBytes: 103.000 B - __MAX_OF_OutputChunkBytes: 54.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 2 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 2 - __MAX_OF_PullRowNum: 1 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 1.998us - __MAX_OF_PullTotalTime: 51.971us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 12.424us - __MAX_OF_ActiveTime: 89.472us - __MIN_OF_ActiveTime: 3.289us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 8.931ms - __MAX_OF_DriverTotalTime: 9.029ms - __MIN_OF_DriverTotalTime: 8.809ms - PeakDriverQueueSize: 1.224K (1224) - __MAX_OF_PeakDriverQueueSize: 49 - __MIN_OF_PeakDriverQueueSize: 2 - PendingTime: 0ns - InputEmptyTime: 8.579ms - __MAX_OF_InputEmptyTime: 8.609ms - __MIN_OF_InputEmptyTime: 8.544ms - FirstInputEmptyTime: 8.579ms - __MAX_OF_FirstInputEmptyTime: 8.609ms - __MIN_OF_FirstInputEmptyTime: 8.544ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 8.918ms - __MAX_OF_ScheduleTime: 9.022ms - __MIN_OF_ScheduleTime: 8.801ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=7): CommonMetrics: - OperatorTotalTime: 15.313us - __MAX_OF_OperatorTotalTime: 72.263us - __MIN_OF_OperatorTotalTime: 3.810us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 4 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 2.053us - __MAX_OF_PushTotalTime: 61.012us - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - AggregateFunctions: max(100: pre_generation_device), max(89: case), max(90: case) - GroupingKeys: 82: tos, 83: device - AggComputeTime: 1.860us - __MAX_OF_AggComputeTime: 55.842us - __MIN_OF_AggComputeTime: 0ns - AggFuncComputeTime: 137ns - __MAX_OF_AggFuncComputeTime: 3.320us - __MIN_OF_AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 152ns - __MAX_OF_ExprComputeTime: 4.140us - __MIN_OF_ExprComputeTime: 0ns - ExprReleaseTime: 51ns - __MAX_OF_ExprReleaseTime: 1.320us - __MIN_OF_ExprReleaseTime: 0ns - GetResultsTime: 1.367us - __MAX_OF_GetResultsTime: 34.011us - __MIN_OF_GetResultsTime: 0ns - HashTableMemoryUsage: 265.191 KB - __MAX_OF_HashTableMemoryUsage: 132.057 KB - __MIN_OF_HashTableMemoryUsage: 24.000 B - HashTableSize: 2 - __MAX_OF_HashTableSize: 1 - __MIN_OF_HashTableSize: 0 - InputRowCount: 4 - __MAX_OF_InputRowCount: 2 - __MIN_OF_InputRowCount: 0 - PassThroughRowCount: 0 - ResultAggAppendTime: 133ns - __MAX_OF_ResultAggAppendTime: 4.300us - __MIN_OF_ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 50ns - __MAX_OF_ResultGroupByAppendTime: 1.390us - __MIN_OF_ResultGroupByAppendTime: 0ns - ResultIteratorTime: 668ns - __MAX_OF_ResultIteratorTime: 17.711us - __MIN_OF_ResultIteratorTime: 0ns - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns LOCAL_EXCHANGE_SOURCE (plan_node_id=7): CommonMetrics: - IsSubordinate - OperatorTotalTime: 2.760us - __MAX_OF_OperatorTotalTime: 17.450us - __MIN_OF_OperatorTotalTime: 1.093us - OutputChunkBytes: 183.000 B - __MAX_OF_OutputChunkBytes: 96.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 2 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 4 - __MAX_OF_PullRowNum: 2 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 628ns - __MAX_OF_PullTotalTime: 15.580us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 270.010us - __MAX_OF_ActiveTime: 500.382us - __MIN_OF_ActiveTime: 189.445us - BlockByInputEmpty: 11 - __MAX_OF_BlockByInputEmpty: 2 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 8.277ms - __MAX_OF_DriverTotalTime: 9.023ms - __MIN_OF_DriverTotalTime: 8.084ms - PeakDriverQueueSize: 23 - __MAX_OF_PeakDriverQueueSize: 5 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - PreconditionBlockTime: 7.775ms - __MAX_OF_PreconditionBlockTime: 7.819ms - __MIN_OF_PreconditionBlockTime: 7.745ms - ScheduleCount: 21 - __MAX_OF_ScheduleCount: 3 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 8.007ms - __MAX_OF_ScheduleTime: 8.522ms - __MIN_OF_ScheduleTime: 7.846ms - TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=7): CommonMetrics: - IsSubordinate - OperatorTotalTime: 12.788us - __MAX_OF_OperatorTotalTime: 108.193us - __MIN_OF_OperatorTotalTime: 400ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 4 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 3.056us - __MAX_OF_PushTotalTime: 15.450us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 48 - Type: Partition(BUCKET_SHUFFLE_HASH_PARTITIONED) - LocalExchangePeakMemoryUsage: 0.000 B PROJECT (plan_node_id=6): CommonMetrics: - OperatorTotalTime: 7.185us - __MAX_OF_OperatorTotalTime: 23.274us - __MIN_OF_OperatorTotalTime: 2.860us - OutputChunkBytes: 183.000 B - __MAX_OF_OutputChunkBytes: 96.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 2 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 4 - __MAX_OF_PullRowNum: 2 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 93ns - __MAX_OF_PullTotalTime: 160ns - __MIN_OF_PullTotalTime: 60ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 4 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 4.035us - __MAX_OF_PushTotalTime: 19.972us - __MIN_OF_PushTotalTime: 220ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 24ns - __MAX_OF_CommonSubExprComputeTime: 180ns - __MIN_OF_CommonSubExprComputeTime: 0ns - ExprComputeTime: 3.528us - __MAX_OF_ExprComputeTime: 17.961us - __MIN_OF_ExprComputeTime: 0ns CHUNK_ACCUMULATE (plan_node_id=5): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.300us - __MAX_OF_OperatorTotalTime: 2.267us - __MIN_OF_OperatorTotalTime: 971ns - OutputChunkBytes: 183.000 B - __MAX_OF_OutputChunkBytes: 96.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 2 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 4 - __MAX_OF_PullRowNum: 2 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 114ns - __MAX_OF_PullTotalTime: 198ns - __MIN_OF_PullTotalTime: 80ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 4 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 704ns - __MAX_OF_PushTotalTime: 1.310us - __MIN_OF_PushTotalTime: 500ns UniqueMetrics: OLAP_SCAN (plan_node_id=5): CommonMetrics: - RuntimeFilterDesc: <0: BloomFilter> - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 4 - __MAX_OF_JoinRuntimeFilterInputRows: 2 - __MIN_OF_JoinRuntimeFilterInputRows: 2 - JoinRuntimeFilterOutputRows: 4 - __MAX_OF_JoinRuntimeFilterOutputRows: 2 - __MIN_OF_JoinRuntimeFilterOutputRows: 2 - JoinRuntimeFilterTime: 645ns - __MAX_OF_JoinRuntimeFilterTime: 700ns - __MIN_OF_JoinRuntimeFilterTime: 590ns - OperatorTotalTime: 386.727us - __MAX_OF_OperatorTotalTime: 505.114us - __MIN_OF_OperatorTotalTime: 316.178us - OutputChunkBytes: 183.000 B - __MAX_OF_OutputChunkBytes: 96.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 2 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 4 - __MAX_OF_PullRowNum: 2 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 201.761us - __MAX_OF_PullTotalTime: 309.898us - __MIN_OF_PullTotalTime: 139.603us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - MorselQueueType: fixed_morsel_queue - NumHeavyExprs: 0 - Predicates: DictDecode(101: index_name, [ IN ('正常启动占比', '冷启动占比')]) - Rollup: dim_perf_pre_generation_target_value - SharedScan: False - Table: dim_perf_pre_generation_target_value - BytesRead: 646.000 B - __MAX_OF_BytesRead: 329.000 B - __MIN_OF_BytesRead: 0.000 B - CachedPagesNum: 30 - __MAX_OF_CachedPagesNum: 15 - __MIN_OF_CachedPagesNum: 0 - ChunkBufferCapacity: 640 - CompressedBytesRead: 0.000 B - DefaultChunkBufferCapacity: 640 - IOTaskExecTime: 130.091us - __MAX_OF_IOTaskExecTime: 414.530us - __MIN_OF_IOTaskExecTime: 23.150us - CreateSegmentIter: 17.555us - __MAX_OF_CreateSegmentIter: 34.341us - __MIN_OF_CreateSegmentIter: 9.590us - DictDecode: 1.600us - __MAX_OF_DictDecode: 2.050us - __MIN_OF_DictDecode: 1.150us - DictDecodeCount: 8 - __MAX_OF_DictDecodeCount: 4 - __MIN_OF_DictDecodeCount: 4 - GetDelVec: 0ns - GetDeltaColumnGroup: 977ns - __MAX_OF_GetDeltaColumnGroup: 6.010us - __MIN_OF_GetDeltaColumnGroup: 0ns - GetRowsets: 6.021us - __MAX_OF_GetRowsets: 9.630us - __MIN_OF_GetRowsets: 3.730us - IOTime: 0ns - LateMaterialize: 16.405us - __MAX_OF_LateMaterialize: 16.870us - __MIN_OF_LateMaterialize: 15.940us - LateMaterializeRows: 4 - __MAX_OF_LateMaterializeRows: 2 - __MIN_OF_LateMaterializeRows: 2 - ReadPKIndex: 0ns - SegmentInit: 35.388us - __MAX_OF_SegmentInit: 181.314us - __MIN_OF_SegmentInit: 0ns - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 999ns - __MAX_OF_BitmapIndexIteratorInit: 5.751us - __MIN_OF_BitmapIndexIteratorInit: 0ns - BloomFilterFilter: 98ns - __MAX_OF_BloomFilterFilter: 570ns - __MIN_OF_BloomFilterFilter: 0ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 14.998us - __MAX_OF_ColumnIteratorInit: 75.681us - __MIN_OF_ColumnIteratorInit: 0ns - GetVectorRowRangesTime: 0ns - GinFilter: 0ns - GinFilterRows: 0 - ProcessVectorDistanceAndIdTime: 0ns - RemainingRowsAfterShortKeyFilter: 14 - __MAX_OF_RemainingRowsAfterShortKeyFilter: 7 - __MIN_OF_RemainingRowsAfterShortKeyFilter: 0 - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 4.819us - __MAX_OF_ShortKeyFilter: 27.560us - __MIN_OF_ShortKeyFilter: 0ns - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 1.477us - __MAX_OF_ZoneMapIndexFilter: 7.671us - __MIN_OF_ZoneMapIndexFilter: 0ns - ZoneMapIndexFilterRows: 0 - SegmentRead: 3.445us - __MAX_OF_SegmentRead: 19.332us - __MIN_OF_SegmentRead: 0ns - BlockFetch: 1.289us - __MAX_OF_BlockFetch: 8.190us - __MIN_OF_BlockFetch: 0ns - BlockFetchCount: 2 - __MAX_OF_BlockFetchCount: 1 - __MIN_OF_BlockFetchCount: 0 - BlockSeek: 2.503us - __MAX_OF_BlockSeek: 14.600us - __MIN_OF_BlockSeek: 0ns - BlockSeekCount: 2 - __MAX_OF_BlockSeekCount: 1 - __MIN_OF_BlockSeekCount: 0 - ChunkCopy: 305ns - __MAX_OF_ChunkCopy: 1.670us - __MIN_OF_ChunkCopy: 0ns - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 487ns - __MAX_OF_PredFilter: 3.009us - __MIN_OF_PredFilter: 0ns - PredFilterRows: 10 - __MAX_OF_PredFilterRows: 5 - __MIN_OF_PredFilterRows: 0 - RowsetsReadCount: 20 - __MAX_OF_RowsetsReadCount: 2 - __MIN_OF_RowsetsReadCount: 2 - SegmentsReadCount: 2 - __MAX_OF_SegmentsReadCount: 1 - __MIN_OF_SegmentsReadCount: 0 - TotalColumnsDataPageCount: 10 - __MAX_OF_TotalColumnsDataPageCount: 5 - __MIN_OF_TotalColumnsDataPageCount: 0 - IOTaskWaitTime: 74.154us - __MAX_OF_IOTaskWaitTime: 155.764us - __MIN_OF_IOTaskWaitTime: 34.211us - MorselsCount: 10 - __MAX_OF_MorselsCount: 1 - __MIN_OF_MorselsCount: 1 - PeakChunkBufferMemoryUsage: 500.083 KB - PeakChunkBufferSize: 1 - PeakIOTasks: 1 - PeakScanTaskQueueSize: 13 - __MAX_OF_PeakScanTaskQueueSize: 3 - __MIN_OF_PeakScanTaskQueueSize: 0 - PrepareChunkSourceTime: 139.299us - __MAX_OF_PrepareChunkSourceTime: 160.574us - __MIN_OF_PrepareChunkSourceTime: 107.252us - PushdownAccessPaths: 0 - PushdownPredicates: 4 - RawRowsRead: 14 - __MAX_OF_RawRowsRead: 7 - __MIN_OF_RawRowsRead: 0 - ReadPagesNum: 30 - __MAX_OF_ReadPagesNum: 15 - __MIN_OF_ReadPagesNum: 0 - RowsRead: 4 - __MAX_OF_RowsRead: 2 - __MIN_OF_RowsRead: 0 - RuntimeFilterEvalTime: 778ns - __MAX_OF_RuntimeFilterEvalTime: 3.970us - __MIN_OF_RuntimeFilterEvalTime: 0ns - RuntimeFilterInputRows: 4 - __MAX_OF_RuntimeFilterInputRows: 2 - __MIN_OF_RuntimeFilterInputRows: 0 - RuntimeFilterOutputRows: 4 - __MAX_OF_RuntimeFilterOutputRows: 2 - __MIN_OF_RuntimeFilterOutputRows: 0 - ScanTime: 204.245us - __MAX_OF_ScanTime: 478.261us - __MIN_OF_ScanTime: 95.393us - SubmitTaskCount: 10 - __MAX_OF_SubmitTaskCount: 1 - __MIN_OF_SubmitTaskCount: 1 - SubmitTaskTime: 48.802us - __MAX_OF_SubmitTaskTime: 154.654us - __MIN_OF_SubmitTaskTime: 9.471us - TabletCount: 10 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 46.772us - __MAX_OF_ActiveTime: 62.161us - __MIN_OF_ActiveTime: 30.611us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 7.830ms - __MAX_OF_DriverTotalTime: 7.892ms - __MIN_OF_DriverTotalTime: 7.764ms - PeakDriverQueueSize: 22 - __MAX_OF_PeakDriverQueueSize: 4 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - PreconditionBlockTime: 7.714ms - __MAX_OF_PreconditionBlockTime: 7.742ms - __MIN_OF_PreconditionBlockTime: 7.694ms - ScheduleCount: 10 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 7.783ms - __MAX_OF_ScheduleTime: 7.846ms - __MIN_OF_ScheduleTime: 7.725ms - TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=5): CommonMetrics: - IsSubordinate - OperatorTotalTime: 481ns - __MAX_OF_OperatorTotalTime: 710ns - __MIN_OF_OperatorTotalTime: 230ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: OLAP_SCAN_PREPARE (plan_node_id=5): CommonMetrics: - IsSubordinate - RuntimeFilterDesc: <0: BloomFilter> - OperatorTotalTime: 49.733us - __MAX_OF_OperatorTotalTime: 66.872us - __MIN_OF_OperatorTotalTime: 32.021us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 41.833us - __MAX_OF_PullTotalTime: 56.732us - __MIN_OF_PullTotalTime: 27.711us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 3.810us - __MAX_OF_CaptureTabletRowsetsTime: 9.010us - __MIN_OF_CaptureTabletRowsetsTime: 2.130us Fragment 4: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019ae23f-6959-7fd3-9bc7-260d0d07c42d - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 12.391ms - FragmentInstancePrepareTime: 14.975ms - prepare-pipeline-driver: 11.413ms - InitialProcessDriverCount: 470 - InitialProcessMem: 45.169 GB - InstanceAllocatedMemoryUsage: 13.669 GB - InstanceDeallocatedMemoryUsage: 12.087 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 1.806 GB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 144.970ms - __MAX_OF_ActiveTime: 167.001ms - __MIN_OF_ActiveTime: 119.515ms - BlockByInputEmpty: 19 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 3 - __MAX_OF_BlockByOutputFull: 1 - __MIN_OF_BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 315.625ms - __MAX_OF_DriverTotalTime: 315.971ms - __MIN_OF_DriverTotalTime: 315.318ms - PeakDriverQueueSize: 2.156K (2156) - __MAX_OF_PeakDriverQueueSize: 101 - __MIN_OF_PeakDriverQueueSize: 9 - PendingTime: 0ns - InputEmptyTime: 55.698ms - __MAX_OF_InputEmptyTime: 82.615ms - __MIN_OF_InputEmptyTime: 36.749ms - FirstInputEmptyTime: 54.107ms - __MAX_OF_FirstInputEmptyTime: 82.615ms - __MIN_OF_FirstInputEmptyTime: 27.711ms - FollowupInputEmptyTime: 1.590ms - __MAX_OF_FollowupInputEmptyTime: 18.925ms - __MIN_OF_FollowupInputEmptyTime: 0ns - OutputFullTime: 6.166ms - __MAX_OF_OutputFullTime: 103.270ms - __MIN_OF_OutputFullTime: 0ns - PendingFinishTime: 94.602ms - __MAX_OF_PendingFinishTime: 123.204ms - __MIN_OF_PendingFinishTime: 745.938us - ScheduleCount: 88 - __MAX_OF_ScheduleCount: 4 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 170.654ms - __MAX_OF_ScheduleTime: 196.204ms - __MIN_OF_ScheduleTime: 148.680ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 18 - __MAX_OF_YieldByTimeLimit: 1 - __MIN_OF_YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=2): CommonMetrics: - OperatorTotalTime: 141.697ms - __MAX_OF_OperatorTotalTime: 164.380ms - __MIN_OF_OperatorTotalTime: 116.174ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.825K (1825) - __MAX_OF_PushChunkNum: 41 - __MIN_OF_PushChunkNum: 34 - PushRowNum: 4.013M (4012848) - __MAX_OF_PushRowNum: 96.843K (96843) - __MIN_OF_PushRowNum: 69.385K (69385) - PushTotalTime: 99.319ms - __MAX_OF_PushTotalTime: 126.707ms - __MIN_OF_PushTotalTime: 76.218ms - SetFinishingTime: 42.375ms - __MAX_OF_SetFinishingTime: 56.448ms - __MIN_OF_SetFinishingTime: 11.327ms UniqueMetrics: - ChannelNum: 1 - DestFragments: 019ae23f69597fd3-9bc7260d0d07c42a - DestID: 2 - PartType: HASH_PARTITIONED - PipelineLevelShuffle: Yes - ShuffleNumPerChannel: 48 - TotalShuffleNum: 48 - BytesPassThrough: 963.963 MB - __MAX_OF_BytesPassThrough: 23.310 MB - __MIN_OF_BytesPassThrough: 16.663 MB - BytesSent: 0.000 B - BytesUnsent: 0.000 B - CompressTime: 0ns - CompressedBytes: 0.000 B - NetworkBandwidth: 0.000 B/sec - NetworkTime: 117.118ms - OverallThroughput: 0.000 B/sec - OverallTime: 164.542ms - PassThroughBufferPeakMemoryUsage: 1.498 MB - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 1.347ms - RpcCount: 2.305K (2305) - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 83.790K (83790) - __MAX_OF_ShuffleChunkAppendCounter: 1.910K (1910) - __MIN_OF_ShuffleChunkAppendCounter: 1.561K (1561) - ShuffleChunkAppendTime: 78.510ms - __MAX_OF_ShuffleChunkAppendTime: 102.388ms - __MIN_OF_ShuffleChunkAppendTime: 58.592ms - ShuffleHashTime: 18.489ms - __MAX_OF_ShuffleHashTime: 26.780ms - __MIN_OF_ShuffleHashTime: 14.945ms - WaitTime: 104.208ms AGGREGATE_STREAMING_SOURCE (plan_node_id=1): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 2.457ms - __MAX_OF_OperatorTotalTime: 9.308ms - __MIN_OF_OperatorTotalTime: 676.557us - OutputChunkBytes: 963.366 MB - __MAX_OF_OutputChunkBytes: 23.298 MB - __MIN_OF_OutputChunkBytes: 16.651 MB - PullChunkNum: 1.825K (1825) - __MAX_OF_PullChunkNum: 41 - __MIN_OF_PullChunkNum: 34 - PullRowNum: 4.013M (4012848) - __MAX_OF_PullRowNum: 96.843K (96843) - __MIN_OF_PullRowNum: 69.385K (69385) - PullTotalTime: 2.399ms - __MAX_OF_PullTotalTime: 9.244ms - __MIN_OF_PullTotalTime: 634.747us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 14.433ms - __MAX_OF_ActiveTime: 27.030ms - __MIN_OF_ActiveTime: 8.878ms - BlockByInputEmpty: 523 - __MAX_OF_BlockByInputEmpty: 13 - __MIN_OF_BlockByInputEmpty: 7 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 113.035ms - __MAX_OF_DriverTotalTime: 113.624ms - __MIN_OF_DriverTotalTime: 112.197ms - PeakDriverQueueSize: 3.316K (3316) - __MAX_OF_PeakDriverQueueSize: 106 - __MIN_OF_PeakDriverQueueSize: 29 - PendingTime: 0ns - InputEmptyTime: 60.205ms - __MAX_OF_InputEmptyTime: 78.322ms - __MIN_OF_InputEmptyTime: 48.994ms - FirstInputEmptyTime: 10.649ms - __MAX_OF_FirstInputEmptyTime: 21.386ms - __MIN_OF_FirstInputEmptyTime: 4.519ms - FollowupInputEmptyTime: 49.556ms - __MAX_OF_FollowupInputEmptyTime: 70.388ms - __MIN_OF_FollowupInputEmptyTime: 34.720ms - ScheduleCount: 571 - __MAX_OF_ScheduleCount: 14 - __MIN_OF_ScheduleCount: 8 - ScheduleTime: 98.602ms - __MAX_OF_ScheduleTime: 104.396ms - __MIN_OF_ScheduleTime: 86.356ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_STREAMING_SINK (plan_node_id=1): CommonMetrics: - OperatorTotalTime: 13.434ms - __MAX_OF_OperatorTotalTime: 26.216ms - __MIN_OF_OperatorTotalTime: 8.046ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.982K (1982) - __MAX_OF_PushChunkNum: 42 - __MIN_OF_PushChunkNum: 41 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 97.103K (97103) - __MIN_OF_PushRowNum: 69.470K (69470) - PushTotalTime: 13.421ms - __MAX_OF_PushTotalTime: 26.206ms - __MIN_OF_PushTotalTime: 8.033ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - AggregateFunctions: sum(19: sn_cnt), sum(39: lag_sn_cnt), sum(29: launch_cnt), sum(30: cold_launch_cnt), sum(31: warm_launch_cnt), sum(32: hot_launch_cnt) - GroupingKeys: 2: rom_vr, 3: os_vr, 1: device, 5: brand, 7: cpu, 8: ram, 9: rom, 6: iso, 10: region, 11: country, 12: family, 13: sub_family, 14: market_name, 4: s_dt - AggComputeTime: 7.219ms - __MAX_OF_AggComputeTime: 20.496ms - __MIN_OF_AggComputeTime: 1.992ms - AggFuncComputeTime: 168.113us - __MAX_OF_AggFuncComputeTime: 890.789us - __MIN_OF_AggFuncComputeTime: 28.381us - ChunkBufferPeakMem: 19.889 MB - __MAX_OF_ChunkBufferPeakMem: 23.609 MB - __MIN_OF_ChunkBufferPeakMem: 16.505 MB - ChunkBufferPeakSize: 27 - __MAX_OF_ChunkBufferPeakSize: 31 - __MIN_OF_ChunkBufferPeakSize: 21 - ExprComputeTime: 397.066us - __MAX_OF_ExprComputeTime: 482.421us - __MIN_OF_ExprComputeTime: 338.112us - ExprReleaseTime: 1.090ms - __MAX_OF_ExprReleaseTime: 1.563ms - __MIN_OF_ExprReleaseTime: 870.230us - GetResultsTime: 2.287ms - __MAX_OF_GetResultsTime: 9.142ms - __MIN_OF_GetResultsTime: 532.023us - HashTableMemoryUsage: 67.644 MB - __MAX_OF_HashTableMemoryUsage: 5.270 MB - __MIN_OF_HashTableMemoryUsage: 413.008 KB - HashTableSize: 147.759K (147759) - __MAX_OF_HashTableSize: 14.046K (14046) - __MIN_OF_HashTableSize: 643 - InputRowCount: 4.022M (4021783) - __MAX_OF_InputRowCount: 97.103K (97103) - __MIN_OF_InputRowCount: 69.470K (69470) - PassThroughRowCount: 3.865M (3865089) - __MAX_OF_PassThroughRowCount: 93.852K (93852) - __MIN_OF_PassThroughRowCount: 64.599K (64599) - ResultAggAppendTime: 284.746us - __MAX_OF_ResultAggAppendTime: 1.213ms - __MIN_OF_ResultAggAppendTime: 34.201us - ResultGroupByAppendTime: 1.737ms - __MAX_OF_ResultGroupByAppendTime: 6.986ms - __MIN_OF_ResultGroupByAppendTime: 351.929us - ResultIteratorTime: 150.909us - __MAX_OF_ResultIteratorTime: 497.641us - __MIN_OF_ResultIteratorTime: 38.711us - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 4.747ms - __MAX_OF_StreamingTime: 11.165ms - __MIN_OF_StreamingTime: 3.229ms LOCAL_EXCHANGE_SOURCE (plan_node_id=1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 597.645us - __MAX_OF_OperatorTotalTime: 6.995ms - __MIN_OF_OperatorTotalTime: 403.293us - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 23.360 MB - __MIN_OF_OutputChunkBytes: 16.671 MB - PullChunkNum: 1.982K (1982) - __MAX_OF_PullChunkNum: 42 - __MIN_OF_PullChunkNum: 41 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 97.103K (97103) - __MIN_OF_PullRowNum: 69.470K (69470) - PullTotalTime: 593.560us - __MAX_OF_PullTotalTime: 6.992ms - __MIN_OF_PullTotalTime: 399.483us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 22.738ms - __MAX_OF_ActiveTime: 75.264ms - __MIN_OF_ActiveTime: 7.142ms - BlockByInputEmpty: 431 - __MAX_OF_BlockByInputEmpty: 16 - __MIN_OF_BlockByInputEmpty: 4 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 111.164ms - __MAX_OF_DriverTotalTime: 113.750ms - __MIN_OF_DriverTotalTime: 110.508ms - OverheadTime: 1.981ms - __MAX_OF_OverheadTime: 5.956ms - __MIN_OF_OverheadTime: 554.790us - PeakDriverQueueSize: 2.814K (2814) - __MAX_OF_PeakDriverQueueSize: 105 - __MIN_OF_PeakDriverQueueSize: 25 - PendingTime: 0ns - InputEmptyTime: 54.783ms - __MAX_OF_InputEmptyTime: 84.318ms - __MIN_OF_InputEmptyTime: 27.726ms - FirstInputEmptyTime: 1.510ms - __MAX_OF_FirstInputEmptyTime: 2.449ms - __MIN_OF_FirstInputEmptyTime: 501.992us - FollowupInputEmptyTime: 53.272ms - __MAX_OF_FollowupInputEmptyTime: 82.671ms - __MIN_OF_FollowupInputEmptyTime: 25.910ms - ScheduleCount: 479 - __MAX_OF_ScheduleCount: 17 - __MIN_OF_ScheduleCount: 5 - ScheduleTime: 88.426ms - __MAX_OF_ScheduleTime: 104.421ms - __MIN_OF_ScheduleTime: 35.243ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.280ms - __MAX_OF_OperatorTotalTime: 31.514ms - __MIN_OF_OperatorTotalTime: 67.620us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.982K (1982) - __MAX_OF_PushChunkNum: 67 - __MIN_OF_PushChunkNum: 26 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 139.960K (139960) - __MIN_OF_PushRowNum: 39.691K (39691) - PushTotalTime: 1.248ms - __MAX_OF_PushTotalTime: 31.514ms - __MIN_OF_PushTotalTime: 66.850us UniqueMetrics: - ShuffleNum: 48 - Type: Passthrough - LocalExchangePeakMemoryUsage: 278.333 MB CHUNK_ACCUMULATE (plan_node_id=0): CommonMetrics: - IsSubordinate - OperatorTotalTime: 2.836ms - __MAX_OF_OperatorTotalTime: 10.171ms - __MIN_OF_OperatorTotalTime: 510.477us - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 33.580 MB - __MIN_OF_OutputChunkBytes: 9.539 MB - PullChunkNum: 1.982K (1982) - __MAX_OF_PullChunkNum: 67 - __MIN_OF_PullChunkNum: 26 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 139.960K (139960) - __MIN_OF_PullRowNum: 39.691K (39691) - PullTotalTime: 5.876us - __MAX_OF_PullTotalTime: 10.130us - __MIN_OF_PullTotalTime: 3.512us - PushChunkNum: 2.310K (2310) - __MAX_OF_PushChunkNum: 83 - __MIN_OF_PushChunkNum: 31 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 139.960K (139960) - __MIN_OF_PushRowNum: 39.691K (39691) - PushTotalTime: 2.830ms - __MAX_OF_PushTotalTime: 10.166ms - __MIN_OF_PushTotalTime: 506.227us UniqueMetrics: OLAP_SCAN (plan_node_id=0): CommonMetrics: - RuntimeFilterDesc: <1: BloomFilter> - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 4.022M (4021783) - __MAX_OF_JoinRuntimeFilterInputRows: 139.960K (139960) - __MIN_OF_JoinRuntimeFilterInputRows: 39.691K (39691) - JoinRuntimeFilterOutputRows: 4.022M (4021783) - __MAX_OF_JoinRuntimeFilterOutputRows: 139.960K (139960) - __MIN_OF_JoinRuntimeFilterOutputRows: 39.691K (39691) - JoinRuntimeFilterTime: 10.011us - __MAX_OF_JoinRuntimeFilterTime: 20.085us - __MIN_OF_JoinRuntimeFilterTime: 3.538us - OperatorTotalTime: 16.639ms - __MAX_OF_OperatorTotalTime: 38.512ms - __MIN_OF_OperatorTotalTime: 4.990ms - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 33.580 MB - __MIN_OF_OutputChunkBytes: 9.539 MB - PullChunkNum: 2.310K (2310) - __MAX_OF_PullChunkNum: 83 - __MIN_OF_PullChunkNum: 31 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 139.960K (139960) - __MIN_OF_PullRowNum: 39.691K (39691) - PullTotalTime: 15.888ms - __MAX_OF_PullTotalTime: 37.804ms - __MIN_OF_PullTotalTime: 4.397ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - MorselQueueType: fixed_morsel_queue - NumHeavyExprs: 0 - Predicates: concat_ws('.', split_part(regexp_replace(3: os_vr, '^[a-zA-Z]+', ''), '.', 1), split_part(regexp_replace(3: os_vr, '^[a-zA-Z]+', ''), '.', 2)) IS NOT NULL, 7: cpu IS NOT NULL, 4: s_dt >= '2025-01-01', 2: rom_vr LIKE '%(%', 2: rom_vr LIKE '%-%' - Rollup: ads_perf_lch_google_app_launch_stage_di - SharedScan: False - Table: ads_perf_lch_google_app_launch_stage_di - BytesRead: 1.170 GB - __MAX_OF_BytesRead: 16.429 MB - __MIN_OF_BytesRead: 79.377 KB - CachedPagesNum: 36.905K (36905) - __MAX_OF_CachedPagesNum: 339 - __MIN_OF_CachedPagesNum: 47 - ChunkBufferCapacity: 3.072K (3072) - CompressedBytesRead: 0.000 B - DefaultChunkBufferCapacity: 3.072K (3072) - IOTaskExecTime: 35.428ms - __MAX_OF_IOTaskExecTime: 73.128ms - __MIN_OF_IOTaskExecTime: 2.365ms - CreateSegmentIter: 483.784us - __MAX_OF_CreateSegmentIter: 10.151ms - __MIN_OF_CreateSegmentIter: 116.263us - DictDecode: 6.057ms - __MAX_OF_DictDecode: 37.230ms - __MIN_OF_DictDecode: 8.480us - DictDecodeCount: 41.856M (41855685) - __MAX_OF_DictDecodeCount: 719.284K (719284) - __MIN_OF_DictDecodeCount: 12 - ExprFilterRows: 0 - ExprFilterTime: 10.667ms - __MAX_OF_ExprFilterTime: 31.901ms - __MIN_OF_ExprFilterTime: 56.971us - GetDelVec: 0ns - GetDeltaColumnGroup: 201.049us - __MAX_OF_GetDeltaColumnGroup: 9.823ms - __MIN_OF_GetDeltaColumnGroup: 2.980us - GetRowsets: 29.935us - __MAX_OF_GetRowsets: 762.940us - __MIN_OF_GetRowsets: 8.831us - IOTime: 0ns - LateMaterialize: 3.380ms - __MAX_OF_LateMaterialize: 16.181ms - __MIN_OF_LateMaterialize: 202.106us - LateMaterializeRows: 947.954K (947954) - __MAX_OF_LateMaterializeRows: 13.028K (13028) - __MIN_OF_LateMaterializeRows: 6 - ReadPKIndex: 0ns - SegmentInit: 2.068ms - __MAX_OF_SegmentInit: 23.824ms - __MIN_OF_SegmentInit: 723.888us - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 137.231us - __MAX_OF_BitmapIndexIteratorInit: 18.821ms - __MIN_OF_BitmapIndexIteratorInit: 18.371us - BloomFilterFilter: 1.992us - __MAX_OF_BloomFilterFilter: 27.482us - __MIN_OF_BloomFilterFilter: 870ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 762.406us - __MAX_OF_ColumnIteratorInit: 6.433ms - __MIN_OF_ColumnIteratorInit: 200.886us - GetVectorRowRangesTime: 0ns - GinFilter: 0ns - GinFilterRows: 0 - ProcessVectorDistanceAndIdTime: 0ns - RemainingRowsAfterShortKeyFilter: 16.223M (16222711) - __MAX_OF_RemainingRowsAfterShortKeyFilter: 178.504K (178504) - __MIN_OF_RemainingRowsAfterShortKeyFilter: 25.534K (25534) - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 103.971us - __MAX_OF_ShortKeyFilter: 551.524us - __MIN_OF_ShortKeyFilter: 42.071us - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 45.702us - __MAX_OF_ZoneMapIndexFilter: 94.823us - __MIN_OF_ZoneMapIndexFilter: 19.051us - ZoneMapIndexFilterRows: 147.456K (147456) - __MAX_OF_ZoneMapIndexFilterRows: 32.768K (32768) - __MIN_OF_ZoneMapIndexFilterRows: 0 - SegmentRead: 7.422ms - __MAX_OF_SegmentRead: 25.354ms - __MIN_OF_SegmentRead: 467.520us - BlockFetch: 5.529ms - __MAX_OF_BlockFetch: 23.822ms - __MIN_OF_BlockFetch: 148.352us - BlockFetchCount: 4.058K (4058) - __MAX_OF_BlockFetchCount: 54 - __MIN_OF_BlockFetchCount: 4 - BlockSeek: 142.711us - __MAX_OF_BlockSeek: 2.702ms - __MIN_OF_BlockSeek: 29.264us - BlockSeekCount: 9.790K (9790) - __MAX_OF_BlockSeekCount: 141 - __MIN_OF_BlockSeekCount: 1 - ChunkCopy: 78.957us - __MAX_OF_ChunkCopy: 267.448us - __MIN_OF_ChunkCopy: 1.170us - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 1.488ms - __MAX_OF_PredFilter: 5.336ms - __MIN_OF_PredFilter: 280.986us - PredFilterRows: 10.293M (10292677) - __MAX_OF_PredFilterRows: 135.561K (135561) - __MIN_OF_PredFilterRows: 11.692K (11692) - RowsetsReadCount: 1.408K (1408) - __MAX_OF_RowsetsReadCount: 12 - __MIN_OF_RowsetsReadCount: 4 - SegmentsReadCount: 704 - __MAX_OF_SegmentsReadCount: 6 - __MIN_OF_SegmentsReadCount: 2 - TotalColumnsDataPageCount: 33.068K (33068) - __MAX_OF_TotalColumnsDataPageCount: 340 - __MIN_OF_TotalColumnsDataPageCount: 52 - IOTaskWaitTime: 15.898ms - __MAX_OF_IOTaskWaitTime: 51.193ms - __MIN_OF_IOTaskWaitTime: 576.624us - MorselsCount: 704 - __MAX_OF_MorselsCount: 19 - __MIN_OF_MorselsCount: 10 - NonPushdownPredicates: 1 - PeakChunkBufferMemoryUsage: 815.275 MB - PeakChunkBufferSize: 39 - PeakIOTasks: 4 - PeakScanTaskQueueSize: 4.016K (4016) - __MAX_OF_PeakScanTaskQueueSize: 92 - __MIN_OF_PeakScanTaskQueueSize: 27 - PrepareChunkSourceTime: 5.294ms - __MAX_OF_PrepareChunkSourceTime: 14.840ms - __MIN_OF_PrepareChunkSourceTime: 3.242ms - PushdownAccessPaths: 0 - PushdownPredicates: 7 - RawRowsRead: 14.314M (14314460) - __MAX_OF_RawRowsRead: 178.504K (178504) - __MIN_OF_RawRowsRead: 15.696K (15696) - ReadPagesNum: 36.905K (36905) - __MAX_OF_ReadPagesNum: 339 - __MIN_OF_ReadPagesNum: 47 - RowsRead: 4.022M (4021783) - __MAX_OF_RowsRead: 60.706K (60706) - __MIN_OF_RowsRead: 6 - RuntimeFilterEvalTime: 138.661us - __MAX_OF_RuntimeFilterEvalTime: 15.781ms - __MIN_OF_RuntimeFilterEvalTime: 11.320us - RuntimeFilterInputRows: 13.237M (13236609) - __MAX_OF_RuntimeFilterInputRows: 134.739K (134739) - __MIN_OF_RuntimeFilterInputRows: 15.636K (15636) - RuntimeFilterOutputRows: 12.593M (12592727) - __MAX_OF_RuntimeFilterOutputRows: 132.003K (132003) - __MIN_OF_RuntimeFilterOutputRows: 15.636K (15636) - ScanTime: 51.326ms - __MAX_OF_ScanTime: 93.015ms - __MIN_OF_ScanTime: 24.075ms - SubmitTaskCount: 704 - __MAX_OF_SubmitTaskCount: 19 - __MIN_OF_SubmitTaskCount: 10 - SubmitTaskTime: 9.390ms - __MAX_OF_SubmitTaskTime: 25.261ms - __MIN_OF_SubmitTaskTime: 65.372us - TabletCount: 704 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 2.669ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverPrepareTime: 1.586ms - DriverTotalTime: 2.708ms - PeakDriverQueueSize: 0 - ScheduleCount: 1 - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=0): CommonMetrics: - IsSubordinate - OperatorTotalTime: 610ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: OLAP_SCAN_PREPARE (plan_node_id=0): CommonMetrics: - IsSubordinate - RuntimeFilterDesc: <1: BloomFilter> - OperatorTotalTime: 2.671ms - OutputChunkBytes: 0.000 B - PrepareTime: 1.568ms - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 2.662ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 1.562ms