Query: Summary: - Query ID: 019adf40-9b2a-7846-8b71-b0d85a2629d4 - Start Time: 2025-12-02 13:29:04 - End Time: 2025-12-02 13:29:16 - Total: 12s115ms - 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=1,max_parallel_scan_instance_num=-1,pipeline_dop=0,enable_adaptive_sink_dop=true,enable_runtime_adaptive_dop=false,runtime_profile_report_interval=10,resource_group=default_wg - NonDefaultSessionVariables: {"broadcast_row_limit":{"defaultValue":15000000,"actualValue":1000000},"exec_mem_limit":{"defaultValue":2147483648,"actualValue":214748364800},"enable_adaptive_sink_dop":{"defaultValue":false,"actualValue":true},"enable_profile":{"defaultValue":false,"actualValue":true}} - Collect Profile Time: 1ms - IsProfileAsync: true Planner: - -- Parser[1] 2ms - -- Total[1] 21ms - -- Analyzer[1] 1ms - -- Lock[1] 0 - -- AnalyzeDatabase[3] 0 - -- AnalyzeTemporaryTable[3] 0 - -- AnalyzeTable[3] 0 - -- Transformer[1] 3ms - -- Optimizer[1] 12ms - -- MVPreprocess[1] 0 - -- MVTextRewrite[1] 0 - -- RuleBaseOptimize[1] 6ms - -- CostBaseOptimize[1] 3ms - -- PhysicalRewrite[1] 2ms - -- DynamicRewrite[1] 0 - -- PlanValidate[1] 0 - -- TypeChecker[1] 0 - -- CTEUniqueChecker[1] 0 - -- InputDependenciesChecker[1] 0 - -- ColumnReuseChecker[1] 0 - -- ExecPlanBuild[1] 2ms - -- Pending[1] 0 - -- Prepare[1] 0 - -- Deploy[1] 44ms - -- DeployLockInternalTime[1] 44ms - -- DeploySerializeConcurrencyTime[3] 3ms - -- DeployStageByStageTime[9] 0 - -- DeployAsyncSendTime[5] 0 - -- DeployWaitTime[9] 39ms - -- 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.791ms - QueryAllocatedMemoryUsage: 59.200 GB - QueryCumulativeCpuTime: 1m25s - QueryCumulativeNetworkTime: 235.280ms - QueryCumulativeOperatorTime: 18s352ms - QueryCumulativeScanTime: 135.412ms - QueryDeallocatedMemoryUsage: 57.375 GB - QueryExecutionWallTime: 12s80ms - QueryPeakMemoryUsagePerNode: 7.437 GB - QueryPeakScheduleTime: 770.169ms - QuerySpillBytes: 0.000 B - QuerySumMemoryUsage: 7.437 GB - ResultDeliverTime: 0ns Fragment 0: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019adf40-9b2a-7846-8b71-b0d85a2629d5 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 194.354us - InitialProcessDriverCount: 0 - InitialProcessMem: 43.700 GB - InstanceAllocatedMemoryUsage: 9.860 GB - InstanceDeallocatedMemoryUsage: 9.858 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 11.953 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 11s309ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 12s79ms - OverheadTime: 5s385ms - PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 768.160ms - FirstInputEmptyTime: 768.160ms - ScheduleCount: 84 - ScheduleTime: 770.169ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 83 RESULT_SINK (plan_node_id=-1): CommonMetrics: - IsFinalSink - OperatorTotalTime: 2s597ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 828 - PushRowNum: 3.362M (3362123) - PushTotalTime: 2s597ms UniqueMetrics: - SinkType: MYSQL_PROTOCAL - AppendChunkTime: 2s105ms - ResultRendTime: 491.158ms - TupleConvertTime: 2s100ms - NumSentRows: 3.362M (3362123) CHUNK_ACCUMULATE (plan_node_id=-1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 2.336ms - OutputChunkBytes: 1.339 GB - PullChunkNum: 828 - PullRowNum: 3.362M (3362123) - PullTotalTime: 66.766us - PushChunkNum: 863 - PushRowNum: 3.362M (3362123) - PushTotalTime: 2.268ms UniqueMetrics: DICT_DECODE (plan_node_id=19): CommonMetrics: - OperatorTotalTime: 40.884ms - OutputChunkBytes: 1.339 GB - PullChunkNum: 863 - PullRowNum: 3.362M (3362123) - PullTotalTime: 139.796us - PushChunkNum: 863 - PushRowNum: 3.362M (3362123) - PushTotalTime: 40.737ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: GLOBAL_MERGE_SOURCE (plan_node_id=18): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 3s283ms - OutputChunkBytes: 1.302 GB - PullChunkNum: 863 - PullRowNum: 3.362M (3362123) - PullTotalTime: 3s283ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 0.000 B - BytesReceived: 103.174 MB - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 96.543ms - DeserializeChunkTime: 661.673ms - PeakBufferMemoryBytes: 516.885 KB - ReceiverProcessTotalTime: 761.989ms - RequestReceived: 339 - WaitLockTime: 49.758us Fragment 1: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019adf40-9b2a-7846-8b71-b0d85a2629d6 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 9.020ms - FragmentInstancePrepareTime: 17.670ms - prepare-pipeline-driver: 13.959ms - InitialProcessDriverCount: 1 - InitialProcessMem: 43.700 GB - InstanceAllocatedMemoryUsage: 35.645 GB - InstanceDeallocatedMemoryUsage: 35.400 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 5.867 GB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 29.256us - __MAX_OF_ActiveTime: 166.654us - __MIN_OF_ActiveTime: 8.452us - BlockByInputEmpty: 48 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 18.961ms - __MAX_OF_DriverTotalTime: 19.111ms - __MIN_OF_DriverTotalTime: 18.844ms - PeakDriverQueueSize: 1.166K (1166) - __MAX_OF_PeakDriverQueueSize: 47 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 18.150ms - __MAX_OF_InputEmptyTime: 18.199ms - __MIN_OF_InputEmptyTime: 18.090ms - FirstInputEmptyTime: 16.931ms - __MAX_OF_FirstInputEmptyTime: 16.934ms - __MIN_OF_FirstInputEmptyTime: 16.928ms - FollowupInputEmptyTime: 1.219ms - __MAX_OF_FollowupInputEmptyTime: 1.269ms - __MIN_OF_FollowupInputEmptyTime: 1.160ms - ScheduleCount: 96 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 18.931ms - __MAX_OF_ScheduleTime: 19.095ms - __MIN_OF_ScheduleTime: 18.764ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 6.545us - __MAX_OF_OperatorTotalTime: 80.852us - __MIN_OF_OperatorTotalTime: 412ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 24 - __MAX_OF_PushChunkNum: 5 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 36 - __MAX_OF_PushRowNum: 10 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 5.857us - __MAX_OF_PushTotalTime: 79.612us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 1 - Type: Passthrough - LocalExchangePeakMemoryUsage: 5.686 KB EXCHANGE_SOURCE (plan_node_id=14): CommonMetrics: - ConjunctsInputRows: 36 - __MAX_OF_ConjunctsInputRows: 10 - __MIN_OF_ConjunctsInputRows: 1 - ConjunctsOutputRows: 36 - __MAX_OF_ConjunctsOutputRows: 10 - __MIN_OF_ConjunctsOutputRows: 1 - ConjunctsTime: 1.637us - __MAX_OF_ConjunctsTime: 3.700us - __MIN_OF_ConjunctsTime: 860ns - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 17.826us - __MAX_OF_OperatorTotalTime: 67.181us - __MIN_OF_OperatorTotalTime: 7.930us - OutputChunkBytes: 4.425 KB - __MAX_OF_OutputChunkBytes: 1.231 KB - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 24 - __MAX_OF_PullChunkNum: 5 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 36 - __MAX_OF_PullRowNum: 10 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 6.214us - __MAX_OF_PullTotalTime: 33.171us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 1 - __MAX_OF_BufferUnplugCount: 1 - __MIN_OF_BufferUnplugCount: 0 - BytesPassThrough: 9.300 KB - __MAX_OF_BytesPassThrough: 5.213 KB - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 0.000 B - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 0ns - DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 9.300 KB - __MAX_OF_PeakBufferMemoryBytes: 5.213 KB - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 1.759us - __MAX_OF_ReceiverProcessTotalTime: 22.481us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 25 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 0ns Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 947.993us - BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 19.674ms - PeakDriverQueueSize: 28 - PendingTime: 0ns - InputEmptyTime: 18.587ms - FirstInputEmptyTime: 17.299ms - FollowupInputEmptyTime: 1.288ms - ScheduleCount: 2 - ScheduleTime: 18.726ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 HASH_JOIN_BUILD (plan_node_id=15): CommonMetrics: - OperatorTotalTime: 674.197us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 24 - PushRowNum: 36 - PushTotalTime: 118.063us - 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: 35.092us - BuildHashTableTime: 161.254us - BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 77.160us - HashTableMemoryUsage: 11.468 KB - PartialRuntimeMembershipFilterBytes: 64.000 B - PartitionNums: 1 - RuntimeFilterBuildTime: 56.832us - RuntimeFilterNum: 2 LOCAL_EXCHANGE_SOURCE (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 64.201us - OutputChunkBytes: 4.425 KB - PullChunkNum: 24 - PullRowNum: 36 - PullTotalTime: 57.901us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=2): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 15.161us - __MAX_OF_ActiveTime: 66.052us - __MIN_OF_ActiveTime: 5.771us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 23.081ms - __MAX_OF_DriverTotalTime: 24.601ms - __MIN_OF_DriverTotalTime: 22.867ms - PeakDriverQueueSize: 917 - __MAX_OF_PeakDriverQueueSize: 43 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 3.175ms - __MAX_OF_InputEmptyTime: 3.234ms - __MIN_OF_InputEmptyTime: 3.140ms - FirstInputEmptyTime: 3.175ms - __MAX_OF_FirstInputEmptyTime: 3.234ms - __MIN_OF_FirstInputEmptyTime: 3.140ms - PreconditionBlockTime: 19.454ms - __MAX_OF_PreconditionBlockTime: 19.485ms - __MIN_OF_PreconditionBlockTime: 19.421ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 23.065ms - __MAX_OF_ScheduleTime: 24.588ms - __MIN_OF_ScheduleTime: 22.843ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=9): CommonMetrics: - IsSubordinate - OperatorTotalTime: 846ns - __MAX_OF_OperatorTotalTime: 6.489us - __MIN_OF_OperatorTotalTime: 360ns - 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: 110ns - __MAX_OF_PushTotalTime: 4.070us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 1 - Type: Passthrough - LocalExchangePeakMemoryUsage: 145.000 B CHUNK_ACCUMULATE (plan_node_id=8): CommonMetrics: - IsSubordinate - OperatorTotalTime: 438ns - __MAX_OF_OperatorTotalTime: 1.090us - __MIN_OF_OperatorTotalTime: 260ns - 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: 3ns - __MAX_OF_PullTotalTime: 120ns - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 2 - __MAX_OF_PushRowNum: 1 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 16ns - __MAX_OF_PushTotalTime: 570ns - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: EXCHANGE_SOURCE (plan_node_id=8): CommonMetrics: - RuntimeFilterDesc: <0: BloomFilter> - ConjunctsInputRows: 2 - __MAX_OF_ConjunctsInputRows: 1 - __MIN_OF_ConjunctsInputRows: 1 - ConjunctsOutputRows: 2 - __MAX_OF_ConjunctsOutputRows: 1 - __MIN_OF_ConjunctsOutputRows: 1 - ConjunctsTime: 5.235us - __MAX_OF_ConjunctsTime: 9.150us - __MIN_OF_ConjunctsTime: 1.320us - JoinRuntimeFilterEvaluate: 2 - __MAX_OF_JoinRuntimeFilterEvaluate: 1 - __MIN_OF_JoinRuntimeFilterEvaluate: 1 - JoinRuntimeFilterHashTime: 305ns - __MAX_OF_JoinRuntimeFilterHashTime: 520ns - __MIN_OF_JoinRuntimeFilterHashTime: 90ns - JoinRuntimeFilterInputRows: 2 - __MAX_OF_JoinRuntimeFilterInputRows: 1 - __MIN_OF_JoinRuntimeFilterInputRows: 1 - JoinRuntimeFilterOutputRows: 2 - __MAX_OF_JoinRuntimeFilterOutputRows: 1 - __MIN_OF_JoinRuntimeFilterOutputRows: 1 - JoinRuntimeFilterTime: 3.700us - __MAX_OF_JoinRuntimeFilterTime: 5.470us - __MIN_OF_JoinRuntimeFilterTime: 1.930us - OperatorTotalTime: 17.974us - __MAX_OF_OperatorTotalTime: 61.892us - __MIN_OF_OperatorTotalTime: 7.329us - 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.402us - __MAX_OF_PullTotalTime: 35.761us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 263.000 B - __MAX_OF_BytesPassThrough: 263.000 B - __MIN_OF_BytesPassThrough: 0.000 B - BytesReceived: 0.000 B - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 0ns - DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 263.000 B - __MAX_OF_PeakBufferMemoryBytes: 263.000 B - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 400ns - __MAX_OF_ReceiverProcessTotalTime: 13.340us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 3 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 0ns Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 479.952us - BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 25.047ms - PeakDriverQueueSize: 42 - PendingTime: 0ns - InputEmptyTime: 22.649ms - FirstInputEmptyTime: 22.630ms - ScheduleCount: 2 - ScheduleTime: 24.567ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 HASH_JOIN_BUILD (plan_node_id=9): CommonMetrics: - OperatorTotalTime: 450.773us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 2 - PushRowNum: 2 - PushTotalTime: 18.591us - 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: 4.920us - BuildHashTableTime: 188.105us - BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 10.320us - HashTableMemoryUsage: 4.233 KB - PartialRuntimeMembershipFilterBytes: 0.000 B - PartitionNums: 1 - RuntimeFilterBuildTime: 5.290us - RuntimeFilterNum: 0 LOCAL_EXCHANGE_SOURCE (plan_node_id=9): CommonMetrics: - IsSubordinate - OperatorTotalTime: 17.010us - OutputChunkBytes: 103.000 B - PullChunkNum: 2 - PullRowNum: 2 - PullTotalTime: 6.830us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=4): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 100.440ms - __MAX_OF_ActiveTime: 116.247ms - __MIN_OF_ActiveTime: 83.963ms - BlockByInputEmpty: 759 - __MAX_OF_BlockByInputEmpty: 28 - __MIN_OF_BlockByInputEmpty: 7 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 354.147ms - __MAX_OF_DriverTotalTime: 355.172ms - __MIN_OF_DriverTotalTime: 353.287ms - OverheadTime: 1.719ms - __MAX_OF_OverheadTime: 2.341ms - __MIN_OF_OverheadTime: 1.389ms - PeakDriverQueueSize: 3.168K (3168) - __MAX_OF_PeakDriverQueueSize: 92 - __MIN_OF_PeakDriverQueueSize: 13 - PendingTime: 0ns - InputEmptyTime: 230.608ms - __MAX_OF_InputEmptyTime: 247.494ms - __MIN_OF_InputEmptyTime: 214.067ms - FirstInputEmptyTime: 172.683ms - __MAX_OF_FirstInputEmptyTime: 182.634ms - __MIN_OF_FirstInputEmptyTime: 167.356ms - FollowupInputEmptyTime: 57.924ms - __MAX_OF_FollowupInputEmptyTime: 74.449ms - __MIN_OF_FollowupInputEmptyTime: 46.708ms - PreconditionBlockTime: 19.515ms - __MAX_OF_PreconditionBlockTime: 19.538ms - __MIN_OF_PreconditionBlockTime: 19.492ms - ScheduleCount: 808 - __MAX_OF_ScheduleCount: 29 - __MIN_OF_ScheduleCount: 8 - ScheduleTime: 253.707ms - __MAX_OF_ScheduleTime: 271.209ms - __MIN_OF_ScheduleTime: 237.040ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=3): CommonMetrics: - OperatorTotalTime: 87.464ms - __MAX_OF_OperatorTotalTime: 100.976ms - __MIN_OF_OperatorTotalTime: 72.931ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.177K (1177) - __MAX_OF_PushChunkNum: 25 - __MIN_OF_PushChunkNum: 24 - PushRowNum: 4.012M (4012361) - __MAX_OF_PushRowNum: 84.096K (84096) - __MIN_OF_PushRowNum: 83.101K (83101) - PushTotalTime: 87.425ms - __MAX_OF_PushTotalTime: 100.940ms - __MIN_OF_PushTotalTime: 72.915ms - 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: 85.760ms - __MAX_OF_AggComputeTime: 99.066ms - __MIN_OF_AggComputeTime: 71.456ms - AggFuncComputeTime: 3.387ms - __MAX_OF_AggFuncComputeTime: 5.004ms - __MIN_OF_AggFuncComputeTime: 2.305ms - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 334.228us - __MAX_OF_ExprComputeTime: 416.776us - __MIN_OF_ExprComputeTime: 271.472us - ExprReleaseTime: 1.447ms - __MAX_OF_ExprReleaseTime: 2.071ms - __MIN_OF_ExprReleaseTime: 1.086ms - GetResultsTime: 45.055ms - __MAX_OF_GetResultsTime: 56.596ms - __MIN_OF_GetResultsTime: 37.286ms - HashTableMemoryUsage: 1.351 GB - __MAX_OF_HashTableMemoryUsage: 29.004 MB - __MIN_OF_HashTableMemoryUsage: 28.504 MB - HashTableSize: 3.740M (3740376) - __MAX_OF_HashTableSize: 78.434K (78434) - __MIN_OF_HashTableSize: 77.436K (77436) - InputRowCount: 4.012M (4012361) - __MAX_OF_InputRowCount: 84.096K (84096) - __MIN_OF_InputRowCount: 83.101K (83101) - PassThroughRowCount: 0 - ResultAggAppendTime: 8.513ms - __MAX_OF_ResultAggAppendTime: 9.431ms - __MIN_OF_ResultAggAppendTime: 7.682ms - ResultGroupByAppendTime: 34.365ms - __MAX_OF_ResultGroupByAppendTime: 45.464ms - __MIN_OF_ResultGroupByAppendTime: 27.140ms - ResultIteratorTime: 1.096ms - __MAX_OF_ResultIteratorTime: 1.383ms - __MIN_OF_ResultIteratorTime: 874.182us - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns CHUNK_ACCUMULATE (plan_node_id=2): CommonMetrics: - IsSubordinate - OperatorTotalTime: 10.143ms - __MAX_OF_OperatorTotalTime: 12.397ms - __MIN_OF_OperatorTotalTime: 8.346ms - OutputChunkBytes: 963.260 MB - __MAX_OF_OutputChunkBytes: 20.186 MB - __MIN_OF_OutputChunkBytes: 19.951 MB - PullChunkNum: 1.177K (1177) - __MAX_OF_PullChunkNum: 25 - __MIN_OF_PullChunkNum: 24 - PullRowNum: 4.012M (4012361) - __MAX_OF_PullRowNum: 84.096K (84096) - __MIN_OF_PullRowNum: 83.101K (83101) - PullTotalTime: 4.360us - __MAX_OF_PullTotalTime: 6.211us - __MIN_OF_PullTotalTime: 3.038us - PushChunkNum: 2.304K (2304) - __MAX_OF_PushChunkNum: 48 - __MIN_OF_PushChunkNum: 48 - PushRowNum: 4.012M (4012361) - __MAX_OF_PushRowNum: 84.096K (84096) - __MIN_OF_PushRowNum: 83.101K (83101) - PushTotalTime: 10.138ms - __MAX_OF_PushTotalTime: 12.392ms - __MIN_OF_PushTotalTime: 8.341ms UniqueMetrics: EXCHANGE_SOURCE (plan_node_id=2): CommonMetrics: - RuntimeFilterDesc: <1: BloomFilter> - ConjunctsInputRows: 4.012M (4012361) - __MAX_OF_ConjunctsInputRows: 84.096K (84096) - __MIN_OF_ConjunctsInputRows: 83.101K (83101) - ConjunctsOutputRows: 4.012M (4012361) - __MAX_OF_ConjunctsOutputRows: 84.096K (84096) - __MIN_OF_ConjunctsOutputRows: 83.101K (83101) - ConjunctsTime: 180.322us - __MAX_OF_ConjunctsTime: 233.239us - __MIN_OF_ConjunctsTime: 138.652us - JoinRuntimeFilterEvaluate: 96 - __MAX_OF_JoinRuntimeFilterEvaluate: 2 - __MIN_OF_JoinRuntimeFilterEvaluate: 2 - JoinRuntimeFilterHashTime: 1.221us - __MAX_OF_JoinRuntimeFilterHashTime: 8.570us - __MIN_OF_JoinRuntimeFilterHashTime: 230ns - JoinRuntimeFilterInputRows: 4.012M (4012361) - __MAX_OF_JoinRuntimeFilterInputRows: 84.096K (84096) - __MIN_OF_JoinRuntimeFilterInputRows: 83.101K (83101) - JoinRuntimeFilterOutputRows: 4.012M (4012361) - __MAX_OF_JoinRuntimeFilterOutputRows: 84.096K (84096) - __MIN_OF_JoinRuntimeFilterOutputRows: 83.101K (83101) - JoinRuntimeFilterTime: 85.818us - __MAX_OF_JoinRuntimeFilterTime: 138.945us - __MIN_OF_JoinRuntimeFilterTime: 38.311us - OperatorTotalTime: 1.113ms - __MAX_OF_OperatorTotalTime: 1.991ms - __MIN_OF_OperatorTotalTime: 735.167us - OutputChunkBytes: 963.260 MB - __MAX_OF_OutputChunkBytes: 20.186 MB - __MIN_OF_OutputChunkBytes: 19.951 MB - PullChunkNum: 2.304K (2304) - __MAX_OF_PullChunkNum: 48 - __MIN_OF_PullChunkNum: 48 - PullRowNum: 4.012M (4012361) - __MAX_OF_PullRowNum: 84.096K (84096) - __MIN_OF_PullRowNum: 83.101K (83101) - PullTotalTime: 1.073ms - __MAX_OF_PullTotalTime: 1.976ms - __MIN_OF_PullTotalTime: 713.817us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 1 UniqueMetrics: - BufferUnplugCount: 27 - __MAX_OF_BufferUnplugCount: 1 - __MIN_OF_BufferUnplugCount: 0 - BytesPassThrough: 963.858 MB - __MAX_OF_BytesPassThrough: 77.769 MB - __MIN_OF_BytesPassThrough: 4.403 MB - BytesReceived: 0.000 B - ClosureBlockCount: 483 - __MAX_OF_ClosureBlockCount: 15 - __MIN_OF_ClosureBlockCount: 3 - ClosureBlockTime: 121.732ms - __MAX_OF_ClosureBlockTime: 396.211ms - __MIN_OF_ClosureBlockTime: 1.980ms - DecompressChunkTime: 0ns - DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 496.842 MB - __MAX_OF_PeakBufferMemoryBytes: 64.765 MB - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 437.476us - __MAX_OF_ReceiverProcessTotalTime: 929.545us - __MIN_OF_ReceiverProcessTotalTime: 173.098us - RequestReceived: 2.305K (2305) - __MAX_OF_RequestReceived: 49 - __MIN_OF_RequestReceived: 48 - WaitLockTime: 0ns Pipeline (id=5): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 210.466ms - __MAX_OF_ActiveTime: 248.057ms - __MIN_OF_ActiveTime: 184.041ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 564.611ms - __MAX_OF_DriverTotalTime: 602.643ms - __MIN_OF_DriverTotalTime: 538.034ms - PeakDriverQueueSize: 627 - __MAX_OF_PeakDriverQueueSize: 83 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 329.070ms - __MAX_OF_InputEmptyTime: 330.150ms - __MIN_OF_InputEmptyTime: 328.303ms - FirstInputEmptyTime: 329.070ms - __MAX_OF_FirstInputEmptyTime: 330.150ms - __MIN_OF_FirstInputEmptyTime: 328.303ms - PreconditionBlockTime: 24.870ms - __MAX_OF_PreconditionBlockTime: 24.936ms - __MIN_OF_PreconditionBlockTime: 24.795ms - ScheduleCount: 72 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 354.144ms - __MAX_OF_ScheduleTime: 355.134ms - __MIN_OF_ScheduleTime: 353.656ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 24 - __MAX_OF_YieldByTimeLimit: 1 - __MIN_OF_YieldByTimeLimit: 0 LOCAL_SORT_SINK (plan_node_id=17): CommonMetrics: - OperatorTotalTime: 109.310ms - __MAX_OF_OperatorTotalTime: 132.329ms - __MIN_OF_OperatorTotalTime: 95.284ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 70.605K (70605) - __MIN_OF_PushRowNum: 69.409K (69409) - PushTotalTime: 125.156us - __MAX_OF_PushTotalTime: 170.304us - __MIN_OF_PushTotalTime: 95.743us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 - SetFinishingTime: 109.181ms - __MAX_OF_SetFinishingTime: 132.191ms - __MIN_OF_SetFinishingTime: 95.157ms UniqueMetrics: - LateMaterialization: False - MaxBufferedBytes: 268435456 - MaxBufferedRows: 1073741824 - SortKeys: 97: date DESC, 1: device ASC - SortType: All - BuildingTime: 13.476us - __MAX_OF_BuildingTime: 26.330us - __MIN_OF_BuildingTime: 8.309us - InputRequiredMemory: 1.302 GB - __MAX_OF_InputRequiredMemory: 27.988 MB - __MIN_OF_InputRequiredMemory: 27.514 MB - MergingTime: 14.177us - __MAX_OF_MergingTime: 36.061us - __MIN_OF_MergingTime: 8.750us - NumSortedRuns: 48 - __MAX_OF_NumSortedRuns: 1 - __MIN_OF_NumSortedRuns: 1 - OutputTime: 3.456ms - __MAX_OF_OutputTime: 4.048ms - __MIN_OF_OutputTime: 3.234ms - SortingCnt: 0 - SortingTime: 71.641ms - __MAX_OF_SortingTime: 87.695ms - __MIN_OF_SortingTime: 62.180ms PROJECT (plan_node_id=16): CommonMetrics: - OperatorTotalTime: 21.809ms - __MAX_OF_OperatorTotalTime: 29.802ms - __MIN_OF_OperatorTotalTime: 16.660ms - OutputChunkBytes: 1.302 GB - __MAX_OF_OutputChunkBytes: 27.988 MB - __MIN_OF_OutputChunkBytes: 27.514 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 70.605K (70605) - __MIN_OF_PullRowNum: 69.409K (69409) - PullTotalTime: 2.214us - __MAX_OF_PullTotalTime: 3.200us - __MIN_OF_PullTotalTime: 1.710us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 70.605K (70605) - __MIN_OF_PushRowNum: 69.409K (69409) - PushTotalTime: 21.803ms - __MAX_OF_PushTotalTime: 29.797ms - __MIN_OF_PushTotalTime: 16.653ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 841.293us - __MAX_OF_CommonSubExprComputeTime: 1.332ms - __MIN_OF_CommonSubExprComputeTime: 570.254us - ExprComputeTime: 20.888ms - __MAX_OF_ExprComputeTime: 28.357ms - __MIN_OF_ExprComputeTime: 16.029ms CHUNK_ACCUMULATE (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 14.599us - __MAX_OF_OperatorTotalTime: 19.242us - __MIN_OF_OperatorTotalTime: 11.131us - OutputChunkBytes: 1.184 GB - __MAX_OF_OutputChunkBytes: 25.460 MB - __MIN_OF_OutputChunkBytes: 25.030 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 70.605K (70605) - __MIN_OF_PullRowNum: 69.409K (69409) - PullTotalTime: 1.670us - __MAX_OF_PullTotalTime: 3.530us - __MIN_OF_PullTotalTime: 1.242us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.362M (3362123) - __MAX_OF_PushRowNum: 70.605K (70605) - __MIN_OF_PushRowNum: 69.409K (69409) - PushTotalTime: 12.093us - __MAX_OF_PushTotalTime: 16.610us - __MIN_OF_PushTotalTime: 9.249us UniqueMetrics: HASH_JOIN_PROBE (plan_node_id=15): CommonMetrics: - OperatorTotalTime: 12.795ms - __MAX_OF_OperatorTotalTime: 17.665ms - __MIN_OF_OperatorTotalTime: 10.092ms - OutputChunkBytes: 1.184 GB - __MAX_OF_OutputChunkBytes: 25.460 MB - __MIN_OF_OutputChunkBytes: 25.030 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.362M (3362123) - __MAX_OF_PullRowNum: 70.605K (70605) - __MIN_OF_PullRowNum: 69.409K (69409) - PullTotalTime: 12.727ms - __MAX_OF_PullTotalTime: 17.551ms - __MIN_OF_PullTotalTime: 10.032ms - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 78.434K (78434) - __MIN_OF_PushRowNum: 77.436K (77436) - PushTotalTime: 55.996us - __MAX_OF_PushTotalTime: 106.513us - __MIN_OF_PushTotalTime: 35.812us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - JoinType: INNER_JOIN - OtherJoinConjunctEvaluateTime: 0ns - OutputBuildColumnTime: 7.228ms - __MAX_OF_OutputBuildColumnTime: 10.469ms - __MIN_OF_OutputBuildColumnTime: 5.643ms - OutputProbeColumnTime: 3.025ms - __MAX_OF_OutputProbeColumnTime: 4.015ms - __MIN_OF_OutputProbeColumnTime: 2.320ms - PartitionProbeOverhead: 0ns - ProbeConjunctEvaluateTime: 0ns - SearchHashTableTime: 2.414ms - __MAX_OF_SearchHashTableTime: 3.086ms - __MIN_OF_SearchHashTableTime: 1.952ms - WhereConjunctEvaluateTime: 0ns - probeCount: 0 PROJECT (plan_node_id=10): CommonMetrics: - OperatorTotalTime: 74.847us - __MAX_OF_OperatorTotalTime: 93.436us - __MIN_OF_OperatorTotalTime: 60.137us - OutputChunkBytes: 988.977 MB - __MAX_OF_OutputChunkBytes: 20.736 MB - __MIN_OF_OutputChunkBytes: 20.472 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 78.434K (78434) - __MIN_OF_PullRowNum: 77.436K (77436) - PullTotalTime: 1.567us - __MAX_OF_PullTotalTime: 6.093us - __MIN_OF_PullTotalTime: 1.020us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 78.434K (78434) - __MIN_OF_PushRowNum: 77.436K (77436) - PushTotalTime: 69.546us - __MAX_OF_PushTotalTime: 87.274us - __MIN_OF_PushTotalTime: 56.096us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 1.227us - __MAX_OF_CommonSubExprComputeTime: 2.271us - __MIN_OF_CommonSubExprComputeTime: 841ns - ExprComputeTime: 33.934us - __MAX_OF_ExprComputeTime: 44.171us - __MIN_OF_ExprComputeTime: 27.340us HASH_JOIN_PROBE (plan_node_id=9): CommonMetrics: - OperatorTotalTime: 3.074ms - __MAX_OF_OperatorTotalTime: 4.002ms - __MIN_OF_OperatorTotalTime: 2.438ms - OutputChunkBytes: 988.977 MB - __MAX_OF_OutputChunkBytes: 20.736 MB - __MIN_OF_OutputChunkBytes: 20.472 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 78.434K (78434) - __MIN_OF_PullRowNum: 77.436K (77436) - PullTotalTime: 3.010ms - __MAX_OF_PullTotalTime: 3.914ms - __MIN_OF_PullTotalTime: 2.378ms - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 78.434K (78434) - __MIN_OF_PushRowNum: 77.436K (77436) - PushTotalTime: 48.096us - __MAX_OF_PushTotalTime: 75.440us - __MIN_OF_PushTotalTime: 31.770us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - JoinType: LEFT_OUTER_JOIN - OtherJoinConjunctEvaluateTime: 0ns - OutputBuildColumnTime: 921.199us - __MAX_OF_OutputBuildColumnTime: 1.269ms - __MIN_OF_OutputBuildColumnTime: 683.657us - OutputProbeColumnTime: 45.478us - __MAX_OF_OutputProbeColumnTime: 80.951us - __MIN_OF_OutputProbeColumnTime: 32.281us - PartitionProbeOverhead: 0ns - ProbeConjunctEvaluateTime: 0ns - SearchHashTableTime: 1.980ms - __MAX_OF_SearchHashTableTime: 2.549ms - __MIN_OF_SearchHashTableTime: 1.580ms - WhereConjunctEvaluateTime: 0ns - probeCount: 0 PROJECT (plan_node_id=4): CommonMetrics: - OperatorTotalTime: 17.871ms - __MAX_OF_OperatorTotalTime: 23.698ms - __MIN_OF_OperatorTotalTime: 13.451ms - OutputChunkBytes: 930.824 MB - __MAX_OF_OutputChunkBytes: 19.517 MB - __MIN_OF_OutputChunkBytes: 19.269 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 78.434K (78434) - __MIN_OF_PullRowNum: 77.436K (77436) - PullTotalTime: 2.348us - __MAX_OF_PullTotalTime: 6.911us - __MIN_OF_PullTotalTime: 1.650us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 78.434K (78434) - __MIN_OF_PushRowNum: 77.436K (77436) - PushTotalTime: 17.862ms - __MAX_OF_PushTotalTime: 23.691ms - __MIN_OF_PushTotalTime: 13.441ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 1 UniqueMetrics: - CommonSubExprComputeTime: 9.065ms - __MAX_OF_CommonSubExprComputeTime: 11.961ms - __MIN_OF_CommonSubExprComputeTime: 6.991ms - ExprComputeTime: 8.736ms - __MAX_OF_ExprComputeTime: 11.919ms - __MIN_OF_ExprComputeTime: 6.405ms AGGREGATE_BLOCKING_SOURCE (plan_node_id=3): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 45.198ms - __MAX_OF_OperatorTotalTime: 56.784ms - __MIN_OF_OperatorTotalTime: 37.415ms - OutputChunkBytes: 898.720 MB - __MAX_OF_OutputChunkBytes: 18.843 MB - __MIN_OF_OutputChunkBytes: 18.605 MB - PullChunkNum: 942 - __MAX_OF_PullChunkNum: 20 - __MIN_OF_PullChunkNum: 19 - PullRowNum: 3.740M (3740376) - __MAX_OF_PullRowNum: 78.434K (78434) - __MIN_OF_PullRowNum: 77.436K (77436) - PullTotalTime: 45.096ms - __MAX_OF_PullTotalTime: 56.655ms - __MIN_OF_PullTotalTime: 37.317ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=6): - IsGroupExecution: false - ActiveTime: 11s421ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 12s38ms - OverheadTime: 23.640ms - PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 602.543ms - FirstInputEmptyTime: 602.543ms - PendingFinishTime: 1.949ms - ScheduleCount: 107 - ScheduleTime: 617.029ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 106 EXCHANGE_SINK (plan_node_id=18): CommonMetrics: - OperatorTotalTime: 738.936ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 863 - PushRowNum: 3.362M (3362123) - PushTotalTime: 738.921ms UniqueMetrics: - ChannelNum: 1 - DestFragments: 019adf409b2a7846-8b71b0d85a2629d5 - DestID: 18 - PartType: UNPARTITIONED - BytesPassThrough: 0.000 B - BytesSent: 103.174 MB - BytesUnsent: 0.000 B - CompressTime: 212.483ms - CompressedBytes: 103.174 MB - NetworkBandwidth: 661.593 MB/sec - NetworkTime: 155.947ms - OverallThroughput: 9.135 MB/sec - OverallTime: 11s294ms - PassThroughBufferPeakMemoryUsage: 0.000 B - RawInputBytes: 1.302 GB - RequestSent: 339 - RequestUnsent: 0 - RpcAvgTime: 458.668us - RpcCount: 340 - SerializeChunkTime: 449.347ms - SerializedBytes: 281.835 MB - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 2.485ms LOCAL_MERGE_SOURCE (plan_node_id=17): CommonMetrics: - OperatorTotalTime: 10s659ms - OutputChunkBytes: 1.302 GB - PullChunkNum: 863 - PullRowNum: 3.362M (3362123) - PullTotalTime: 10s658ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Fragment 2: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019adf40-9b2a-7846-8b71-b0d85a2629d7 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 5.075ms - InitialProcessDriverCount: 196 - InitialProcessMem: 43.725 GB - InstanceAllocatedMemoryUsage: 27.298 MB - InstanceDeallocatedMemoryUsage: 27.286 MB - InstanceNum: 1 - InstancePeakMemoryUsage: 20.004 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 408.145us - __MAX_OF_ActiveTime: 1.458ms - __MIN_OF_ActiveTime: 3us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 5.617ms - __MAX_OF_DriverTotalTime: 6.046ms - __MIN_OF_DriverTotalTime: 5.239ms - PeakDriverQueueSize: 1.004K (1004) - __MAX_OF_PeakDriverQueueSize: 45 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 2.221ms - __MAX_OF_InputEmptyTime: 2.793ms - __MIN_OF_InputEmptyTime: 1.788ms - FirstInputEmptyTime: 2.221ms - __MAX_OF_FirstInputEmptyTime: 2.793ms - __MIN_OF_FirstInputEmptyTime: 1.788ms - PendingFinishTime: 2.423ms - __MAX_OF_PendingFinishTime: 3.370ms - __MIN_OF_PendingFinishTime: 1.300ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 5.209ms - __MAX_OF_ScheduleTime: 6.030ms - __MIN_OF_ScheduleTime: 4.195ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=14): CommonMetrics: - OperatorTotalTime: 340.980us - __MAX_OF_OperatorTotalTime: 1.311ms - __MIN_OF_OperatorTotalTime: 670ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 24 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 36 - __MAX_OF_PushRowNum: 3 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 10.875us - __MAX_OF_PushTotalTime: 40.771us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ChannelNum: 1 - DestFragments: 019adf409b2a7846-8b71b0d85a2629d6 - DestID: 14 - PartType: UNPARTITIONED - BytesPassThrough: 9.300 KB - __MAX_OF_BytesPassThrough: 583.000 B - __MIN_OF_BytesPassThrough: 0.000 B - BytesSent: 0.000 B - BytesUnsent: 0.000 B - CompressTime: 0ns - CompressedBytes: 0.000 B - NetworkBandwidth: 0.000 B/sec - NetworkTime: 6.131ms - OverallThroughput: 0.000 B/sec - OverallTime: 2.964ms - PassThroughBufferPeakMemoryUsage: 3.891 KB - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 510.101us - RpcCount: 25 - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 797.360us AGGREGATE_BLOCKING_SOURCE (plan_node_id=13): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 76.007us - __MAX_OF_OperatorTotalTime: 236.448us - __MIN_OF_OperatorTotalTime: 10.690us - OutputChunkBytes: 4.425 KB - __MAX_OF_OutputChunkBytes: 375.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 24 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 36 - __MAX_OF_PullRowNum: 3 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 58.338us - __MAX_OF_PullTotalTime: 210.786us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 97.783us - __MAX_OF_ActiveTime: 707.208us - __MIN_OF_ActiveTime: 4.481us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 2.611ms - __MAX_OF_DriverTotalTime: 3.602ms - __MIN_OF_DriverTotalTime: 1.827ms - PeakDriverQueueSize: 957 - __MAX_OF_PeakDriverQueueSize: 44 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 1.883ms - __MAX_OF_InputEmptyTime: 1.929ms - __MIN_OF_InputEmptyTime: 1.735ms - FirstInputEmptyTime: 1.883ms - __MAX_OF_FirstInputEmptyTime: 1.929ms - __MIN_OF_FirstInputEmptyTime: 1.735ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 2.514ms - __MAX_OF_ScheduleTime: 3.147ms - __MIN_OF_ScheduleTime: 1.810ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=13): CommonMetrics: - OperatorTotalTime: 79.876us - __MAX_OF_OperatorTotalTime: 670.576us - __MIN_OF_OperatorTotalTime: 6.700us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 24 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 72 - __MAX_OF_PushRowNum: 6 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 35.161us - __MAX_OF_PushTotalTime: 130.383us - __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: 32.044us - __MAX_OF_AggComputeTime: 121.693us - __MIN_OF_AggComputeTime: 0ns - AggFuncComputeTime: 4.265us - __MAX_OF_AggFuncComputeTime: 17.160us - __MIN_OF_AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 3.094us - __MAX_OF_ExprComputeTime: 10.500us - __MIN_OF_ExprComputeTime: 0ns - ExprReleaseTime: 818ns - __MAX_OF_ExprReleaseTime: 3.160us - __MIN_OF_ExprReleaseTime: 0ns - GetResultsTime: 50.572us - __MAX_OF_GetResultsTime: 186.445us - __MIN_OF_GetResultsTime: 0ns - HashTableMemoryUsage: 12.096 MB - __MAX_OF_HashTableMemoryUsage: 516.105 KB - __MIN_OF_HashTableMemoryUsage: 24.000 B - HashTableSize: 36 - __MAX_OF_HashTableSize: 3 - __MIN_OF_HashTableSize: 0 - InputRowCount: 72 - __MAX_OF_InputRowCount: 6 - __MIN_OF_InputRowCount: 0 - PassThroughRowCount: 0 - ResultAggAppendTime: 2.575us - __MAX_OF_ResultAggAppendTime: 17.881us - __MIN_OF_ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 1.054us - __MAX_OF_ResultGroupByAppendTime: 4.510us - __MIN_OF_ResultGroupByAppendTime: 0ns - ResultIteratorTime: 36.311us - __MAX_OF_ResultIteratorTime: 136.123us - __MIN_OF_ResultIteratorTime: 0ns - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns LOCAL_EXCHANGE_SOURCE (plan_node_id=13): CommonMetrics: - IsSubordinate - OperatorTotalTime: 20.413us - __MAX_OF_OperatorTotalTime: 74.162us - __MIN_OF_OperatorTotalTime: 1.290us - OutputChunkBytes: 7.119 KB - __MAX_OF_OutputChunkBytes: 600.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 24 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 72 - __MAX_OF_PullRowNum: 6 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 17.426us - __MAX_OF_PullTotalTime: 69.032us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 711.699us - __MAX_OF_ActiveTime: 980.014us - __MIN_OF_ActiveTime: 548.644us - BlockByInputEmpty: 8 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 8 - DriverTotalTime: 1.760ms - __MAX_OF_DriverTotalTime: 2.249ms - __MIN_OF_DriverTotalTime: 1.592ms - PeakDriverQueueSize: 21 - __MAX_OF_PeakDriverQueueSize: 5 - __MIN_OF_PeakDriverQueueSize: 1 - ScheduleCount: 16 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 1.049ms - __MAX_OF_ScheduleTime: 1.269ms - __MIN_OF_ScheduleTime: 927.183us - TotalDegreeOfParallelism: 8 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=13): CommonMetrics: - IsSubordinate - OperatorTotalTime: 49.068us - __MAX_OF_OperatorTotalTime: 253.187us - __MIN_OF_OperatorTotalTime: 15.040us - 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: 20.342us - __MAX_OF_PushTotalTime: 30.951us - __MIN_OF_PushTotalTime: 14.720us UniqueMetrics: - ShuffleNum: 48 - Type: Partition(BUCKET_SHUFFLE_HASH_PARTITIONED) - LocalExchangePeakMemoryUsage: 5.950 KB PROJECT (plan_node_id=12): CommonMetrics: - OperatorTotalTime: 45.248us - __MAX_OF_OperatorTotalTime: 64.372us - __MIN_OF_OperatorTotalTime: 38.611us - 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: 202ns - __MAX_OF_PullTotalTime: 260ns - __MIN_OF_PullTotalTime: 150ns - PushChunkNum: 8 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 72 - __MAX_OF_PushRowNum: 14 - __MIN_OF_PushRowNum: 6 - PushTotalTime: 42.214us - __MAX_OF_PushTotalTime: 60.572us - __MIN_OF_PushTotalTime: 36.571us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 6.786us - __MAX_OF_CommonSubExprComputeTime: 10.121us - __MIN_OF_CommonSubExprComputeTime: 5.220us - ExprComputeTime: 31.815us - __MAX_OF_ExprComputeTime: 43.731us - __MIN_OF_ExprComputeTime: 24.310us CHUNK_ACCUMULATE (plan_node_id=11): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.907us - __MAX_OF_OperatorTotalTime: 2.240us - __MIN_OF_OperatorTotalTime: 1.580us - 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: 188ns - __MAX_OF_PullTotalTime: 220ns - __MIN_OF_PullTotalTime: 150ns - PushChunkNum: 8 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 72 - __MAX_OF_PushRowNum: 14 - __MIN_OF_PushRowNum: 6 - PushTotalTime: 1.195us - __MAX_OF_PushTotalTime: 1.630us - __MIN_OF_PushTotalTime: 890ns UniqueMetrics: OLAP_SCAN (plan_node_id=11): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 673.013us - __MAX_OF_OperatorTotalTime: 854.982us - __MIN_OF_OperatorTotalTime: 513.473us - 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: 470.253us - __MAX_OF_PullTotalTime: 586.235us - __MIN_OF_PullTotalTime: 333.838us - 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: 797.570us - __MAX_OF_IOTaskExecTime: 964.165us - __MIN_OF_IOTaskExecTime: 661.176us - CreateSegmentIter: 107.266us - __MAX_OF_CreateSegmentIter: 166.454us - __MIN_OF_CreateSegmentIter: 51.021us - DictDecode: 2.738us - __MAX_OF_DictDecode: 4.270us - __MIN_OF_DictDecode: 2.040us - DictDecodeCount: 216 - __MAX_OF_DictDecodeCount: 42 - __MIN_OF_DictDecodeCount: 18 - GetDelVec: 0ns - GetDeltaColumnGroup: 23.608us - __MAX_OF_GetDeltaColumnGroup: 67.722us - __MIN_OF_GetDeltaColumnGroup: 5.060us - GetRowsets: 7.849us - __MAX_OF_GetRowsets: 10.101us - __MIN_OF_GetRowsets: 4.541us - IOTime: 0ns - LateMaterialize: 39.228us - __MAX_OF_LateMaterialize: 44.971us - __MIN_OF_LateMaterialize: 29.261us - LateMaterializeRows: 72 - __MAX_OF_LateMaterializeRows: 14 - __MIN_OF_LateMaterializeRows: 6 - ReadPKIndex: 0ns - SegmentInit: 339.002us - __MAX_OF_SegmentInit: 490.922us - __MIN_OF_SegmentInit: 242.856us - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 5.400us - __MAX_OF_BitmapIndexIteratorInit: 8.450us - __MIN_OF_BitmapIndexIteratorInit: 3.690us - BloomFilterFilter: 507ns - __MAX_OF_BloomFilterFilter: 910ns - __MIN_OF_BloomFilterFilter: 329ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 207.912us - __MAX_OF_ColumnIteratorInit: 299.768us - __MIN_OF_ColumnIteratorInit: 121.404us - GetVectorRowRangesTime: 0ns - GinFilter: 0ns - GinFilterRows: 0 - ProcessVectorDistanceAndIdTime: 0ns - RemainingRowsAfterShortKeyFilter: 288 - __MAX_OF_RemainingRowsAfterShortKeyFilter: 56 - __MIN_OF_RemainingRowsAfterShortKeyFilter: 24 - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 35.993us - __MAX_OF_ShortKeyFilter: 64.811us - __MIN_OF_ShortKeyFilter: 24.531us - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 12.339us - __MAX_OF_ZoneMapIndexFilter: 21.670us - __MIN_OF_ZoneMapIndexFilter: 9.210us - ZoneMapIndexFilterRows: 0 - SegmentRead: 20.819us - __MAX_OF_SegmentRead: 26.410us - __MIN_OF_SegmentRead: 17.321us - BlockFetch: 7.685us - __MAX_OF_BlockFetch: 12.430us - __MIN_OF_BlockFetch: 4.991us - BlockFetchCount: 8 - __MAX_OF_BlockFetchCount: 1 - __MIN_OF_BlockFetchCount: 1 - BlockSeek: 23.528us - __MAX_OF_BlockSeek: 33.492us - __MIN_OF_BlockSeek: 14.951us - BlockSeekCount: 8 - __MAX_OF_BlockSeekCount: 1 - __MIN_OF_BlockSeekCount: 1 - ChunkCopy: 1.576us - __MAX_OF_ChunkCopy: 2.390us - __MIN_OF_ChunkCopy: 700ns - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 2.247us - __MAX_OF_PredFilter: 3.530us - __MIN_OF_PredFilter: 1.190us - 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: 130.448us - __MAX_OF_IOTaskWaitTime: 210.446us - __MIN_OF_IOTaskWaitTime: 68.082us - MorselsCount: 8 - __MAX_OF_MorselsCount: 1 - __MIN_OF_MorselsCount: 1 - PeakChunkBufferMemoryUsage: 724.655 KB - PeakChunkBufferSize: 2 - PeakIOTasks: 1 - PeakScanTaskQueueSize: 9 - __MAX_OF_PeakScanTaskQueueSize: 2 - __MIN_OF_PeakScanTaskQueueSize: 0 - PrepareChunkSourceTime: 375.942us - __MAX_OF_PrepareChunkSourceTime: 465.162us - __MIN_OF_PrepareChunkSourceTime: 279.967us - 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: 928.018us - __MAX_OF_ScanTime: 1.064ms - __MIN_OF_ScanTime: 856.672us - SubmitTaskCount: 8 - __MAX_OF_SubmitTaskCount: 1 - __MIN_OF_SubmitTaskCount: 1 - SubmitTaskTime: 59.012us - __MAX_OF_SubmitTaskTime: 125.393us - __MIN_OF_SubmitTaskTime: 17.280us - TabletCount: 8 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 121.143us - __MAX_OF_ActiveTime: 190.155us - __MIN_OF_ActiveTime: 74.492us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 8 - DriverTotalTime: 300.975us - __MAX_OF_DriverTotalTime: 399.100us - __MIN_OF_DriverTotalTime: 128.553us - PeakDriverQueueSize: 18 - __MAX_OF_PeakDriverQueueSize: 5 - __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: 616ns - __MAX_OF_OperatorTotalTime: 870ns - __MIN_OF_OperatorTotalTime: 230ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: OLAP_SCAN_PREPARE (plan_node_id=11): CommonMetrics: - IsSubordinate - OperatorTotalTime: 117.936us - __MAX_OF_OperatorTotalTime: 183.846us - __MIN_OF_OperatorTotalTime: 72.572us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 109.156us - __MAX_OF_PullTotalTime: 175.045us - __MIN_OF_PullTotalTime: 67.912us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 5.527us - __MAX_OF_CaptureTabletRowsetsTime: 10.350us - __MIN_OF_CaptureTabletRowsetsTime: 2.820us Fragment 3: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019adf40-9b2a-7846-8b71-b0d85a2629d8 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 6.479ms - InitialProcessDriverCount: 196 - InitialProcessMem: 43.724 GB - InstanceAllocatedMemoryUsage: 5.868 MB - InstanceDeallocatedMemoryUsage: 6.725 MB - InstanceNum: 1 - InstancePeakMemoryUsage: 2.739 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 19.317us - __MAX_OF_ActiveTime: 150.034us - __MIN_OF_ActiveTime: 4.761us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 13.232ms - __MAX_OF_DriverTotalTime: 14.133ms - __MIN_OF_DriverTotalTime: 12.494ms - PeakDriverQueueSize: 870 - __MAX_OF_PeakDriverQueueSize: 40 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 8.955ms - __MAX_OF_InputEmptyTime: 9.098ms - __MIN_OF_InputEmptyTime: 8.448ms - FirstInputEmptyTime: 8.955ms - __MAX_OF_FirstInputEmptyTime: 9.098ms - __MIN_OF_FirstInputEmptyTime: 8.448ms - PendingFinishTime: 3.668ms - __MAX_OF_PendingFinishTime: 4.332ms - __MIN_OF_PendingFinishTime: 2.760ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 13.212ms - __MAX_OF_ScheduleTime: 14.123ms - __MIN_OF_ScheduleTime: 12.465ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=8): CommonMetrics: - OperatorTotalTime: 10.565us - __MAX_OF_OperatorTotalTime: 93.703us - __MIN_OF_OperatorTotalTime: 1.640us - 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: 409ns - __MAX_OF_PushTotalTime: 10.410us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ChannelNum: 1 - DestFragments: 019adf409b2a7846-8b71b0d85a2629d6 - 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: 558.374us - OverallThroughput: 0.000 B/sec - OverallTime: 2.746ms - PassThroughBufferPeakMemoryUsage: 0.000 B - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 186.124us - RpcCount: 3 - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 2.741ms AGGREGATE_BLOCKING_SOURCE (plan_node_id=7): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 22.626us - __MAX_OF_OperatorTotalTime: 101.172us - __MIN_OF_OperatorTotalTime: 11.810us - 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: 3.286us - __MAX_OF_PullTotalTime: 79.862us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 32.126us - __MAX_OF_ActiveTime: 587.495us - __MIN_OF_ActiveTime: 4.961us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 9.119ms - __MAX_OF_DriverTotalTime: 9.765ms - __MIN_OF_DriverTotalTime: 8.504ms - PeakDriverQueueSize: 868 - __MAX_OF_PeakDriverQueueSize: 41 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 8.618ms - __MAX_OF_InputEmptyTime: 8.653ms - __MIN_OF_InputEmptyTime: 8.463ms - FirstInputEmptyTime: 8.618ms - __MAX_OF_FirstInputEmptyTime: 8.653ms - __MIN_OF_FirstInputEmptyTime: 8.463ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 9.087ms - __MAX_OF_ScheduleTime: 9.374ms - __MIN_OF_ScheduleTime: 8.494ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=7): CommonMetrics: - OperatorTotalTime: 33.735us - __MAX_OF_OperatorTotalTime: 585.335us - __MIN_OF_OperatorTotalTime: 7.080us - 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.930us - __MAX_OF_PushTotalTime: 46.801us - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - AggregateFunctions: max(100: pre_generation_device), max(89: case), max(90: case) - GroupingKeys: 82: tos, 83: device - AggComputeTime: 1.721us - __MAX_OF_AggComputeTime: 41.561us - __MIN_OF_AggComputeTime: 0ns - AggFuncComputeTime: 151ns - __MAX_OF_AggFuncComputeTime: 3.760us - __MIN_OF_AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 150ns - __MAX_OF_ExprComputeTime: 4.010us - __MIN_OF_ExprComputeTime: 0ns - ExprReleaseTime: 65ns - __MAX_OF_ExprReleaseTime: 1.590us - __MIN_OF_ExprReleaseTime: 0ns - GetResultsTime: 2.693us - __MAX_OF_GetResultsTime: 67.481us - __MIN_OF_GetResultsTime: 0ns - HashTableMemoryUsage: 265.191 KB - __MAX_OF_HashTableMemoryUsage: 132.057 KB - __MIN_OF_HashTableMemoryUsage: 24.000 B - HashTableSize: 2 - __MAX_OF_HashTableSize: 1 - __MIN_OF_HashTableSize: 0 - InputRowCount: 4 - __MAX_OF_InputRowCount: 2 - __MIN_OF_InputRowCount: 0 - PassThroughRowCount: 0 - ResultAggAppendTime: 97ns - __MAX_OF_ResultAggAppendTime: 2.550us - __MIN_OF_ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 41ns - __MAX_OF_ResultGroupByAppendTime: 1.080us - __MIN_OF_ResultGroupByAppendTime: 0ns - ResultIteratorTime: 2.118us - __MAX_OF_ResultIteratorTime: 53.861us - __MIN_OF_ResultIteratorTime: 0ns - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns LOCAL_EXCHANGE_SOURCE (plan_node_id=7): CommonMetrics: - IsSubordinate - OperatorTotalTime: 2.584us - __MAX_OF_OperatorTotalTime: 16.111us - __MIN_OF_OperatorTotalTime: 1.092us - 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: 512ns - __MAX_OF_PullTotalTime: 14.550us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 291.435us - __MAX_OF_ActiveTime: 684.127us - __MIN_OF_ActiveTime: 165.953us - BlockByInputEmpty: 11 - __MAX_OF_BlockByInputEmpty: 2 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 8.081ms - __MAX_OF_DriverTotalTime: 9.098ms - __MIN_OF_DriverTotalTime: 7.838ms - PeakDriverQueueSize: 27 - __MAX_OF_PeakDriverQueueSize: 6 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - PreconditionBlockTime: 7.388ms - __MAX_OF_PreconditionBlockTime: 7.390ms - __MIN_OF_PreconditionBlockTime: 7.387ms - ScheduleCount: 21 - __MAX_OF_ScheduleCount: 3 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 7.789ms - __MAX_OF_ScheduleTime: 8.414ms - __MIN_OF_ScheduleTime: 7.627ms - TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=7): CommonMetrics: - IsSubordinate - OperatorTotalTime: 27.926us - __MAX_OF_OperatorTotalTime: 258.406us - __MIN_OF_OperatorTotalTime: 391ns - 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.359us - __MAX_OF_PushTotalTime: 17.400us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 48 - Type: Partition(BUCKET_SHUFFLE_HASH_PARTITIONED) - LocalExchangePeakMemoryUsage: 0.000 B PROJECT (plan_node_id=6): CommonMetrics: - OperatorTotalTime: 7.508us - __MAX_OF_OperatorTotalTime: 24.869us - __MIN_OF_OperatorTotalTime: 2.850us - 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: 137ns - __MAX_OF_PullTotalTime: 200ns - __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: 4.313us - __MAX_OF_PushTotalTime: 21.730us - __MIN_OF_PushTotalTime: 230ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 34ns - __MAX_OF_CommonSubExprComputeTime: 180ns - __MIN_OF_CommonSubExprComputeTime: 0ns - ExprComputeTime: 3.770us - __MAX_OF_ExprComputeTime: 20.490us - __MIN_OF_ExprComputeTime: 0ns CHUNK_ACCUMULATE (plan_node_id=5): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.551us - __MAX_OF_OperatorTotalTime: 1.970us - __MIN_OF_OperatorTotalTime: 1.130us - 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: 127ns - __MAX_OF_PullTotalTime: 220ns - __MIN_OF_PullTotalTime: 90ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 4 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 838ns - __MAX_OF_PushTotalTime: 1.280us - __MIN_OF_PushTotalTime: 600ns 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: 875ns - __MAX_OF_JoinRuntimeFilterTime: 880ns - __MIN_OF_JoinRuntimeFilterTime: 870ns - OperatorTotalTime: 429.263us - __MAX_OF_OperatorTotalTime: 558.254us - __MIN_OF_OperatorTotalTime: 331.139us - 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: 211.774us - __MAX_OF_PullTotalTime: 338.998us - __MIN_OF_PullTotalTime: 133.903us - 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: 146.215us - __MAX_OF_IOTaskExecTime: 495.502us - __MIN_OF_IOTaskExecTime: 43.121us - CreateSegmentIter: 30.857us - __MAX_OF_CreateSegmentIter: 110.543us - __MIN_OF_CreateSegmentIter: 8.960us - DictDecode: 1.424us - __MAX_OF_DictDecode: 1.849us - __MIN_OF_DictDecode: 1us - DictDecodeCount: 8 - __MAX_OF_DictDecodeCount: 4 - __MIN_OF_DictDecodeCount: 4 - GetDelVec: 0ns - GetDeltaColumnGroup: 1.175us - __MAX_OF_GetDeltaColumnGroup: 6.060us - __MIN_OF_GetDeltaColumnGroup: 0ns - GetRowsets: 5.764us - __MAX_OF_GetRowsets: 7.680us - __MIN_OF_GetRowsets: 3.460us - IOTime: 0ns - LateMaterialize: 15.955us - __MAX_OF_LateMaterialize: 18.130us - __MIN_OF_LateMaterialize: 13.780us - LateMaterializeRows: 4 - __MAX_OF_LateMaterializeRows: 2 - __MIN_OF_LateMaterializeRows: 2 - ReadPKIndex: 0ns - SegmentInit: 44.821us - __MAX_OF_SegmentInit: 270.867us - __MIN_OF_SegmentInit: 0ns - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 933ns - __MAX_OF_BitmapIndexIteratorInit: 5.510us - __MIN_OF_BitmapIndexIteratorInit: 0ns - BloomFilterFilter: 86ns - __MAX_OF_BloomFilterFilter: 510ns - __MIN_OF_BloomFilterFilter: 0ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 23.322us - __MAX_OF_ColumnIteratorInit: 140.773us - __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: 5.291us - __MAX_OF_ShortKeyFilter: 29.821us - __MIN_OF_ShortKeyFilter: 0ns - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 1.394us - __MAX_OF_ZoneMapIndexFilter: 8.270us - __MIN_OF_ZoneMapIndexFilter: 0ns - ZoneMapIndexFilterRows: 0 - SegmentRead: 3.860us - __MAX_OF_SegmentRead: 21.750us - __MIN_OF_SegmentRead: 0ns - BlockFetch: 1.073us - __MAX_OF_BlockFetch: 6.440us - __MIN_OF_BlockFetch: 0ns - BlockFetchCount: 2 - __MAX_OF_BlockFetchCount: 1 - __MIN_OF_BlockFetchCount: 0 - BlockSeek: 3.571us - __MAX_OF_BlockSeek: 21.471us - __MIN_OF_BlockSeek: 0ns - BlockSeekCount: 2 - __MAX_OF_BlockSeekCount: 1 - __MIN_OF_BlockSeekCount: 0 - ChunkCopy: 220ns - __MAX_OF_ChunkCopy: 1.540us - __MIN_OF_ChunkCopy: 0ns - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 392ns - __MAX_OF_PredFilter: 2.210us - __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: 58.966us - __MAX_OF_IOTaskWaitTime: 124.063us - __MIN_OF_IOTaskWaitTime: 19.671us - MorselsCount: 10 - __MAX_OF_MorselsCount: 1 - __MIN_OF_MorselsCount: 1 - PeakChunkBufferMemoryUsage: 300.050 KB - PeakChunkBufferSize: 1 - PeakIOTasks: 1 - PeakScanTaskQueueSize: 5 - __MAX_OF_PeakScanTaskQueueSize: 2 - __MIN_OF_PeakScanTaskQueueSize: 0 - PrepareChunkSourceTime: 157.261us - __MAX_OF_PrepareChunkSourceTime: 258.716us - __MIN_OF_PrepareChunkSourceTime: 114.153us - 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: 814ns - __MAX_OF_RuntimeFilterEvalTime: 4.300us - __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: 205.182us - __MAX_OF_ScanTime: 515.173us - __MIN_OF_ScanTime: 88.722us - SubmitTaskCount: 10 - __MAX_OF_SubmitTaskCount: 1 - __MIN_OF_SubmitTaskCount: 1 - SubmitTaskTime: 39.910us - __MAX_OF_SubmitTaskTime: 100.583us - __MIN_OF_SubmitTaskTime: 4.230us - TabletCount: 10 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 73.492us - __MAX_OF_ActiveTime: 98.473us - __MIN_OF_ActiveTime: 47.191us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 7.574ms - __MAX_OF_DriverTotalTime: 7.715ms - __MIN_OF_DriverTotalTime: 7.523ms - PeakDriverQueueSize: 55 - __MAX_OF_PeakDriverQueueSize: 10 - __MIN_OF_PeakDriverQueueSize: 1 - PendingTime: 0ns - PreconditionBlockTime: 7.383ms - __MAX_OF_PreconditionBlockTime: 7.384ms - __MIN_OF_PreconditionBlockTime: 7.383ms - ScheduleCount: 10 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 7.500ms - __MAX_OF_ScheduleTime: 7.620ms - __MIN_OF_ScheduleTime: 7.465ms - TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=5): CommonMetrics: - IsSubordinate - OperatorTotalTime: 414ns - __MAX_OF_OperatorTotalTime: 710ns - __MIN_OF_OperatorTotalTime: 291ns - 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: 76.810us - __MAX_OF_OperatorTotalTime: 102.462us - __MIN_OF_OperatorTotalTime: 51.030us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 68.045us - __MAX_OF_PullTotalTime: 92.992us - __MIN_OF_PullTotalTime: 42.281us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 4.523us - __MAX_OF_CaptureTabletRowsetsTime: 14.831us - __MIN_OF_CaptureTabletRowsetsTime: 2.800us Fragment 4: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019adf40-9b2a-7846-8b71-b0d85a2629d9 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 11.156ms - FragmentInstancePrepareTime: 15.194ms - prepare-pipeline-driver: 11.509ms - InitialProcessDriverCount: 312 - InitialProcessMem: 43.729 GB - InstanceAllocatedMemoryUsage: 13.661 GB - InstanceDeallocatedMemoryUsage: 12.084 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 1.870 GB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 132.434ms - __MAX_OF_ActiveTime: 165ms - __MIN_OF_ActiveTime: 91.676ms - BlockByInputEmpty: 2 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 18 - __MAX_OF_BlockByOutputFull: 1 - __MIN_OF_BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 332.754ms - __MAX_OF_DriverTotalTime: 332.842ms - __MIN_OF_DriverTotalTime: 332.645ms - PeakDriverQueueSize: 2.438K (2438) - __MAX_OF_PeakDriverQueueSize: 114 - __MIN_OF_PeakDriverQueueSize: 5 - PendingTime: 0ns - InputEmptyTime: 71.684ms - __MAX_OF_InputEmptyTime: 113.297ms - __MIN_OF_InputEmptyTime: 55.193ms - FirstInputEmptyTime: 70.996ms - __MAX_OF_FirstInputEmptyTime: 113.297ms - __MIN_OF_FirstInputEmptyTime: 26.343ms - OutputFullTime: 21.109ms - __MAX_OF_OutputFullTime: 58.733ms - __MIN_OF_OutputFullTime: 0ns - PendingFinishTime: 84.057ms - __MAX_OF_PendingFinishTime: 150.501ms - __MIN_OF_PendingFinishTime: 19.162ms - ScheduleCount: 91 - __MAX_OF_ScheduleCount: 3 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 200.319ms - __MAX_OF_ScheduleTime: 241.057ms - __MIN_OF_ScheduleTime: 167.671ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 29 - __MAX_OF_YieldByTimeLimit: 2 - __MIN_OF_YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=2): CommonMetrics: - OperatorTotalTime: 129.209ms - __MAX_OF_OperatorTotalTime: 161.674ms - __MIN_OF_OperatorTotalTime: 90.316ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.773K (1773) - __MAX_OF_PushChunkNum: 40 - __MIN_OF_PushChunkNum: 32 - PushRowNum: 4.012M (4012361) - __MAX_OF_PushRowNum: 103.392K (103392) - __MIN_OF_PushRowNum: 59.391K (59391) - PushTotalTime: 98.619ms - __MAX_OF_PushTotalTime: 133.178ms - __MIN_OF_PushTotalTime: 63.500ms - SetFinishingTime: 30.589ms - __MAX_OF_SetFinishingTime: 41.675ms - __MIN_OF_SetFinishingTime: 19.272ms UniqueMetrics: - ChannelNum: 1 - DestFragments: 019adf409b2a7846-8b71b0d85a2629d6 - DestID: 2 - PartType: HASH_PARTITIONED - PipelineLevelShuffle: Yes - ShuffleNumPerChannel: 48 - TotalShuffleNum: 48 - BytesPassThrough: 963.858 MB - __MAX_OF_BytesPassThrough: 24.864 MB - __MIN_OF_BytesPassThrough: 14.240 MB - BytesSent: 0.000 B - BytesUnsent: 0.000 B - CompressTime: 0ns - CompressedBytes: 0.000 B - NetworkBandwidth: 0.000 B/sec - NetworkTime: 72.643ms - OverallThroughput: 0.000 B/sec - OverallTime: 172.050ms - PassThroughBufferPeakMemoryUsage: 35.727 MB - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 960.971us - RpcCount: 2.305K (2305) - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 81.878K (81878) - __MAX_OF_ShuffleChunkAppendCounter: 1.875K (1875) - __MIN_OF_ShuffleChunkAppendCounter: 1.489K (1489) - ShuffleChunkAppendTime: 78.106ms - __MAX_OF_ShuffleChunkAppendTime: 112.856ms - __MIN_OF_ShuffleChunkAppendTime: 50.116ms - ShuffleHashTime: 18.272ms - __MAX_OF_ShuffleHashTime: 32.071ms - __MIN_OF_ShuffleHashTime: 11.730ms - WaitTime: 78.546ms AGGREGATE_STREAMING_SOURCE (plan_node_id=1): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 2.465ms - __MAX_OF_OperatorTotalTime: 12.327ms - __MIN_OF_OperatorTotalTime: 589.142us - OutputChunkBytes: 963.260 MB - __MAX_OF_OutputChunkBytes: 24.851 MB - __MIN_OF_OutputChunkBytes: 14.227 MB - PullChunkNum: 1.773K (1773) - __MAX_OF_PullChunkNum: 40 - __MIN_OF_PullChunkNum: 32 - PullRowNum: 4.012M (4012361) - __MAX_OF_PullRowNum: 103.392K (103392) - __MIN_OF_PullRowNum: 59.391K (59391) - PullTotalTime: 2.415ms - __MAX_OF_PullTotalTime: 12.273ms - __MIN_OF_PullTotalTime: 557.011us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 16.566ms - __MAX_OF_ActiveTime: 48.099ms - __MIN_OF_ActiveTime: 9.796ms - BlockByInputEmpty: 321 - __MAX_OF_BlockByInputEmpty: 8 - __MIN_OF_BlockByInputEmpty: 5 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 144.050ms - __MAX_OF_DriverTotalTime: 144.597ms - __MIN_OF_DriverTotalTime: 142.945ms - PeakDriverQueueSize: 3.693K (3693) - __MAX_OF_PeakDriverQueueSize: 117 - __MIN_OF_PeakDriverQueueSize: 25 - PendingTime: 0ns - InputEmptyTime: 85.563ms - __MAX_OF_InputEmptyTime: 93.209ms - __MIN_OF_InputEmptyTime: 75.823ms - FirstInputEmptyTime: 9.542ms - __MAX_OF_FirstInputEmptyTime: 14.078ms - __MIN_OF_FirstInputEmptyTime: 4.489ms - FollowupInputEmptyTime: 76.021ms - __MAX_OF_FollowupInputEmptyTime: 85.439ms - __MIN_OF_FollowupInputEmptyTime: 67.712ms - ScheduleCount: 369 - __MAX_OF_ScheduleCount: 9 - __MIN_OF_ScheduleCount: 6 - ScheduleTime: 127.484ms - __MAX_OF_ScheduleTime: 134.105ms - __MIN_OF_ScheduleTime: 96.194ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_STREAMING_SINK (plan_node_id=1): CommonMetrics: - OperatorTotalTime: 15.827ms - __MAX_OF_OperatorTotalTime: 47.449ms - __MIN_OF_OperatorTotalTime: 9.039ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.957K (1957) - __MAX_OF_PushChunkNum: 41 - __MIN_OF_PushChunkNum: 40 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 104.162K (104162) - __MIN_OF_PushRowNum: 60.935K (60935) - PushTotalTime: 15.812ms - __MAX_OF_PushTotalTime: 47.437ms - __MIN_OF_PushTotalTime: 9.023ms - 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: 9.459ms - __MAX_OF_AggComputeTime: 44.074ms - __MIN_OF_AggComputeTime: 3.326ms - AggFuncComputeTime: 155.905us - __MAX_OF_AggFuncComputeTime: 642.225us - __MIN_OF_AggFuncComputeTime: 41.130us - ChunkBufferPeakMem: 20.676 MB - __MAX_OF_ChunkBufferPeakMem: 26.088 MB - __MIN_OF_ChunkBufferPeakMem: 16.091 MB - ChunkBufferPeakSize: 28 - __MAX_OF_ChunkBufferPeakSize: 33 - __MIN_OF_ChunkBufferPeakSize: 22 - ExprComputeTime: 303.953us - __MAX_OF_ExprComputeTime: 347.043us - __MIN_OF_ExprComputeTime: 239.160us - ExprReleaseTime: 962.873us - __MAX_OF_ExprReleaseTime: 1.887ms - __MIN_OF_ExprReleaseTime: 704.532us - GetResultsTime: 2.304ms - __MAX_OF_GetResultsTime: 12.189ms - __MIN_OF_GetResultsTime: 438.621us - HashTableMemoryUsage: 66.242 MB - __MAX_OF_HashTableMemoryUsage: 4.770 MB - __MIN_OF_HashTableMemoryUsage: 413.008 KB - HashTableSize: 148.981K (148981) - __MAX_OF_HashTableSize: 12.972K (12972) - __MIN_OF_HashTableSize: 688 - InputRowCount: 4.022M (4021783) - __MAX_OF_InputRowCount: 104.162K (104162) - __MIN_OF_InputRowCount: 60.935K (60935) - PassThroughRowCount: 3.863M (3863380) - __MAX_OF_PassThroughRowCount: 96.229K (96229) - __MIN_OF_PassThroughRowCount: 46.419K (46419) - ResultAggAppendTime: 307.019us - __MAX_OF_ResultAggAppendTime: 1.719ms - __MIN_OF_ResultAggAppendTime: 34.100us - ResultGroupByAppendTime: 1.731ms - __MAX_OF_ResultGroupByAppendTime: 9.259ms - __MIN_OF_ResultGroupByAppendTime: 311.758us - ResultIteratorTime: 147.397us - __MAX_OF_ResultIteratorTime: 616.006us - __MIN_OF_ResultIteratorTime: 17.591us - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 5.108ms - __MAX_OF_StreamingTime: 24.171ms - __MIN_OF_StreamingTime: 1.706ms LOCAL_EXCHANGE_SOURCE (plan_node_id=1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 392.214us - __MAX_OF_OperatorTotalTime: 778.065us - __MIN_OF_OperatorTotalTime: 296.571us - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 25.031 MB - __MIN_OF_OutputChunkBytes: 14.600 MB - PullChunkNum: 1.957K (1957) - __MAX_OF_PullChunkNum: 41 - __MIN_OF_PullChunkNum: 40 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 104.162K (104162) - __MIN_OF_PullRowNum: 60.935K (60935) - PullTotalTime: 388.287us - __MAX_OF_PullTotalTime: 775.626us - __MIN_OF_PullTotalTime: 294.360us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 14.899ms - __MAX_OF_ActiveTime: 29.571ms - __MIN_OF_ActiveTime: 8.011ms - BlockByInputEmpty: 470 - __MAX_OF_BlockByInputEmpty: 20 - __MIN_OF_BlockByInputEmpty: 6 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 142.507ms - __MAX_OF_DriverTotalTime: 144.710ms - __MIN_OF_DriverTotalTime: 141.962ms - OverheadTime: 2.726ms - __MAX_OF_OverheadTime: 10.538ms - __MIN_OF_OverheadTime: 696.009us - PeakDriverQueueSize: 3.925K (3925) - __MAX_OF_PeakDriverQueueSize: 116 - __MIN_OF_PeakDriverQueueSize: 42 - PendingTime: 0ns - InputEmptyTime: 88.244ms - __MAX_OF_InputEmptyTime: 110.299ms - __MIN_OF_InputEmptyTime: 71.126ms - FollowupInputEmptyTime: 87.840ms - __MAX_OF_FollowupInputEmptyTime: 109.900ms - __MIN_OF_FollowupInputEmptyTime: 70.723ms - ScheduleCount: 518 - __MAX_OF_ScheduleCount: 21 - __MIN_OF_ScheduleCount: 7 - ScheduleTime: 127.607ms - __MAX_OF_ScheduleTime: 134.336ms - __MIN_OF_ScheduleTime: 112.670ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 443.885us - __MAX_OF_OperatorTotalTime: 9.611ms - __MIN_OF_OperatorTotalTime: 75.191us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.957K (1957) - __MAX_OF_PushChunkNum: 67 - __MIN_OF_PushChunkNum: 22 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 151.630K (151630) - __MIN_OF_PushRowNum: 38.844K (38844) - PushTotalTime: 407.036us - __MAX_OF_PushTotalTime: 9.610ms - __MIN_OF_PushTotalTime: 74.264us UniqueMetrics: - ShuffleNum: 48 - Type: Passthrough - LocalExchangePeakMemoryUsage: 443.247 MB CHUNK_ACCUMULATE (plan_node_id=0): CommonMetrics: - IsSubordinate - OperatorTotalTime: 3.675ms - __MAX_OF_OperatorTotalTime: 16.982ms - __MIN_OF_OperatorTotalTime: 680.051us - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 36.711 MB - __MIN_OF_OutputChunkBytes: 9.307 MB - PullChunkNum: 1.957K (1957) - __MAX_OF_PullChunkNum: 67 - __MIN_OF_PullChunkNum: 22 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 151.630K (151630) - __MIN_OF_PullRowNum: 38.844K (38844) - PullTotalTime: 6.178us - __MAX_OF_PullTotalTime: 13.680us - __MIN_OF_PullTotalTime: 3.402us - PushChunkNum: 2.310K (2310) - __MAX_OF_PushChunkNum: 75 - __MIN_OF_PushChunkNum: 24 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 151.630K (151630) - __MIN_OF_PushRowNum: 38.844K (38844) - PushTotalTime: 3.668ms - __MAX_OF_PushTotalTime: 16.976ms - __MIN_OF_PushTotalTime: 673.922us UniqueMetrics: OLAP_SCAN (plan_node_id=0): CommonMetrics: - RuntimeFilterDesc: <1: BloomFilter> - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 4.022M (4021783) - __MAX_OF_JoinRuntimeFilterInputRows: 151.630K (151630) - __MIN_OF_JoinRuntimeFilterInputRows: 38.844K (38844) - JoinRuntimeFilterOutputRows: 4.022M (4021783) - __MAX_OF_JoinRuntimeFilterOutputRows: 151.630K (151630) - __MIN_OF_JoinRuntimeFilterOutputRows: 38.844K (38844) - JoinRuntimeFilterTime: 8.570us - __MAX_OF_JoinRuntimeFilterTime: 14.538us - __MIN_OF_JoinRuntimeFilterTime: 2.877us - OperatorTotalTime: 8.054ms - __MAX_OF_OperatorTotalTime: 23.739ms - __MIN_OF_OperatorTotalTime: 6.023ms - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 36.711 MB - __MIN_OF_OutputChunkBytes: 9.307 MB - PullChunkNum: 2.310K (2310) - __MAX_OF_PullChunkNum: 75 - __MIN_OF_PullChunkNum: 24 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 151.630K (151630) - __MIN_OF_PullRowNum: 38.844K (38844) - PullTotalTime: 7.299ms - __MAX_OF_PullTotalTime: 22.998ms - __MIN_OF_PullTotalTime: 5.086ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - MorselQueueType: fixed_morsel_queue - NumHeavyExprs: 0 - Predicates: concat_ws('.', split_part(regexp_replace(3: os_vr, '^[a-zA-Z]+', ''), '.', 1), split_part(regexp_replace(3: os_vr, '^[a-zA-Z]+', ''), '.', 2)) IS NOT NULL, 7: cpu IS NOT NULL, 4: s_dt >= '2025-01-01', 2: rom_vr LIKE '%(%', 2: rom_vr LIKE '%-%' - Rollup: ads_perf_lch_google_app_launch_stage_di - SharedScan: False - Table: ads_perf_lch_google_app_launch_stage_di - BytesRead: 1.170 GB - __MAX_OF_BytesRead: 16.280 MB - __MIN_OF_BytesRead: 840.417 KB - CachedPagesNum: 36.905K (36905) - __MAX_OF_CachedPagesNum: 347 - __MIN_OF_CachedPagesNum: 71 - ChunkBufferCapacity: 3.072K (3072) - CompressedBytesRead: 0.000 B - DefaultChunkBufferCapacity: 3.072K (3072) - IOTaskExecTime: 48.375ms - __MAX_OF_IOTaskExecTime: 130.304ms - __MIN_OF_IOTaskExecTime: 11.451ms - CreateSegmentIter: 327.649us - __MAX_OF_CreateSegmentIter: 1.936ms - __MIN_OF_CreateSegmentIter: 134.713us - DictDecode: 7.349ms - __MAX_OF_DictDecode: 36.776ms - __MIN_OF_DictDecode: 107.052us - DictDecodeCount: 41.856M (41855685) - __MAX_OF_DictDecodeCount: 673.527K (673527) - __MIN_OF_DictDecodeCount: 1.772K (1772) - ExprFilterRows: 0 - ExprFilterTime: 11.360ms - __MAX_OF_ExprFilterTime: 44.914ms - __MIN_OF_ExprFilterTime: 507.663us - GetDelVec: 0ns - GetDeltaColumnGroup: 38.892us - __MAX_OF_GetDeltaColumnGroup: 1.577ms - __MIN_OF_GetDeltaColumnGroup: 5.619us - GetRowsets: 21.068us - __MAX_OF_GetRowsets: 255.797us - __MIN_OF_GetRowsets: 9.340us - IOTime: 0ns - LateMaterialize: 5.755ms - __MAX_OF_LateMaterialize: 28.594ms - __MIN_OF_LateMaterialize: 513.293us - LateMaterializeRows: 947.954K (947954) - __MAX_OF_LateMaterializeRows: 14.288K (14288) - __MIN_OF_LateMaterializeRows: 93 - ReadPKIndex: 0ns - SegmentInit: 2.727ms - __MAX_OF_SegmentInit: 17.133ms - __MIN_OF_SegmentInit: 1.350ms - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 46.354us - __MAX_OF_BitmapIndexIteratorInit: 1.368ms - __MIN_OF_BitmapIndexIteratorInit: 19.701us - BloomFilterFilter: 2.073us - __MAX_OF_BloomFilterFilter: 30.320us - __MIN_OF_BloomFilterFilter: 731ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 1.468ms - __MAX_OF_ColumnIteratorInit: 15.027ms - __MIN_OF_ColumnIteratorInit: 468.822us - GetVectorRowRangesTime: 0ns - GinFilter: 0ns - GinFilterRows: 0 - ProcessVectorDistanceAndIdTime: 0ns - RemainingRowsAfterShortKeyFilter: 16.223M (16222711) - __MAX_OF_RemainingRowsAfterShortKeyFilter: 178.528K (178528) - __MIN_OF_RemainingRowsAfterShortKeyFilter: 33.143K (33143) - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 180.564us - __MAX_OF_ShortKeyFilter: 1.331ms - __MIN_OF_ShortKeyFilter: 80.763us - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 44.776us - __MAX_OF_ZoneMapIndexFilter: 87.453us - __MIN_OF_ZoneMapIndexFilter: 17.811us - ZoneMapIndexFilterRows: 147.456K (147456) - __MAX_OF_ZoneMapIndexFilterRows: 32.768K (32768) - __MIN_OF_ZoneMapIndexFilterRows: 0 - SegmentRead: 13.864ms - __MAX_OF_SegmentRead: 93.577ms - __MIN_OF_SegmentRead: 1.936ms - BlockFetch: 11.255ms - __MAX_OF_BlockFetch: 82.281ms - __MIN_OF_BlockFetch: 1.462ms - BlockFetchCount: 4.058K (4058) - __MAX_OF_BlockFetchCount: 56 - __MIN_OF_BlockFetchCount: 5 - BlockSeek: 452.941us - __MAX_OF_BlockSeek: 9.472ms - __MIN_OF_BlockSeek: 70.953us - BlockSeekCount: 9.790K (9790) - __MAX_OF_BlockSeekCount: 138 - __MIN_OF_BlockSeekCount: 1 - ChunkCopy: 147.704us - __MAX_OF_ChunkCopy: 12.292ms - __MIN_OF_ChunkCopy: 1.040us - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 1.935ms - __MAX_OF_PredFilter: 44.386ms - __MIN_OF_PredFilter: 399.051us - PredFilterRows: 10.293M (10292677) - __MAX_OF_PredFilterRows: 150.899K (150899) - __MIN_OF_PredFilterRows: 11.207K (11207) - RowsetsReadCount: 1.408K (1408) - __MAX_OF_RowsetsReadCount: 10 - __MIN_OF_RowsetsReadCount: 4 - SegmentsReadCount: 704 - __MAX_OF_SegmentsReadCount: 5 - __MIN_OF_SegmentsReadCount: 2 - TotalColumnsDataPageCount: 33.068K (33068) - __MAX_OF_TotalColumnsDataPageCount: 340 - __MIN_OF_TotalColumnsDataPageCount: 78 - IOTaskWaitTime: 31.296ms - __MAX_OF_IOTaskWaitTime: 78.531ms - __MIN_OF_IOTaskWaitTime: 2.396ms - MorselsCount: 704 - __MAX_OF_MorselsCount: 17 - __MIN_OF_MorselsCount: 11 - NonPushdownPredicates: 1 - PeakChunkBufferMemoryUsage: 833.791 MB - PeakChunkBufferSize: 46 - PeakIOTasks: 4 - PeakScanTaskQueueSize: 4.501K (4501) - __MAX_OF_PeakScanTaskQueueSize: 97 - __MIN_OF_PeakScanTaskQueueSize: 89 - PrepareChunkSourceTime: 5.226ms - __MAX_OF_PrepareChunkSourceTime: 7.016ms - __MIN_OF_PrepareChunkSourceTime: 4.152ms - PushdownAccessPaths: 0 - PushdownPredicates: 7 - RawRowsRead: 14.314M (14314460) - __MAX_OF_RawRowsRead: 178.528K (178528) - __MIN_OF_RawRowsRead: 16.615K (16615) - ReadPagesNum: 36.905K (36905) - __MAX_OF_ReadPagesNum: 347 - __MIN_OF_ReadPagesNum: 71 - RowsRead: 4.022M (4021783) - __MAX_OF_RowsRead: 59.921K (59921) - __MIN_OF_RowsRead: 886 - RuntimeFilterEvalTime: 63.974us - __MAX_OF_RuntimeFilterEvalTime: 495.371us - __MIN_OF_RuntimeFilterEvalTime: 12.080us - RuntimeFilterInputRows: 13.237M (13236609) - __MAX_OF_RuntimeFilterInputRows: 139.618K (139618) - __MIN_OF_RuntimeFilterInputRows: 16.615K (16615) - RuntimeFilterOutputRows: 12.593M (12592727) - __MAX_OF_RuntimeFilterOutputRows: 136.787K (136787) - __MIN_OF_RuntimeFilterOutputRows: 16.615K (16615) - ScanTime: 79.671ms - __MAX_OF_ScanTime: 133.832ms - __MIN_OF_ScanTime: 47.021ms - SubmitTaskCount: 704 - __MAX_OF_SubmitTaskCount: 17 - __MIN_OF_SubmitTaskCount: 11 - SubmitTaskTime: 684.135us - __MAX_OF_SubmitTaskTime: 2.550ms - __MIN_OF_SubmitTaskTime: 52.690us - TabletCount: 704 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 505.833us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverPrepareTime: 1.653ms - DriverTotalTime: 1.037ms - PeakDriverQueueSize: 0 - ScheduleCount: 1 - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=0): CommonMetrics: - IsSubordinate - OperatorTotalTime: 370ns - 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: 507.423us - OutputChunkBytes: 0.000 B - PrepareTime: 1.632ms - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 499.512us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 1.625ms