Query: Summary: - Query ID: 019ade7b-029c-78e6-94b8-37f1d86718af - Start Time: 2025-12-02 09:53:14 - End Time: 2025-12-02 09:53:27 - Total: 12s500ms - 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 ORDER BY `日期` DESC, device - Warehouse - Variables: parallel_fragment_exec_instance_num=64,max_parallel_scan_instance_num=-1,pipeline_dop=64,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},"parallel_fragment_exec_instance_num":{"defaultValue":1,"actualValue":64},"enable_adaptive_sink_dop":{"defaultValue":false,"actualValue":true},"pipeline_dop":{"defaultValue":0,"actualValue":64},"enable_profile":{"defaultValue":false,"actualValue":true}} - Collect Profile Time: 0 - IsProfileAsync: true Planner: - -- Parser[1] 1ms - -- Total[1] 16ms - -- Analyzer[1] 1ms - -- Lock[1] 0 - -- AnalyzeDatabase[3] 0 - -- AnalyzeTemporaryTable[3] 0 - -- AnalyzeTable[3] 0 - -- Transformer[1] 2ms - -- Optimizer[1] 10ms - -- MVPreprocess[1] 0 - -- MVTextRewrite[1] 0 - -- RuleBaseOptimize[1] 5ms - -- CostBaseOptimize[1] 3ms - -- 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] 53ms - -- DeployLockInternalTime[1] 53ms - -- DeploySerializeConcurrencyTime[3] 2ms - -- DeployStageByStageTime[9] 0 - -- DeployAsyncSendTime[5] 0 - -- DeployWaitTime[9] 49ms - -- DeployScanRanges[1] 0 - DeployDataSize: 212445 Reason: Execution: - Topology: {"rootId":19,"nodes":[{"id":19,"name":"DECODE","properties":{"sinkIds":[],"displayMem":false},"children":[18]},{"id":18,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[17]},{"id":17,"name":"SORT","properties":{"sinkIds":[18],"displayMem":true},"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: 3.895ms - QueryAllocatedMemoryUsage: 61.619 GB - QueryCumulativeCpuTime: 1m43s - QueryCumulativeNetworkTime: 349.032ms - QueryCumulativeOperatorTime: 18s935ms - QueryCumulativeScanTime: 109.314ms - QueryDeallocatedMemoryUsage: 59.749 GB - QueryExecutionWallTime: 12s471ms - QueryPeakMemoryUsagePerNode: 7.370 GB - QueryPeakScheduleTime: 831.133ms - QuerySpillBytes: 0.000 B - QuerySumMemoryUsage: 7.370 GB - ResultDeliverTime: 0ns Fragment 0: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019ade7b-029c-78e6-94b8-37f1d86718b0 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 179.795us - InitialProcessDriverCount: 0 - InitialProcessMem: 42.879 GB - InstanceAllocatedMemoryUsage: 10.102 GB - InstanceDeallocatedMemoryUsage: 10.100 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 11.819 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 11s639ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 12s470ms - OverheadTime: 5s649ms - PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 829.093ms - FirstInputEmptyTime: 829.093ms - ScheduleCount: 86 - ScheduleTime: 831.133ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 85 RESULT_SINK (plan_node_id=-1): CommonMetrics: - IsFinalSink - OperatorTotalTime: 2s572ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 832 - PushRowNum: 3.362M (3362123) - PushTotalTime: 2s572ms UniqueMetrics: - SinkType: MYSQL_PROTOCAL - AppendChunkTime: 2s100ms - ResultRendTime: 471.584ms - TupleConvertTime: 2s96ms - NumSentRows: 3.362M (3362123) CHUNK_ACCUMULATE (plan_node_id=-1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 407.270us - OutputChunkBytes: 1.339 GB - PullChunkNum: 832 - PullRowNum: 3.362M (3362123) - PullTotalTime: 60.395us - PushChunkNum: 832 - PushRowNum: 3.362M (3362123) - PushTotalTime: 346.105us UniqueMetrics: DICT_DECODE (plan_node_id=19): CommonMetrics: - OperatorTotalTime: 40.045ms - OutputChunkBytes: 1.339 GB - PullChunkNum: 832 - PullRowNum: 3.362M (3362123) - PullTotalTime: 124.678us - PushChunkNum: 832 - PushRowNum: 3.362M (3362123) - PushTotalTime: 39.913ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: GLOBAL_MERGE_SOURCE (plan_node_id=18): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 3s377ms - OutputChunkBytes: 1.302 GB - PullChunkNum: 832 - PullRowNum: 3.362M (3362123) - PullTotalTime: 3s377ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 0.000 B - BytesReceived: 103.332 MB - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 101.350ms - DeserializeChunkTime: 680.489ms - PeakBufferMemoryBytes: 394.919 KB - ReceiverProcessTotalTime: 785.589ms - RequestReceived: 344 - WaitLockTime: 58.834us Fragment 1: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019ade7b-029c-78e6-94b8-37f1d86718b1 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 14.023ms - FragmentInstancePrepareTime: 23.849ms - prepare-pipeline-driver: 19.054ms - InitialProcessDriverCount: 1 - InitialProcessMem: 42.880 GB - InstanceAllocatedMemoryUsage: 37.590 GB - InstanceDeallocatedMemoryUsage: 37.320 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 5.776 GB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 26.066us - __MAX_OF_ActiveTime: 173.304us - __MIN_OF_ActiveTime: 10.310us - BlockByInputEmpty: 64 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 22.262ms - __MAX_OF_DriverTotalTime: 22.427ms - __MIN_OF_DriverTotalTime: 22.117ms - PeakDriverQueueSize: 2.019K (2019) - __MAX_OF_PeakDriverQueueSize: 61 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 21.440ms - __MAX_OF_InputEmptyTime: 21.710ms - __MIN_OF_InputEmptyTime: 21.323ms - FirstInputEmptyTime: 20.574ms - __MAX_OF_FirstInputEmptyTime: 20.596ms - __MIN_OF_FirstInputEmptyTime: 20.559ms - ScheduleCount: 128 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 22.236ms - __MAX_OF_ScheduleTime: 22.409ms - __MIN_OF_ScheduleTime: 21.989ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 2.741us - __MAX_OF_OperatorTotalTime: 59.372us - __MIN_OF_OperatorTotalTime: 370ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 30 - __MAX_OF_PushChunkNum: 15 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 36 - __MAX_OF_PushRowNum: 19 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 2.130us - __MAX_OF_PushTotalTime: 58.932us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 1 - Type: Passthrough - LocalExchangePeakMemoryUsage: 6.034 KB EXCHANGE_SOURCE (plan_node_id=14): CommonMetrics: - ConjunctsInputRows: 36 - __MAX_OF_ConjunctsInputRows: 19 - __MIN_OF_ConjunctsInputRows: 7 - ConjunctsOutputRows: 36 - __MAX_OF_ConjunctsOutputRows: 19 - __MIN_OF_ConjunctsOutputRows: 7 - ConjunctsTime: 4.723us - __MAX_OF_ConjunctsTime: 7.101us - __MIN_OF_ConjunctsTime: 2.489us - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 20.002us - __MAX_OF_OperatorTotalTime: 104.484us - __MIN_OF_OperatorTotalTime: 8.190us - OutputChunkBytes: 4.425 KB - __MAX_OF_OutputChunkBytes: 2.318 KB - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 30 - __MAX_OF_PullChunkNum: 15 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 36 - __MAX_OF_PullRowNum: 19 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 2.162us - __MAX_OF_PullTotalTime: 60.303us - __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: 10.519 KB - __MAX_OF_BytesPassThrough: 4.487 KB - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 0.000 B - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 0ns - DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 10.519 KB - __MAX_OF_PeakBufferMemoryBytes: 4.487 KB - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 2.078us - __MAX_OF_ReceiverProcessTotalTime: 21.010us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 31 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 0ns Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 968.524us - BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 22.924ms - PeakDriverQueueSize: 20 - PendingTime: 0ns - InputEmptyTime: 21.431ms - FirstInputEmptyTime: 20.523ms - ScheduleCount: 2 - ScheduleTime: 21.956ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 HASH_JOIN_BUILD (plan_node_id=15): CommonMetrics: - OperatorTotalTime: 649.455us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 30 - PushRowNum: 36 - PushTotalTime: 173.123us - 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: 69.302us - BuildHashTableTime: 92.912us - BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 96.608us - HashTableMemoryUsage: 12.085 KB - PartialRuntimeMembershipFilterBytes: 64.000 B - PartitionNums: 1 - RuntimeFilterBuildTime: 51.071us - RuntimeFilterNum: 2 LOCAL_EXCHANGE_SOURCE (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 96.381us - OutputChunkBytes: 4.425 KB - PullChunkNum: 30 - PullRowNum: 36 - PullTotalTime: 87.412us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=2): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 18.766us - __MAX_OF_ActiveTime: 98.603us - __MIN_OF_ActiveTime: 7.230us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 27.082ms - __MAX_OF_DriverTotalTime: 28.530ms - __MIN_OF_DriverTotalTime: 26.849ms - PeakDriverQueueSize: 1.742K (1742) - __MAX_OF_PeakDriverQueueSize: 60 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 3.975ms - __MAX_OF_InputEmptyTime: 4.001ms - __MIN_OF_InputEmptyTime: 3.936ms - FirstInputEmptyTime: 3.975ms - __MAX_OF_FirstInputEmptyTime: 4.001ms - __MIN_OF_FirstInputEmptyTime: 3.936ms - PreconditionBlockTime: 22.639ms - __MAX_OF_PreconditionBlockTime: 22.649ms - __MIN_OF_PreconditionBlockTime: 22.620ms - ScheduleCount: 64 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 27.063ms - __MAX_OF_ScheduleTime: 28.516ms - __MIN_OF_ScheduleTime: 26.818ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=9): CommonMetrics: - IsSubordinate - OperatorTotalTime: 742ns - __MAX_OF_OperatorTotalTime: 4.690us - __MIN_OF_OperatorTotalTime: 380ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 2 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 59ns - __MAX_OF_PushTotalTime: 3.790us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 1 - Type: Passthrough - LocalExchangePeakMemoryUsage: 140.000 B CHUNK_ACCUMULATE (plan_node_id=8): CommonMetrics: - IsSubordinate - OperatorTotalTime: 612ns - __MAX_OF_OperatorTotalTime: 9.732us - __MIN_OF_OperatorTotalTime: 260ns - OutputChunkBytes: 103.000 B - __MAX_OF_OutputChunkBytes: 103.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 1 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 2 - __MAX_OF_PullRowNum: 2 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 2ns - __MAX_OF_PullTotalTime: 131ns - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 2 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 2 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 144ns - __MAX_OF_PushTotalTime: 9.221us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: EXCHANGE_SOURCE (plan_node_id=8): CommonMetrics: - RuntimeFilterDesc: <0: BloomFilter> - ConjunctsInputRows: 2 - ConjunctsOutputRows: 2 - ConjunctsTime: 1.280us - JoinRuntimeFilterEvaluate: 1 - JoinRuntimeFilterHashTime: 260ns - JoinRuntimeFilterInputRows: 2 - JoinRuntimeFilterOutputRows: 2 - JoinRuntimeFilterTime: 3.500us - OperatorTotalTime: 19.153us - __MAX_OF_OperatorTotalTime: 73.611us - __MIN_OF_OperatorTotalTime: 8.450us - OutputChunkBytes: 103.000 B - __MAX_OF_OutputChunkBytes: 103.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 2 - __MAX_OF_PullChunkNum: 2 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 2 - __MAX_OF_PullRowNum: 2 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 503ns - __MAX_OF_PullTotalTime: 32.221us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 263.000 B - __MAX_OF_BytesPassThrough: 134.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: 134.000 B - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 351ns - __MAX_OF_ReceiverProcessTotalTime: 15us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 3 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 0ns Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 534.773us - BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 28.549ms - PeakDriverQueueSize: 50 - PendingTime: 0ns - InputEmptyTime: 27.138ms - FirstInputEmptyTime: 26.606ms - ScheduleCount: 2 - ScheduleTime: 28.014ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 HASH_JOIN_BUILD (plan_node_id=9): CommonMetrics: - OperatorTotalTime: 513.483us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1 - PushRowNum: 2 - PushTotalTime: 10.010us - 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: 2.540us - BuildHashTableTime: 181.854us - BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 5.310us - HashTableMemoryUsage: 4.220 KB - PartialRuntimeMembershipFilterBytes: 0.000 B - PartitionNums: 1 - RuntimeFilterBuildTime: 4.250us - RuntimeFilterNum: 0 LOCAL_EXCHANGE_SOURCE (plan_node_id=9): CommonMetrics: - IsSubordinate - OperatorTotalTime: 16.790us - OutputChunkBytes: 103.000 B - PullChunkNum: 1 - PullRowNum: 2 - PullTotalTime: 3.500us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=4): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 107.691ms - __MAX_OF_ActiveTime: 132.374ms - __MIN_OF_ActiveTime: 83.513ms - BlockByInputEmpty: 1.317K (1317) - __MAX_OF_BlockByInputEmpty: 34 - __MIN_OF_BlockByInputEmpty: 6 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 390.041ms - __MAX_OF_DriverTotalTime: 397.808ms - __MIN_OF_DriverTotalTime: 376.380ms - OverheadTime: 2.579ms - __MAX_OF_OverheadTime: 3.539ms - __MIN_OF_OverheadTime: 2.124ms - PeakDriverQueueSize: 2.217K (2217) - __MAX_OF_PeakDriverQueueSize: 57 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 250.548ms - __MAX_OF_InputEmptyTime: 263.414ms - __MIN_OF_InputEmptyTime: 237.945ms - FirstInputEmptyTime: 155.915ms - __MAX_OF_FirstInputEmptyTime: 157.609ms - __MIN_OF_FirstInputEmptyTime: 155.348ms - FollowupInputEmptyTime: 94.632ms - __MAX_OF_FollowupInputEmptyTime: 107.532ms - __MIN_OF_FollowupInputEmptyTime: 82.053ms - PreconditionBlockTime: 22.681ms - __MAX_OF_PreconditionBlockTime: 22.712ms - __MIN_OF_PreconditionBlockTime: 22.653ms - ScheduleCount: 1.385K (1385) - __MAX_OF_ScheduleCount: 35 - __MIN_OF_ScheduleCount: 7 - ScheduleTime: 282.350ms - __MAX_OF_ScheduleTime: 306.696ms - __MIN_OF_ScheduleTime: 265.358ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 26 - __MAX_OF_YieldByTimeLimit: 3 - __MIN_OF_YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=3): CommonMetrics: - OperatorTotalTime: 85.988ms - __MAX_OF_OperatorTotalTime: 108.466ms - __MIN_OF_OperatorTotalTime: 67.184ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.155K (1155) - __MAX_OF_PushChunkNum: 19 - __MIN_OF_PushChunkNum: 17 - PushRowNum: 4.005M (4005432) - __MAX_OF_PushRowNum: 63.169K (63169) - __MIN_OF_PushRowNum: 62.094K (62094) - PushTotalTime: 85.940ms - __MAX_OF_PushTotalTime: 108.451ms - __MIN_OF_PushTotalTime: 67.133ms - 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.412ms - __MAX_OF_AggComputeTime: 106.634ms - __MIN_OF_AggComputeTime: 65.718ms - AggFuncComputeTime: 3.582ms - __MAX_OF_AggFuncComputeTime: 5.191ms - __MIN_OF_AggFuncComputeTime: 2.214ms - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 339.235us - __MAX_OF_ExprComputeTime: 433.463us - __MIN_OF_ExprComputeTime: 244.963us - ExprReleaseTime: 1.318ms - __MAX_OF_ExprReleaseTime: 1.805ms - __MIN_OF_ExprReleaseTime: 970.383us - GetResultsTime: 41.925ms - __MAX_OF_GetResultsTime: 51.196ms - __MIN_OF_GetResultsTime: 31.603ms - HashTableMemoryUsage: 1.406 GB - __MAX_OF_HashTableMemoryUsage: 22.504 MB - __MIN_OF_HashTableMemoryUsage: 22.504 MB - HashTableSize: 3.740M (3740376) - __MAX_OF_HashTableSize: 58.994K (58994) - __MIN_OF_HashTableSize: 57.974K (57974) - InputRowCount: 4.005M (4005432) - __MAX_OF_InputRowCount: 63.169K (63169) - __MIN_OF_InputRowCount: 62.094K (62094) - PassThroughRowCount: 0 - ResultAggAppendTime: 8.401ms - __MAX_OF_ResultAggAppendTime: 9.568ms - __MIN_OF_ResultAggAppendTime: 6.822ms - ResultGroupByAppendTime: 31.313ms - __MAX_OF_ResultGroupByAppendTime: 39.092ms - __MIN_OF_ResultGroupByAppendTime: 22.424ms - ResultIteratorTime: 1.204ms - __MAX_OF_ResultIteratorTime: 1.679ms - __MIN_OF_ResultIteratorTime: 913.590us - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns CHUNK_ACCUMULATE (plan_node_id=2): CommonMetrics: - IsSubordinate - OperatorTotalTime: 17.740ms - __MAX_OF_OperatorTotalTime: 21.970ms - __MIN_OF_OperatorTotalTime: 11.858ms - OutputChunkBytes: 961.588 MB - __MAX_OF_OutputChunkBytes: 15.166 MB - __MIN_OF_OutputChunkBytes: 14.906 MB - PullChunkNum: 1.155K (1155) - __MAX_OF_PullChunkNum: 19 - __MIN_OF_PullChunkNum: 17 - PullRowNum: 4.005M (4005432) - __MAX_OF_PullRowNum: 63.169K (63169) - __MIN_OF_PullRowNum: 62.094K (62094) - PullTotalTime: 3.444us - __MAX_OF_PullTotalTime: 6.518us - __MIN_OF_PullTotalTime: 2.068us - PushChunkNum: 4.096K (4096) - __MAX_OF_PushChunkNum: 64 - __MIN_OF_PushChunkNum: 64 - PushRowNum: 4.005M (4005432) - __MAX_OF_PushRowNum: 63.169K (63169) - __MIN_OF_PushRowNum: 62.094K (62094) - PushTotalTime: 17.736ms - __MAX_OF_PushTotalTime: 21.964ms - __MIN_OF_PushTotalTime: 11.854ms UniqueMetrics: EXCHANGE_SOURCE (plan_node_id=2): CommonMetrics: - RuntimeFilterDesc: <1: BloomFilter> - ConjunctsInputRows: 4.005M (4005432) - __MAX_OF_ConjunctsInputRows: 63.169K (63169) - __MIN_OF_ConjunctsInputRows: 62.094K (62094) - ConjunctsOutputRows: 4.005M (4005432) - __MAX_OF_ConjunctsOutputRows: 63.169K (63169) - __MIN_OF_ConjunctsOutputRows: 62.094K (62094) - ConjunctsTime: 182.138us - __MAX_OF_ConjunctsTime: 256.726us - __MIN_OF_ConjunctsTime: 146.331us - JoinRuntimeFilterEvaluate: 128 - __MAX_OF_JoinRuntimeFilterEvaluate: 2 - __MIN_OF_JoinRuntimeFilterEvaluate: 2 - JoinRuntimeFilterHashTime: 1.231us - __MAX_OF_JoinRuntimeFilterHashTime: 2.750us - __MIN_OF_JoinRuntimeFilterHashTime: 210ns - JoinRuntimeFilterInputRows: 4.005M (4005432) - __MAX_OF_JoinRuntimeFilterInputRows: 63.169K (63169) - __MIN_OF_JoinRuntimeFilterInputRows: 62.094K (62094) - JoinRuntimeFilterOutputRows: 4.005M (4005432) - __MAX_OF_JoinRuntimeFilterOutputRows: 63.169K (63169) - __MIN_OF_JoinRuntimeFilterOutputRows: 62.094K (62094) - JoinRuntimeFilterTime: 67.272us - __MAX_OF_JoinRuntimeFilterTime: 127.835us - __MIN_OF_JoinRuntimeFilterTime: 41.362us - OperatorTotalTime: 1.382ms - __MAX_OF_OperatorTotalTime: 4.578ms - __MIN_OF_OperatorTotalTime: 764.839us - OutputChunkBytes: 961.588 MB - __MAX_OF_OutputChunkBytes: 15.166 MB - __MIN_OF_OutputChunkBytes: 14.906 MB - PullChunkNum: 4.096K (4096) - __MAX_OF_PullChunkNum: 64 - __MIN_OF_PullChunkNum: 64 - PullRowNum: 4.005M (4005432) - __MAX_OF_PullRowNum: 63.169K (63169) - __MIN_OF_PullRowNum: 62.094K (62094) - PullTotalTime: 1.335ms - __MAX_OF_PullTotalTime: 4.547ms - __MIN_OF_PullTotalTime: 731.157us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 1 UniqueMetrics: - BufferUnplugCount: 64 - __MAX_OF_BufferUnplugCount: 1 - __MIN_OF_BufferUnplugCount: 1 - BytesPassThrough: 962.650 MB - __MAX_OF_BytesPassThrough: 102.076 MB - __MIN_OF_BytesPassThrough: 2.274 MB - BytesReceived: 0.000 B - ClosureBlockCount: 505 - __MAX_OF_ClosureBlockCount: 12 - __MIN_OF_ClosureBlockCount: 3 - ClosureBlockTime: 82.042ms - __MAX_OF_ClosureBlockTime: 515.073ms - __MIN_OF_ClosureBlockTime: 299.579us - DecompressChunkTime: 0ns - DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 639.678 MB - __MAX_OF_PeakBufferMemoryBytes: 100.293 MB - __MIN_OF_PeakBufferMemoryBytes: 341.794 KB - ReceiverProcessTotalTime: 591.101us - __MAX_OF_ReceiverProcessTotalTime: 1.964ms - __MIN_OF_ReceiverProcessTotalTime: 184.676us - RequestReceived: 2.670K (2670) - __MAX_OF_RequestReceived: 42 - __MIN_OF_RequestReceived: 41 - WaitLockTime: 0ns Pipeline (id=5): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 183.595ms - __MAX_OF_ActiveTime: 212.174ms - __MIN_OF_ActiveTime: 156.081ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 573.617ms - __MAX_OF_DriverTotalTime: 598.292ms - __MIN_OF_DriverTotalTime: 538.531ms - PeakDriverQueueSize: 168 - __MAX_OF_PeakDriverQueueSize: 43 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 361.615ms - __MAX_OF_InputEmptyTime: 369.424ms - __MIN_OF_InputEmptyTime: 347.982ms - FirstInputEmptyTime: 361.615ms - __MAX_OF_FirstInputEmptyTime: 369.424ms - __MIN_OF_FirstInputEmptyTime: 347.982ms - PreconditionBlockTime: 28.282ms - __MAX_OF_PreconditionBlockTime: 28.375ms - __MIN_OF_PreconditionBlockTime: 28.194ms - ScheduleCount: 88 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 390.021ms - __MAX_OF_ScheduleTime: 397.741ms - __MIN_OF_ScheduleTime: 376.622ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 24 - __MAX_OF_YieldByTimeLimit: 1 - __MIN_OF_YieldByTimeLimit: 0 LOCAL_SORT_SINK (plan_node_id=17): CommonMetrics: - OperatorTotalTime: 92.273ms - __MAX_OF_OperatorTotalTime: 114.184ms - __MIN_OF_OperatorTotalTime: 79.295ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 960 - __MAX_OF_PushChunkNum: 15 - __MIN_OF_PushChunkNum: 15 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 53.107K (53107) - __MIN_OF_PushRowNum: 51.931K (51931) - PushTotalTime: 104.369us - __MAX_OF_PushTotalTime: 137.693us - __MIN_OF_PushTotalTime: 77.044us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 - SetFinishingTime: 92.165ms - __MAX_OF_SetFinishingTime: 114.064ms - __MIN_OF_SetFinishingTime: 79.169ms UniqueMetrics: - LateMaterialization: False - MaxBufferedBytes: 268435456 - MaxBufferedRows: 1073741824 - SortKeys: 97: date DESC, 1: device ASC - SortType: All - BuildingTime: 11.665us - __MAX_OF_BuildingTime: 18.480us - __MIN_OF_BuildingTime: 7.730us - InputRequiredMemory: 1.302 GB - __MAX_OF_InputRequiredMemory: 21.053 MB - __MIN_OF_InputRequiredMemory: 20.590 MB - MergingTime: 14.042us - __MAX_OF_MergingTime: 24.651us - __MIN_OF_MergingTime: 8.570us - NumSortedRuns: 64 - __MAX_OF_NumSortedRuns: 1 - __MIN_OF_NumSortedRuns: 1 - OutputTime: 2.556ms - __MAX_OF_OutputTime: 3.006ms - __MIN_OF_OutputTime: 2.307ms - SortingCnt: 0 - SortingTime: 57.839ms - __MAX_OF_SortingTime: 70.870ms - __MIN_OF_SortingTime: 47.083ms PROJECT (plan_node_id=16): CommonMetrics: - OperatorTotalTime: 18.882ms - __MAX_OF_OperatorTotalTime: 24.074ms - __MIN_OF_OperatorTotalTime: 13.809ms - OutputChunkBytes: 1.302 GB - __MAX_OF_OutputChunkBytes: 21.053 MB - __MIN_OF_OutputChunkBytes: 20.590 MB - PullChunkNum: 960 - __MAX_OF_PullChunkNum: 15 - __MIN_OF_PullChunkNum: 15 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 53.107K (53107) - __MIN_OF_PullRowNum: 51.931K (51931) - PullTotalTime: 2.339us - __MAX_OF_PullTotalTime: 31.330us - __MIN_OF_PullTotalTime: 1.429us - PushChunkNum: 960 - __MAX_OF_PushChunkNum: 15 - __MIN_OF_PushChunkNum: 15 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 53.107K (53107) - __MIN_OF_PushRowNum: 51.931K (51931) - PushTotalTime: 18.876ms - __MAX_OF_PushTotalTime: 24.068ms - __MIN_OF_PushTotalTime: 13.804ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 735.985us - __MAX_OF_CommonSubExprComputeTime: 1.005ms - __MIN_OF_CommonSubExprComputeTime: 511.247us - ExprComputeTime: 18.071ms - __MAX_OF_ExprComputeTime: 23.008ms - __MIN_OF_ExprComputeTime: 13.204ms CHUNK_ACCUMULATE (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 12.536us - __MAX_OF_OperatorTotalTime: 18.872us - __MIN_OF_OperatorTotalTime: 8.869us - OutputChunkBytes: 1.184 GB - __MAX_OF_OutputChunkBytes: 19.151 MB - __MIN_OF_OutputChunkBytes: 18.732 MB - PullChunkNum: 960 - __MAX_OF_PullChunkNum: 15 - __MIN_OF_PullChunkNum: 15 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 53.107K (53107) - __MIN_OF_PullRowNum: 51.931K (51931) - PullTotalTime: 1.402us - __MAX_OF_PullTotalTime: 1.920us - __MIN_OF_PullTotalTime: 991ns - PushChunkNum: 960 - __MAX_OF_PushChunkNum: 15 - __MIN_OF_PushChunkNum: 15 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 53.107K (53107) - __MIN_OF_PushRowNum: 51.931K (51931) - PushTotalTime: 10.179us - __MAX_OF_PushTotalTime: 16.152us - __MIN_OF_PushTotalTime: 7.090us UniqueMetrics: HASH_JOIN_PROBE (plan_node_id=15): CommonMetrics: - OperatorTotalTime: 11.385ms - __MAX_OF_OperatorTotalTime: 14.057ms - __MIN_OF_OperatorTotalTime: 8.251ms - OutputChunkBytes: 1.184 GB - __MAX_OF_OutputChunkBytes: 19.151 MB - __MIN_OF_OutputChunkBytes: 18.732 MB - PullChunkNum: 960 - __MAX_OF_PullChunkNum: 15 - __MIN_OF_PullChunkNum: 15 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 53.107K (53107) - __MIN_OF_PullRowNum: 51.931K (51931) - PullTotalTime: 11.307ms - __MAX_OF_PullTotalTime: 13.950ms - __MIN_OF_PullTotalTime: 8.193ms - PushChunkNum: 960 - __MAX_OF_PushChunkNum: 15 - __MIN_OF_PushChunkNum: 15 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 58.994K (58994) - __MIN_OF_PushRowNum: 57.974K (57974) - PushTotalTime: 64.956us - __MAX_OF_PushTotalTime: 110.581us - __MIN_OF_PushTotalTime: 39.881us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - JoinType: INNER_JOIN - OtherJoinConjunctEvaluateTime: 0ns - OutputBuildColumnTime: 6.267ms - __MAX_OF_OutputBuildColumnTime: 8.385ms - __MIN_OF_OutputBuildColumnTime: 4.429ms - OutputProbeColumnTime: 2.949ms - __MAX_OF_OutputProbeColumnTime: 3.667ms - __MIN_OF_OutputProbeColumnTime: 2.098ms - PartitionProbeOverhead: 0ns - ProbeConjunctEvaluateTime: 0ns - SearchHashTableTime: 2.034ms - __MAX_OF_SearchHashTableTime: 2.451ms - __MIN_OF_SearchHashTableTime: 1.513ms - WhereConjunctEvaluateTime: 0ns - probeCount: 0 PROJECT (plan_node_id=10): CommonMetrics: - OperatorTotalTime: 66.356us - __MAX_OF_OperatorTotalTime: 88.843us - __MIN_OF_OperatorTotalTime: 50.853us - OutputChunkBytes: 988.977 MB - __MAX_OF_OutputChunkBytes: 15.599 MB - __MIN_OF_OutputChunkBytes: 15.331 MB - PullChunkNum: 960 - __MAX_OF_PullChunkNum: 15 - __MIN_OF_PullChunkNum: 15 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 58.994K (58994) - __MIN_OF_PullRowNum: 57.974K (57974) - PullTotalTime: 1.327us - __MAX_OF_PullTotalTime: 2.501us - __MIN_OF_PullTotalTime: 820ns - PushChunkNum: 960 - __MAX_OF_PushChunkNum: 15 - __MIN_OF_PushChunkNum: 15 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 58.994K (58994) - __MIN_OF_PushRowNum: 57.974K (57974) - PushTotalTime: 61.058us - __MAX_OF_PushTotalTime: 83.592us - __MIN_OF_PushTotalTime: 47.001us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 1.087us - __MAX_OF_CommonSubExprComputeTime: 2.560us - __MIN_OF_CommonSubExprComputeTime: 628ns - ExprComputeTime: 29.278us - __MAX_OF_ExprComputeTime: 51.423us - __MIN_OF_ExprComputeTime: 22.051us HASH_JOIN_PROBE (plan_node_id=9): CommonMetrics: - OperatorTotalTime: 2.695ms - __MAX_OF_OperatorTotalTime: 3.182ms - __MIN_OF_OperatorTotalTime: 1.993ms - OutputChunkBytes: 988.977 MB - __MAX_OF_OutputChunkBytes: 15.599 MB - __MIN_OF_OutputChunkBytes: 15.331 MB - PullChunkNum: 960 - __MAX_OF_PullChunkNum: 15 - __MIN_OF_PullChunkNum: 15 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 58.994K (58994) - __MIN_OF_PullRowNum: 57.974K (57974) - PullTotalTime: 2.617ms - __MAX_OF_PullTotalTime: 3.057ms - __MIN_OF_PullTotalTime: 1.924ms - PushChunkNum: 960 - __MAX_OF_PushChunkNum: 15 - __MIN_OF_PushChunkNum: 15 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 58.994K (58994) - __MIN_OF_PushRowNum: 57.974K (57974) - PushTotalTime: 59.687us - __MAX_OF_PushTotalTime: 103.542us - __MIN_OF_PushTotalTime: 33.741us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - JoinType: LEFT_OUTER_JOIN - OtherJoinConjunctEvaluateTime: 0ns - OutputBuildColumnTime: 800.630us - __MAX_OF_OutputBuildColumnTime: 1.002ms - __MIN_OF_OutputBuildColumnTime: 569.456us - OutputProbeColumnTime: 36.955us - __MAX_OF_OutputProbeColumnTime: 56.303us - __MIN_OF_OutputProbeColumnTime: 24.340us - PartitionProbeOverhead: 0ns - ProbeConjunctEvaluateTime: 0ns - SearchHashTableTime: 1.719ms - __MAX_OF_SearchHashTableTime: 2.022ms - __MIN_OF_SearchHashTableTime: 1.282ms - WhereConjunctEvaluateTime: 0ns - probeCount: 0 PROJECT (plan_node_id=4): CommonMetrics: - OperatorTotalTime: 15.872ms - __MAX_OF_OperatorTotalTime: 19.543ms - __MIN_OF_OperatorTotalTime: 11.031ms - OutputChunkBytes: 930.824 MB - __MAX_OF_OutputChunkBytes: 14.681 MB - __MIN_OF_OutputChunkBytes: 14.430 MB - PullChunkNum: 960 - __MAX_OF_PullChunkNum: 15 - __MIN_OF_PullChunkNum: 15 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 58.994K (58994) - __MIN_OF_PullRowNum: 57.974K (57974) - PullTotalTime: 1.894us - __MAX_OF_PullTotalTime: 3.188us - __MIN_OF_PullTotalTime: 1.430us - PushChunkNum: 960 - __MAX_OF_PushChunkNum: 15 - __MIN_OF_PushChunkNum: 15 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 58.994K (58994) - __MIN_OF_PushRowNum: 57.974K (57974) - PushTotalTime: 15.864ms - __MAX_OF_PushTotalTime: 19.536ms - __MIN_OF_PushTotalTime: 11.023ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 1 UniqueMetrics: - CommonSubExprComputeTime: 8.014ms - __MAX_OF_CommonSubExprComputeTime: 9.775ms - __MIN_OF_CommonSubExprComputeTime: 5.562ms - ExprComputeTime: 7.790ms - __MAX_OF_ExprComputeTime: 10.489ms - __MIN_OF_ExprComputeTime: 5.341ms AGGREGATE_BLOCKING_SOURCE (plan_node_id=3): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 42.063ms - __MAX_OF_OperatorTotalTime: 51.366ms - __MIN_OF_OperatorTotalTime: 31.745ms - OutputChunkBytes: 898.720 MB - __MAX_OF_OutputChunkBytes: 14.175 MB - __MIN_OF_OutputChunkBytes: 13.932 MB - PullChunkNum: 960 - __MAX_OF_PullChunkNum: 15 - __MIN_OF_PullChunkNum: 15 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 58.994K (58994) - __MIN_OF_PullRowNum: 57.974K (57974) - PullTotalTime: 41.974ms - __MAX_OF_PullTotalTime: 51.253ms - __MIN_OF_PullTotalTime: 31.639ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=6): - IsGroupExecution: false - ActiveTime: 11s810ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 12s424ms - OverheadTime: 23.006ms - PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 598.201ms - FirstInputEmptyTime: 598.201ms - PendingFinishTime: 1.692ms - ScheduleCount: 109 - ScheduleTime: 614.177ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 108 EXCHANGE_SINK (plan_node_id=18): CommonMetrics: - OperatorTotalTime: 746.939ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 832 - PushRowNum: 3.362M (3362123) - PushTotalTime: 746.799ms UniqueMetrics: - ChannelNum: 1 - DestFragments: 019ade7b029c78e6-94b837f1d86718b0 - DestID: 18 - PartType: UNPARTITIONED - BytesPassThrough: 0.000 B - BytesSent: 103.332 MB - BytesUnsent: 0.000 B - CompressTime: 211.614ms - CompressedBytes: 103.332 MB - NetworkBandwidth: 659.075 MB/sec - NetworkTime: 156.783ms - OverallThroughput: 8.888 MB/sec - OverallTime: 11s625ms - PassThroughBufferPeakMemoryUsage: 0.000 B - RawInputBytes: 1.302 GB - RequestSent: 344 - RequestUnsent: 0 - RpcAvgTime: 454.444us - RpcCount: 345 - SerializeChunkTime: 457.046ms - SerializedBytes: 281.974 MB - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 2.669ms LOCAL_MERGE_SOURCE (plan_node_id=17): CommonMetrics: - OperatorTotalTime: 11s40ms - OutputChunkBytes: 1.302 GB - PullChunkNum: 832 - PullRowNum: 3.362M (3362123) - PullTotalTime: 11s39ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Fragment 2: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019ade7b-029c-78e6-94b8-37f1d86718b2 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 6.293ms - FragmentInstancePrepareTime: 13.848ms - prepare-pipeline-driver: 11.767ms - InitialProcessDriverCount: 260 - InitialProcessMem: 42.911 GB - InstanceAllocatedMemoryUsage: 32.185 MB - InstanceDeallocatedMemoryUsage: 32.766 MB - InstanceNum: 1 - InstancePeakMemoryUsage: 24.663 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 250.272us - __MAX_OF_ActiveTime: 1.157ms - __MIN_OF_ActiveTime: 4.240us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 5.875ms - __MAX_OF_DriverTotalTime: 6.081ms - __MIN_OF_DriverTotalTime: 5.551ms - PeakDriverQueueSize: 803 - __MAX_OF_PeakDriverQueueSize: 33 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 2.673ms - __MAX_OF_InputEmptyTime: 3.200ms - __MIN_OF_InputEmptyTime: 1.766ms - FirstInputEmptyTime: 2.673ms - __MAX_OF_FirstInputEmptyTime: 3.200ms - __MIN_OF_FirstInputEmptyTime: 1.766ms - PendingFinishTime: 2.627ms - __MAX_OF_PendingFinishTime: 3.649ms - __MIN_OF_PendingFinishTime: 1.357ms - ScheduleCount: 64 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 5.625ms - __MAX_OF_ScheduleTime: 6.076ms - __MIN_OF_ScheduleTime: 4.884ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=14): CommonMetrics: - OperatorTotalTime: 194.977us - __MAX_OF_OperatorTotalTime: 1.052ms - __MIN_OF_OperatorTotalTime: 1.579us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 30 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 36 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 8.618us - __MAX_OF_PushTotalTime: 47.881us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ChannelNum: 1 - DestFragments: 019ade7b029c78e6-94b837f1d86718b1 - DestID: 14 - PartType: UNPARTITIONED - BytesPassThrough: 10.519 KB - __MAX_OF_BytesPassThrough: 463.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: 4.880ms - OverallThroughput: 0.000 B/sec - OverallTime: 3.063ms - PassThroughBufferPeakMemoryUsage: 0.000 B - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 411.402us - RpcCount: 31 - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 1.070ms AGGREGATE_BLOCKING_SOURCE (plan_node_id=13): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 66.169us - __MAX_OF_OperatorTotalTime: 165.944us - __MIN_OF_OperatorTotalTime: 9.191us - OutputChunkBytes: 4.425 KB - __MAX_OF_OutputChunkBytes: 255.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 30 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 36 - __MAX_OF_PullRowNum: 2 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 47.331us - __MAX_OF_PullTotalTime: 149.324us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 59.017us - __MAX_OF_ActiveTime: 331.968us - __MIN_OF_ActiveTime: 6.391us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 2.892ms - __MAX_OF_DriverTotalTime: 3.584ms - __MIN_OF_DriverTotalTime: 1.875ms - PeakDriverQueueSize: 777 - __MAX_OF_PeakDriverQueueSize: 37 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 2.483ms - __MAX_OF_InputEmptyTime: 2.776ms - __MIN_OF_InputEmptyTime: 1.789ms - FirstInputEmptyTime: 2.483ms - __MAX_OF_FirstInputEmptyTime: 2.776ms - __MIN_OF_FirstInputEmptyTime: 1.789ms - ScheduleCount: 64 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 2.833ms - __MAX_OF_ScheduleTime: 3.570ms - __MIN_OF_ScheduleTime: 1.865ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=13): CommonMetrics: - OperatorTotalTime: 48.068us - __MAX_OF_OperatorTotalTime: 335.259us - __MIN_OF_OperatorTotalTime: 8.750us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 30 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 72 - __MAX_OF_PushRowNum: 4 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 27.315us - __MAX_OF_PushTotalTime: 132.143us - __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: 24.967us - __MAX_OF_AggComputeTime: 125.863us - __MIN_OF_AggComputeTime: 0ns - AggFuncComputeTime: 3.298us - __MAX_OF_AggFuncComputeTime: 15.340us - __MIN_OF_AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 2.557us - __MAX_OF_ExprComputeTime: 9.750us - __MIN_OF_ExprComputeTime: 0ns - ExprReleaseTime: 585ns - __MAX_OF_ExprReleaseTime: 1.950us - __MIN_OF_ExprReleaseTime: 0ns - GetResultsTime: 41.185us - __MAX_OF_GetResultsTime: 129.963us - __MIN_OF_GetResultsTime: 0ns - HashTableMemoryUsage: 15.120 MB - __MAX_OF_HashTableMemoryUsage: 516.105 KB - __MIN_OF_HashTableMemoryUsage: 24.000 B - HashTableSize: 36 - __MAX_OF_HashTableSize: 2 - __MIN_OF_HashTableSize: 0 - InputRowCount: 72 - __MAX_OF_InputRowCount: 4 - __MIN_OF_InputRowCount: 0 - PassThroughRowCount: 0 - ResultAggAppendTime: 1.600us - __MAX_OF_ResultAggAppendTime: 9.330us - __MIN_OF_ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 758ns - __MAX_OF_ResultGroupByAppendTime: 3.320us - __MIN_OF_ResultGroupByAppendTime: 0ns - ResultIteratorTime: 29.706us - __MAX_OF_ResultIteratorTime: 103.542us - __MIN_OF_ResultIteratorTime: 0ns - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns LOCAL_EXCHANGE_SOURCE (plan_node_id=13): CommonMetrics: - IsSubordinate - OperatorTotalTime: 13.634us - __MAX_OF_OperatorTotalTime: 55.171us - __MIN_OF_OperatorTotalTime: 1.231us - OutputChunkBytes: 7.119 KB - __MAX_OF_OutputChunkBytes: 405.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 30 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 72 - __MAX_OF_PullRowNum: 4 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 11.383us - __MAX_OF_PullTotalTime: 53.521us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 731.632us - __MAX_OF_ActiveTime: 1.568ms - __MIN_OF_ActiveTime: 526.784us - BlockByInputEmpty: 8 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 8 - DriverTotalTime: 1.901ms - __MAX_OF_DriverTotalTime: 3.138ms - __MIN_OF_DriverTotalTime: 1.437ms - PeakDriverQueueSize: 19 - __MAX_OF_PeakDriverQueueSize: 4 - __MIN_OF_PeakDriverQueueSize: 0 - ScheduleCount: 16 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 1.169ms - __MAX_OF_ScheduleTime: 1.570ms - __MIN_OF_ScheduleTime: 869.753us - TotalDegreeOfParallelism: 8 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=13): CommonMetrics: - IsSubordinate - OperatorTotalTime: 158.510us - __MAX_OF_OperatorTotalTime: 1.072ms - __MIN_OF_OperatorTotalTime: 19.001us - 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: 26.460us - __MAX_OF_PushTotalTime: 38.221us - __MIN_OF_PushTotalTime: 18.300us UniqueMetrics: - ShuffleNum: 64 - Type: Partition(BUCKET_SHUFFLE_HASH_PARTITIONED) - LocalExchangePeakMemoryUsage: 839.000 B PROJECT (plan_node_id=12): CommonMetrics: - OperatorTotalTime: 62.701us - __MAX_OF_OperatorTotalTime: 98.073us - __MIN_OF_OperatorTotalTime: 43.641us - 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: 251ns - __MAX_OF_PullTotalTime: 490ns - __MIN_OF_PullTotalTime: 149ns - PushChunkNum: 8 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 72 - __MAX_OF_PushRowNum: 14 - __MIN_OF_PushRowNum: 6 - PushTotalTime: 58.777us - __MAX_OF_PushTotalTime: 93.983us - __MIN_OF_PushTotalTime: 39.271us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 8.627us - __MAX_OF_CommonSubExprComputeTime: 12.051us - __MIN_OF_CommonSubExprComputeTime: 5.780us - ExprComputeTime: 46.427us - __MAX_OF_ExprComputeTime: 76.562us - __MIN_OF_ExprComputeTime: 29.771us CHUNK_ACCUMULATE (plan_node_id=11): CommonMetrics: - IsSubordinate - OperatorTotalTime: 2.366us - __MAX_OF_OperatorTotalTime: 3.419us - __MIN_OF_OperatorTotalTime: 1.751us - 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: 256ns - __MAX_OF_PullTotalTime: 390ns - __MIN_OF_PullTotalTime: 169ns - PushChunkNum: 8 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 72 - __MAX_OF_PushRowNum: 14 - __MIN_OF_PushRowNum: 6 - PushTotalTime: 1.442us - __MAX_OF_PushTotalTime: 2.180us - __MIN_OF_PushTotalTime: 981ns UniqueMetrics: OLAP_SCAN (plan_node_id=11): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 620.596us - __MAX_OF_OperatorTotalTime: 876.310us - __MIN_OF_OperatorTotalTime: 491.872us - 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: 373.903us - __MAX_OF_PullTotalTime: 618.114us - __MIN_OF_PullTotalTime: 256.216us - 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: 866.578us - __MAX_OF_IOTaskExecTime: 985.776us - __MIN_OF_IOTaskExecTime: 726.978us - CreateSegmentIter: 60.971us - __MAX_OF_CreateSegmentIter: 93.403us - __MIN_OF_CreateSegmentIter: 44.492us - DictDecode: 4.123us - __MAX_OF_DictDecode: 5.810us - __MIN_OF_DictDecode: 2.350us - DictDecodeCount: 216 - __MAX_OF_DictDecodeCount: 42 - __MIN_OF_DictDecodeCount: 18 - GetDelVec: 0ns - GetDeltaColumnGroup: 6.390us - __MAX_OF_GetDeltaColumnGroup: 10.140us - __MIN_OF_GetDeltaColumnGroup: 3.570us - GetRowsets: 8.371us - __MAX_OF_GetRowsets: 11.160us - __MIN_OF_GetRowsets: 7.010us - IOTime: 0ns - LateMaterialize: 71.409us - __MAX_OF_LateMaterialize: 102.303us - __MIN_OF_LateMaterialize: 38.311us - LateMaterializeRows: 72 - __MAX_OF_LateMaterializeRows: 14 - __MIN_OF_LateMaterializeRows: 6 - ReadPKIndex: 0ns - SegmentInit: 331.990us - __MAX_OF_SegmentInit: 416.311us - __MIN_OF_SegmentInit: 199.455us - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 7.552us - __MAX_OF_BitmapIndexIteratorInit: 11.281us - __MIN_OF_BitmapIndexIteratorInit: 4.700us - BloomFilterFilter: 703ns - __MAX_OF_BloomFilterFilter: 950ns - __MIN_OF_BloomFilterFilter: 390ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 174.198us - __MAX_OF_ColumnIteratorInit: 238.936us - __MIN_OF_ColumnIteratorInit: 80.322us - GetVectorRowRangesTime: 0ns - GinFilter: 0ns - GinFilterRows: 0 - ProcessVectorDistanceAndIdTime: 0ns - RemainingRowsAfterShortKeyFilter: 288 - __MAX_OF_RemainingRowsAfterShortKeyFilter: 56 - __MIN_OF_RemainingRowsAfterShortKeyFilter: 24 - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 35.521us - __MAX_OF_ShortKeyFilter: 48.211us - __MIN_OF_ShortKeyFilter: 24.181us - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 14.949us - __MAX_OF_ZoneMapIndexFilter: 22.521us - __MIN_OF_ZoneMapIndexFilter: 9.550us - ZoneMapIndexFilterRows: 0 - SegmentRead: 27.551us - __MAX_OF_SegmentRead: 44.451us - __MIN_OF_SegmentRead: 14.610us - BlockFetch: 9.375us - __MAX_OF_BlockFetch: 12.920us - __MIN_OF_BlockFetch: 5.070us - BlockFetchCount: 8 - __MAX_OF_BlockFetchCount: 1 - __MIN_OF_BlockFetchCount: 1 - BlockSeek: 25.170us - __MAX_OF_BlockSeek: 39.772us - __MIN_OF_BlockSeek: 16.859us - BlockSeekCount: 8 - __MAX_OF_BlockSeekCount: 1 - __MIN_OF_BlockSeekCount: 1 - ChunkCopy: 2.737us - __MAX_OF_ChunkCopy: 3.820us - __MIN_OF_ChunkCopy: 1.810us - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 3.376us - __MAX_OF_PredFilter: 4.600us - __MIN_OF_PredFilter: 1.800us - 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: 142.606us - __MAX_OF_IOTaskWaitTime: 208.486us - __MIN_OF_IOTaskWaitTime: 53.541us - MorselsCount: 8 - __MAX_OF_MorselsCount: 1 - __MIN_OF_MorselsCount: 1 - PeakChunkBufferMemoryUsage: 181.883 KB - PeakChunkBufferSize: 2 - PeakIOTasks: 1 - PeakScanTaskQueueSize: 14 - __MAX_OF_PeakScanTaskQueueSize: 4 - __MIN_OF_PeakScanTaskQueueSize: 0 - PrepareChunkSourceTime: 287.338us - __MAX_OF_PrepareChunkSourceTime: 422.030us - __MIN_OF_PrepareChunkSourceTime: 194.205us - 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: 1.009ms - __MAX_OF_ScanTime: 1.152ms - __MIN_OF_ScanTime: 831.291us - SubmitTaskCount: 8 - __MAX_OF_SubmitTaskCount: 1 - __MIN_OF_SubmitTaskCount: 1 - SubmitTaskTime: 48.285us - __MAX_OF_SubmitTaskTime: 149.654us - __MIN_OF_SubmitTaskTime: 12.380us - TabletCount: 8 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 124.935us - __MAX_OF_ActiveTime: 334.259us - __MIN_OF_ActiveTime: 61.271us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 8 - DriverTotalTime: 234.068us - __MAX_OF_DriverTotalTime: 423.761us - __MIN_OF_DriverTotalTime: 157.754us - PeakDriverQueueSize: 28 - __MAX_OF_PeakDriverQueueSize: 7 - __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: 665ns - __MAX_OF_OperatorTotalTime: 1us - __MIN_OF_OperatorTotalTime: 341ns - 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: 122.857us - __MAX_OF_OperatorTotalTime: 329.978us - __MIN_OF_OperatorTotalTime: 61.432us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 114.979us - __MAX_OF_PullTotalTime: 320.748us - __MIN_OF_PullTotalTime: 55.632us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 5.656us - __MAX_OF_CaptureTabletRowsetsTime: 10.431us - __MIN_OF_CaptureTabletRowsetsTime: 4.201us Fragment 3: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019ade7b-029c-78e6-94b8-37f1d86718b3 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 11.335ms - FragmentInstancePrepareTime: 11.117ms - InitialProcessDriverCount: 260 - InitialProcessMem: 42.911 GB - InstanceAllocatedMemoryUsage: 6.407 MB - InstanceDeallocatedMemoryUsage: 7.556 MB - InstanceNum: 1 - InstancePeakMemoryUsage: 3.120 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 60.021us - __MAX_OF_ActiveTime: 569.264us - __MIN_OF_ActiveTime: 4.440us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 25.105ms - __MAX_OF_DriverTotalTime: 33.771ms - __MIN_OF_DriverTotalTime: 12.956ms - PeakDriverQueueSize: 5.946K (5946) - __MAX_OF_PeakDriverQueueSize: 127 - __MIN_OF_PeakDriverQueueSize: 28 - PendingTime: 0ns - InputEmptyTime: 10.338ms - __MAX_OF_InputEmptyTime: 10.482ms - __MIN_OF_InputEmptyTime: 9.808ms - FirstInputEmptyTime: 10.338ms - __MAX_OF_FirstInputEmptyTime: 10.482ms - __MIN_OF_FirstInputEmptyTime: 9.808ms - PendingFinishTime: 12.467ms - __MAX_OF_PendingFinishTime: 20.769ms - __MIN_OF_PendingFinishTime: 1.428ms - ScheduleCount: 64 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 25.045ms - __MAX_OF_ScheduleTime: 33.754ms - __MIN_OF_ScheduleTime: 12.946ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=8): CommonMetrics: - OperatorTotalTime: 52.343us - __MAX_OF_OperatorTotalTime: 561.924us - __MIN_OF_OperatorTotalTime: 1.211us - 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: 305ns - __MAX_OF_PushTotalTime: 10.011us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ChannelNum: 1 - DestFragments: 019ade7b029c78e6-94b837f1d86718b1 - 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: 573.683us - OverallThroughput: 0.000 B/sec - OverallTime: 1.098ms - PassThroughBufferPeakMemoryUsage: 0.000 B - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 191.227us - RpcCount: 3 - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 862.862us AGGREGATE_BLOCKING_SOURCE (plan_node_id=7): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 23.243us - __MAX_OF_OperatorTotalTime: 91.032us - __MIN_OF_OperatorTotalTime: 12.200us - 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.658us - __MAX_OF_PullTotalTime: 62.241us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 21.098us - __MAX_OF_ActiveTime: 402.130us - __MIN_OF_ActiveTime: 6.240us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 10.674ms - __MAX_OF_DriverTotalTime: 12.971ms - __MIN_OF_DriverTotalTime: 10.289ms - PeakDriverQueueSize: 2.015K (2015) - __MAX_OF_PeakDriverQueueSize: 63 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 9.887ms - __MAX_OF_InputEmptyTime: 9.906ms - __MIN_OF_InputEmptyTime: 9.841ms - FirstInputEmptyTime: 9.887ms - __MAX_OF_FirstInputEmptyTime: 9.906ms - __MIN_OF_FirstInputEmptyTime: 9.841ms - ScheduleCount: 64 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 10.653ms - __MAX_OF_ScheduleTime: 12.963ms - __MIN_OF_ScheduleTime: 10.159ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=7): CommonMetrics: - OperatorTotalTime: 23.614us - __MAX_OF_OperatorTotalTime: 405.761us - __MIN_OF_OperatorTotalTime: 8.230us - 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: 1.117us - __MAX_OF_PushTotalTime: 37.931us - __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: 973ns - __MAX_OF_AggComputeTime: 33.150us - __MIN_OF_AggComputeTime: 0ns - AggFuncComputeTime: 122ns - __MAX_OF_AggFuncComputeTime: 3.950us - __MIN_OF_AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 103ns - __MAX_OF_ExprComputeTime: 3.680us - __MIN_OF_ExprComputeTime: 0ns - ExprReleaseTime: 41ns - __MAX_OF_ExprReleaseTime: 1.591us - __MIN_OF_ExprReleaseTime: 0ns - GetResultsTime: 1.216us - __MAX_OF_GetResultsTime: 46.001us - __MIN_OF_GetResultsTime: 0ns - HashTableMemoryUsage: 265.566 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: 55ns - __MAX_OF_ResultAggAppendTime: 1.860us - __MIN_OF_ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 35ns - __MAX_OF_ResultGroupByAppendTime: 1.270us - __MIN_OF_ResultGroupByAppendTime: 0ns - ResultIteratorTime: 783ns - __MAX_OF_ResultIteratorTime: 32.931us - __MIN_OF_ResultIteratorTime: 0ns - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns LOCAL_EXCHANGE_SOURCE (plan_node_id=7): CommonMetrics: - IsSubordinate - OperatorTotalTime: 2.184us - __MAX_OF_OperatorTotalTime: 18.751us - __MIN_OF_OperatorTotalTime: 980ns - 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: 409ns - __MAX_OF_PullTotalTime: 17.510us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 239.411us - __MAX_OF_ActiveTime: 527.724us - __MIN_OF_ActiveTime: 167.085us - BlockByInputEmpty: 10 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 9.498ms - __MAX_OF_DriverTotalTime: 10.592ms - __MIN_OF_DriverTotalTime: 9.198ms - PeakDriverQueueSize: 14 - __MAX_OF_PeakDriverQueueSize: 4 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - PreconditionBlockTime: 9.004ms - __MAX_OF_PreconditionBlockTime: 9.074ms - __MIN_OF_PreconditionBlockTime: 8.794ms - ScheduleCount: 21 - __MAX_OF_ScheduleCount: 3 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 9.259ms - __MAX_OF_ScheduleTime: 10.065ms - __MIN_OF_ScheduleTime: 8.982ms - TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=7): CommonMetrics: - IsSubordinate - OperatorTotalTime: 17.201us - __MAX_OF_OperatorTotalTime: 149.154us - __MIN_OF_OperatorTotalTime: 349ns - 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.168us - __MAX_OF_PushTotalTime: 19.041us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 64 - Type: Partition(BUCKET_SHUFFLE_HASH_PARTITIONED) - LocalExchangePeakMemoryUsage: 0.000 B PROJECT (plan_node_id=6): CommonMetrics: - OperatorTotalTime: 7.689us - __MAX_OF_OperatorTotalTime: 28.852us - __MIN_OF_OperatorTotalTime: 2.779us - 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: 103ns - __MAX_OF_PullTotalTime: 170ns - __MIN_OF_PullTotalTime: 70ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 4 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 4.649us - __MAX_OF_PushTotalTime: 25.841us - __MIN_OF_PushTotalTime: 220ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 31ns - __MAX_OF_CommonSubExprComputeTime: 160ns - __MIN_OF_CommonSubExprComputeTime: 0ns - ExprComputeTime: 4.080us - __MAX_OF_ExprComputeTime: 24.061us - __MIN_OF_ExprComputeTime: 0ns CHUNK_ACCUMULATE (plan_node_id=5): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.273us - __MAX_OF_OperatorTotalTime: 1.620us - __MIN_OF_OperatorTotalTime: 929ns - 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: 118ns - __MAX_OF_PullTotalTime: 210ns - __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: 743ns - __MAX_OF_PushTotalTime: 1.210us - __MIN_OF_PushTotalTime: 450ns 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: 665ns - __MAX_OF_JoinRuntimeFilterTime: 710ns - __MIN_OF_JoinRuntimeFilterTime: 620ns - OperatorTotalTime: 392.582us - __MAX_OF_OperatorTotalTime: 532.174us - __MIN_OF_OperatorTotalTime: 296.957us - 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: 168.337us - __MAX_OF_PullTotalTime: 275.297us - __MIN_OF_PullTotalTime: 122.313us - 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: 139.602us - __MAX_OF_IOTaskExecTime: 439.371us - __MIN_OF_IOTaskExecTime: 55.372us - CreateSegmentIter: 21.728us - __MAX_OF_CreateSegmentIter: 102.892us - __MIN_OF_CreateSegmentIter: 8.010us - DictDecode: 1.060us - __MAX_OF_DictDecode: 1.140us - __MIN_OF_DictDecode: 980ns - DictDecodeCount: 8 - __MAX_OF_DictDecodeCount: 4 - __MIN_OF_DictDecodeCount: 4 - GetDelVec: 0ns - GetDeltaColumnGroup: 6.356us - __MAX_OF_GetDeltaColumnGroup: 58.262us - __MIN_OF_GetDeltaColumnGroup: 0ns - GetRowsets: 4.997us - __MAX_OF_GetRowsets: 6.631us - __MIN_OF_GetRowsets: 3.420us - IOTime: 0ns - LateMaterialize: 15.185us - __MAX_OF_LateMaterialize: 15.270us - __MIN_OF_LateMaterialize: 15.101us - LateMaterializeRows: 4 - __MAX_OF_LateMaterializeRows: 2 - __MIN_OF_LateMaterializeRows: 2 - ReadPKIndex: 0ns - SegmentInit: 38.636us - __MAX_OF_SegmentInit: 213.365us - __MIN_OF_SegmentInit: 0ns - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 744ns - __MAX_OF_BitmapIndexIteratorInit: 4.180us - __MIN_OF_BitmapIndexIteratorInit: 0ns - BloomFilterFilter: 68ns - __MAX_OF_BloomFilterFilter: 360ns - __MIN_OF_BloomFilterFilter: 0ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 21.943us - __MAX_OF_ColumnIteratorInit: 128.103us - __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: 3.991us - __MAX_OF_ShortKeyFilter: 20.261us - __MIN_OF_ShortKeyFilter: 0ns - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 1.276us - __MAX_OF_ZoneMapIndexFilter: 6.590us - __MIN_OF_ZoneMapIndexFilter: 0ns - ZoneMapIndexFilterRows: 0 - SegmentRead: 3.132us - __MAX_OF_SegmentRead: 19.091us - __MIN_OF_SegmentRead: 0ns - BlockFetch: 812ns - __MAX_OF_BlockFetch: 4.158us - __MIN_OF_BlockFetch: 0ns - BlockFetchCount: 2 - __MAX_OF_BlockFetchCount: 1 - __MIN_OF_BlockFetchCount: 0 - BlockSeek: 2.526us - __MAX_OF_BlockSeek: 17.141us - __MIN_OF_BlockSeek: 0ns - BlockSeekCount: 2 - __MAX_OF_BlockSeekCount: 1 - __MIN_OF_BlockSeekCount: 0 - ChunkCopy: 157ns - __MAX_OF_ChunkCopy: 870ns - __MIN_OF_ChunkCopy: 0ns - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 276ns - __MAX_OF_PredFilter: 1.390us - __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: 36.178us - __MAX_OF_IOTaskWaitTime: 50.141us - __MIN_OF_IOTaskWaitTime: 26.251us - MorselsCount: 10 - __MAX_OF_MorselsCount: 1 - __MIN_OF_MorselsCount: 1 - PeakChunkBufferMemoryUsage: 100.017 KB - PeakChunkBufferSize: 1 - PeakIOTasks: 1 - PeakScanTaskQueueSize: 7 - __MAX_OF_PeakScanTaskQueueSize: 2 - __MIN_OF_PeakScanTaskQueueSize: 0 - PrepareChunkSourceTime: 142.905us - __MAX_OF_PrepareChunkSourceTime: 242.956us - __MIN_OF_PrepareChunkSourceTime: 100.403us - 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: 839ns - __MAX_OF_RuntimeFilterEvalTime: 4.420us - __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: 175.781us - __MAX_OF_ScanTime: 469.452us - __MIN_OF_ScanTime: 85.033us - SubmitTaskCount: 10 - __MAX_OF_SubmitTaskCount: 1 - __MIN_OF_SubmitTaskCount: 1 - SubmitTaskTime: 12.131us - __MAX_OF_SubmitTaskTime: 25.990us - __MIN_OF_SubmitTaskTime: 4.270us - TabletCount: 10 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 43.614us - __MAX_OF_ActiveTime: 52.291us - __MIN_OF_ActiveTime: 20.120us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 9.067ms - __MAX_OF_DriverTotalTime: 9.195ms - __MIN_OF_DriverTotalTime: 8.825ms - PeakDriverQueueSize: 12 - __MAX_OF_PeakDriverQueueSize: 4 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - PreconditionBlockTime: 8.938ms - __MAX_OF_PreconditionBlockTime: 9.073ms - __MIN_OF_PreconditionBlockTime: 8.609ms - ScheduleCount: 10 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 9.024ms - __MAX_OF_ScheduleTime: 9.150ms - __MIN_OF_ScheduleTime: 8.780ms - TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=5): CommonMetrics: - IsSubordinate - OperatorTotalTime: 359ns - __MAX_OF_OperatorTotalTime: 480ns - __MIN_OF_OperatorTotalTime: 259ns - 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: 45.644us - __MAX_OF_OperatorTotalTime: 54.052us - __MIN_OF_OperatorTotalTime: 21.190us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 38.877us - __MAX_OF_PullTotalTime: 47.331us - __MIN_OF_PullTotalTime: 17.180us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 4.442us - __MAX_OF_CaptureTabletRowsetsTime: 9.390us - __MIN_OF_CaptureTabletRowsetsTime: 2.230us Fragment 4: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019ade7b-029c-78e6-94b8-37f1d86718b4 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 9.557ms - FragmentInstancePrepareTime: 18.881ms - prepare-pipeline-driver: 14.558ms - InitialProcessDriverCount: 552 - InitialProcessMem: 42.918 GB - InstanceAllocatedMemoryUsage: 13.889 GB - InstanceDeallocatedMemoryUsage: 12.290 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 1.899 GB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 160.864ms - __MAX_OF_ActiveTime: 190.602ms - __MIN_OF_ActiveTime: 89.500ms - BlockByInputEmpty: 4 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 2 - __MAX_OF_BlockByOutputFull: 1 - __MIN_OF_BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 343.296ms - __MAX_OF_DriverTotalTime: 343.669ms - __MIN_OF_DriverTotalTime: 342.887ms - PeakDriverQueueSize: 2.517K (2517) - __MAX_OF_PeakDriverQueueSize: 95 - __MIN_OF_PeakDriverQueueSize: 2 - PendingTime: 0ns - InputEmptyTime: 65.246ms - __MAX_OF_InputEmptyTime: 90.043ms - __MIN_OF_InputEmptyTime: 49.439ms - FirstInputEmptyTime: 64.364ms - __MAX_OF_FirstInputEmptyTime: 90.043ms - __MIN_OF_FirstInputEmptyTime: 37.192ms - OutputFullTime: 3.217ms - __MAX_OF_OutputFullTime: 105.154ms - __MIN_OF_OutputFullTime: 0ns - PendingFinishTime: 103.356ms - __MAX_OF_PendingFinishTime: 186.781ms - __MIN_OF_PendingFinishTime: 1.637ms - ScheduleCount: 110 - __MAX_OF_ScheduleCount: 3 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 182.432ms - __MAX_OF_ScheduleTime: 253.657ms - __MIN_OF_ScheduleTime: 152.522ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 40 - __MAX_OF_YieldByTimeLimit: 1 - __MIN_OF_YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=2): CommonMetrics: - OperatorTotalTime: 156.141ms - __MAX_OF_OperatorTotalTime: 188.108ms - __MIN_OF_OperatorTotalTime: 86.799ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.707K (1707) - __MAX_OF_PushChunkNum: 29 - __MIN_OF_PushChunkNum: 22 - PushRowNum: 4.005M (4005432) - __MAX_OF_PushRowNum: 82.665K (82665) - __MIN_OF_PushRowNum: 44.271K (44271) - PushTotalTime: 105.239ms - __MAX_OF_PushTotalTime: 136.956ms - __MIN_OF_PushTotalTime: 70.834ms - SetFinishingTime: 50.900ms - __MAX_OF_SetFinishingTime: 68.687ms - __MIN_OF_SetFinishingTime: 8.667ms UniqueMetrics: - ChannelNum: 1 - DestFragments: 019ade7b029c78e6-94b837f1d86718b1 - DestID: 2 - PartType: HASH_PARTITIONED - PipelineLevelShuffle: Yes - ShuffleNumPerChannel: 64 - TotalShuffleNum: 64 - BytesPassThrough: 962.650 MB - __MAX_OF_BytesPassThrough: 19.976 MB - __MIN_OF_BytesPassThrough: 10.703 MB - BytesSent: 0.000 B - BytesUnsent: 0.000 B - CompressTime: 0ns - CompressedBytes: 0.000 B - NetworkBandwidth: 0.000 B/sec - NetworkTime: 186.794ms - OverallThroughput: 0.000 B/sec - OverallTime: 202.121ms - PassThroughBufferPeakMemoryUsage: 99.259 MB - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 1.633ms - RpcCount: 2.670K (2670) - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 104.746K (104746) - __MAX_OF_ShuffleChunkAppendCounter: 1.855K (1855) - __MIN_OF_ShuffleChunkAppendCounter: 1.250K (1250) - ShuffleChunkAppendTime: 86.549ms - __MAX_OF_ShuffleChunkAppendTime: 116.400ms - __MIN_OF_ShuffleChunkAppendTime: 54.956ms - ShuffleHashTime: 15.366ms - __MAX_OF_ShuffleHashTime: 29.783ms - __MIN_OF_ShuffleHashTime: 10.421ms - WaitTime: 106.710ms AGGREGATE_STREAMING_SOURCE (plan_node_id=1): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 3.804ms - __MAX_OF_OperatorTotalTime: 14.777ms - __MIN_OF_OperatorTotalTime: 856.671us - OutputChunkBytes: 961.588 MB - __MAX_OF_OutputChunkBytes: 19.960 MB - __MIN_OF_OutputChunkBytes: 10.686 MB - PullChunkNum: 1.707K (1707) - __MAX_OF_PullChunkNum: 29 - __MIN_OF_PullChunkNum: 22 - PullRowNum: 4.005M (4005432) - __MAX_OF_PullRowNum: 82.665K (82665) - __MIN_OF_PullRowNum: 44.271K (44271) - PullTotalTime: 3.755ms - __MAX_OF_PullTotalTime: 14.718ms - __MIN_OF_PullTotalTime: 821.231us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 16.373ms - __MAX_OF_ActiveTime: 46.173ms - __MIN_OF_ActiveTime: 9.191ms - BlockByInputEmpty: 419 - __MAX_OF_BlockByInputEmpty: 8 - __MIN_OF_BlockByInputEmpty: 4 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 117.460ms - __MAX_OF_DriverTotalTime: 117.676ms - __MIN_OF_DriverTotalTime: 117.035ms - PeakDriverQueueSize: 4.535K (4535) - __MAX_OF_PeakDriverQueueSize: 104 - __MIN_OF_PeakDriverQueueSize: 48 - PendingTime: 0ns - InputEmptyTime: 53.954ms - __MAX_OF_InputEmptyTime: 66.410ms - __MIN_OF_InputEmptyTime: 44.363ms - FirstInputEmptyTime: 13.210ms - __MAX_OF_FirstInputEmptyTime: 21.926ms - __MIN_OF_FirstInputEmptyTime: 4.098ms - FollowupInputEmptyTime: 40.744ms - __MAX_OF_FollowupInputEmptyTime: 57.755ms - __MIN_OF_FollowupInputEmptyTime: 27.704ms - ScheduleCount: 483 - __MAX_OF_ScheduleCount: 9 - __MIN_OF_ScheduleCount: 5 - ScheduleTime: 101.087ms - __MAX_OF_ScheduleTime: 108.287ms - __MIN_OF_ScheduleTime: 71.183ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_STREAMING_SINK (plan_node_id=1): CommonMetrics: - OperatorTotalTime: 15.690ms - __MAX_OF_OperatorTotalTime: 45.509ms - __MIN_OF_OperatorTotalTime: 8.574ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.886K (1886) - __MAX_OF_PushChunkNum: 30 - __MIN_OF_PushChunkNum: 29 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 84.356K (84356) - __MIN_OF_PushRowNum: 44.485K (44485) - PushTotalTime: 15.675ms - __MAX_OF_PushTotalTime: 45.492ms - __MIN_OF_PushTotalTime: 8.560ms - 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: 10.467ms - __MAX_OF_AggComputeTime: 41.254ms - __MIN_OF_AggComputeTime: 3.485ms - AggFuncComputeTime: 233.543us - __MAX_OF_AggFuncComputeTime: 1.049ms - __MIN_OF_AggFuncComputeTime: 35.711us - ChunkBufferPeakMem: 13.431 MB - __MAX_OF_ChunkBufferPeakMem: 18.857 MB - __MIN_OF_ChunkBufferPeakMem: 8.534 MB - ChunkBufferPeakSize: 17 - __MAX_OF_ChunkBufferPeakSize: 23 - __MIN_OF_ChunkBufferPeakSize: 11 - ExprComputeTime: 287.773us - __MAX_OF_ExprComputeTime: 379.176us - __MIN_OF_ExprComputeTime: 226.468us - ExprReleaseTime: 1.566ms - __MAX_OF_ExprReleaseTime: 23.204ms - __MIN_OF_ExprReleaseTime: 608.365us - GetResultsTime: 3.633ms - __MAX_OF_GetResultsTime: 14.597ms - __MIN_OF_GetResultsTime: 712.698us - HashTableMemoryUsage: 106.758 MB - __MAX_OF_HashTableMemoryUsage: 4.770 MB - __MIN_OF_HashTableMemoryUsage: 413.008 KB - HashTableSize: 240.235K (240235) - __MAX_OF_HashTableSize: 13.300K (13300) - __MIN_OF_HashTableSize: 609 - InputRowCount: 4.022M (4021783) - __MAX_OF_InputRowCount: 84.356K (84356) - __MIN_OF_InputRowCount: 44.485K (44485) - PassThroughRowCount: 3.765M (3765197) - __MAX_OF_PassThroughRowCount: 73.795K (73795) - __MIN_OF_PassThroughRowCount: 37.990K (37990) - ResultAggAppendTime: 548.239us - __MAX_OF_ResultAggAppendTime: 2.762ms - __MIN_OF_ResultAggAppendTime: 45.101us - ResultGroupByAppendTime: 2.662ms - __MAX_OF_ResultGroupByAppendTime: 10.889ms - __MIN_OF_ResultGroupByAppendTime: 433.101us - ResultIteratorTime: 236.665us - __MAX_OF_ResultIteratorTime: 844.591us - __MIN_OF_ResultIteratorTime: 43.861us - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 3.384ms - __MAX_OF_StreamingTime: 4.501ms - __MIN_OF_StreamingTime: 1.983ms LOCAL_EXCHANGE_SOURCE (plan_node_id=1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 372.874us - __MAX_OF_OperatorTotalTime: 1.442ms - __MIN_OF_OperatorTotalTime: 301.800us - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 20.369 MB - __MIN_OF_OutputChunkBytes: 10.738 MB - PullChunkNum: 1.886K (1886) - __MAX_OF_PullChunkNum: 30 - __MIN_OF_PullChunkNum: 29 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 84.356K (84356) - __MIN_OF_PullRowNum: 44.485K (44485) - PullTotalTime: 369.662us - __MAX_OF_PullTotalTime: 1.441ms - __MIN_OF_PullTotalTime: 299.550us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 16.324ms - __MAX_OF_ActiveTime: 48.673ms - __MIN_OF_ActiveTime: 7.694ms - BlockByInputEmpty: 439 - __MAX_OF_BlockByInputEmpty: 10 - __MIN_OF_BlockByInputEmpty: 4 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 64 - DriverTotalTime: 116.239ms - __MAX_OF_DriverTotalTime: 117.791ms - __MIN_OF_DriverTotalTime: 114.877ms - OverheadTime: 3.581ms - __MAX_OF_OverheadTime: 22.912ms - __MIN_OF_OverheadTime: 0ns - PeakDriverQueueSize: 6.297K (6297) - __MAX_OF_PeakDriverQueueSize: 127 - __MIN_OF_PeakDriverQueueSize: 65 - PendingTime: 0ns - InputEmptyTime: 60.910ms - __MAX_OF_InputEmptyTime: 85.040ms - __MIN_OF_InputEmptyTime: 32.626ms - FollowupInputEmptyTime: 60.499ms - __MAX_OF_FollowupInputEmptyTime: 84.624ms - __MIN_OF_FollowupInputEmptyTime: 32.209ms - ScheduleCount: 503 - __MAX_OF_ScheduleCount: 11 - __MIN_OF_ScheduleCount: 5 - ScheduleTime: 99.915ms - __MAX_OF_ScheduleTime: 108.122ms - __MIN_OF_ScheduleTime: 66.328ms - TotalDegreeOfParallelism: 64 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.325ms - __MAX_OF_OperatorTotalTime: 29.041ms - __MIN_OF_OperatorTotalTime: 47.374us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.886K (1886) - __MAX_OF_PushChunkNum: 47 - __MIN_OF_PushChunkNum: 15 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 107.705K (107705) - __MIN_OF_PushRowNum: 20.926K (20926) - PushTotalTime: 1.319ms - __MAX_OF_PushTotalTime: 29.040ms - __MIN_OF_PushTotalTime: 46.983us UniqueMetrics: - ShuffleNum: 64 - Type: Passthrough - LocalExchangePeakMemoryUsage: 236.259 MB CHUNK_ACCUMULATE (plan_node_id=0): CommonMetrics: - IsSubordinate - OperatorTotalTime: 3.462ms - __MAX_OF_OperatorTotalTime: 20.028ms - __MIN_OF_OperatorTotalTime: 646.563us - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 25.772 MB - __MIN_OF_OutputChunkBytes: 5.000 MB - PullChunkNum: 1.886K (1886) - __MAX_OF_PullChunkNum: 47 - __MIN_OF_PullChunkNum: 15 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 107.705K (107705) - __MIN_OF_PullRowNum: 20.926K (20926) - PullTotalTime: 4.231us - __MAX_OF_PullTotalTime: 6.348us - __MIN_OF_PullTotalTime: 2.448us - PushChunkNum: 2.310K (2310) - __MAX_OF_PushChunkNum: 55 - __MIN_OF_PushChunkNum: 21 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 107.705K (107705) - __MIN_OF_PushRowNum: 20.926K (20926) - PushTotalTime: 3.457ms - __MAX_OF_PushTotalTime: 20.023ms - __MIN_OF_PushTotalTime: 642.413us UniqueMetrics: OLAP_SCAN (plan_node_id=0): CommonMetrics: - RuntimeFilterDesc: <1: BloomFilter> - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 4.022M (4021783) - __MAX_OF_JoinRuntimeFilterInputRows: 107.705K (107705) - __MIN_OF_JoinRuntimeFilterInputRows: 20.926K (20926) - JoinRuntimeFilterOutputRows: 4.022M (4021783) - __MAX_OF_JoinRuntimeFilterOutputRows: 107.705K (107705) - __MIN_OF_JoinRuntimeFilterOutputRows: 20.926K (20926) - JoinRuntimeFilterTime: 7.317us - __MAX_OF_JoinRuntimeFilterTime: 12.423us - __MIN_OF_JoinRuntimeFilterTime: 3.509us - OperatorTotalTime: 7.971ms - __MAX_OF_OperatorTotalTime: 30.961ms - __MIN_OF_OperatorTotalTime: 4.710ms - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 25.772 MB - __MIN_OF_OutputChunkBytes: 5.000 MB - PullChunkNum: 2.310K (2310) - __MAX_OF_PullChunkNum: 55 - __MIN_OF_PullChunkNum: 21 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 107.705K (107705) - __MIN_OF_PullRowNum: 20.926K (20926) - PullTotalTime: 7.241ms - __MAX_OF_PullTotalTime: 30.350ms - __MIN_OF_PullTotalTime: 4.010ms - 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: 11.645 MB - __MIN_OF_BytesRead: 354.523 KB - CachedPagesNum: 36.905K (36905) - __MAX_OF_CachedPagesNum: 279 - __MIN_OF_CachedPagesNum: 66 - ChunkBufferCapacity: 4.096K (4096) - CompressedBytesRead: 0.000 B - DefaultChunkBufferCapacity: 4.096K (4096) - IOTaskExecTime: 35.429ms - __MAX_OF_IOTaskExecTime: 85.419ms - __MIN_OF_IOTaskExecTime: 5.811ms - CreateSegmentIter: 272.465us - __MAX_OF_CreateSegmentIter: 3.829ms - __MIN_OF_CreateSegmentIter: 113.552us - DictDecode: 5.119ms - __MAX_OF_DictDecode: 36.333ms - __MIN_OF_DictDecode: 100.021us - DictDecodeCount: 41.856M (41855685) - __MAX_OF_DictDecodeCount: 473.679K (473679) - __MIN_OF_DictDecodeCount: 1.722K (1722) - ExprFilterRows: 0 - ExprFilterTime: 8.093ms - __MAX_OF_ExprFilterTime: 29.851ms - __MIN_OF_ExprFilterTime: 473.323us - GetDelVec: 0ns - GetDeltaColumnGroup: 52.746us - __MAX_OF_GetDeltaColumnGroup: 3.557ms - __MIN_OF_GetDeltaColumnGroup: 2.850us - GetRowsets: 22.253us - __MAX_OF_GetRowsets: 1.707ms - __MIN_OF_GetRowsets: 7.520us - IOTime: 0ns - LateMaterialize: 3.672ms - __MAX_OF_LateMaterialize: 29.163ms - __MIN_OF_LateMaterialize: 418.560us - LateMaterializeRows: 947.954K (947954) - __MAX_OF_LateMaterializeRows: 14.531K (14531) - __MIN_OF_LateMaterializeRows: 53 - ReadPKIndex: 0ns - SegmentInit: 1.817ms - __MAX_OF_SegmentInit: 22.392ms - __MIN_OF_SegmentInit: 769.388us - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 28.967us - __MAX_OF_BitmapIndexIteratorInit: 58.771us - __MIN_OF_BitmapIndexIteratorInit: 16.190us - BloomFilterFilter: 1.440us - __MAX_OF_BloomFilterFilter: 3.531us - __MIN_OF_BloomFilterFilter: 682ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 820.923us - __MAX_OF_ColumnIteratorInit: 21.271ms - __MIN_OF_ColumnIteratorInit: 244.616us - GetVectorRowRangesTime: 0ns - GinFilter: 0ns - GinFilterRows: 0 - ProcessVectorDistanceAndIdTime: 0ns - RemainingRowsAfterShortKeyFilter: 16.223M (16222711) - __MAX_OF_RemainingRowsAfterShortKeyFilter: 152.627K (152627) - __MIN_OF_RemainingRowsAfterShortKeyFilter: 17.342K (17342) - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 92.376us - __MAX_OF_ShortKeyFilter: 1.027ms - __MIN_OF_ShortKeyFilter: 37.681us - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 35.396us - __MAX_OF_ZoneMapIndexFilter: 73.062us - __MIN_OF_ZoneMapIndexFilter: 18.080us - ZoneMapIndexFilterRows: 147.456K (147456) - __MAX_OF_ZoneMapIndexFilterRows: 32.768K (32768) - __MIN_OF_ZoneMapIndexFilterRows: 0 - SegmentRead: 10.017ms - __MAX_OF_SegmentRead: 43.113ms - __MIN_OF_SegmentRead: 677.847us - BlockFetch: 8.348ms - __MAX_OF_BlockFetch: 41.384ms - __MIN_OF_BlockFetch: 275.339us - BlockFetchCount: 4.058K (4058) - __MAX_OF_BlockFetchCount: 54 - __MIN_OF_BlockFetchCount: 5 - BlockSeek: 300.881us - __MAX_OF_BlockSeek: 19.924ms - __MIN_OF_BlockSeek: 31.341us - BlockSeekCount: 9.790K (9790) - __MAX_OF_BlockSeekCount: 135 - __MIN_OF_BlockSeekCount: 1 - ChunkCopy: 93.538us - __MAX_OF_ChunkCopy: 5.931ms - __MIN_OF_ChunkCopy: 1.490us - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 1.206ms - __MAX_OF_PredFilter: 10.252ms - __MIN_OF_PredFilter: 293.277us - PredFilterRows: 10.293M (10292677) - __MAX_OF_PredFilterRows: 113.710K (113710) - __MIN_OF_PredFilterRows: 6.702K (6702) - RowsetsReadCount: 1.408K (1408) - __MAX_OF_RowsetsReadCount: 8 - __MIN_OF_RowsetsReadCount: 4 - SegmentsReadCount: 704 - __MAX_OF_SegmentsReadCount: 4 - __MIN_OF_SegmentsReadCount: 2 - TotalColumnsDataPageCount: 33.068K (33068) - __MAX_OF_TotalColumnsDataPageCount: 294 - __MIN_OF_TotalColumnsDataPageCount: 46 - IOTaskWaitTime: 33.293ms - __MAX_OF_IOTaskWaitTime: 82.340ms - __MIN_OF_IOTaskWaitTime: 1.179ms - MorselsCount: 704 - __MAX_OF_MorselsCount: 14 - __MIN_OF_MorselsCount: 8 - NonPushdownPredicates: 1 - PeakChunkBufferMemoryUsage: 848.386 MB - PeakChunkBufferSize: 23 - PeakIOTasks: 4 - PeakScanTaskQueueSize: 9.440K (9440) - __MAX_OF_PeakScanTaskQueueSize: 160 - __MIN_OF_PeakScanTaskQueueSize: 119 - PrepareChunkSourceTime: 3.647ms - __MAX_OF_PrepareChunkSourceTime: 7.295ms - __MIN_OF_PrepareChunkSourceTime: 2.374ms - PushdownAccessPaths: 0 - PushdownPredicates: 7 - RawRowsRead: 14.314M (14314460) - __MAX_OF_RawRowsRead: 131.777K (131777) - __MIN_OF_RawRowsRead: 17.342K (17342) - ReadPagesNum: 36.905K (36905) - __MAX_OF_ReadPagesNum: 279 - __MIN_OF_ReadPagesNum: 66 - RowsRead: 4.022M (4021783) - __MAX_OF_RowsRead: 40.692K (40692) - __MIN_OF_RowsRead: 814 - RuntimeFilterEvalTime: 44.910us - __MAX_OF_RuntimeFilterEvalTime: 161.064us - __MIN_OF_RuntimeFilterEvalTime: 13.889us - RuntimeFilterInputRows: 13.237M (13236609) - __MAX_OF_RuntimeFilterInputRows: 108.755K (108755) - __MIN_OF_RuntimeFilterInputRows: 16.752K (16752) - RuntimeFilterOutputRows: 12.593M (12592727) - __MAX_OF_RuntimeFilterOutputRows: 108.330K (108330) - __MIN_OF_RuntimeFilterOutputRows: 12.531K (12531) - ScanTime: 68.723ms - __MAX_OF_ScanTime: 107.693ms - __MIN_OF_ScanTime: 26.689ms - SubmitTaskCount: 704 - __MAX_OF_SubmitTaskCount: 14 - __MIN_OF_SubmitTaskCount: 8 - SubmitTaskTime: 1.804ms - __MAX_OF_SubmitTaskTime: 3.781ms - __MIN_OF_SubmitTaskTime: 65.090us - TabletCount: 704 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 535.943us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverPrepareTime: 1.573ms - DriverTotalTime: 900.553us - 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: 537.063us - OutputChunkBytes: 0.000 B - PrepareTime: 1.553ms - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 530.563us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 1.544ms