Summary:
   - Profile ID: e8dcc0bc9264316-80bf92e2c23c7ae4
   - Task Type: QUERY
   - Start Time: 2026-08-20 04:49:55
   - End Time: 2026-08-20 04:49:55
   - Total: 140ms
   - Task State: OK
   - User: root
   - Default Catalog: internal
   - Default Db: variant_perf_doris
   - Sql Statement: SELECT COUNT(*) AS group_rows,
       SUM(visit_count) AS source_rows,
       SUM(anomaly_count) AS anomaly_rows
FROM internal.variant_perf_doris.mv_truewatch_spark_unshredded
   - Distributed Plan: N/A
Execution Summary:
   - Workload Group: normal
   - Parse SQL Time: 1ms
   - Plan Time: 112ms
     - Garbage Collect During Plan Time: 0ms
     - Nereids Preload External Metadata Time: 0ms
     - Nereids Lock Table Time: 0ms
     - Nereids Analysis Time: 5ms
     - Nereids Rewrite Time: 100ms
       - Nereids Fold Const By BE Time: 0ms
     - Nereids Collect Table Partition Time: 0ms
   - Nereids Pre Rewrite By Mv Time: N/A
     - Nereids Optimize Time: N/A
     - Nereids Translate Time: 1ms
       - Init Scan Node Time: N/A
       - Finalize Scan Node Time: N/A
         - Get Splits Time: N/A
           - External Table Meta Time: N/A
             - External Table Get Table Meta Time: N/A
             - External Table Get Partition Values Time: N/A
         - Get Partitions Time: N/A
         - Get Partition Files Time: N/A
             - External Table Get File Scan Tasks Time: N/A
         - Sink Set Partition Values Time: N/A
       - Create Scan Range Time: N/A
         - Iceberg Scan Metrics: N/A
         - Paimon Scan Metrics: N/A
     - Nereids Distribute Time: 1ms
   - Get Meta Version Time: N/A
     - Get Meta Version Rate Limit Wait Time: N/A
     - Get Partition Version Time: N/A
     - Get Partition Version Count (hasData): N/A
     - Get Partition Version Count: N/A
     - Get Table Version Time: N/A
     - Get Table Version Count: N/A
   - Schedule Time: 18ms
     - Fragment Assign Time: 0ms
     - Fragment Serialize Time: 12ms
     - Fragment RPC Phase1 Time: 6ms
     - Fragment RPC Phase2 Time: N/A
     - Fragment Compressed Size: 1.46 KB
     - Fragment RPC Count: 1
   - Schedule Time Of BE: {"phase1":{"172.20.49.61: 8060":{"RPC Work Time":"1ms","RPC Latency From FE To BE":"3ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"2ms"}}}
   - Wait and Fetch Result Time: 9ms
   - Fetch Result Time: 9ms
   - Write Result Time: 0ms
   - Doris Version: doris-4.1.3-rc02-be8771b5bc4
   - Is Nereids: Yes
   - Is Cached: No
   - Total Instances Num: 1
   - Instances Num Per BE: 172.20.49.61:8060:1
   - Parallel Fragment Exec Instance Num: 8
   - Trace ID: 
   - Transaction Commit Time: N/A
   - System Message: N/A
   - Executed By Frontend: N/A
   - Splits Assignment Weight: N/A

ChangedSessionVariables:
[
  {
    "VarName": "enable_profile",
    "CurrentValue": "true",
    "DefaultValue": "false"
  },
  {
    "VarName": "query_timeout",
    "CurrentValue": "3600",
    "DefaultValue": "900"
  },
  {
    "VarName": "enable_file_cache",
    "CurrentValue": "true",
    "DefaultValue": "false"
  }
]
MergedProfile:
     Fragments:
       Fragment 0:
         Pipeline 0(instance_num=1):
            - WaitWorkerTime: avg 9.906us, max 9.906us, min 9.906us
           RESULT_SINK_OPERATOR(id=2):
             CommonCounters:
                - ExecTime: avg 24.761us, max 24.761us, min 24.761us
                - InputRows: sum 1, avg 1, max 1, min 1
                - MemoryUsage: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - MemoryUsagePeak: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - WaitForDependency[RESULT_SINK_OPERATOR_DEPENDENCY]Time: avg 0ns, max 0ns, min 0ns
             CustomCounters:
                - WaitForDependencyTime: avg 0ns, max 0ns, min 0ns
           AGGREGATION_OPERATOR(nereids_id=74)(id=1):
              - PlanInfo
                 - output: count(*)[#2], sum(visit_count)[#3], sum(anomaly_count)[#4]
                 - group by: 
                 - sortByGroupKey:false
                 - cardinality=1
             CommonCounters:
                - BlocksProduced: sum 1, avg 1, max 1, min 1
                - ExecTime: avg 47.398us, max 47.398us, min 47.398us
                - MaxOutputBlockBytes: sum 26.00 B, avg 26.00 B, max 26.00 B, min 26.00 B
                - MemoryUsage: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - MemoryUsagePeak: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - MinOutputBlockBytes: sum 26.00 B, avg 26.00 B, max 26.00 B, min 26.00 B
                - OutputBlockBytes: sum 26.00 B, avg 26.00 B, max 26.00 B, min 26.00 B
                - RowsProduced: sum 1, avg 1, max 1, min 1
                - WaitForDependency[AGGREGATION_OPERATOR_DEPENDENCY]Time: avg 35.534us, max 35.534us, min 35.534us
             CustomCounters:
                - HashTableInputCount: sum 0, avg 0, max 0, min 0
                - HashTableSize: sum 0, avg 0, max 0, min 0
                - MemoryUsageHashTable: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
         Pipeline 1(instance_num=1):
            - WaitWorkerTime: avg 4.649us, max 4.649us, min 4.649us
           AGGREGATION_SINK_OPERATOR(nereids_id=74)(id=1):
             CommonCounters:
                - ExecTime: avg 45.515us, max 45.515us, min 45.515us
                - InputRows: sum 0, avg 0, max 0, min 0
                - MemoryUsage: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - MemoryUsagePeak: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - WaitForDependency[AGGREGATION_SINK_OPERATOR_DEPENDENCY]Time: avg 0ns, max 0ns, min 0ns
             CustomCounters:
                - MemoryUsageHashTable: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - MemoryUsageSerializeKeyArena: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
           EMPTY_SET_OPERATOR(nereids_id=70)(id=0):
              - PlanInfo
                 - 
             CommonCounters:
                - BlocksProduced: sum 0, avg 0, max 0, min 0
                - ExecTime: avg 0ns, max 0ns, min 0ns
                - MaxOutputBlockBytes: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - MemoryUsage: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - MemoryUsagePeak: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - MinOutputBlockBytes: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - OutputBlockBytes: sum 0.00 , avg 0.00 , max 0.00 , min 0.00 
                - RowsProduced: sum 0, avg 0, max 0, min 0
             CustomCounters:

DetailProfile(e8dcc0bc9264316-80bf92e2c23c7ae4):
  Fragments:
    Fragment 0:
      FragmentLevelProfile:(host=TNetworkAddress(hostname:172.20.49.61, port:9050)):
         - BuildPipelinesTime: 28.989us
         - BuildTasksTime: 66.334us
         - InitContextTime: 4.659us
         - PlanLocalLocalExchangerTime: 485ns
         - PrepareAllPipelinesTime: 228.338us
         - PrepareTime: 331.147us
      Pipeline 0(host=TNetworkAddress(hostname:172.20.49.61, port:9050)):
        PipelineTask(index=0):
           - TaskState: FINALIZED
           - BlockedByDependency: 
           - WakeUpEarly: 0
           - CoreChangeTimes: 0
           - ExecuteTime: 78.477us
             - CloseTime: 3.152us
             - GetBlockTime: 45.451us
             - OpenTime: 11.526us
             - PrepareTime: 22.995us
             - SinkTime: 13.175us
           - GetBlockCounter: 1
           - MemoryReserveFailedTimes: 0
           - MemoryReserveTimes: 2
           - NumScheduleTimes: 2
           - NumYieldTimes: 0
           - TaskCpuTime: 123.492us
           - WaitWorkerTime: 9.906us
          RESULT_SINK_OPERATOR(id=2):
            CommonCounters:
               - IsColocate: 0
               - IsShuffled: 0
               - FollowedByShuffledOperator: 0
               - CloseTime: 1.924us
               - ExecTime: 24.761us
               - InitTime: 1.736us
               - InputRows: 1
               - MemoryUsage: 0.00 
               - MemoryUsagePeak: 0.00 
               - OpenTime: 9.732us
               - PendingFinishDependency: 0ns
               - WaitForDependency[RESULT_SINK_OPERATOR_DEPENDENCY]Time: 0ns
            CustomCounters:
               - AppendBatchTime: 10.888us
                 - ResultSendTime: 1.213us
                 - TupleConvertTime: 6.712us
               - BytesSent: 4.00 B
               - FetchRowIdTime: 0ns
               - NumSentRows: 1
               - WaitForDependencyTime: 0ns
               - WriteDataTime: 11.110us
          AGGREGATION_OPERATOR(nereids_id=74)(id=1):
            CommonCounters:
               - IsColocate: 0
               - IsShuffled: 0
               - FollowedByShuffledOperator: 0
               - BlocksProduced: 1
               - CloseTime: 309ns
               - ExecTime: 47.398us
               - InitTime: 4.364us
               - MaxOutputBlockBytes: 26.00 B
               - MemoryUsage: 0.00 
               - MemoryUsagePeak: 0.00 
               - MinOutputBlockBytes: 26.00 B
               - OpenTime: 0ns
               - OutputBlockBytes: 26.00 B
               - ProjectionTime: 0ns
               - RowsProduced: 1
               - WaitForDependency[AGGREGATION_OPERATOR_DEPENDENCY]Time: 35.534us
            CustomCounters:
               - DeserializeAndMergeTime: 0ns
               - GetResultsTime: 0ns
               - HashTableComputeTime: 0ns
               - HashTableEmplaceTime: 0ns
               - HashTableInputCount: 0
               - HashTableIterateTime: 0ns
               - HashTableSize: 0
               - InsertKeysToColumnTime: 0ns
               - InsertValuesToColumnTime: 0ns
               - MemoryUsageArena: 0.00 
               - MemoryUsageContainer: 0.00 
               - MemoryUsageHashTable: 0.00 
               - MergeTime: 0ns
      Pipeline 1(host=TNetworkAddress(hostname:172.20.49.61, port:9050)):
        PipelineTask(index=1):
           - TaskState: FINALIZED
           - BlockedByDependency: 
           - WakeUpEarly: 0
           - CoreChangeTimes: 0
           - ExecuteTime: 52.766us
             - CloseTime: 961ns
             - GetBlockTime: 2.484us
             - OpenTime: 38.677us
             - PrepareTime: 17.651us
             - SinkTime: 6.337us
           - GetBlockCounter: 1
           - MemoryReserveFailedTimes: 0
           - MemoryReserveTimes: 1
           - NumScheduleTimes: 1
           - NumYieldTimes: 0
           - TaskCpuTime: 119.935us
           - WaitWorkerTime: 4.649us
          AGGREGATION_SINK_OPERATOR(nereids_id=74)(id=1):
            CommonCounters:
               - IsColocate: 1
               - IsShuffled: 0
               - FollowedByShuffledOperator: 0
               - CloseTime: 350ns
               - ExecTime: 45.515us
               - InitTime: 3.307us
               - InputRows: 0
               - MemoryUsage: 0.00 
               - MemoryUsagePeak: 0.00 
               - OpenTime: 36.516us
               - PendingFinishDependency: 0ns
               - WaitForDependency[AGGREGATION_SINK_OPERATOR_DEPENDENCY]Time: 0ns
            CustomCounters:
               - BuildTime: 0ns
               - DeserializeAndMergeTime: 0ns
               - DoLimitComputeTime: 0ns
               - ExprTime: 0ns
               - HashTableComputeTime: 0ns
               - HashTableEmplaceTime: 0ns
               - HashTableInputCount: 0
               - HashTableSize: 0
               - MemoryUsageArena: 0.00 
               - MemoryUsageContainer: 0.00 
               - MemoryUsageHashTable: 0.00 
               - MemoryUsageSerializeKeyArena: 0.00 
               - MergeTime: 0ns
          EMPTY_SET_OPERATOR(nereids_id=70)(id=0):
            CommonCounters:
               - IsColocate: 0
               - IsShuffled: 0
               - FollowedByShuffledOperator: 0
               - BlocksProduced: 0
               - CloseTime: 0ns
               - ExecTime: 0ns
               - InitTime: 0ns
               - MaxOutputBlockBytes: 0.00 
               - MemoryUsage: 0.00 
               - MemoryUsagePeak: 0.00 
               - MinOutputBlockBytes: 0.00 
               - OpenTime: 0ns
               - OutputBlockBytes: 0.00 
               - ProjectionTime: 0ns
               - RowsProduced: 0
            CustomCounters:
  LoadChannels:

Appendix:

PhysicalPlan:
PhysicalResultSink[78] ( outputExprs=[group_rows#6, source_rows#7, anomaly_rows#8] )
     +--PhysicalHashAggregate[74]@1 ( stats=1 actualRows=1, aggPhase=GLOBAL, aggMode=INPUT_TO_RESULT, maybeUseStreaming=false, groupByExpr=[], outputExpr=[count(*) AS `group_rows`#6, sum(visit_count#4) AS `source_rows`#7, sum(anomaly_count#5) AS `anomaly_rows`#8], partitionExpr=Optional.empty, topnFilter=false, topnPushDown=false )
        +--PhysicalEmptyRelation ( projects=[visit_count#4, anomaly_count#5] )
     
