Query: Summary: - Query ID: 019adf54-fe43-7ae2-a249-1c5be46a01cb - Start Time: 2025-12-02 13:51:20 - End Time: 2025-12-02 13:51:32 - Total: 12s271ms - Query Type: Query - Query State: Finished - StarRocks Version: 4.0.1-cd9df36 - User: root - Default Db - Sql Statement: explain analyze 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},"enable_async_profile":{"defaultValue":true,"actualValue":false}} - Collect Profile Time: 0 - IsProfileAsync: false Planner: - -- Parser[1] 1ms - -- Total[1] 12ms - -- Analyzer[1] 0 - -- Lock[1] 0 - -- AnalyzeDatabase[3] 0 - -- AnalyzeTemporaryTable[3] 0 - -- AnalyzeTable[3] 0 - -- Transformer[1] 2ms - -- Optimizer[1] 8ms - -- MVPreprocess[1] 0 - -- MVTextRewrite[1] 0 - -- RuleBaseOptimize[1] 4ms - -- CostBaseOptimize[1] 2ms - -- PhysicalRewrite[1] 1ms - -- DynamicRewrite[1] 0 - -- PlanValidate[1] 0 - -- TypeChecker[1] 0 - -- CTEUniqueChecker[1] 0 - -- InputDependenciesChecker[1] 0 - -- ColumnReuseChecker[1] 0 - -- ExecPlanBuild[1] 1ms - -- Pending[1] 0 - -- Prepare[1] 0 - -- Deploy[1] 43ms - -- DeployLockInternalTime[1] 43ms - -- DeploySerializeConcurrencyTime[3] 1ms - -- DeployStageByStageTime[9] 0 - -- DeployAsyncSendTime[5] 0 - -- DeployWaitTime[9] 40ms - -- 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: 4.104ms - QueryAllocatedMemoryUsage: 59.171 GB - QueryCumulativeCpuTime: 1m30s - QueryCumulativeNetworkTime: 254.443ms - QueryCumulativeOperatorTime: 18s644ms - QueryCumulativeScanTime: 102.559ms - QueryDeallocatedMemoryUsage: 57.337 GB - QueryExecutionWallTime: 12s247ms - QueryPeakMemoryUsagePerNode: 7.396 GB - QueryPeakScheduleTime: 779.148ms - QuerySpillBytes: 0.000 B - QuerySumMemoryUsage: 7.396 GB - ResultDeliverTime: 0ns Fragment 0: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019adf54-fe43-7ae2-a249-1c5be46a01cc - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 191.175us - InitialProcessDriverCount: 0 - InitialProcessMem: 43.893 GB - InstanceAllocatedMemoryUsage: 9.794 GB - InstanceDeallocatedMemoryUsage: 9.792 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 10.078 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 11s467ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 12s246ms - OverheadTime: 5s417ms - PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 777.152ms - FirstInputEmptyTime: 777.152ms - ScheduleCount: 85 - ScheduleTime: 779.148ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 84 RESULT_SINK (plan_node_id=-1): CommonMetrics: - IsFinalSink - OperatorTotalTime: 2s719ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 828 - PushRowNum: 3.362M (3362123) - PushTotalTime: 2s719ms UniqueMetrics: - SinkType: MYSQL_PROTOCAL - AppendChunkTime: 2s197ms - ResultRendTime: 520.865ms - TupleConvertTime: 2s194ms - NumSentRows: 3.362M (3362123) CHUNK_ACCUMULATE (plan_node_id=-1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 2.272ms - OutputChunkBytes: 1.339 GB - PullChunkNum: 828 - PullRowNum: 3.362M (3362123) - PullTotalTime: 70.392us - PushChunkNum: 863 - PushRowNum: 3.362M (3362123) - PushTotalTime: 2.201ms UniqueMetrics: DICT_DECODE (plan_node_id=19): CommonMetrics: - OperatorTotalTime: 42.814ms - OutputChunkBytes: 1.339 GB - PullChunkNum: 863 - PullRowNum: 3.362M (3362123) - PullTotalTime: 148.288us - PushChunkNum: 863 - PushRowNum: 3.362M (3362123) - PushTotalTime: 42.659ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: GLOBAL_MERGE_SOURCE (plan_node_id=18): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 3s285ms - OutputChunkBytes: 1.302 GB - PullChunkNum: 863 - PullRowNum: 3.362M (3362123) - PullTotalTime: 3s285ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 0.000 B - BytesReceived: 103.197 MB - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 102.551ms - DeserializeChunkTime: 688.448ms - PeakBufferMemoryBytes: 394.229 KB - ReceiverProcessTotalTime: 794.885ms - RequestReceived: 340 - WaitLockTime: 68.868us Fragment 1: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019adf54-fe43-7ae2-a249-1c5be46a01cd - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 9.757ms - FragmentInstancePrepareTime: 18.614ms - prepare-pipeline-driver: 15.118ms - InitialProcessDriverCount: 1 - InitialProcessMem: 43.892 GB - InstanceAllocatedMemoryUsage: 35.615 GB - InstanceDeallocatedMemoryUsage: 35.381 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 5.804 GB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 30.965us - __MAX_OF_ActiveTime: 122.444us - __MIN_OF_ActiveTime: 8.250us - BlockByInputEmpty: 48 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 18.233ms - __MAX_OF_DriverTotalTime: 18.418ms - __MIN_OF_DriverTotalTime: 18.097ms - PeakDriverQueueSize: 1.135K (1135) - __MAX_OF_PeakDriverQueueSize: 47 - __MIN_OF_PeakDriverQueueSize: 1 - PendingTime: 0ns - InputEmptyTime: 17.609ms - __MAX_OF_InputEmptyTime: 17.658ms - __MIN_OF_InputEmptyTime: 17.545ms - FirstInputEmptyTime: 16.506ms - __MAX_OF_FirstInputEmptyTime: 16.518ms - __MIN_OF_FirstInputEmptyTime: 16.496ms - FollowupInputEmptyTime: 1.102ms - __MAX_OF_FollowupInputEmptyTime: 1.146ms - __MIN_OF_FollowupInputEmptyTime: 1.047ms - ScheduleCount: 96 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 18.202ms - __MAX_OF_ScheduleTime: 18.381ms - __MIN_OF_ScheduleTime: 18.020ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 6.738us - __MAX_OF_OperatorTotalTime: 43.652us - __MIN_OF_OperatorTotalTime: 401ns - 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: 9 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 6.011us - __MAX_OF_PushTotalTime: 42.821us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 1 - Type: Passthrough - LocalExchangePeakMemoryUsage: 3.676 KB EXCHANGE_SOURCE (plan_node_id=14): CommonMetrics: - ConjunctsInputRows: 36 - __MAX_OF_ConjunctsInputRows: 9 - __MIN_OF_ConjunctsInputRows: 1 - ConjunctsOutputRows: 36 - __MAX_OF_ConjunctsOutputRows: 9 - __MIN_OF_ConjunctsOutputRows: 1 - ConjunctsTime: 2.001us - __MAX_OF_ConjunctsTime: 4.221us - __MIN_OF_ConjunctsTime: 840ns - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 20.128us - __MAX_OF_OperatorTotalTime: 73.482us - __MIN_OF_OperatorTotalTime: 6.680us - OutputChunkBytes: 4.425 KB - __MAX_OF_OutputChunkBytes: 1.088 KB - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 24 - __MAX_OF_PullChunkNum: 5 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 36 - __MAX_OF_PullRowNum: 9 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 7.574us - __MAX_OF_PullTotalTime: 37.811us - __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: 3.544 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: 3.544 KB - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 2.076us - __MAX_OF_ReceiverProcessTotalTime: 20.150us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 25 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 0ns Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 849.421us - BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 18.966ms - PeakDriverQueueSize: 39 - PendingTime: 0ns - InputEmptyTime: 17.730ms - FirstInputEmptyTime: 16.698ms - FollowupInputEmptyTime: 1.032ms - ScheduleCount: 2 - ScheduleTime: 18.117ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 HASH_JOIN_BUILD (plan_node_id=15): CommonMetrics: - OperatorTotalTime: 616.760us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 24 - PushRowNum: 36 - PushTotalTime: 119.277us - 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: 40.102us - BuildHashTableTime: 134.114us - BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 72.612us - HashTableMemoryUsage: 11.329 KB - PartialRuntimeMembershipFilterBytes: 64.000 B - PartitionNums: 1 - RuntimeFilterBuildTime: 59.672us - RuntimeFilterNum: 2 LOCAL_EXCHANGE_SOURCE (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 59.792us - OutputChunkBytes: 4.425 KB - PullChunkNum: 24 - PullRowNum: 36 - PullTotalTime: 53.311us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=2): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 15.903us - __MAX_OF_ActiveTime: 57.762us - __MIN_OF_ActiveTime: 5.531us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 21.669ms - __MAX_OF_DriverTotalTime: 21.886ms - __MIN_OF_DriverTotalTime: 21.541ms - PeakDriverQueueSize: 919 - __MAX_OF_PeakDriverQueueSize: 42 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 2.742ms - __MAX_OF_InputEmptyTime: 2.767ms - __MIN_OF_InputEmptyTime: 2.715ms - FirstInputEmptyTime: 2.742ms - __MAX_OF_FirstInputEmptyTime: 2.767ms - __MIN_OF_FirstInputEmptyTime: 2.715ms - PreconditionBlockTime: 18.586ms - __MAX_OF_PreconditionBlockTime: 18.597ms - __MIN_OF_PreconditionBlockTime: 18.569ms - ScheduleCount: 49 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 21.654ms - __MAX_OF_ScheduleTime: 21.878ms - __MIN_OF_ScheduleTime: 21.502ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=9): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.153us - __MAX_OF_OperatorTotalTime: 18.771us - __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: 2 - __MAX_OF_PushRowNum: 1 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 189ns - __MAX_OF_PushTotalTime: 5.150us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 1 - Type: Passthrough - LocalExchangePeakMemoryUsage: 145.000 B CHUNK_ACCUMULATE (plan_node_id=8): CommonMetrics: - IsSubordinate - OperatorTotalTime: 478ns - __MAX_OF_OperatorTotalTime: 1.360us - __MIN_OF_OperatorTotalTime: 261ns - 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: 4ns - __MAX_OF_PullTotalTime: 130ns - __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: 26ns - __MAX_OF_PushTotalTime: 850ns - __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: 1.124us - __MAX_OF_ConjunctsTime: 1.249us - __MIN_OF_ConjunctsTime: 1us - JoinRuntimeFilterEvaluate: 2 - __MAX_OF_JoinRuntimeFilterEvaluate: 1 - __MIN_OF_JoinRuntimeFilterEvaluate: 1 - JoinRuntimeFilterHashTime: 250ns - __MAX_OF_JoinRuntimeFilterHashTime: 260ns - __MIN_OF_JoinRuntimeFilterHashTime: 240ns - JoinRuntimeFilterInputRows: 2 - __MAX_OF_JoinRuntimeFilterInputRows: 1 - __MIN_OF_JoinRuntimeFilterInputRows: 1 - JoinRuntimeFilterOutputRows: 2 - __MAX_OF_JoinRuntimeFilterOutputRows: 1 - __MIN_OF_JoinRuntimeFilterOutputRows: 1 - JoinRuntimeFilterTime: 5.280us - __MAX_OF_JoinRuntimeFilterTime: 5.360us - __MIN_OF_JoinRuntimeFilterTime: 5.200us - OperatorTotalTime: 16.771us - __MAX_OF_OperatorTotalTime: 44.070us - __MIN_OF_OperatorTotalTime: 5.951us - 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.008us - __MAX_OF_PullTotalTime: 25.221us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 263.000 B - __MAX_OF_BytesPassThrough: 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: 366ns - __MAX_OF_ReceiverProcessTotalTime: 14.431us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 3 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 0ns Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 421.611us - BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 22.166ms - PeakDriverQueueSize: 39 - PendingTime: 0ns - InputEmptyTime: 21.343ms - FirstInputEmptyTime: 21.324ms - ScheduleCount: 2 - ScheduleTime: 21.745ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 HASH_JOIN_BUILD (plan_node_id=9): CommonMetrics: - OperatorTotalTime: 394.359us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 2 - PushRowNum: 2 - PushTotalTime: 15.650us - 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.811us - BuildHashTableTime: 132.603us - BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 8.600us - HashTableMemoryUsage: 4.233 KB - PartialRuntimeMembershipFilterBytes: 0.000 B - PartitionNums: 1 - RuntimeFilterBuildTime: 3.981us - RuntimeFilterNum: 0 LOCAL_EXCHANGE_SOURCE (plan_node_id=9): CommonMetrics: - IsSubordinate - OperatorTotalTime: 17.662us - OutputChunkBytes: 103.000 B - PullChunkNum: 2 - PullRowNum: 2 - PullTotalTime: 7.411us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=4): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 106.085ms - __MAX_OF_ActiveTime: 122.079ms - __MIN_OF_ActiveTime: 83.739ms - BlockByInputEmpty: 1.367K (1367) - __MAX_OF_BlockByInputEmpty: 51 - __MIN_OF_BlockByInputEmpty: 14 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 351.040ms - __MAX_OF_DriverTotalTime: 351.917ms - __MIN_OF_DriverTotalTime: 349.592ms - OverheadTime: 1.885ms - __MAX_OF_OverheadTime: 2.345ms - __MIN_OF_OverheadTime: 1.497ms - PeakDriverQueueSize: 1.000K (1000) - __MAX_OF_PeakDriverQueueSize: 39 - __MIN_OF_PeakDriverQueueSize: 2 - PendingTime: 0ns - InputEmptyTime: 222.477ms - __MAX_OF_InputEmptyTime: 243.986ms - __MIN_OF_InputEmptyTime: 207.363ms - FirstInputEmptyTime: 151.962ms - __MAX_OF_FirstInputEmptyTime: 159.274ms - __MIN_OF_FirstInputEmptyTime: 149.113ms - FollowupInputEmptyTime: 70.515ms - __MAX_OF_FollowupInputEmptyTime: 85.951ms - __MIN_OF_FollowupInputEmptyTime: 57.684ms - PreconditionBlockTime: 18.622ms - __MAX_OF_PreconditionBlockTime: 18.649ms - __MIN_OF_PreconditionBlockTime: 18.595ms - ScheduleCount: 1.446K (1446) - __MAX_OF_ScheduleCount: 53 - __MIN_OF_ScheduleCount: 16 - ScheduleTime: 244.955ms - __MAX_OF_ScheduleTime: 267.676ms - __MIN_OF_ScheduleTime: 228.393ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 99 - __MAX_OF_YieldByTimeLimit: 9 - __MIN_OF_YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=3): CommonMetrics: - OperatorTotalTime: 92.831ms - __MAX_OF_OperatorTotalTime: 107.854ms - __MIN_OF_OperatorTotalTime: 73.222ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.212K (1212) - __MAX_OF_PushChunkNum: 26 - __MIN_OF_PushChunkNum: 24 - PushRowNum: 4.010M (4009539) - __MAX_OF_PushRowNum: 84.029K (84029) - __MIN_OF_PushRowNum: 83.031K (83031) - PushTotalTime: 92.794ms - __MAX_OF_PushTotalTime: 107.839ms - __MIN_OF_PushTotalTime: 73.168ms - 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: 90.942ms - __MAX_OF_AggComputeTime: 105.703ms - __MIN_OF_AggComputeTime: 71.835ms - AggFuncComputeTime: 3.764ms - __MAX_OF_AggFuncComputeTime: 4.946ms - __MIN_OF_AggFuncComputeTime: 2.504ms - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 379.845us - __MAX_OF_ExprComputeTime: 478.959us - __MIN_OF_ExprComputeTime: 286.276us - ExprReleaseTime: 1.612ms - __MAX_OF_ExprReleaseTime: 2.389ms - __MIN_OF_ExprReleaseTime: 1.138ms - GetResultsTime: 45.979ms - __MAX_OF_GetResultsTime: 57.991ms - __MIN_OF_GetResultsTime: 37.314ms - 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.010M (4009539) - __MAX_OF_InputRowCount: 84.029K (84029) - __MIN_OF_InputRowCount: 83.031K (83031) - PassThroughRowCount: 0 - ResultAggAppendTime: 8.777ms - __MAX_OF_ResultAggAppendTime: 9.991ms - __MIN_OF_ResultAggAppendTime: 7.346ms - ResultGroupByAppendTime: 34.976ms - __MAX_OF_ResultGroupByAppendTime: 45.667ms - __MIN_OF_ResultGroupByAppendTime: 26.713ms - ResultIteratorTime: 1.114ms - __MAX_OF_ResultIteratorTime: 1.562ms - __MIN_OF_ResultIteratorTime: 871.430us - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns CHUNK_ACCUMULATE (plan_node_id=2): CommonMetrics: - IsSubordinate - OperatorTotalTime: 10.225ms - __MAX_OF_OperatorTotalTime: 12.031ms - __MIN_OF_OperatorTotalTime: 8.225ms - OutputChunkBytes: 962.587 MB - __MAX_OF_OutputChunkBytes: 20.170 MB - __MIN_OF_OutputChunkBytes: 19.933 MB - PullChunkNum: 1.212K (1212) - __MAX_OF_PullChunkNum: 26 - __MIN_OF_PullChunkNum: 24 - PullRowNum: 4.010M (4009539) - __MAX_OF_PullRowNum: 84.029K (84029) - __MIN_OF_PullRowNum: 83.031K (83031) - PullTotalTime: 5.104us - __MAX_OF_PullTotalTime: 15.057us - __MIN_OF_PullTotalTime: 3.308us - PushChunkNum: 2.304K (2304) - __MAX_OF_PushChunkNum: 48 - __MIN_OF_PushChunkNum: 48 - PushRowNum: 4.010M (4009539) - __MAX_OF_PushRowNum: 84.029K (84029) - __MIN_OF_PushRowNum: 83.031K (83031) - PushTotalTime: 10.219ms - __MAX_OF_PushTotalTime: 12.025ms - __MIN_OF_PushTotalTime: 8.221ms UniqueMetrics: EXCHANGE_SOURCE (plan_node_id=2): CommonMetrics: - RuntimeFilterDesc: <1: BloomFilter> - ConjunctsInputRows: 4.010M (4009539) - __MAX_OF_ConjunctsInputRows: 84.029K (84029) - __MIN_OF_ConjunctsInputRows: 83.031K (83031) - ConjunctsOutputRows: 4.010M (4009539) - __MAX_OF_ConjunctsOutputRows: 84.029K (84029) - __MIN_OF_ConjunctsOutputRows: 83.031K (83031) - ConjunctsTime: 179.873us - __MAX_OF_ConjunctsTime: 219.948us - __MIN_OF_ConjunctsTime: 132.844us - JoinRuntimeFilterEvaluate: 96 - __MAX_OF_JoinRuntimeFilterEvaluate: 2 - __MIN_OF_JoinRuntimeFilterEvaluate: 2 - JoinRuntimeFilterHashTime: 1.073us - __MAX_OF_JoinRuntimeFilterHashTime: 2.950us - __MIN_OF_JoinRuntimeFilterHashTime: 230ns - JoinRuntimeFilterInputRows: 4.010M (4009539) - __MAX_OF_JoinRuntimeFilterInputRows: 84.029K (84029) - __MIN_OF_JoinRuntimeFilterInputRows: 83.031K (83031) - JoinRuntimeFilterOutputRows: 4.010M (4009539) - __MAX_OF_JoinRuntimeFilterOutputRows: 84.029K (84029) - __MIN_OF_JoinRuntimeFilterOutputRows: 83.031K (83031) - JoinRuntimeFilterTime: 98.722us - __MAX_OF_JoinRuntimeFilterTime: 151.547us - __MIN_OF_JoinRuntimeFilterTime: 56.676us - OperatorTotalTime: 1.141ms - __MAX_OF_OperatorTotalTime: 2.407ms - __MIN_OF_OperatorTotalTime: 696.854us - OutputChunkBytes: 962.587 MB - __MAX_OF_OutputChunkBytes: 20.170 MB - __MIN_OF_OutputChunkBytes: 19.933 MB - PullChunkNum: 2.304K (2304) - __MAX_OF_PullChunkNum: 48 - __MIN_OF_PullChunkNum: 48 - PullRowNum: 4.010M (4009539) - __MAX_OF_PullRowNum: 84.029K (84029) - __MIN_OF_PullRowNum: 83.031K (83031) - PullTotalTime: 1.110ms - __MAX_OF_PullTotalTime: 2.348ms - __MIN_OF_PullTotalTime: 680.253us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 1 UniqueMetrics: - BufferUnplugCount: 48 - __MAX_OF_BufferUnplugCount: 1 - __MIN_OF_BufferUnplugCount: 1 - BytesPassThrough: 963.185 MB - __MAX_OF_BytesPassThrough: 255.646 MB - __MIN_OF_BytesPassThrough: 4.307 MB - BytesReceived: 0.000 B - ClosureBlockCount: 438 - __MAX_OF_ClosureBlockCount: 12 - __MIN_OF_ClosureBlockCount: 5 - ClosureBlockTime: 99.772ms - __MAX_OF_ClosureBlockTime: 541.537ms - __MIN_OF_ClosureBlockTime: 414.220us - DecompressChunkTime: 0ns - DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 590.290 MB - __MAX_OF_PeakBufferMemoryBytes: 247.502 MB - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 429.106us - __MAX_OF_ReceiverProcessTotalTime: 1.068ms - __MIN_OF_ReceiverProcessTotalTime: 188.458us - RequestReceived: 2.305K (2305) - __MAX_OF_RequestReceived: 49 - __MIN_OF_RequestReceived: 48 - WaitLockTime: 0ns Pipeline (id=5): - LocalRfWaitingSet: 1 - IsGroupExecution: false - ActiveTime: 213.782ms - __MAX_OF_ActiveTime: 250.517ms - __MIN_OF_ActiveTime: 191.329ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 564.788ms - __MAX_OF_DriverTotalTime: 600.962ms - __MIN_OF_DriverTotalTime: 542.673ms - PeakDriverQueueSize: 81 - __MAX_OF_PeakDriverQueueSize: 21 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 329.004ms - __MAX_OF_InputEmptyTime: 329.914ms - __MIN_OF_InputEmptyTime: 327.572ms - FirstInputEmptyTime: 329.004ms - __MAX_OF_FirstInputEmptyTime: 329.914ms - __MIN_OF_FirstInputEmptyTime: 327.572ms - PreconditionBlockTime: 21.924ms - __MAX_OF_PreconditionBlockTime: 21.995ms - __MIN_OF_PreconditionBlockTime: 21.862ms - ScheduleCount: 73 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 351.006ms - __MAX_OF_ScheduleTime: 351.897ms - __MIN_OF_ScheduleTime: 349.782ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 25 - __MAX_OF_YieldByTimeLimit: 1 - __MIN_OF_YieldByTimeLimit: 0 LOCAL_SORT_SINK (plan_node_id=17): CommonMetrics: - OperatorTotalTime: 110.545ms - __MAX_OF_OperatorTotalTime: 123.233ms - __MIN_OF_OperatorTotalTime: 98.116ms - 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: 120.672us - __MAX_OF_PushTotalTime: 168.114us - __MIN_OF_PushTotalTime: 94.431us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 - SetFinishingTime: 110.421ms - __MAX_OF_SetFinishingTime: 123.110ms - __MIN_OF_SetFinishingTime: 97.994ms UniqueMetrics: - LateMaterialization: False - MaxBufferedBytes: 268435456 - MaxBufferedRows: 1073741824 - SortKeys: 97: date DESC, 1: device ASC - SortType: All - BuildingTime: 14.156us - __MAX_OF_BuildingTime: 22.871us - __MIN_OF_BuildingTime: 8.819us - InputRequiredMemory: 1.302 GB - __MAX_OF_InputRequiredMemory: 27.988 MB - __MIN_OF_InputRequiredMemory: 27.514 MB - MergingTime: 13.616us - __MAX_OF_MergingTime: 23.311us - __MIN_OF_MergingTime: 8.770us - NumSortedRuns: 48 - __MAX_OF_NumSortedRuns: 1 - __MIN_OF_NumSortedRuns: 1 - OutputTime: 3.543ms - __MAX_OF_OutputTime: 6.516ms - __MIN_OF_OutputTime: 3.274ms - SortingCnt: 0 - SortingTime: 72.085ms - __MAX_OF_SortingTime: 86.290ms - __MIN_OF_SortingTime: 60.899ms PROJECT (plan_node_id=16): CommonMetrics: - OperatorTotalTime: 22.212ms - __MAX_OF_OperatorTotalTime: 28.564ms - __MIN_OF_OperatorTotalTime: 16.476ms - 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.465us - __MAX_OF_PullTotalTime: 7.881us - __MIN_OF_PullTotalTime: 1.780us - 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: 22.205ms - __MAX_OF_PushTotalTime: 28.552ms - __MIN_OF_PushTotalTime: 16.469ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 846.631us - __MAX_OF_CommonSubExprComputeTime: 1.225ms - __MIN_OF_CommonSubExprComputeTime: 587.644us - ExprComputeTime: 21.277ms - __MAX_OF_ExprComputeTime: 27.334ms - __MIN_OF_ExprComputeTime: 15.812ms CHUNK_ACCUMULATE (plan_node_id=15): CommonMetrics: - IsSubordinate - OperatorTotalTime: 16.078us - __MAX_OF_OperatorTotalTime: 27.970us - __MIN_OF_OperatorTotalTime: 12.838us - 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.690us - __MAX_OF_PullTotalTime: 2.330us - __MIN_OF_PullTotalTime: 1.248us - 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: 13.526us - __MAX_OF_PushTotalTime: 25.510us - __MIN_OF_PushTotalTime: 11.009us UniqueMetrics: HASH_JOIN_PROBE (plan_node_id=15): CommonMetrics: - OperatorTotalTime: 12.992ms - __MAX_OF_OperatorTotalTime: 17.323ms - __MIN_OF_OperatorTotalTime: 10.209ms - 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.921ms - __MAX_OF_PullTotalTime: 17.211ms - __MIN_OF_PullTotalTime: 10.165ms - 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: 58.497us - __MAX_OF_PushTotalTime: 110.012us - __MIN_OF_PushTotalTime: 31.481us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - JoinType: INNER_JOIN - OtherJoinConjunctEvaluateTime: 0ns - OutputBuildColumnTime: 7.258ms - __MAX_OF_OutputBuildColumnTime: 9.892ms - __MIN_OF_OutputBuildColumnTime: 5.400ms - OutputProbeColumnTime: 3.149ms - __MAX_OF_OutputProbeColumnTime: 4.265ms - __MIN_OF_OutputProbeColumnTime: 2.367ms - PartitionProbeOverhead: 0ns - ProbeConjunctEvaluateTime: 0ns - SearchHashTableTime: 2.440ms - __MAX_OF_SearchHashTableTime: 3.149ms - __MIN_OF_SearchHashTableTime: 1.983ms - WhereConjunctEvaluateTime: 0ns - probeCount: 0 PROJECT (plan_node_id=10): CommonMetrics: - OperatorTotalTime: 81.007us - __MAX_OF_OperatorTotalTime: 98.913us - __MIN_OF_OperatorTotalTime: 65.490us - 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.520us - __MAX_OF_PullTotalTime: 2.019us - __MIN_OF_PullTotalTime: 1.089us - 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: 75.549us - __MAX_OF_PushTotalTime: 93.903us - __MIN_OF_PushTotalTime: 61.100us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 1.473us - __MAX_OF_CommonSubExprComputeTime: 2.290us - __MIN_OF_CommonSubExprComputeTime: 1.010us - ExprComputeTime: 34.698us - __MAX_OF_ExprComputeTime: 54.765us - __MIN_OF_ExprComputeTime: 27.510us HASH_JOIN_PROBE (plan_node_id=9): CommonMetrics: - OperatorTotalTime: 3.181ms - __MAX_OF_OperatorTotalTime: 4.123ms - __MIN_OF_OperatorTotalTime: 2.505ms - 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.110ms - __MAX_OF_PullTotalTime: 4.042ms - __MIN_OF_PullTotalTime: 2.444ms - 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: 54.881us - __MAX_OF_PushTotalTime: 87.184us - __MIN_OF_PushTotalTime: 35.451us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - JoinType: LEFT_OUTER_JOIN - OtherJoinConjunctEvaluateTime: 0ns - OutputBuildColumnTime: 955.776us - __MAX_OF_OutputBuildColumnTime: 1.293ms - __MIN_OF_OutputBuildColumnTime: 714.935us - OutputProbeColumnTime: 51.694us - __MAX_OF_OutputProbeColumnTime: 78.730us - __MIN_OF_OutputProbeColumnTime: 37.720us - PartitionProbeOverhead: 0ns - ProbeConjunctEvaluateTime: 0ns - SearchHashTableTime: 2.026ms - __MAX_OF_SearchHashTableTime: 2.614ms - __MIN_OF_SearchHashTableTime: 1.603ms - WhereConjunctEvaluateTime: 0ns - probeCount: 0 PROJECT (plan_node_id=4): CommonMetrics: - OperatorTotalTime: 18.250ms - __MAX_OF_OperatorTotalTime: 24.415ms - __MIN_OF_OperatorTotalTime: 14.076ms - 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.231us - __MAX_OF_PullTotalTime: 2.940us - __MIN_OF_PullTotalTime: 1.531us - PushChunkNum: 942 - __MAX_OF_PushChunkNum: 20 - __MIN_OF_PushChunkNum: 19 - PushRowNum: 3.740M (3740376) - __MAX_OF_PushRowNum: 78.434K (78434) - __MIN_OF_PushRowNum: 77.436K (77436) - PushTotalTime: 18.242ms - __MAX_OF_PushTotalTime: 24.408ms - __MIN_OF_PushTotalTime: 14.066ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 1 UniqueMetrics: - CommonSubExprComputeTime: 9.297ms - __MAX_OF_CommonSubExprComputeTime: 12.618ms - __MIN_OF_CommonSubExprComputeTime: 7.164ms - ExprComputeTime: 8.876ms - __MAX_OF_ExprComputeTime: 11.696ms - __MIN_OF_ExprComputeTime: 6.639ms AGGREGATE_BLOCKING_SOURCE (plan_node_id=3): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 46.150ms - __MAX_OF_OperatorTotalTime: 58.148ms - __MIN_OF_OperatorTotalTime: 37.451ms - 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: 46.027ms - __MAX_OF_PullTotalTime: 58.042ms - __MIN_OF_PullTotalTime: 37.358ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=6): - IsGroupExecution: false - ActiveTime: 11s593ms - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 12s209ms - OverheadTime: 23.780ms - PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 600.865ms - FirstInputEmptyTime: 600.865ms - PendingFinishTime: 4.041ms - ScheduleCount: 109 - ScheduleTime: 616.570ms - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 108 EXCHANGE_SINK (plan_node_id=18): CommonMetrics: - OperatorTotalTime: 740.642ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 863 - PushRowNum: 3.362M (3362123) - PushTotalTime: 740.629ms UniqueMetrics: - ChannelNum: 1 - DestFragments: 019adf54fe437ae2-a2491c5be46a01cc - DestID: 18 - PartType: UNPARTITIONED - BytesPassThrough: 0.000 B - BytesSent: 103.197 MB - BytesUnsent: 0.000 B - CompressTime: 214.281ms - CompressedBytes: 103.197 MB - NetworkBandwidth: 636.560 MB/sec - NetworkTime: 162.115ms - OverallThroughput: 9.008 MB/sec - OverallTime: 11s455ms - PassThroughBufferPeakMemoryUsage: 0.000 B - RawInputBytes: 1.302 GB - RequestSent: 340 - RequestUnsent: 0 - RpcAvgTime: 475.413us - RpcCount: 341 - SerializeChunkTime: 449.769ms - SerializedBytes: 281.853 MB - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 4.435ms LOCAL_MERGE_SOURCE (plan_node_id=17): CommonMetrics: - OperatorTotalTime: 10s828ms - OutputChunkBytes: 1.302 GB - PullChunkNum: 863 - PullRowNum: 3.362M (3362123) - PullTotalTime: 10s828ms - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Fragment 2: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019adf54-fe43-7ae2-a249-1c5be46a01ce - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 5.408ms - FragmentInstancePrepareTime: 11.133ms - InitialProcessDriverCount: 196 - InitialProcessMem: 43.918 GB - InstanceAllocatedMemoryUsage: 27.299 MB - InstanceDeallocatedMemoryUsage: 27.286 MB - InstanceNum: 1 - InstancePeakMemoryUsage: 20.009 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 238.212us - __MAX_OF_ActiveTime: 1.030ms - __MIN_OF_ActiveTime: 5.771us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 4.995ms - __MAX_OF_DriverTotalTime: 5.338ms - __MIN_OF_DriverTotalTime: 4.585ms - PeakDriverQueueSize: 513 - __MAX_OF_PeakDriverQueueSize: 39 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 2.019ms - __MAX_OF_InputEmptyTime: 2.387ms - __MIN_OF_InputEmptyTime: 1.470ms - FirstInputEmptyTime: 2.019ms - __MAX_OF_FirstInputEmptyTime: 2.387ms - __MIN_OF_FirstInputEmptyTime: 1.470ms - PendingFinishTime: 2.426ms - __MAX_OF_PendingFinishTime: 3.202ms - __MIN_OF_PendingFinishTime: 1.350ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 4.757ms - __MAX_OF_ScheduleTime: 5.271ms - __MIN_OF_ScheduleTime: 3.940ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=14): CommonMetrics: - OperatorTotalTime: 182.939us - __MAX_OF_OperatorTotalTime: 939.713us - __MIN_OF_OperatorTotalTime: 1.941us - 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: 9.125us - __MAX_OF_PushTotalTime: 33.320us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ChannelNum: 1 - DestFragments: 019adf54fe437ae2-a2491c5be46a01cd - DestID: 14 - PartType: UNPARTITIONED - BytesPassThrough: 9.300 KB - __MAX_OF_BytesPassThrough: 583.000 B - __MIN_OF_BytesPassThrough: 0.000 B - BytesSent: 0.000 B - BytesUnsent: 0.000 B - CompressTime: 0ns - CompressedBytes: 0.000 B - NetworkBandwidth: 0.000 B/sec - NetworkTime: 3.141ms - OverallThroughput: 0.000 B/sec - OverallTime: 2.721ms - PassThroughBufferPeakMemoryUsage: 3.891 KB - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 397.091us - RpcCount: 25 - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 1.004ms AGGREGATE_BLOCKING_SOURCE (plan_node_id=13): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 65.907us - __MAX_OF_OperatorTotalTime: 158.604us - __MIN_OF_OperatorTotalTime: 8.101us - 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: 46.410us - __MAX_OF_PullTotalTime: 126.663us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 64.028us - __MAX_OF_ActiveTime: 451.462us - __MIN_OF_ActiveTime: 6.530us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 2.205ms - __MAX_OF_DriverTotalTime: 3.110ms - __MIN_OF_DriverTotalTime: 1.505ms - PeakDriverQueueSize: 479 - __MAX_OF_PeakDriverQueueSize: 29 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 1.827ms - __MAX_OF_InputEmptyTime: 1.974ms - __MIN_OF_InputEmptyTime: 1.448ms - FirstInputEmptyTime: 1.827ms - __MAX_OF_FirstInputEmptyTime: 1.974ms - __MIN_OF_FirstInputEmptyTime: 1.448ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 2.141ms - __MAX_OF_ScheduleTime: 3.050ms - __MIN_OF_ScheduleTime: 1.492ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=13): CommonMetrics: - OperatorTotalTime: 51.569us - __MAX_OF_OperatorTotalTime: 449.472us - __MIN_OF_OperatorTotalTime: 8.680us - 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: 26.233us - __MAX_OF_PushTotalTime: 108.693us - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - AggregateFunctions: max(71: case), max(62: case), max(63: case), max(64: case), max(65: case), max(66: case), max(67: case), max(68: case), max(69: case), max(70: case) - GroupingKeys: 49: tos, 50: cpu, 102: cpu_name - AggComputeTime: 24.017us - __MAX_OF_AggComputeTime: 103.733us - __MIN_OF_AggComputeTime: 0ns - AggFuncComputeTime: 4.320us - __MAX_OF_AggFuncComputeTime: 24.860us - __MIN_OF_AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 2.444us - __MAX_OF_ExprComputeTime: 9.253us - __MIN_OF_ExprComputeTime: 0ns - ExprReleaseTime: 607ns - __MAX_OF_ExprReleaseTime: 6.570us - __MIN_OF_ExprReleaseTime: 0ns - GetResultsTime: 39.901us - __MAX_OF_GetResultsTime: 112.913us - __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.029us - __MAX_OF_ResultAggAppendTime: 7.690us - __MIN_OF_ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 986ns - __MAX_OF_ResultGroupByAppendTime: 3.540us - __MIN_OF_ResultGroupByAppendTime: 0ns - ResultIteratorTime: 25.985us - __MAX_OF_ResultIteratorTime: 77.182us - __MIN_OF_ResultIteratorTime: 0ns - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns LOCAL_EXCHANGE_SOURCE (plan_node_id=13): CommonMetrics: - IsSubordinate - OperatorTotalTime: 15.325us - __MAX_OF_OperatorTotalTime: 44.971us - __MIN_OF_OperatorTotalTime: 1.120us - 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: 13.122us - __MAX_OF_PullTotalTime: 42.301us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 620.775us - __MAX_OF_ActiveTime: 1.297ms - __MIN_OF_ActiveTime: 477.002us - BlockByInputEmpty: 8 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 8 - DriverTotalTime: 1.405ms - __MAX_OF_DriverTotalTime: 2.254ms - __MIN_OF_DriverTotalTime: 1.175ms - PeakDriverQueueSize: 23 - __MAX_OF_PeakDriverQueueSize: 5 - __MIN_OF_PeakDriverQueueSize: 0 - ScheduleCount: 16 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 2 - TotalDegreeOfParallelism: 8 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=13): CommonMetrics: - IsSubordinate - OperatorTotalTime: 93.793us - __MAX_OF_OperatorTotalTime: 576.705us - __MIN_OF_OperatorTotalTime: 12.671us - 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: 23.594us - __MAX_OF_PushTotalTime: 36.961us - __MIN_OF_PushTotalTime: 12.271us UniqueMetrics: - ShuffleNum: 48 - Type: Partition(BUCKET_SHUFFLE_HASH_PARTITIONED) - LocalExchangePeakMemoryUsage: 839.000 B PROJECT (plan_node_id=12): CommonMetrics: - OperatorTotalTime: 54.602us - __MAX_OF_OperatorTotalTime: 73.763us - __MIN_OF_OperatorTotalTime: 32.920us - 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: 241ns - __MAX_OF_PullTotalTime: 350ns - __MIN_OF_PullTotalTime: 130ns - PushChunkNum: 8 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 72 - __MAX_OF_PushRowNum: 14 - __MIN_OF_PushRowNum: 6 - PushTotalTime: 51.380us - __MAX_OF_PushTotalTime: 70.692us - __MIN_OF_PushTotalTime: 30.290us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 8.019us - __MAX_OF_CommonSubExprComputeTime: 10.431us - __MIN_OF_CommonSubExprComputeTime: 4.790us - ExprComputeTime: 39.228us - __MAX_OF_ExprComputeTime: 52.921us - __MIN_OF_ExprComputeTime: 22.430us CHUNK_ACCUMULATE (plan_node_id=11): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.963us - __MAX_OF_OperatorTotalTime: 2.301us - __MIN_OF_OperatorTotalTime: 1.350us - 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: 227ns - __MAX_OF_PullTotalTime: 260ns - __MIN_OF_PullTotalTime: 190ns - PushChunkNum: 8 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 1 - PushRowNum: 72 - __MAX_OF_PushRowNum: 14 - __MIN_OF_PushRowNum: 6 - PushTotalTime: 1.101us - __MAX_OF_PushTotalTime: 1.440us - __MIN_OF_PushTotalTime: 740ns UniqueMetrics: OLAP_SCAN (plan_node_id=11): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 515.580us - __MAX_OF_OperatorTotalTime: 846.552us - __MIN_OF_OperatorTotalTime: 423.752us - 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: 308.288us - __MAX_OF_PullTotalTime: 516.003us - __MIN_OF_PullTotalTime: 240.856us - 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: 596.727us - __MAX_OF_IOTaskExecTime: 667.107us - __MIN_OF_IOTaskExecTime: 520.554us - CreateSegmentIter: 48.203us - __MAX_OF_CreateSegmentIter: 71.142us - __MIN_OF_CreateSegmentIter: 34.041us - DictDecode: 2.895us - __MAX_OF_DictDecode: 3.610us - __MIN_OF_DictDecode: 2.120us - DictDecodeCount: 216 - __MAX_OF_DictDecodeCount: 42 - __MIN_OF_DictDecodeCount: 18 - GetDelVec: 0ns - GetDeltaColumnGroup: 9.985us - __MAX_OF_GetDeltaColumnGroup: 29.180us - __MIN_OF_GetDeltaColumnGroup: 2.681us - GetRowsets: 5.463us - __MAX_OF_GetRowsets: 7.220us - __MIN_OF_GetRowsets: 4.140us - IOTime: 0ns - LateMaterialize: 41.312us - __MAX_OF_LateMaterialize: 54.572us - __MIN_OF_LateMaterialize: 34.490us - LateMaterializeRows: 72 - __MAX_OF_LateMaterializeRows: 14 - __MIN_OF_LateMaterializeRows: 6 - ReadPKIndex: 0ns - SegmentInit: 242.188us - __MAX_OF_SegmentInit: 272.847us - __MIN_OF_SegmentInit: 208.895us - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 5.060us - __MAX_OF_BitmapIndexIteratorInit: 6.130us - __MIN_OF_BitmapIndexIteratorInit: 4.150us - BloomFilterFilter: 487ns - __MAX_OF_BloomFilterFilter: 710ns - __MIN_OF_BloomFilterFilter: 311ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 124.448us - __MAX_OF_ColumnIteratorInit: 165.444us - __MIN_OF_ColumnIteratorInit: 92.452us - GetVectorRowRangesTime: 0ns - GinFilter: 0ns - GinFilterRows: 0 - ProcessVectorDistanceAndIdTime: 0ns - RemainingRowsAfterShortKeyFilter: 288 - __MAX_OF_RemainingRowsAfterShortKeyFilter: 56 - __MIN_OF_RemainingRowsAfterShortKeyFilter: 24 - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 26.518us - __MAX_OF_ShortKeyFilter: 39.721us - __MIN_OF_ShortKeyFilter: 23.010us - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 10.011us - __MAX_OF_ZoneMapIndexFilter: 11.660us - __MIN_OF_ZoneMapIndexFilter: 8.301us - ZoneMapIndexFilterRows: 0 - SegmentRead: 18.676us - __MAX_OF_SegmentRead: 21.871us - __MIN_OF_SegmentRead: 16.230us - BlockFetch: 8.782us - __MAX_OF_BlockFetch: 20.750us - __MIN_OF_BlockFetch: 4.350us - BlockFetchCount: 8 - __MAX_OF_BlockFetchCount: 1 - __MIN_OF_BlockFetchCount: 1 - BlockSeek: 17.021us - __MAX_OF_BlockSeek: 19.810us - __MIN_OF_BlockSeek: 12.720us - BlockSeekCount: 8 - __MAX_OF_BlockSeekCount: 1 - __MIN_OF_BlockSeekCount: 1 - ChunkCopy: 1.698us - __MAX_OF_ChunkCopy: 2.470us - __MIN_OF_ChunkCopy: 790ns - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 2.408us - __MAX_OF_PredFilter: 3.600us - __MIN_OF_PredFilter: 1.340us - PredFilterRows: 216 - __MAX_OF_PredFilterRows: 42 - __MIN_OF_PredFilterRows: 18 - RowsetsReadCount: 16 - __MAX_OF_RowsetsReadCount: 2 - __MIN_OF_RowsetsReadCount: 2 - SegmentsReadCount: 8 - __MAX_OF_SegmentsReadCount: 1 - __MIN_OF_SegmentsReadCount: 1 - TotalColumnsDataPageCount: 72 - __MAX_OF_TotalColumnsDataPageCount: 9 - __MIN_OF_TotalColumnsDataPageCount: 9 - IOTaskWaitTime: 87.414us - __MAX_OF_IOTaskWaitTime: 245.526us - __MIN_OF_IOTaskWaitTime: 35.291us - MorselsCount: 8 - __MAX_OF_MorselsCount: 1 - __MIN_OF_MorselsCount: 1 - PeakChunkBufferMemoryUsage: 726.417 KB - PeakChunkBufferSize: 2 - PeakIOTasks: 1 - PeakScanTaskQueueSize: 4 - __MAX_OF_PeakScanTaskQueueSize: 1 - __MIN_OF_PeakScanTaskQueueSize: 0 - PrepareChunkSourceTime: 224.221us - __MAX_OF_PrepareChunkSourceTime: 266.276us - __MIN_OF_PrepareChunkSourceTime: 185.504us - 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: 684.142us - __MAX_OF_ScanTime: 781.129us - __MIN_OF_ScanTime: 596.715us - SubmitTaskCount: 8 - __MAX_OF_SubmitTaskCount: 1 - __MIN_OF_SubmitTaskCount: 1 - SubmitTaskTime: 51.053us - __MAX_OF_SubmitTaskTime: 222.086us - __MIN_OF_SubmitTaskTime: 7.990us - TabletCount: 8 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 90.458us - __MAX_OF_ActiveTime: 128.573us - __MIN_OF_ActiveTime: 48.301us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 8 - DriverTotalTime: 255.248us - __MAX_OF_DriverTotalTime: 353.539us - __MIN_OF_DriverTotalTime: 185.915us - PeakDriverQueueSize: 28 - __MAX_OF_PeakDriverQueueSize: 7 - __MIN_OF_PeakDriverQueueSize: 0 - ScheduleCount: 8 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - TotalDegreeOfParallelism: 8 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=11): CommonMetrics: - IsSubordinate - OperatorTotalTime: 667ns - __MAX_OF_OperatorTotalTime: 1.071us - __MIN_OF_OperatorTotalTime: 250ns - 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: 88.252us - __MAX_OF_OperatorTotalTime: 123.243us - __MIN_OF_OperatorTotalTime: 48.841us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 81.235us - __MAX_OF_PullTotalTime: 118.813us - __MIN_OF_PullTotalTime: 43.631us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 4.317us - __MAX_OF_CaptureTabletRowsetsTime: 7.641us - __MIN_OF_CaptureTabletRowsetsTime: 2.820us Fragment 3: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019adf54-fe43-7ae2-a249-1c5be46a01cf - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 10.931ms - InitialProcessDriverCount: 196 - InitialProcessMem: 43.918 GB - InstanceAllocatedMemoryUsage: 5.868 MB - InstanceDeallocatedMemoryUsage: 6.726 MB - InstanceNum: 1 - InstancePeakMemoryUsage: 2.746 MB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 23.474us - __MAX_OF_ActiveTime: 159.784us - __MIN_OF_ActiveTime: 4.690us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 11.107ms - __MAX_OF_DriverTotalTime: 11.498ms - __MIN_OF_DriverTotalTime: 10.700ms - PeakDriverQueueSize: 912 - __MAX_OF_PeakDriverQueueSize: 43 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 8.821ms - __MAX_OF_InputEmptyTime: 8.958ms - __MIN_OF_InputEmptyTime: 8.539ms - FirstInputEmptyTime: 8.821ms - __MAX_OF_FirstInputEmptyTime: 8.958ms - __MIN_OF_FirstInputEmptyTime: 8.539ms - PendingFinishTime: 1.924ms - __MAX_OF_PendingFinishTime: 2.224ms - __MIN_OF_PendingFinishTime: 1.508ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 11.083ms - __MAX_OF_ScheduleTime: 11.493ms - __MIN_OF_ScheduleTime: 10.684ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=8): CommonMetrics: - OperatorTotalTime: 16.726us - __MAX_OF_OperatorTotalTime: 116.973us - __MIN_OF_OperatorTotalTime: 1.620us - 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: 328ns - __MAX_OF_PushTotalTime: 8.950us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ChannelNum: 1 - DestFragments: 019adf54fe437ae2-a2491c5be46a01cd - 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: 953.084us - OverallThroughput: 0.000 B/sec - OverallTime: 1.490ms - PassThroughBufferPeakMemoryUsage: 0.000 B - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 317.694us - RpcCount: 3 - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 0 - ShuffleChunkAppendTime: 0ns - ShuffleHashTime: 0ns - WaitTime: 1.362ms AGGREGATE_BLOCKING_SOURCE (plan_node_id=7): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 21.137us - __MAX_OF_OperatorTotalTime: 102.172us - __MIN_OF_OperatorTotalTime: 9.861us - 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: 2.195us - __MAX_OF_PullTotalTime: 72.522us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 29.231us - __MAX_OF_ActiveTime: 574.594us - __MIN_OF_ActiveTime: 6.390us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 9.036ms - __MAX_OF_DriverTotalTime: 9.458ms - __MIN_OF_DriverTotalTime: 8.626ms - PeakDriverQueueSize: 866 - __MAX_OF_PeakDriverQueueSize: 44 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 0ns - InputEmptyTime: 8.628ms - __MAX_OF_InputEmptyTime: 8.652ms - __MIN_OF_InputEmptyTime: 8.556ms - FirstInputEmptyTime: 8.628ms - __MAX_OF_FirstInputEmptyTime: 8.652ms - __MIN_OF_FirstInputEmptyTime: 8.556ms - ScheduleCount: 48 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 9.007ms - __MAX_OF_ScheduleTime: 9.427ms - __MIN_OF_ScheduleTime: 8.612ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_BLOCKING_SINK (plan_node_id=7): CommonMetrics: - OperatorTotalTime: 30.298us - __MAX_OF_OperatorTotalTime: 572.514us - __MIN_OF_OperatorTotalTime: 6.970us - 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.697us - __MAX_OF_PushTotalTime: 52.092us - __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.505us - __MAX_OF_AggComputeTime: 47.591us - __MIN_OF_AggComputeTime: 0ns - AggFuncComputeTime: 146ns - __MAX_OF_AggFuncComputeTime: 3.830us - __MIN_OF_AggFuncComputeTime: 0ns - ChunkBufferPeakMem: 0.000 B - ChunkBufferPeakSize: 0 - ExprComputeTime: 149ns - __MAX_OF_ExprComputeTime: 3.741us - __MIN_OF_ExprComputeTime: 0ns - ExprReleaseTime: 54ns - __MAX_OF_ExprReleaseTime: 1.340us - __MIN_OF_ExprReleaseTime: 0ns - GetResultsTime: 1.750us - __MAX_OF_GetResultsTime: 60.811us - __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: 67ns - __MAX_OF_ResultAggAppendTime: 2.269us - __MIN_OF_ResultAggAppendTime: 0ns - ResultGroupByAppendTime: 38ns - __MAX_OF_ResultGroupByAppendTime: 1.040us - __MIN_OF_ResultGroupByAppendTime: 0ns - ResultIteratorTime: 1.272us - __MAX_OF_ResultIteratorTime: 51.901us - __MIN_OF_ResultIteratorTime: 0ns - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 0ns LOCAL_EXCHANGE_SOURCE (plan_node_id=7): CommonMetrics: - IsSubordinate - OperatorTotalTime: 3.023us - __MAX_OF_OperatorTotalTime: 22.431us - __MIN_OF_OperatorTotalTime: 1.049us - 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: 676ns - __MAX_OF_PullTotalTime: 20.581us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 230.795us - __MAX_OF_ActiveTime: 502.073us - __MIN_OF_ActiveTime: 150.413us - BlockByInputEmpty: 11 - __MAX_OF_BlockByInputEmpty: 2 - __MIN_OF_BlockByInputEmpty: 1 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 8.310ms - __MAX_OF_DriverTotalTime: 8.903ms - __MIN_OF_DriverTotalTime: 8.085ms - PeakDriverQueueSize: 157 - __MAX_OF_PeakDriverQueueSize: 22 - __MIN_OF_PeakDriverQueueSize: 2 - PendingTime: 0ns - PreconditionBlockTime: 7.643ms - __MAX_OF_PreconditionBlockTime: 7.645ms - __MIN_OF_PreconditionBlockTime: 7.641ms - ScheduleCount: 21 - __MAX_OF_ScheduleCount: 3 - __MIN_OF_ScheduleCount: 2 - ScheduleTime: 8.079ms - __MAX_OF_ScheduleTime: 8.401ms - __MIN_OF_ScheduleTime: 7.911ms - TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=7): CommonMetrics: - IsSubordinate - OperatorTotalTime: 17.788us - __MAX_OF_OperatorTotalTime: 160.045us - __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: 4 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 2.988us - __MAX_OF_PushTotalTime: 16.421us - __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.178us - __MAX_OF_OperatorTotalTime: 24.650us - __MIN_OF_OperatorTotalTime: 2.241us - OutputChunkBytes: 183.000 B - __MAX_OF_OutputChunkBytes: 96.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 2 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 4 - __MAX_OF_PullRowNum: 2 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 93ns - __MAX_OF_PullTotalTime: 140ns - __MIN_OF_PullTotalTime: 70ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 4 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 4.175us - __MAX_OF_PushTotalTime: 21.211us - __MIN_OF_PushTotalTime: 210ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - CommonSubExprComputeTime: 32ns - __MAX_OF_CommonSubExprComputeTime: 269ns - __MIN_OF_CommonSubExprComputeTime: 0ns - ExprComputeTime: 3.646us - __MAX_OF_ExprComputeTime: 19.280us - __MIN_OF_ExprComputeTime: 0ns CHUNK_ACCUMULATE (plan_node_id=5): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.426us - __MAX_OF_OperatorTotalTime: 1.961us - __MIN_OF_OperatorTotalTime: 830ns - OutputChunkBytes: 183.000 B - __MAX_OF_OutputChunkBytes: 96.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 2 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 4 - __MAX_OF_PullRowNum: 2 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 114ns - __MAX_OF_PullTotalTime: 180ns - __MIN_OF_PullTotalTime: 70ns - PushChunkNum: 2 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 4 - __MAX_OF_PushRowNum: 2 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 642ns - __MAX_OF_PushTotalTime: 1.040us - __MIN_OF_PushTotalTime: 390ns 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: 650ns - __MAX_OF_JoinRuntimeFilterTime: 900ns - __MIN_OF_JoinRuntimeFilterTime: 400ns - OperatorTotalTime: 336.717us - __MAX_OF_OperatorTotalTime: 477.572us - __MIN_OF_OperatorTotalTime: 286.036us - 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: 162.750us - __MAX_OF_PullTotalTime: 289.938us - __MIN_OF_PullTotalTime: 109.401us - 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: 123.102us - __MAX_OF_IOTaskExecTime: 298.678us - __MIN_OF_IOTaskExecTime: 25.691us - CreateSegmentIter: 20.315us - __MAX_OF_CreateSegmentIter: 42.981us - __MIN_OF_CreateSegmentIter: 9.540us - DictDecode: 1.295us - __MAX_OF_DictDecode: 1.541us - __MIN_OF_DictDecode: 1.050us - DictDecodeCount: 8 - __MAX_OF_DictDecodeCount: 4 - __MIN_OF_DictDecodeCount: 4 - GetDelVec: 0ns - GetDeltaColumnGroup: 1.698us - __MAX_OF_GetDeltaColumnGroup: 10.720us - __MIN_OF_GetDeltaColumnGroup: 0ns - GetRowsets: 4.592us - __MAX_OF_GetRowsets: 5.790us - __MIN_OF_GetRowsets: 3.340us - IOTime: 0ns - LateMaterialize: 15.170us - __MAX_OF_LateMaterialize: 15.961us - __MIN_OF_LateMaterialize: 14.380us - LateMaterializeRows: 4 - __MAX_OF_LateMaterializeRows: 2 - __MIN_OF_LateMaterializeRows: 2 - ReadPKIndex: 0ns - SegmentInit: 27.039us - __MAX_OF_SegmentInit: 137.053us - __MIN_OF_SegmentInit: 0ns - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 738ns - __MAX_OF_BitmapIndexIteratorInit: 4.380us - __MIN_OF_BitmapIndexIteratorInit: 0ns - BloomFilterFilter: 81ns - __MAX_OF_BloomFilterFilter: 430ns - __MIN_OF_BloomFilterFilter: 0ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 11.199us - __MAX_OF_ColumnIteratorInit: 59.381us - __MIN_OF_ColumnIteratorInit: 0ns - GetVectorRowRangesTime: 0ns - GinFilter: 0ns - GinFilterRows: 0 - ProcessVectorDistanceAndIdTime: 0ns - RemainingRowsAfterShortKeyFilter: 14 - __MAX_OF_RemainingRowsAfterShortKeyFilter: 7 - __MIN_OF_RemainingRowsAfterShortKeyFilter: 0 - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 3.538us - __MAX_OF_ShortKeyFilter: 18.771us - __MIN_OF_ShortKeyFilter: 0ns - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 1.170us - __MAX_OF_ZoneMapIndexFilter: 6.990us - __MIN_OF_ZoneMapIndexFilter: 0ns - ZoneMapIndexFilterRows: 0 - SegmentRead: 2.869us - __MAX_OF_SegmentRead: 15.100us - __MIN_OF_SegmentRead: 0ns - BlockFetch: 931ns - __MAX_OF_BlockFetch: 5.141us - __MIN_OF_BlockFetch: 0ns - BlockFetchCount: 2 - __MAX_OF_BlockFetchCount: 1 - __MIN_OF_BlockFetchCount: 0 - BlockSeek: 1.981us - __MAX_OF_BlockSeek: 10.478us - __MIN_OF_BlockSeek: 0ns - BlockSeekCount: 2 - __MAX_OF_BlockSeekCount: 1 - __MIN_OF_BlockSeekCount: 0 - ChunkCopy: 246ns - __MAX_OF_ChunkCopy: 1.420us - __MIN_OF_ChunkCopy: 0ns - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 355ns - __MAX_OF_PredFilter: 2.180us - __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: 37.421us - __MAX_OF_IOTaskWaitTime: 50.541us - __MIN_OF_IOTaskWaitTime: 11.690us - MorselsCount: 10 - __MAX_OF_MorselsCount: 1 - __MIN_OF_MorselsCount: 1 - PeakChunkBufferMemoryUsage: 500.083 KB - PeakChunkBufferSize: 1 - PeakIOTasks: 1 - PeakScanTaskQueueSize: 7 - __MAX_OF_PeakScanTaskQueueSize: 2 - __MIN_OF_PeakScanTaskQueueSize: 0 - PrepareChunkSourceTime: 129.407us - __MAX_OF_PrepareChunkSourceTime: 168.414us - __MIN_OF_PrepareChunkSourceTime: 93.022us - 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: 737ns - __MAX_OF_RuntimeFilterEvalTime: 3.950us - __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: 160.524us - __MAX_OF_ScanTime: 349.219us - __MIN_OF_ScanTime: 37.381us - SubmitTaskCount: 10 - __MAX_OF_SubmitTaskCount: 1 - __MIN_OF_SubmitTaskCount: 1 - SubmitTaskTime: 13.933us - __MAX_OF_SubmitTaskTime: 30.671us - __MIN_OF_SubmitTaskTime: 3.970us - TabletCount: 10 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 86.247us - __MAX_OF_ActiveTime: 324.338us - __MIN_OF_ActiveTime: 39.291us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 10 - DriverTotalTime: 7.897ms - __MAX_OF_DriverTotalTime: 8.015ms - __MIN_OF_DriverTotalTime: 7.729ms - PeakDriverQueueSize: 75 - __MAX_OF_PeakDriverQueueSize: 12 - __MIN_OF_PeakDriverQueueSize: 3 - PendingTime: 0ns - PreconditionBlockTime: 7.633ms - __MAX_OF_PreconditionBlockTime: 7.636ms - __MIN_OF_PreconditionBlockTime: 7.630ms - ScheduleCount: 10 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 7.810ms - __MAX_OF_ScheduleTime: 7.873ms - __MIN_OF_ScheduleTime: 7.688ms - TotalDegreeOfParallelism: 10 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=5): CommonMetrics: - IsSubordinate - OperatorTotalTime: 477ns - __MAX_OF_OperatorTotalTime: 770ns - __MIN_OF_OperatorTotalTime: 340ns - 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: 88.789us - __MAX_OF_OperatorTotalTime: 328.648us - __MIN_OF_OperatorTotalTime: 43.452us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 81.265us - __MAX_OF_PullTotalTime: 319.478us - __MIN_OF_PullTotalTime: 35.561us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 3.946us - __MAX_OF_CaptureTabletRowsetsTime: 9.261us - __MIN_OF_CaptureTabletRowsetsTime: 2.920us Fragment 4: - BackendAddresses: 10.166.13.35:9060 - InstanceIds: 019adf54-fe43-7ae2-a249-1c5be46a01d0 - EnableEventScheduler: true - BackendNum: 1 - BackendProfileMergeTime: 10.318ms - FragmentInstancePrepareTime: 16.363ms - prepare-pipeline-driver: 12.137ms - InitialProcessDriverCount: 312 - InitialProcessMem: 43.922 GB - InstanceAllocatedMemoryUsage: 13.729 GB - InstanceDeallocatedMemoryUsage: 12.131 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 1.805 GB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 149.319ms - __MAX_OF_ActiveTime: 179.554ms - __MIN_OF_ActiveTime: 87.703ms - BlockByInputEmpty: 15 - __MAX_OF_BlockByInputEmpty: 2 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 6 - __MAX_OF_BlockByOutputFull: 1 - __MIN_OF_BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 324.870ms - __MAX_OF_DriverTotalTime: 325.213ms - __MIN_OF_DriverTotalTime: 324.572ms - PeakDriverQueueSize: 2.461K (2461) - __MAX_OF_PeakDriverQueueSize: 93 - __MIN_OF_PeakDriverQueueSize: 4 - PendingTime: 0ns - InputEmptyTime: 54.479ms - __MAX_OF_InputEmptyTime: 70.704ms - __MIN_OF_InputEmptyTime: 36.786ms - FirstInputEmptyTime: 51.903ms - __MAX_OF_FirstInputEmptyTime: 70.704ms - __MIN_OF_FirstInputEmptyTime: 19.707ms - FollowupInputEmptyTime: 2.576ms - __MAX_OF_FollowupInputEmptyTime: 29.204ms - __MIN_OF_FollowupInputEmptyTime: 0ns - OutputFullTime: 10.466ms - __MAX_OF_OutputFullTime: 85.186ms - __MIN_OF_OutputFullTime: 0ns - PendingFinishTime: 98.864ms - __MAX_OF_PendingFinishTime: 167.931ms - __MIN_OF_PendingFinishTime: 984.455us - ScheduleCount: 100 - __MAX_OF_ScheduleCount: 4 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 175.551ms - __MAX_OF_ScheduleTime: 237.357ms - __MIN_OF_ScheduleTime: 145.448ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 31 - __MAX_OF_YieldByTimeLimit: 1 - __MIN_OF_YieldByTimeLimit: 0 EXCHANGE_SINK (plan_node_id=2): CommonMetrics: - OperatorTotalTime: 145.467ms - __MAX_OF_OperatorTotalTime: 176.942ms - __MIN_OF_OperatorTotalTime: 86.046ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.780K (1780) - __MAX_OF_PushChunkNum: 40 - __MIN_OF_PushChunkNum: 32 - PushRowNum: 4.010M (4009539) - __MAX_OF_PushRowNum: 102.164K (102164) - __MIN_OF_PushRowNum: 65.789K (65789) - PushTotalTime: 110.206ms - __MAX_OF_PushTotalTime: 141.999ms - __MIN_OF_PushTotalTime: 70.838ms - SetFinishingTime: 35.259ms - __MAX_OF_SetFinishingTime: 45.541ms - __MIN_OF_SetFinishingTime: 10.589ms UniqueMetrics: - ChannelNum: 1 - DestFragments: 019adf54fe437ae2-a2491c5be46a01cd - DestID: 2 - PartType: HASH_PARTITIONED - PipelineLevelShuffle: Yes - ShuffleNumPerChannel: 48 - TotalShuffleNum: 48 - BytesPassThrough: 963.185 MB - __MAX_OF_BytesPassThrough: 24.480 MB - __MIN_OF_BytesPassThrough: 15.719 MB - BytesSent: 0.000 B - BytesUnsent: 0.000 B - CompressTime: 0ns - CompressedBytes: 0.000 B - NetworkBandwidth: 0.000 B/sec - NetworkTime: 88.233ms - OverallThroughput: 0.000 B/sec - OverallTime: 182.438ms - PassThroughBufferPeakMemoryUsage: 270.909 MB - RawInputBytes: 0.000 B - RequestSent: 0 - RequestUnsent: 0 - RpcAvgTime: 1.013ms - RpcCount: 2.305K (2305) - SerializeChunkTime: 0ns - SerializedBytes: 0.000 B - ShuffleChunkAppendCounter: 82.343K (82343) - __MAX_OF_ShuffleChunkAppendCounter: 1.872K (1872) - __MIN_OF_ShuffleChunkAppendCounter: 1.437K (1437) - ShuffleChunkAppendTime: 88.597ms - __MAX_OF_ShuffleChunkAppendTime: 117.896ms - __MIN_OF_ShuffleChunkAppendTime: 54.913ms - ShuffleHashTime: 18.877ms - __MAX_OF_ShuffleHashTime: 22.236ms - __MIN_OF_ShuffleHashTime: 14.218ms - WaitTime: 86.092ms AGGREGATE_STREAMING_SOURCE (plan_node_id=1): CommonMetrics: - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 2.973ms - __MAX_OF_OperatorTotalTime: 11.014ms - __MIN_OF_OperatorTotalTime: 618.993us - OutputChunkBytes: 962.587 MB - __MAX_OF_OutputChunkBytes: 24.468 MB - __MIN_OF_OutputChunkBytes: 15.707 MB - PullChunkNum: 1.780K (1780) - __MAX_OF_PullChunkNum: 40 - __MIN_OF_PullChunkNum: 32 - PullRowNum: 4.010M (4009539) - __MAX_OF_PullRowNum: 102.164K (102164) - __MIN_OF_PullRowNum: 65.789K (65789) - PullTotalTime: 2.919ms - __MAX_OF_PullTotalTime: 10.980ms - __MIN_OF_PullTotalTime: 553.912us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 15.747ms - __MAX_OF_ActiveTime: 32.742ms - __MIN_OF_ActiveTime: 8.302ms - BlockByInputEmpty: 816 - __MAX_OF_BlockByInputEmpty: 18 - __MIN_OF_BlockByInputEmpty: 15 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 118.543ms - __MAX_OF_DriverTotalTime: 119.116ms - __MIN_OF_DriverTotalTime: 118.099ms - PeakDriverQueueSize: 3.071K (3071) - __MAX_OF_PeakDriverQueueSize: 95 - __MIN_OF_PeakDriverQueueSize: 39 - PendingTime: 0ns - InputEmptyTime: 61.801ms - __MAX_OF_InputEmptyTime: 75.366ms - __MIN_OF_InputEmptyTime: 54.775ms - FirstInputEmptyTime: 7.464ms - __MAX_OF_FirstInputEmptyTime: 11.211ms - __MIN_OF_FirstInputEmptyTime: 3.281ms - FollowupInputEmptyTime: 54.336ms - __MAX_OF_FollowupInputEmptyTime: 68.733ms - __MIN_OF_FollowupInputEmptyTime: 47.976ms - ScheduleCount: 864 - __MAX_OF_ScheduleCount: 19 - __MIN_OF_ScheduleCount: 16 - ScheduleTime: 102.796ms - __MAX_OF_ScheduleTime: 110.325ms - __MIN_OF_ScheduleTime: 85.713ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 AGGREGATE_STREAMING_SINK (plan_node_id=1): CommonMetrics: - OperatorTotalTime: 14.898ms - __MAX_OF_OperatorTotalTime: 31.909ms - __MIN_OF_OperatorTotalTime: 7.448ms - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.953K (1953) - __MAX_OF_PushChunkNum: 41 - __MIN_OF_PushChunkNum: 40 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 102.818K (102818) - __MIN_OF_PushRowNum: 65.886K (65886) - PushTotalTime: 14.883ms - __MAX_OF_PushTotalTime: 31.895ms - __MIN_OF_PushTotalTime: 7.435ms - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - AggregateFunctions: sum(19: sn_cnt), sum(39: lag_sn_cnt), sum(29: launch_cnt), sum(30: cold_launch_cnt), sum(31: warm_launch_cnt), sum(32: hot_launch_cnt) - GroupingKeys: 2: rom_vr, 3: os_vr, 1: device, 5: brand, 7: cpu, 8: ram, 9: rom, 6: iso, 10: region, 11: country, 12: family, 13: sub_family, 14: market_name, 4: s_dt - AggComputeTime: 7.223ms - __MAX_OF_AggComputeTime: 22.821ms - __MIN_OF_AggComputeTime: 1.339ms - AggFuncComputeTime: 197.496us - __MAX_OF_AggFuncComputeTime: 735.436us - __MIN_OF_AggFuncComputeTime: 28.831us - ChunkBufferPeakMem: 17.493 MB - __MAX_OF_ChunkBufferPeakMem: 24.369 MB - __MIN_OF_ChunkBufferPeakMem: 10.566 MB - ChunkBufferPeakSize: 23 - __MAX_OF_ChunkBufferPeakSize: 29 - __MIN_OF_ChunkBufferPeakSize: 13 - ExprComputeTime: 465.218us - __MAX_OF_ExprComputeTime: 779.753us - __MIN_OF_ExprComputeTime: 401.866us - ExprReleaseTime: 2.589ms - __MAX_OF_ExprReleaseTime: 16.084ms - __MIN_OF_ExprReleaseTime: 925.016us - GetResultsTime: 2.707ms - __MAX_OF_GetResultsTime: 9.755ms - __MIN_OF_GetResultsTime: 420.491us - HashTableMemoryUsage: 72.035 MB - __MAX_OF_HashTableMemoryUsage: 5.270 MB - __MIN_OF_HashTableMemoryUsage: 413.008 KB - HashTableSize: 160.095K (160095) - __MAX_OF_HashTableSize: 13.739K (13739) - __MIN_OF_HashTableSize: 666 - InputRowCount: 4.022M (4021783) - __MAX_OF_InputRowCount: 102.818K (102818) - __MIN_OF_InputRowCount: 65.886K (65886) - PassThroughRowCount: 3.849M (3849444) - __MAX_OF_PassThroughRowCount: 99.892K (99892) - __MIN_OF_PassThroughRowCount: 60.969K (60969) - ResultAggAppendTime: 347.122us - __MAX_OF_ResultAggAppendTime: 1.346ms - __MIN_OF_ResultAggAppendTime: 32.081us - ResultGroupByAppendTime: 2.046ms - __MAX_OF_ResultGroupByAppendTime: 7.426ms - __MIN_OF_ResultGroupByAppendTime: 311.858us - ResultIteratorTime: 174.004us - __MAX_OF_ResultIteratorTime: 501.902us - __MIN_OF_ResultIteratorTime: 16.110us - RowsReturned: 0 - StateAllocate: 0ns - StateDestroy: 0ns - StreamingTime: 4.640ms - __MAX_OF_StreamingTime: 5.881ms - __MIN_OF_StreamingTime: 2.939ms LOCAL_EXCHANGE_SOURCE (plan_node_id=1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 413.904us - __MAX_OF_OperatorTotalTime: 489.600us - __MIN_OF_OperatorTotalTime: 317.463us - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 24.625 MB - __MIN_OF_OutputChunkBytes: 15.730 MB - PullChunkNum: 1.953K (1953) - __MAX_OF_PullChunkNum: 41 - __MIN_OF_PullChunkNum: 40 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 102.818K (102818) - __MIN_OF_PullRowNum: 65.886K (65886) - PullTotalTime: 410.377us - __MAX_OF_PullTotalTime: 487.069us - __MIN_OF_PullTotalTime: 315.172us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 32.960ms - __MAX_OF_ActiveTime: 58.101ms - __MIN_OF_ActiveTime: 10.601ms - BlockByInputEmpty: 533 - __MAX_OF_BlockByInputEmpty: 18 - __MIN_OF_BlockByInputEmpty: 4 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 48 - DriverTotalTime: 117.526ms - __MAX_OF_DriverTotalTime: 119.182ms - __MIN_OF_DriverTotalTime: 117.018ms - OverheadTime: 4.008ms - __MAX_OF_OverheadTime: 15.110ms - __MIN_OF_OverheadTime: 1.114ms - PeakDriverQueueSize: 2.858K (2858) - __MAX_OF_PeakDriverQueueSize: 94 - __MIN_OF_PeakDriverQueueSize: 25 - PendingTime: 0ns - InputEmptyTime: 59.459ms - __MAX_OF_InputEmptyTime: 85.998ms - __MIN_OF_InputEmptyTime: 34.653ms - FollowupInputEmptyTime: 58.963ms - __MAX_OF_FollowupInputEmptyTime: 85.522ms - __MIN_OF_FollowupInputEmptyTime: 34.235ms - ScheduleCount: 581 - __MAX_OF_ScheduleCount: 19 - __MIN_OF_ScheduleCount: 5 - ScheduleTime: 84.566ms - __MAX_OF_ScheduleTime: 106.496ms - __MIN_OF_ScheduleTime: 59.032ms - TotalDegreeOfParallelism: 48 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=1): CommonMetrics: - IsSubordinate - OperatorTotalTime: 650.146us - __MAX_OF_OperatorTotalTime: 4.618ms - __MIN_OF_OperatorTotalTime: 120.914us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1.953K (1953) - __MAX_OF_PushChunkNum: 74 - __MIN_OF_PushChunkNum: 11 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 144.613K (144613) - __MIN_OF_PushRowNum: 16.644K (16644) - PushTotalTime: 624.438us - __MAX_OF_PushTotalTime: 4.617ms - __MIN_OF_PushTotalTime: 120.245us UniqueMetrics: - ShuffleNum: 48 - Type: Passthrough - LocalExchangePeakMemoryUsage: 98.129 MB CHUNK_ACCUMULATE (plan_node_id=0): CommonMetrics: - IsSubordinate - OperatorTotalTime: 3.148ms - __MAX_OF_OperatorTotalTime: 10.140ms - __MIN_OF_OperatorTotalTime: 794.611us - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 34.639 MB - __MIN_OF_OutputChunkBytes: 4.013 MB - PullChunkNum: 1.953K (1953) - __MAX_OF_PullChunkNum: 74 - __MIN_OF_PullChunkNum: 11 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 144.613K (144613) - __MIN_OF_PullRowNum: 16.644K (16644) - PullTotalTime: 6.033us - __MAX_OF_PullTotalTime: 14.304us - __MIN_OF_PullTotalTime: 2.540us - PushChunkNum: 2.310K (2310) - __MAX_OF_PushChunkNum: 83 - __MIN_OF_PushChunkNum: 15 - PushRowNum: 4.022M (4021783) - __MAX_OF_PushRowNum: 144.613K (144613) - __MIN_OF_PushRowNum: 16.644K (16644) - PushTotalTime: 3.141ms - __MAX_OF_PushTotalTime: 10.134ms - __MIN_OF_PushTotalTime: 791.080us UniqueMetrics: OLAP_SCAN (plan_node_id=0): CommonMetrics: - RuntimeFilterDesc: <1: BloomFilter> - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 4.022M (4021783) - __MAX_OF_JoinRuntimeFilterInputRows: 144.613K (144613) - __MIN_OF_JoinRuntimeFilterInputRows: 16.644K (16644) - JoinRuntimeFilterOutputRows: 4.022M (4021783) - __MAX_OF_JoinRuntimeFilterOutputRows: 144.613K (144613) - __MIN_OF_JoinRuntimeFilterOutputRows: 16.644K (16644) - JoinRuntimeFilterTime: 12.333us - __MAX_OF_JoinRuntimeFilterTime: 26.600us - __MIN_OF_JoinRuntimeFilterTime: 5.698us - OperatorTotalTime: 25.153ms - __MAX_OF_OperatorTotalTime: 47.643ms - __MIN_OF_OperatorTotalTime: 6.814ms - OutputChunkBytes: 965.491 MB - __MAX_OF_OutputChunkBytes: 34.639 MB - __MIN_OF_OutputChunkBytes: 4.013 MB - PullChunkNum: 2.310K (2310) - __MAX_OF_PullChunkNum: 83 - __MIN_OF_PullChunkNum: 15 - PullRowNum: 4.022M (4021783) - __MAX_OF_PullRowNum: 144.613K (144613) - __MIN_OF_PullRowNum: 16.644K (16644) - PullTotalTime: 24.399ms - __MAX_OF_PullTotalTime: 46.968ms - __MIN_OF_PullTotalTime: 6.131ms - 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: 15.578 MB - __MIN_OF_BytesRead: 139.963 KB - CachedPagesNum: 36.905K (36905) - __MAX_OF_CachedPagesNum: 348 - __MIN_OF_CachedPagesNum: 51 - ChunkBufferCapacity: 3.072K (3072) - CompressedBytesRead: 0.000 B - DefaultChunkBufferCapacity: 3.072K (3072) - IOTaskExecTime: 35.825ms - __MAX_OF_IOTaskExecTime: 71.054ms - __MIN_OF_IOTaskExecTime: 4.253ms - CreateSegmentIter: 490.693us - __MAX_OF_CreateSegmentIter: 10.570ms - __MIN_OF_CreateSegmentIter: 132.453us - DictDecode: 6.161ms - __MAX_OF_DictDecode: 25.947ms - __MIN_OF_DictDecode: 14.791us - DictDecodeCount: 41.856M (41855685) - __MAX_OF_DictDecodeCount: 657.463K (657463) - __MIN_OF_DictDecodeCount: 106 - ExprFilterRows: 0 - ExprFilterTime: 10.526ms - __MAX_OF_ExprFilterTime: 30.765ms - __MIN_OF_ExprFilterTime: 360.399us - GetDelVec: 0ns - GetDeltaColumnGroup: 148.595us - __MAX_OF_GetDeltaColumnGroup: 9.721ms - __MIN_OF_GetDeltaColumnGroup: 3.370us - GetRowsets: 26.070us - __MAX_OF_GetRowsets: 668.237us - __MIN_OF_GetRowsets: 7.662us - IOTime: 0ns - LateMaterialize: 3.237ms - __MAX_OF_LateMaterialize: 22.445ms - __MIN_OF_LateMaterialize: 206.444us - LateMaterializeRows: 947.954K (947954) - __MAX_OF_LateMaterializeRows: 12.625K (12625) - __MIN_OF_LateMaterializeRows: 45 - ReadPKIndex: 0ns - SegmentInit: 2.011ms - __MAX_OF_SegmentInit: 7.226ms - __MIN_OF_SegmentInit: 784.810us - BitmapIndexFilter: 0ns - BitmapIndexFilterRows: 0 - BitmapIndexIteratorInit: 42.480us - __MAX_OF_BitmapIndexIteratorInit: 82.812us - __MIN_OF_BitmapIndexIteratorInit: 17.300us - BloomFilterFilter: 2.043us - __MAX_OF_BloomFilterFilter: 10.411us - __MIN_OF_BloomFilterFilter: 820ns - BloomFilterFilterRows: 0 - ColumnIteratorInit: 801.550us - __MAX_OF_ColumnIteratorInit: 6.073ms - __MIN_OF_ColumnIteratorInit: 252.256us - GetVectorRowRangesTime: 0ns - GinFilter: 0ns - GinFilterRows: 0 - ProcessVectorDistanceAndIdTime: 0ns - RemainingRowsAfterShortKeyFilter: 16.223M (16222711) - __MAX_OF_RemainingRowsAfterShortKeyFilter: 197.678K (197678) - __MIN_OF_RemainingRowsAfterShortKeyFilter: 15.053K (15053) - SegmentRuntimeZoneMapFilterRows: 0 - SegmentZoneMapFilterRows: 0 - ShortKeyFilter: 119.562us - __MAX_OF_ShortKeyFilter: 723.858us - __MIN_OF_ShortKeyFilter: 41.280us - ShortKeyFilterRows: 0 - ShortKeyRangeNumber: 0 - VectorIndexFilterRows: 0 - VectorSearchTime: 0ns - ZoneMapIndexFilter: 49.071us - __MAX_OF_ZoneMapIndexFilter: 104.801us - __MIN_OF_ZoneMapIndexFilter: 19.870us - ZoneMapIndexFilterRows: 147.456K (147456) - __MAX_OF_ZoneMapIndexFilterRows: 32.768K (32768) - __MIN_OF_ZoneMapIndexFilterRows: 0 - SegmentRead: 7.129ms - __MAX_OF_SegmentRead: 23.372ms - __MIN_OF_SegmentRead: 563.834us - BlockFetch: 5.342ms - __MAX_OF_BlockFetch: 20.507ms - __MIN_OF_BlockFetch: 172.895us - BlockFetchCount: 4.058K (4058) - __MAX_OF_BlockFetchCount: 57 - __MIN_OF_BlockFetchCount: 3 - BlockSeek: 157.415us - __MAX_OF_BlockSeek: 2.232ms - __MIN_OF_BlockSeek: 30.150us - BlockSeekCount: 9.790K (9790) - __MAX_OF_BlockSeekCount: 153 - __MIN_OF_BlockSeekCount: 1 - ChunkCopy: 80.773us - __MAX_OF_ChunkCopy: 284.086us - __MIN_OF_ChunkCopy: 890ns - DecompressT: 0ns - DelVecFilterRows: 0 - PredFilter: 1.448ms - __MAX_OF_PredFilter: 3.607ms - __MIN_OF_PredFilter: 218.405us - PredFilterRows: 10.293M (10292677) - __MAX_OF_PredFilterRows: 127.490K (127490) - __MIN_OF_PredFilterRows: 10.356K (10356) - RowsetsReadCount: 1.408K (1408) - __MAX_OF_RowsetsReadCount: 12 - __MIN_OF_RowsetsReadCount: 4 - SegmentsReadCount: 704 - __MAX_OF_SegmentsReadCount: 6 - __MIN_OF_SegmentsReadCount: 2 - TotalColumnsDataPageCount: 33.068K (33068) - __MAX_OF_TotalColumnsDataPageCount: 372 - __MIN_OF_TotalColumnsDataPageCount: 46 - IOTaskWaitTime: 21.274ms - __MAX_OF_IOTaskWaitTime: 75.373ms - __MIN_OF_IOTaskWaitTime: 1.178ms - MorselsCount: 704 - __MAX_OF_MorselsCount: 20 - __MIN_OF_MorselsCount: 9 - NonPushdownPredicates: 1 - PeakChunkBufferMemoryUsage: 896.710 MB - PeakChunkBufferSize: 37 - PeakIOTasks: 4 - PeakScanTaskQueueSize: 4.138K (4138) - __MAX_OF_PeakScanTaskQueueSize: 95 - __MIN_OF_PeakScanTaskQueueSize: 70 - PrepareChunkSourceTime: 5.670ms - __MAX_OF_PrepareChunkSourceTime: 15.400ms - __MIN_OF_PrepareChunkSourceTime: 2.597ms - PushdownAccessPaths: 0 - PushdownPredicates: 7 - RawRowsRead: 14.314M (14314460) - __MAX_OF_RawRowsRead: 145.960K (145960) - __MIN_OF_RawRowsRead: 11.413K (11413) - ReadPagesNum: 36.905K (36905) - __MAX_OF_ReadPagesNum: 348 - __MIN_OF_ReadPagesNum: 51 - RowsRead: 4.022M (4021783) - __MAX_OF_RowsRead: 56.619K (56619) - __MIN_OF_RowsRead: 53 - RuntimeFilterEvalTime: 59.779us - __MAX_OF_RuntimeFilterEvalTime: 144.543us - __MIN_OF_RuntimeFilterEvalTime: 12.231us - RuntimeFilterInputRows: 13.237M (13236609) - __MAX_OF_RuntimeFilterInputRows: 124.000K (124000) - __MIN_OF_RuntimeFilterInputRows: 11.413K (11413) - RuntimeFilterOutputRows: 12.593M (12592727) - __MAX_OF_RuntimeFilterOutputRows: 124.000K (124000) - __MIN_OF_RuntimeFilterOutputRows: 11.408K (11408) - ScanTime: 57.100ms - __MAX_OF_ScanTime: 101.429ms - __MIN_OF_ScanTime: 24.481ms - SubmitTaskCount: 704 - __MAX_OF_SubmitTaskCount: 20 - __MIN_OF_SubmitTaskCount: 9 - SubmitTaskTime: 16.792ms - __MAX_OF_SubmitTaskTime: 35.285ms - __MIN_OF_SubmitTaskTime: 970.024us - TabletCount: 704 - UncompressedBytesRead: 0.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 838.091us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverPrepareTime: 1.536ms - DriverTotalTime: 868.302us - PeakDriverQueueSize: 0 - ScheduleCount: 1 - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=0): CommonMetrics: - IsSubordinate - OperatorTotalTime: 461ns - 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: 839.891us - OutputChunkBytes: 0.000 B - PrepareTime: 1.514ms - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 831.611us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 1 - RuntimeInFilterNum: 0 UniqueMetrics: - CaptureTabletRowsetsTime: 1.507ms