Created
October 30, 2023 08:58
-
-
Save liuyehcf/a4ec577d188622cf16d324d0491e6e69 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Query: | |
| Summary: | |
| - Query ID: b90f2e6b-76fc-11ee-a1ce-00163e25836c | |
| - Start Time: 2023-10-30 16:17:10 | |
| - End Time: 2023-10-30 16:18:25 | |
| - Total: 1m14s | |
| - Query Type: Query | |
| - Query State: Finished | |
| - StarRocks Version: profile-d5ccd35 | |
| - User: root | |
| - Default Db: window | |
| - Sql Statement: SELECT SUM(wv) FROM ( | |
| SELECT max(fn_int) OVER (ORDER BY fn_int ROWS BETWEEN UNBOUNDED PRECEDING AND 2 PRECEDING) AS wv FROM t_small | |
| ) AS sub | |
| - 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 | |
| - NonDefaultSessionVariables: {"sql_mode_v2":{"defaultValue":32,"actualValue":34},"enable_big_query_profile":{"defaultValue":false,"actualValue":true},"enable_show_all_variables":{"defaultValue":false,"actualValue":true},"prefer_compute_node":{"defaultValue":false,"actualValue":true},"enable_adaptive_sink_dop":{"defaultValue":false,"actualValue":true}} | |
| - Collect Profile Time: 5ms | |
| - IsProfileAsync: true | |
| Planner: | |
| - -- Total[1] 3ms | |
| - -- Analyzer[1] 0 | |
| - -- Transformer[1] 0 | |
| - -- Optimizer[1] 1ms | |
| - -- preprocessMvs[1] 0 | |
| - -- RuleBaseOptimize[1] 0 | |
| - -- CostBaseOptimize[1] 0 | |
| - -- PhysicalRewrite[1] 0 | |
| - -- PlanValidate[1] 0 | |
| - -- InputDependenciesChecker[1] 0 | |
| - -- TypeChecker[1] 0 | |
| - -- CTEUniqueChecker[1] 0 | |
| - -- ColumnReuseChecker[1] 0 | |
| - -- ExecPlanBuild[1] 0 | |
| - -- Pending[1] 0 | |
| - -- Prepare[1] 0 | |
| - -- Deploy[1] 8ms | |
| - -- DeployLockInternalTime[1] 8ms | |
| - -- DeploySerializeConcurrencyTime[2] 0 | |
| - -- DeployStageByStageTime[6] 0 | |
| - -- DeployWaitTime[6] 7ms | |
| - -- DeployAsyncSendTime[4] 0 | |
| - DeployDataSize: 35522 | |
| Execution: | |
| - Topology: {"rootId":5,"nodes":[{"id":5,"name":"AGGREGATION","properties":{"sinkIds":[],"displayMem":true},"children":[4]},{"id":4,"name":"PROJECT","properties":{"displayMem":false},"children":[3]},{"id":3,"name":"ANALYTIC_EVAL","properties":{"displayMem":true},"children":[2]},{"id":2,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[1]},{"id":1,"name":"SORT","properties":{"sinkIds":[2],"displayMem":true},"children":[0]},{"id":0,"name":"OLAP_SCAN","properties":{"displayMem":true},"children":[]}]} | |
| - FrontendProfileMergeTime: 1.761ms | |
| - QueryAllocatedMemoryUsage: 72.829 MB | |
| - QueryCumulativeCpuTime: 1m14s | |
| - QueryCumulativeNetworkTime: 0ns | |
| - QueryCumulativeOperatorTime: 1m14s | |
| - QueryCumulativeScanTime: 0ns | |
| - QueryDeallocatedMemoryUsage: 61.014 MB | |
| - QueryExecutionWallTime: 1m14s | |
| - QueryPeakMemoryUsage: 16.165 MB | |
| - QueryPeakScheduleTime: 26.920ms | |
| - QuerySpillBytes: 0.000 B | |
| - ResultDeliverTime: 0ns | |
| Fragment 0: | |
| - BackendAddresses: 172.26.80.84:9060 | |
| - InstanceIds: b90f2e6b-76fc-11ee-a1ce-00163e25836d | |
| - BackendNum: 1 | |
| - BackendProfileMergeTime: 1.828ms | |
| - FragmentInstancePrepareTime: 1.075ms | |
| - prepare-fragment-ctx: 5.507us | |
| - prepare-pipeline-driver: 780.850us | |
| - prepare-pipeline-driver-factory: 201.072us | |
| - prepare-query-ctx: 5.312us | |
| - prepare-runtime-state: 80.779us | |
| - InitialProcessDriverCount: 0 | |
| - InitialProcessMem: 119.773 MB | |
| - InstanceAllocatedMemoryUsage: 72.829 MB | |
| - InstanceDeallocatedMemoryUsage: 61.014 MB | |
| - InstanceNum: 1 | |
| - InstancePeakMemoryUsage: 15.829 MB | |
| - QueryMemoryLimit: 32.000 GB | |
| Pipeline (id=0): | |
| - ActiveTime: 9.683ms | |
| - __MAX_OF_ActiveTime: 10.802ms | |
| - __MIN_OF_ActiveTime: 7.929ms | |
| - BlockByInputEmpty: 0 | |
| - BlockByOutputFull: 0 | |
| - BlockByPrecondition: 0 | |
| - DegreeOfParallelism: 8 | |
| - DriverPrepareTime: 65.473us | |
| - __MAX_OF_DriverPrepareTime: 149.274us | |
| - __MIN_OF_DriverPrepareTime: 49.350us | |
| - DriverTotalTime: 44.252ms | |
| - __MAX_OF_DriverTotalTime: 44.272ms | |
| - __MIN_OF_DriverTotalTime: 44.241ms | |
| - OverheadTime: 193.932us | |
| - __MAX_OF_OverheadTime: 321.642us | |
| - __MIN_OF_OverheadTime: 155.344us | |
| - PeakDriverQueueSize: 26 | |
| - __MAX_OF_PeakDriverQueueSize: 6 | |
| - __MIN_OF_PeakDriverQueueSize: 0 | |
| - PendingTime: 24.529ms | |
| - __MAX_OF_PendingTime: 25.232ms | |
| - __MIN_OF_PendingTime: 22.430ms | |
| - InputEmptyTime: 24.531ms | |
| - __MAX_OF_InputEmptyTime: 25.233ms | |
| - __MIN_OF_InputEmptyTime: 22.431ms | |
| - FirstInputEmptyTime: 2.405ms | |
| - __MAX_OF_FirstInputEmptyTime: 18.687ms | |
| - __MIN_OF_FirstInputEmptyTime: 40.531us | |
| - FollowupInputEmptyTime: 22.126ms | |
| - __MAX_OF_FollowupInputEmptyTime: 25.144ms | |
| - __MIN_OF_FollowupInputEmptyTime: 6.335ms | |
| - OutputFullTime: 0ns | |
| - PendingFinishTime: 0ns | |
| - PreconditionBlockTime: 0ns | |
| - ScheduleCount: 318 | |
| - __MAX_OF_ScheduleCount: 45 | |
| - __MIN_OF_ScheduleCount: 36 | |
| - ScheduleTime: 10.039ms | |
| - __MAX_OF_ScheduleTime: 11.296ms | |
| - __MIN_OF_ScheduleTime: 8.820ms | |
| - TotalDegreeOfParallelism: 8 | |
| - YieldByLocalWait: 307 | |
| - __MAX_OF_YieldByLocalWait: 44 | |
| - __MIN_OF_YieldByLocalWait: 34 | |
| - YieldByPreempt: 0 | |
| - YieldByTimeLimit: 0 | |
| LOCAL_EXCHANGE_SINK (plan_node_id=2): | |
| CommonMetrics: | |
| - IsSubordinate | |
| - CloseTime: 196ns | |
| - __MAX_OF_CloseTime: 339ns | |
| - __MIN_OF_CloseTime: 108ns | |
| - OperatorAllocatedMemoryUsage: 4.000 KB | |
| - __MAX_OF_OperatorAllocatedMemoryUsage: 4.000 KB | |
| - __MIN_OF_OperatorAllocatedMemoryUsage: 0.000 B | |
| - OperatorDeallocatedMemoryUsage: 0.000 B | |
| - OperatorPeakMemoryUsage: 512.000 B | |
| - __MAX_OF_OperatorPeakMemoryUsage: 4.000 KB | |
| - __MIN_OF_OperatorPeakMemoryUsage: 0.000 B | |
| - OperatorTotalTime: 11.338us | |
| - __MAX_OF_OperatorTotalTime: 87.879us | |
| - __MIN_OF_OperatorTotalTime: 297ns | |
| - PrepareTime: 9.156us | |
| - __MAX_OF_PrepareTime: 12.485us | |
| - __MIN_OF_PrepareTime: 7.378us | |
| - PullChunkNum: 0 | |
| - PullRowNum: 0 | |
| - PullTotalTime: 0ns | |
| - PushChunkNum: 256 | |
| - __MAX_OF_PushChunkNum: 256 | |
| - __MIN_OF_PushChunkNum: 0 | |
| - PushRowNum: 1.000M (1000000) | |
| - __MAX_OF_PushRowNum: 1.000M (1000000) | |
| - __MIN_OF_PushRowNum: 0 | |
| - PushTotalTime: 10.937us | |
| - __MAX_OF_PushTotalTime: 87.500us | |
| - __MIN_OF_PushTotalTime: 0ns | |
| - SetFinishedTime: 29ns | |
| - __MAX_OF_SetFinishedTime: 39ns | |
| - __MIN_OF_SetFinishedTime: 28ns | |
| - SetFinishingTime: 174ns | |
| - __MAX_OF_SetFinishingTime: 233ns | |
| - __MIN_OF_SetFinishingTime: 99ns | |
| UniqueMetrics: | |
| - ShuffleNum: 1 | |
| - Type: Passthrough | |
| - LocalExchangePeakMemoryUsage: 864.000 KB | |
| GLOBAL_PARALLEL_MERGE_SOURCE (plan_node_id=2): | |
| CommonMetrics: | |
| - CloseTime: 311ns | |
| - __MAX_OF_CloseTime: 403ns | |
| - __MIN_OF_CloseTime: 152ns | |
| - OperatorAllocatedMemoryUsage: 29.662 MB | |
| - __MAX_OF_OperatorAllocatedMemoryUsage: 3.964 MB | |
| - __MIN_OF_OperatorAllocatedMemoryUsage: 3.408 MB | |
| - OperatorDeallocatedMemoryUsage: 29.601 MB | |
| - __MAX_OF_OperatorDeallocatedMemoryUsage: 6.185 MB | |
| - __MIN_OF_OperatorDeallocatedMemoryUsage: 2.459 MB | |
| - OperatorPeakMemoryUsage: 678.222 KB | |
| - __MAX_OF_OperatorPeakMemoryUsage: 1.142 MB | |
| - __MIN_OF_OperatorPeakMemoryUsage: 17.656 KB | |
| - OperatorTotalTime: 9.477ms | |
| - __MAX_OF_OperatorTotalTime: 10.616ms | |
| - __MIN_OF_OperatorTotalTime: 7.519ms | |
| - PrepareTime: 41.644us | |
| - __MAX_OF_PrepareTime: 115.323us | |
| - __MIN_OF_PrepareTime: 28.006us | |
| - PullChunkNum: 256 | |
| - __MAX_OF_PullChunkNum: 256 | |
| - __MIN_OF_PullChunkNum: 0 | |
| - PullRowNum: 1.000M (1000000) | |
| - __MAX_OF_PullRowNum: 1.000M (1000000) | |
| - __MIN_OF_PullRowNum: 0 | |
| - PullTotalTime: 9.476ms | |
| - __MAX_OF_PullTotalTime: 10.615ms | |
| - __MIN_OF_PullTotalTime: 7.519ms | |
| - PushChunkNum: 0 | |
| - PushRowNum: 0 | |
| - PushTotalTime: 0ns | |
| - SetFinishedTime: 106ns | |
| - __MAX_OF_SetFinishedTime: 185ns | |
| - __MIN_OF_SetFinishedTime: 28ns | |
| - SetFinishingTime: 790ns | |
| - __MAX_OF_SetFinishingTime: 5.250us | |
| - __MIN_OF_SetFinishingTime: 96ns | |
| UniqueMetrics: | |
| - LateMaterialization: false | |
| - Limit: -1 | |
| - Offset: 0 | |
| - StreamingBatchSize: 131072 | |
| - BufferUnplugCount: 0 | |
| - BytesPassThrough: 0.000 B | |
| - BytesReceived: 3.046 MB | |
| - __MAX_OF_BytesReceived: 767.912 KB | |
| - __MIN_OF_BytesReceived: 0.000 B | |
| - ClosureBlockCount: 0 | |
| - ClosureBlockTime: 0ns | |
| - DecompressChunkTime: 0ns | |
| - DeserializeChunkTime: 293.497us | |
| - __MAX_OF_DeserializeChunkTime: 502.483us | |
| - __MIN_OF_DeserializeChunkTime: 0ns | |
| - LateMaterializationMaxBufferChunkNum: 0 | |
| - OverallStageCount: 644 | |
| - __MAX_OF_OverallStageCount: 340 | |
| - __MIN_OF_OverallStageCount: 43 | |
| - 1-InitStageCount: 1 | |
| - __MAX_OF_1-InitStageCount: 1 | |
| - __MIN_OF_1-InitStageCount: 0 | |
| - 2-PrepareStageCount: 38 | |
| - __MAX_OF_2-PrepareStageCount: 38 | |
| - __MIN_OF_2-PrepareStageCount: 0 | |
| - 3-ProcessStageCount: 167 | |
| - __MAX_OF_3-ProcessStageCount: 31 | |
| - __MIN_OF_3-ProcessStageCount: 19 | |
| - 4-SplitChunkStageCount: 88 | |
| - __MAX_OF_4-SplitChunkStageCount: 11 | |
| - __MIN_OF_4-SplitChunkStageCount: 11 | |
| - 5-FetchChunkStageCount: 335 | |
| - __MAX_OF_5-FetchChunkStageCount: 258 | |
| - __MIN_OF_5-FetchChunkStageCount: 11 | |
| - 6-PendingStageCount: 8 | |
| - __MAX_OF_6-PendingStageCount: 1 | |
| - __MIN_OF_6-PendingStageCount: 1 | |
| - 7-FinishedStageCount: 7 | |
| - __MAX_OF_7-FinishedStageCount: 1 | |
| - __MIN_OF_7-FinishedStageCount: 0 | |
| - OverallStageTime: 13.330ms | |
| - __MAX_OF_OverallStageTime: 14.485ms | |
| - __MIN_OF_OverallStageTime: 11.310ms | |
| - 1-InitStageTime: 2.194us | |
| - __MAX_OF_1-InitStageTime: 17.558us | |
| - __MIN_OF_1-InitStageTime: 0ns | |
| - 2-PrepareStageTime: 8.235us | |
| - __MAX_OF_2-PrepareStageTime: 65.884us | |
| - __MIN_OF_2-PrepareStageTime: 0ns | |
| - 3-ProcessStageTime: 9.211ms | |
| - __MAX_OF_3-ProcessStageTime: 10.375ms | |
| - __MIN_OF_3-ProcessStageTime: 7.113ms | |
| - LateMaterializationGenerateOrdinalTime: 0ns | |
| - SortedRunProviderTime: 12.403us | |
| - __MAX_OF_SortedRunProviderTime: 72.822us | |
| - __MIN_OF_SortedRunProviderTime: 0ns | |
| - 4-SplitChunkStageTime: 191.085us | |
| - __MAX_OF_4-SplitChunkStageTime: 241.777us | |
| - __MIN_OF_4-SplitChunkStageTime: 149.263us | |
| - LateMaterializationRestoreAccordingToOrdinalTime: 0ns | |
| - 5-FetchChunkStageTime: 13.262us | |
| - __MAX_OF_5-FetchChunkStageTime: 23.555us | |
| - __MIN_OF_5-FetchChunkStageTime: 6.985us | |
| - 6-PendingStageTime: 3.894ms | |
| - 7-FinishedStageTime: 48ns | |
| - __MAX_OF_7-FinishedStageTime: 76ns | |
| - __MIN_OF_7-FinishedStageTime: 0ns | |
| - PeakBufferMemoryBytes: 2.416 MB | |
| - __MAX_OF_PeakBufferMemoryBytes: 575.429 KB | |
| - __MIN_OF_PeakBufferMemoryBytes: 0.000 B | |
| - ReceiverProcessTotalTime: 324.087us | |
| - __MAX_OF_ReceiverProcessTotalTime: 573.768us | |
| - __MIN_OF_ReceiverProcessTotalTime: 0ns | |
| - RequestReceived: 13 | |
| - __MAX_OF_RequestReceived: 3 | |
| - __MIN_OF_RequestReceived: 0 | |
| - WaitLockTime: 503ns | |
| - __MAX_OF_WaitLockTime: 2.507us | |
| - __MIN_OF_WaitLockTime: 0ns | |
| Pipeline (id=1): | |
| - ActiveTime: 1m14s | |
| - BlockByInputEmpty: 7 | |
| - BlockByOutputFull: 0 | |
| - BlockByPrecondition: 0 | |
| - DegreeOfParallelism: 1 | |
| - DriverPrepareTime: 59.963us | |
| - DriverTotalTime: 1m14s | |
| - OverheadTime: 284.471us | |
| - PeakDriverQueueSize: 0 | |
| - PendingTime: 32.095ms | |
| - InputEmptyTime: 32.132ms | |
| - FirstInputEmptyTime: 26.291ms | |
| - FollowupInputEmptyTime: 5.840ms | |
| - OutputFullTime: 0ns | |
| - PendingFinishTime: 0ns | |
| - PreconditionBlockTime: 0ns | |
| - ScheduleCount: 8 | |
| - ScheduleTime: 139.667us | |
| - TotalDegreeOfParallelism: 1 | |
| - YieldByLocalWait: 0 | |
| - YieldByPreempt: 0 | |
| - YieldByTimeLimit: 0 | |
| ANALYTIC_SINK (plan_node_id=3): | |
| CommonMetrics: | |
| - CloseTime: 3.979us | |
| - OperatorAllocatedMemoryUsage: 22.844 MB | |
| - OperatorDeallocatedMemoryUsage: 8.986 MB | |
| - OperatorPeakMemoryUsage: 13.858 MB | |
| - OperatorTotalTime: 1m14s | |
| - PrepareTime: 36.910us | |
| - PullChunkNum: 0 | |
| - PullRowNum: 0 | |
| - PullTotalTime: 0ns | |
| - PushChunkNum: 256 | |
| - PushRowNum: 1.000M (1000000) | |
| - PushTotalTime: 11.726ms | |
| - RuntimeBloomFilterNum: 0 | |
| - RuntimeInFilterNum: 0 | |
| - SetFinishedTime: 417ns | |
| - SetFinishingTime: 1m14s | |
| UniqueMetrics: | |
| - AggregateFunctions: max(1: fn_int) | |
| - ColumnResizeTime: 11.614ms | |
| - PartitionSearchTime: 0ns | |
| - PeerGroupSearchTime: 0ns | |
| - RowsReturned: 1.000M (1000000) | |
| LOCAL_EXCHANGE_SOURCE (plan_node_id=2): | |
| CommonMetrics: | |
| - IsSubordinate | |
| - CloseTime: 8.189us | |
| - OperatorAllocatedMemoryUsage: 1.781 KB | |
| - OperatorDeallocatedMemoryUsage: 7.188 KB | |
| - OperatorPeakMemoryUsage: 0.000 B | |
| - OperatorTotalTime: 159.217us | |
| - PrepareTime: 9.691us | |
| - PullChunkNum: 256 | |
| - PullRowNum: 1.000M (1000000) | |
| - PullTotalTime: 146.770us | |
| - PushChunkNum: 0 | |
| - PushRowNum: 0 | |
| - PushTotalTime: 0ns | |
| - RuntimeBloomFilterNum: 0 | |
| - RuntimeInFilterNum: 0 | |
| - SetFinishedTime: 4.023us | |
| - SetFinishingTime: 235ns | |
| UniqueMetrics: | |
| Pipeline (id=2): | |
| - ActiveTime: 8.513ms | |
| - BlockByInputEmpty: 255 | |
| - BlockByOutputFull: 0 | |
| - BlockByPrecondition: 0 | |
| - DegreeOfParallelism: 1 | |
| - DriverPrepareTime: 149.539us | |
| - DriverTotalTime: 1m14s | |
| - OverheadTime: 3.675ms | |
| - PeakDriverQueueSize: 0 | |
| - PendingTime: 1m14s | |
| - InputEmptyTime: 1m14s | |
| - FirstInputEmptyTime: 45.097ms | |
| - FollowupInputEmptyTime: 1m14s | |
| - OutputFullTime: 0ns | |
| - PendingFinishTime: 0ns | |
| - PreconditionBlockTime: 0ns | |
| - ScheduleCount: 256 | |
| - ScheduleTime: 26.920ms | |
| - TotalDegreeOfParallelism: 1 | |
| - YieldByLocalWait: 0 | |
| - YieldByPreempt: 0 | |
| - YieldByTimeLimit: 0 | |
| AGGREGATE_BLOCKING_SINK (plan_node_id=5): | |
| CommonMetrics: | |
| - CloseTime: 7.357us | |
| - OperatorAllocatedMemoryUsage: 1008.000 B | |
| - OperatorDeallocatedMemoryUsage: 4.821 MB | |
| - OperatorPeakMemoryUsage: 0.000 B | |
| - OperatorTotalTime: 2.645ms | |
| - PrepareTime: 111.513us | |
| - PullChunkNum: 0 | |
| - PullRowNum: 0 | |
| - PullTotalTime: 0ns | |
| - PushChunkNum: 256 | |
| - PushRowNum: 1.000M (1000000) | |
| - PushTotalTime: 2.637ms | |
| - RuntimeBloomFilterNum: 0 | |
| - RuntimeInFilterNum: 0 | |
| - SetFinishedTime: 29ns | |
| - SetFinishingTime: 343ns | |
| UniqueMetrics: | |
| - AggregateFunctions: sum(7: max(1: fn_int)) | |
| - AggComputeTime: 1.365ms | |
| - AggFuncComputeTime: 1.246ms | |
| - ChunkBufferPeakMem: 0.000 B | |
| - ChunkBufferPeakSize: 0 | |
| - ExprComputeTime: 165.687us | |
| - ExprReleaseTime: 875.857us | |
| - GetResultsTime: 10.983us | |
| - HashTableMemoryUsage: 4.023 KB | |
| - HashTableSize: 0 | |
| - InputRowCount: 1.000M (1000000) | |
| - PassThroughRowCount: 0 | |
| - ResultAggAppendTime: 0ns | |
| - ResultGroupByAppendTime: 0ns | |
| - ResultIteratorTime: 0ns | |
| - RowsReturned: 0 | |
| - StateAllocate: 0ns | |
| - StateDestroy: 0ns | |
| - StreamingTime: 0ns | |
| PROJECT (plan_node_id=4): | |
| CommonMetrics: | |
| - CloseTime: 5.445us | |
| - OperatorAllocatedMemoryUsage: 104.656 KB | |
| - OperatorDeallocatedMemoryUsage: 6.063 KB | |
| - OperatorPeakMemoryUsage: 98.594 KB | |
| - OperatorTotalTime: 1.371ms | |
| - PrepareTime: 9.084us | |
| - PullChunkNum: 256 | |
| - PullRowNum: 1.000M (1000000) | |
| - PullTotalTime: 50.698us | |
| - PushChunkNum: 256 | |
| - PushRowNum: 1.000M (1000000) | |
| - PushTotalTime: 1.315ms | |
| - RuntimeBloomFilterNum: 0 | |
| - RuntimeInFilterNum: 0 | |
| - SetFinishedTime: 54ns | |
| - SetFinishingTime: 130ns | |
| UniqueMetrics: | |
| - CommonSubExprComputeTime: 74.076us | |
| - ExprComputeTime: 543.379us | |
| ANALYTIC_SOURCE (plan_node_id=3): | |
| CommonMetrics: | |
| - CloseTime: 5.327us | |
| - JoinRuntimeFilterEvaluate: 0 | |
| - JoinRuntimeFilterHashTime: 0ns | |
| - JoinRuntimeFilterInputRows: 0 | |
| - JoinRuntimeFilterOutputRows: 0 | |
| - JoinRuntimeFilterTime: 0ns | |
| - OperatorAllocatedMemoryUsage: 2.797 KB | |
| - OperatorDeallocatedMemoryUsage: 6.633 KB | |
| - OperatorPeakMemoryUsage: 2.320 KB | |
| - OperatorTotalTime: 821.889us | |
| - PrepareTime: 10.199us | |
| - PullChunkNum: 256 | |
| - PullRowNum: 1.000M (1000000) | |
| - PullTotalTime: 816.303us | |
| - PushChunkNum: 0 | |
| - PushRowNum: 0 | |
| - PushTotalTime: 0ns | |
| - RuntimeBloomFilterNum: 0 | |
| - RuntimeInFilterNum: 0 | |
| - SetFinishedTime: 59ns | |
| - SetFinishingTime: 200ns | |
| UniqueMetrics: | |
| Pipeline (id=3): | |
| - ActiveTime: 90.992us | |
| - BlockByInputEmpty: 0 | |
| - BlockByOutputFull: 0 | |
| - BlockByPrecondition: 0 | |
| - DegreeOfParallelism: 1 | |
| - DriverPrepareTime: 38.620us | |
| - DriverTotalTime: 1m14s | |
| - OverheadTime: 0ns | |
| - PeakDriverQueueSize: 1 | |
| - PendingTime: 1m14s | |
| - InputEmptyTime: 1m14s | |
| - FirstInputEmptyTime: 1m14s | |
| - FollowupInputEmptyTime: 0ns | |
| - OutputFullTime: 0ns | |
| - PendingFinishTime: 0ns | |
| - PreconditionBlockTime: 0ns | |
| - ScheduleCount: 1 | |
| - ScheduleTime: 138.594us | |
| - TotalDegreeOfParallelism: 1 | |
| - YieldByLocalWait: 0 | |
| - YieldByPreempt: 0 | |
| - YieldByTimeLimit: 0 | |
| RESULT_SINK (plan_node_id=-1): | |
| CommonMetrics: | |
| - IsFinalSink | |
| - CloseTime: 6.904us | |
| - OperatorAllocatedMemoryUsage: 5.727 KB | |
| - OperatorDeallocatedMemoryUsage: 6.547 KB | |
| - OperatorPeakMemoryUsage: 0.000 B | |
| - OperatorTotalTime: 61.125us | |
| - PrepareTime: 14.944us | |
| - PullChunkNum: 0 | |
| - PullRowNum: 0 | |
| - PullTotalTime: 0ns | |
| - PushChunkNum: 1 | |
| - PushRowNum: 1 | |
| - PushTotalTime: 54.108us | |
| - SetFinishedTime: 52ns | |
| - SetFinishingTime: 61ns | |
| UniqueMetrics: | |
| result sink: | |
| - AppendChunkTime: 3.893us | |
| - ResultRendTime: 47.935us | |
| - TupleConvertTime: 1.867us | |
| - NumSentRows: 1 | |
| AGGREGATE_BLOCKING_SOURCE (plan_node_id=5): | |
| CommonMetrics: | |
| - CloseTime: 10.050us | |
| - JoinRuntimeFilterEvaluate: 0 | |
| - JoinRuntimeFilterHashTime: 0ns | |
| - JoinRuntimeFilterInputRows: 0 | |
| - JoinRuntimeFilterOutputRows: 0 | |
| - JoinRuntimeFilterTime: 0ns | |
| - OperatorAllocatedMemoryUsage: 3.797 KB | |
| - OperatorDeallocatedMemoryUsage: 65.180 KB | |
| - OperatorPeakMemoryUsage: 2.930 KB | |
| - OperatorTotalTime: 38.771us | |
| - PrepareTime: 7.292us | |
| - PullChunkNum: 1 | |
| - PullRowNum: 1 | |
| - PullTotalTime: 28.298us | |
| - PushChunkNum: 0 | |
| - PushRowNum: 0 | |
| - PushTotalTime: 0ns | |
| - RuntimeBloomFilterNum: 0 | |
| - RuntimeInFilterNum: 0 | |
| - SetFinishedTime: 250ns | |
| - SetFinishingTime: 173ns | |
| UniqueMetrics: | |
| Fragment 1: | |
| - BackendAddresses: 172.26.80.84:9060,172.26.80.89:9060,172.26.80.90:9060 | |
| - InstanceIds: b90f2e6b-76fc-11ee-a1ce-00163e258370,b90f2e6b-76fc-11ee-a1ce-00163e25836f,b90f2e6b-76fc-11ee-a1ce-00163e25836e | |
| - MissingInstanceIds: b90f2e6b-76fc-11ee-a1ce-00163e258370,b90f2e6b-76fc-11ee-a1ce-00163e25836f,b90f2e6b-76fc-11ee-a1ce-00163e25836e | |
| - BackendNum: 3 | |
| - InstanceNum: 3 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment