How to get the profile / query plan of a StarRocks query

[alberttwong]

How to provide the profile for the query so others can debug or figure how how the SQL was executed?

Warning

Don't enable this setting globally because there will be a query performance slowdown.

Note

More information can be found at https://docs.starrocks.io/en-us/latest/administration/query_profile

Note

youtube video on the topic. https://www.youtube.com/watch?v=oUFKSSmypbs

Run

set enable_profile=true;

and execute the SQL again!

Next you have to get the query profile

1. Enter http://<fe_ip>:<fe_http_port> in your browser. Should be http://localhost:8030 with username of "root" with no password for the allin1 container image.
2. On the page this is displayed, click queries on the top navigation pane.
3. In the Finished Queries list, choose the query you want to check and click the link in the Profile column.

It should look like this

Query:
  Summary:
     - Query ID: f0d556f6-4092-11ee-87f3-02420a080272
     - Start Time: 2023-08-22 02:23:54
     - End Time: 2023-08-22 02:24:06
     - Total: 11s712ms
     - Query Type: Query
     - Query State: Error
     - StarRocks Version: 3.1.1-e0229632f9
     - User: root
     - Default Db: bitcoin_subset_700000_802268
     - Sql Statement: Select * from tx_in join tx_out t on tx_in.txid = t.txid Limit 5
     - 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
     - Collect Profile Time: 64ms
  Planner:
     - Analyzer: 0ms / 1
     - CTEUniqueChecker: 0ms / 1
     - CoordDeliverExec: 5ms / 1
     - CoordPrepareExec: 0ms / 1
     - ExecPlanBuild: 0ms / 1
     - InputDependenciesChecker: 0ms / 1
     - Optimizer: 2ms / 1
     - Total: 3ms / 1
     - Transformer: 0ms / 1
     - TypeChecker: 0ms / 1
    Optimizer:
       - CostBaseOptimize: 0ms / 1
       - PhysicalRewrite: 0ms / 1
       - PlanValidate: 0ms / 1
       - RuleBaseOptimize: 1ms / 1
       - preprocessMvs: 0ms / 1
  Execution:
     - QueryAllocatedMemoryUsage: 214.602 GB
     - QueryCumulativeCpuTime: 0ns
     - QueryCumulativeOperatorTime: 18s901ms
     - QueryDeallocatedMemoryUsage: 211.755 GB
     - QueryExecutionWallTime: 11s705ms
     - QueryPeakMemoryUsage: 0.000 B
     - ResultDeliverTime: 0ns
    Fragment 0:
       - BackendAddresses: 127.0.0.1:9060
       - InstanceIds: null
       - BackendNum: 1
       - FragmentInstancePrepareTime: 327.848us
         - prepare-fragment-ctx: 85.215us
         - prepare-pipeline-driver: 99.837us
         - prepare-query-ctx: 3.429us
         - prepare-runtime-state: 99.837us
       - InitialProcessDriverCount: 0
       - InitialProcessMem: 3.713 GB
       - InstanceAllocatedMemoryUsage: 696.461 KB
       - InstanceDeallocatedMemoryUsage: 531.570 KB
       - InstanceNum: 1
       - InstancePeakMemoryUsage: 164.891 KB
       - QueryMemoryLimit: 38.880 GB
      Pipeline (id=0):
         - ActiveTime: 0ns
         - BlockByInputEmpty: 0
         - BlockByOutputFull: 0
         - BlockByPrecondition: 0
         - DegreeOfParallelism: 8
         - DriverPrepareTime: 37.086us
           - __MAX_OF_DriverPrepareTime: 193.073us
           - __MIN_OF_DriverPrepareTime: 13.273us
         - DriverTotalTime: 11s705ms
           - __MAX_OF_DriverTotalTime: 11s705ms
           - __MIN_OF_DriverTotalTime: 11s705ms
         - GlobalScheduleCount: 88.054K (88054)
           - __MAX_OF_GlobalScheduleCount: 11.012K (11012)
           - __MIN_OF_GlobalScheduleCount: 10.998K (10998)
         - GlobalScheduleTime: 1m36s
         - OverheadTime: 0ns
         - PeakDriverQueueSize: 28
           - __MAX_OF_PeakDriverQueueSize: 7
           - __MIN_OF_PeakDriverQueueSize: 0
         - PendingTime: 11s705ms
           - __MAX_OF_PendingTime: 11s705ms
           - __MIN_OF_PendingTime: 11s704ms
           - InputEmptyTime: 11s705ms
             - __MAX_OF_InputEmptyTime: 11s705ms
             - __MIN_OF_InputEmptyTime: 11s705ms
             - FirstInputEmptyTime: 11s705ms
               - __MAX_OF_FirstInputEmptyTime: 11s705ms
               - __MIN_OF_FirstInputEmptyTime: 11s705ms
             - FollowupInputEmptyTime: 0ns
           - OutputFullTime: 0ns
           - PendingFinishTime: 0ns
           - PreconditionBlockTime: 0ns
         - ScheduleCount: 0
         - ScheduleTime: 570.117us
           - __MAX_OF_ScheduleTime: 1.397ms
           - __MIN_OF_ScheduleTime: 380.309us
         - TotalDegreeOfParallelism: 8
         - YieldByLocalWait: 0
         - YieldByPreempt: 0
         - YieldByTimeLimit: 0
        RESULT_SINK:
          CommonMetrics:
             - CloseTime: 5.415us
               - __MAX_OF_CloseTime: 39.136us
               - __MIN_OF_CloseTime: 220ns
             - OperatorAllocatedMemoryUsage: 1.359 KB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 1.359 KB
               - __MIN_OF_OperatorAllocatedMemoryUsage: 0.000 B
             - OperatorDeallocatedMemoryUsage: 1.594 KB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 1.594 KB
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 0.000 B
             - OperatorPeakMemoryUsage: 0.000 B
             - OperatorTotalTime: 5.489us
               - __MAX_OF_OperatorTotalTime: 39.430us
               - __MIN_OF_OperatorTotalTime: 264ns
             - PrepareTime: 3.973us
               - __MAX_OF_PrepareTime: 5.746us
               - __MIN_OF_PrepareTime: 3.379us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - SetFinishedTime: 16ns
               - __MAX_OF_SetFinishedTime: 18ns
               - __MIN_OF_SetFinishedTime: 16ns
             - SetFinishingTime: 57ns
               - __MAX_OF_SetFinishingTime: 276ns
               - __MIN_OF_SetFinishingTime: 25ns
          UniqueMetrics:
        EXCHANGE_SOURCE (plan_node_id=4):
          CommonMetrics:
             - CloseTime: 4.961us
               - __MAX_OF_CloseTime: 15.002us
               - __MIN_OF_CloseTime: 1.344us
             - OperatorAllocatedMemoryUsage: 5.000 KB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 640.000 B
               - __MIN_OF_OperatorAllocatedMemoryUsage: 640.000 B
             - OperatorDeallocatedMemoryUsage: 624.000 B
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 176.000 B
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 64.000 B
             - OperatorPeakMemoryUsage: 562.000 B
               - __MAX_OF_OperatorPeakMemoryUsage: 576.000 B
               - __MIN_OF_OperatorPeakMemoryUsage: 464.000 B
             - OperatorTotalTime: 5.671us
               - __MAX_OF_OperatorTotalTime: 19.358us
               - __MIN_OF_OperatorTotalTime: 1.393us
             - PrepareTime: 23.886us
               - __MAX_OF_PrepareTime: 171.132us
               - __MIN_OF_PrepareTime: 2.408us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - RuntimeBloomFilterNum: 0
             - RuntimeInFilterNum: 0
             - SetFinishedTime: 17ns
               - __MAX_OF_SetFinishedTime: 20ns
               - __MIN_OF_SetFinishedTime: 16ns
             - SetFinishingTime: 693ns
               - __MAX_OF_SetFinishingTime: 4.338us
               - __MIN_OF_SetFinishingTime: 33ns
          UniqueMetrics:
             - BufferUnplugCount: 0
             - BytesPassThrough: 0.000 B
             - BytesReceived: 0.000 B
             - ClosureBlockCount: 0
             - ClosureBlockTime: 0ns
             - DecompressChunkTime: 0ns
             - DeserializeChunkTime: 0ns
             - PeakBufferMemoryBytes: 0.000 B
             - ReceiverProcessTotalTime: 0ns
             - RequestReceived: 0
             - SenderTotalTime: 0ns
             - SenderWaitLockTime: 0ns
    Fragment 1:
       - BackendAddresses: 127.0.0.1:9060
       - InstanceIds: null
       - BackendNum: 1
       - FragmentInstancePrepareTime: 296.943us
         - prepare-fragment-ctx: 5.795us
         - prepare-pipeline-driver: 37.017us
         - prepare-query-ctx: 991ns
         - prepare-runtime-state: 37.017us
       - InitialProcessDriverCount: 8
       - InitialProcessMem: 3.712 GB
       - InstanceAllocatedMemoryUsage: 95.112 GB
       - InstanceDeallocatedMemoryUsage: 92.355 GB
       - InstanceNum: 1
       - InstancePeakMemoryUsage: 36.900 GB
       - QueryMemoryLimit: 38.880 GB
      Pipeline (id=0):
         - ErrorMsg: Memory of process exceed limit. try consume:2684354560 Used: 45179078524, Limit: 46385646796. Mem usage has exceed the limit of BE
         - ErrorMsg__DUP(0): Memory of process exceed limit. try consume:2684354560 Used: 45564508728, Limit: 46385646796. Mem usage has exceed the limit of BE
         - ActiveTime: 5s537ms
           - __MAX_OF_ActiveTime: 6s764ms
           - __MIN_OF_ActiveTime: 4s664ms
         - BlockByInputEmpty: 8.086K (8086)
           - __MAX_OF_BlockByInputEmpty: 1.117K (1117)
           - __MIN_OF_BlockByInputEmpty: 909
         - BlockByOutputFull: 0
         - BlockByPrecondition: 0
         - DegreeOfParallelism: 8
         - DriverPrepareTime: 19.100us
           - __MAX_OF_DriverPrepareTime: 40.880us
           - __MIN_OF_DriverPrepareTime: 13.875us
         - DriverTotalTime: 11s518ms
           - __MAX_OF_DriverTotalTime: 11s752ms
           - __MIN_OF_DriverTotalTime: 10s850ms
         - GlobalScheduleCount: 88.038K (88038)
           - __MAX_OF_GlobalScheduleCount: 11.023K (11023)
           - __MIN_OF_GlobalScheduleCount: 10.993K (10993)
         - GlobalScheduleTime: 1m36s
           - __MAX_OF_GlobalScheduleTime: 1m36s
           - __MIN_OF_GlobalScheduleTime: 1m36s
         - OverheadTime: 66.032ms
           - __MAX_OF_OverheadTime: 204.547ms
           - __MIN_OF_OverheadTime: 0ns
         - PeakDriverQueueSize: 69
           - __MAX_OF_PeakDriverQueueSize: 11
           - __MIN_OF_PeakDriverQueueSize: 7
         - PendingTime: 4s834ms
           - __MAX_OF_PendingTime: 6s76ms
           - __MIN_OF_PendingTime: 3s976ms
           - InputEmptyTime: 5s32ms
             - __MAX_OF_InputEmptyTime: 6s256ms
             - __MIN_OF_InputEmptyTime: 4s158ms
             - FirstInputEmptyTime: 11.647ms
               - __MAX_OF_FirstInputEmptyTime: 12.901ms
               - __MIN_OF_FirstInputEmptyTime: 11.464ms
             - FollowupInputEmptyTime: 5s21ms
               - __MAX_OF_FollowupInputEmptyTime: 6s245ms
               - __MIN_OF_FollowupInputEmptyTime: 4s147ms
           - OutputFullTime: 0ns
           - PendingFinishTime: 0ns
           - PreconditionBlockTime: 0ns
         - ScheduleCount: 8.198K (8198)
           - __MAX_OF_ScheduleCount: 1.131K (1131)
           - __MIN_OF_ScheduleCount: 927
         - ScheduleTime: 1s146ms
           - __MAX_OF_ScheduleTime: 1s548ms
           - __MIN_OF_ScheduleTime: 916.514ms
         - TotalDegreeOfParallelism: 8
         - YieldByLocalWait: 0
         - YieldByPreempt: 0
         - YieldByTimeLimit: 104
           - __MAX_OF_YieldByTimeLimit: 18
           - __MIN_OF_YieldByTimeLimit: 10
        HASH_JOIN_BUILD (plan_node_id=3):
          CommonMetrics:
             - CloseTime: 6.311ms
               - __MAX_OF_CloseTime: 49.016ms
               - __MIN_OF_CloseTime: 2.426us
             - OperatorAllocatedMemoryUsage: 72.225 GB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 12.391 GB
               - __MIN_OF_OperatorAllocatedMemoryUsage: 5.946 GB
             - OperatorDeallocatedMemoryUsage: 60.022 GB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 13.282 GB
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 4.533 GB
             - OperatorPeakMemoryUsage: 4.094 GB
               - __MAX_OF_OperatorPeakMemoryUsage: 5.593 GB
               - __MIN_OF_OperatorPeakMemoryUsage: 2.873 GB
             - OperatorTotalTime: 5s439ms
               - __MAX_OF_OperatorTotalTime: 6s527ms
               - __MIN_OF_OperatorTotalTime: 4s377ms
             - PrepareTime: 7.679us
               - __MAX_OF_PrepareTime: 14.031us
               - __MIN_OF_PrepareTime: 6.370us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 33.304K (33304)
               - __MAX_OF_PushChunkNum: 4.379K (4379)
               - __MIN_OF_PushChunkNum: 4.051K (4051)
             - PushRowNum: 136.413M (136413184)
               - __MAX_OF_PushRowNum: 17.936M (17936384)
               - __MIN_OF_PushRowNum: 16.593M (16592896)
             - PushTotalTime: 5s188ms
               - __MAX_OF_PushTotalTime: 6s349ms
               - __MIN_OF_PushTotalTime: 4s330ms
             - RuntimeBloomFilterNum: 0
             - RuntimeInFilterNum: 0
             - SetFinishedTime: 165ns
               - __MAX_OF_SetFinishedTime: 359ns
               - __MIN_OF_SetFinishedTime: 0ns
             - SetFinishingTime: 245.052ms
               - __MAX_OF_SetFinishingTime: 507.442ms
               - __MIN_OF_SetFinishingTime: 299ns
          UniqueMetrics:
             - DistributionMode: LOCAL_HASH_BUCKET
             - JoinPredicates: 6: txid = 1: txid
             - JoinType: INNER_JOIN
             - BuildBuckets: 134.218M (134217728)
               - __MAX_OF_BuildBuckets: 33.554M (33554432)
               - __MIN_OF_BuildBuckets: 0
             - BuildConjunctEvaluateTime: 59.242ms
               - __MAX_OF_BuildConjunctEvaluateTime: 78.157ms
               - __MIN_OF_BuildConjunctEvaluateTime: 40.431ms
             - BuildHashTableTime: 245.029ms
               - __MAX_OF_BuildHashTableTime: 507.436ms
               - __MIN_OF_BuildHashTableTime: 0ns
             - CopyRightTableChunkTime: 5s120ms
               - __MAX_OF_CopyRightTableChunkTime: 6s280ms
               - __MIN_OF_CopyRightTableChunkTime: 4s271ms
             - RuntimeFilterBuildTime: 0ns
             - RuntimeFilterNum: 0
        EXCHANGE_SOURCE (plan_node_id=2):
          CommonMetrics:
             - ErrorMsg: Memory of process exceed limit. try consume:2684354560 Used: 45179078524, Limit: 46385646796. Mem usage has exceed the limit of BE
             - ErrorMsg__DUP(0): Memory of process exceed limit. try consume:2684354560 Used: 45564508728, Limit: 46385646796. Mem usage has exceed the limit of BE
             - CloseTime: 694ns
               - __MAX_OF_CloseTime: 1.147us
               - __MIN_OF_CloseTime: 284ns
             - JoinRuntimeFilterEvaluate: 0
             - JoinRuntimeFilterHashTime: 0ns
             - JoinRuntimeFilterInputRows: 0
             - JoinRuntimeFilterOutputRows: 0
             - JoinRuntimeFilterTime: 0ns
             - OperatorAllocatedMemoryUsage: 16.957 MB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 2.204 MB
               - __MIN_OF_OperatorAllocatedMemoryUsage: 2.064 MB
             - OperatorDeallocatedMemoryUsage: 174.097 MB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 99.815 MB
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 4.235 MB
             - OperatorPeakMemoryUsage: 1.976 KB
               - __MAX_OF_OperatorPeakMemoryUsage: 2.313 KB
               - __MIN_OF_OperatorPeakMemoryUsage: 1.023 KB
             - OperatorTotalTime: 178.514ms
               - __MAX_OF_OperatorTotalTime: 210.971ms
               - __MIN_OF_OperatorTotalTime: 143.063ms
             - PrepareTime: 4.751us
               - __MAX_OF_PrepareTime: 19.912us
               - __MIN_OF_PrepareTime: 2.371us
             - PullChunkNum: 33.304K (33304)
               - __MAX_OF_PullChunkNum: 4.379K (4379)
               - __MIN_OF_PullChunkNum: 4.051K (4051)
             - PullRowNum: 136.413M (136413184)
               - __MAX_OF_PullRowNum: 17.936M (17936384)
               - __MIN_OF_PullRowNum: 16.593M (16592896)
             - PullTotalTime: 178.209ms
               - __MAX_OF_PullTotalTime: 210.961ms
               - __MIN_OF_PullTotalTime: 142.892ms
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - RuntimeBloomFilterNum: 0
             - RuntimeInFilterNum: 0
             - SetFinishedTime: 125ns
               - __MAX_OF_SetFinishedTime: 379ns
               - __MIN_OF_SetFinishedTime: 20ns
             - SetFinishingTime: 304.689us
               - __MAX_OF_SetFinishingTime: 1.458ms
               - __MIN_OF_SetFinishingTime: 876ns
          UniqueMetrics:
             - BufferUnplugCount: 119
             - BytesPassThrough: 20.372 GB
             - BytesReceived: 0.000 B
             - ClosureBlockCount: 14.811K (14811)
             - ClosureBlockTime: 10m7s
             - DecompressChunkTime: 0ns
             - DeserializeChunkTime: 0ns
             - PeakBufferMemoryBytes: 240.639 MB
             - ReceiverProcessTotalTime: 136.439ms
             - RequestReceived: 33.501K (33501)
             - SenderTotalTime: 133.068ms
             - SenderWaitLockTime: 0ns
      Pipeline (id=1):
         - ActiveTime: 25.387us
           - __MAX_OF_ActiveTime: 43.335us
           - __MIN_OF_ActiveTime: 7.177us
         - BlockByInputEmpty: 0
         - BlockByOutputFull: 0
         - BlockByPrecondition: 0
         - DegreeOfParallelism: 8
         - DriverPrepareTime: 12.009us
           - __MAX_OF_DriverPrepareTime: 16.246us
           - __MIN_OF_DriverPrepareTime: 9.889us
         - DriverTotalTime: 9s999ms
           - __MAX_OF_DriverTotalTime: 9s999ms
           - __MIN_OF_DriverTotalTime: 9s999ms
         - GlobalScheduleCount: 48
           - __MAX_OF_GlobalScheduleCount: 7
           - __MIN_OF_GlobalScheduleCount: 5
         - GlobalScheduleTime: 141.144us
           - __MAX_OF_GlobalScheduleTime: 203.100us
           - __MIN_OF_GlobalScheduleTime: 43.335us
         - OverheadTime: 5.593us
           - __MAX_OF_OverheadTime: 16.293us
           - __MIN_OF_OverheadTime: 0ns
         - PeakDriverQueueSize: 24
           - __MAX_OF_PeakDriverQueueSize: 6
           - __MIN_OF_PeakDriverQueueSize: 0
         - PendingTime: 0ns
           - InputEmptyTime: 0ns
             - FirstInputEmptyTime: 0ns
             - FollowupInputEmptyTime: 0ns
           - OutputFullTime: 0ns
           - PendingFinishTime: 0ns
           - PreconditionBlockTime: 0ns
         - ScheduleCount: 8
           - __MAX_OF_ScheduleCount: 1
           - __MIN_OF_ScheduleCount: 1
         - ScheduleTime: 9s999ms
           - __MAX_OF_ScheduleTime: 9s999ms
           - __MIN_OF_ScheduleTime: 9s999ms
         - TotalDegreeOfParallelism: 8
         - YieldByLocalWait: 0
         - YieldByPreempt: 0
         - YieldByTimeLimit: 0
        NOOP_SINK (plan_node_id=0):
          CommonMetrics:
             - CloseTime: 99ns
               - __MAX_OF_CloseTime: 134ns
               - __MIN_OF_CloseTime: 56ns
             - OperatorAllocatedMemoryUsage: 0.000 B
             - OperatorDeallocatedMemoryUsage: 0.000 B
             - OperatorPeakMemoryUsage: 0.000 B
             - OperatorTotalTime: 167ns
               - __MAX_OF_OperatorTotalTime: 210ns
               - __MIN_OF_OperatorTotalTime: 109ns
             - PrepareTime: 2.619us
               - __MAX_OF_PrepareTime: 3.211us
               - __MIN_OF_PrepareTime: 2.238us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - SetFinishedTime: 22ns
               - __MAX_OF_SetFinishedTime: 30ns
               - __MIN_OF_SetFinishedTime: 13ns
             - SetFinishingTime: 45ns
               - __MAX_OF_SetFinishingTime: 60ns
               - __MIN_OF_SetFinishingTime: 32ns
          UniqueMetrics:
        OLAP_SCAN_PREPARE (plan_node_id=0):
          CommonMetrics:
             - CloseTime: 2.332us
               - __MAX_OF_CloseTime: 3.488us
               - __MIN_OF_CloseTime: 1.253us
             - OperatorAllocatedMemoryUsage: 22.438 KB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 2.828 KB
               - __MIN_OF_OperatorAllocatedMemoryUsage: 2.797 KB
             - OperatorDeallocatedMemoryUsage: 2.750 KB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 352.000 B
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 352.000 B
             - OperatorPeakMemoryUsage: 2.461 KB
               - __MAX_OF_OperatorPeakMemoryUsage: 2.484 KB
               - __MIN_OF_OperatorPeakMemoryUsage: 2.453 KB
             - OperatorTotalTime: 19.631us
               - __MAX_OF_OperatorTotalTime: 33.463us
               - __MIN_OF_OperatorTotalTime: 7.026us
             - PrepareTime: 4.093us
               - __MAX_OF_PrepareTime: 7.560us
               - __MIN_OF_PrepareTime: 2.820us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 17.176us
               - __MAX_OF_PullTotalTime: 30.280us
               - __MIN_OF_PullTotalTime: 5.557us
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - RuntimeBloomFilterNum: 0
             - RuntimeInFilterNum: 0
             - SetFinishedTime: 40ns
               - __MAX_OF_SetFinishedTime: 53ns
               - __MIN_OF_SetFinishedTime: 19ns
             - SetFinishingTime: 82ns
               - __MAX_OF_SetFinishingTime: 137ns
               - __MIN_OF_SetFinishingTime: 38ns
          UniqueMetrics:
      Pipeline (id=2):
         - ActiveTime: 0ns
         - BlockByInputEmpty: 0
         - BlockByOutputFull: 0
         - BlockByPrecondition: 0
         - DegreeOfParallelism: 8
         - DriverPrepareTime: 37.058us
           - __MAX_OF_DriverPrepareTime: 48.060us
           - __MIN_OF_DriverPrepareTime: 31.875us
         - DriverTotalTime: 11s713ms
           - __MAX_OF_DriverTotalTime: 11s758ms
           - __MIN_OF_DriverTotalTime: 11s703ms
         - GlobalScheduleCount: 88.011K (88011)
           - __MAX_OF_GlobalScheduleCount: 11.005K (11005)
           - __MIN_OF_GlobalScheduleCount: 10.996K (10996)
         - GlobalScheduleTime: 1m36s
         - OverheadTime: 0ns
         - PeakDriverQueueSize: 127
           - __MAX_OF_PeakDriverQueueSize: 20
           - __MIN_OF_PeakDriverQueueSize: 8
         - PendingTime: 11s703ms
           - __MAX_OF_PendingTime: 11s703ms
           - __MIN_OF_PendingTime: 11s703ms
           - InputEmptyTime: 0ns
             - FirstInputEmptyTime: 0ns
             - FollowupInputEmptyTime: 0ns
           - OutputFullTime: 0ns
           - PendingFinishTime: 203.930us
             - __MAX_OF_PendingFinishTime: 247.895us
             - __MIN_OF_PendingFinishTime: 0ns
           - PreconditionBlockTime: 11s703ms
             - __MAX_OF_PreconditionBlockTime: 11s703ms
             - __MIN_OF_PreconditionBlockTime: 11s703ms
         - ScheduleCount: 0
         - ScheduleTime: 10.332ms
           - __MAX_OF_ScheduleTime: 54.795ms
           - __MIN_OF_ScheduleTime: 138.343us
         - TotalDegreeOfParallelism: 8
         - YieldByLocalWait: 0
         - YieldByPreempt: 0
         - YieldByTimeLimit: 0
        EXCHANGE_SINK (plan_node_id=4):
          CommonMetrics:
             - CloseTime: 961ns
               - __MAX_OF_CloseTime: 5.999us
               - __MIN_OF_CloseTime: 95ns
             - OperatorAllocatedMemoryUsage: 258.781 KB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 32.531 KB
               - __MIN_OF_OperatorAllocatedMemoryUsage: 32.281 KB
             - OperatorDeallocatedMemoryUsage: 258.531 KB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 32.406 KB
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 32.281 KB
             - OperatorPeakMemoryUsage: 32.000 B
               - __MAX_OF_OperatorPeakMemoryUsage: 128.000 B
               - __MIN_OF_OperatorPeakMemoryUsage: 0.000 B
             - OperatorTotalTime: 1.545us
               - __MAX_OF_OperatorTotalTime: 7.263us
               - __MIN_OF_OperatorTotalTime: 379ns
             - PrepareTime: 10.703us
               - __MAX_OF_PrepareTime: 16.581us
               - __MIN_OF_PrepareTime: 8.527us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - SetFinishedTime: 19ns
               - __MAX_OF_SetFinishedTime: 28ns
               - __MIN_OF_SetFinishedTime: 16ns
             - SetFinishingTime: 565ns
               - __MAX_OF_SetFinishingTime: 1.236us
               - __MIN_OF_SetFinishingTime: 242ns
          UniqueMetrics:
             - ChannelNum: 1
             - DestFragments: f0d556f6409211ee-87f302420a080275
             - DestID: 4
             - PartType: UNPARTITIONED
             - BytesPassThrough: 0.000 B
             - BytesSent: 0.000 B
             - CompressTime: 0ns
             - NetworkBandwidth: 0.000 B/sec
             - NetworkTime: 0ns
             - OverallThroughput: 0.000 B/sec
             - OverallTime: 0ns
             - RequestSent: 0
             - RpcAvgTime: 0ns
             - RpcCount: 0
             - SerializeChunkTime: 0ns
             - ShuffleHashTime: 0ns
             - UncompressedBytes: 0.000 B
             - WaitTime: 315.789us
        CHUNK_ACCUMULATE (plan_node_id=3):
          CommonMetrics:
             - CloseTime: 123ns
               - __MAX_OF_CloseTime: 219ns
               - __MIN_OF_CloseTime: 65ns
             - OperatorAllocatedMemoryUsage: 0.000 B
             - OperatorDeallocatedMemoryUsage: 0.000 B
             - OperatorPeakMemoryUsage: 0.000 B
             - OperatorTotalTime: 170ns
               - __MAX_OF_OperatorTotalTime: 265ns
               - __MIN_OF_OperatorTotalTime: 112ns
             - PrepareTime: 3.114us
               - __MAX_OF_PrepareTime: 4.408us
               - __MIN_OF_PrepareTime: 2.276us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - SetFinishedTime: 19ns
               - __MAX_OF_SetFinishedTime: 30ns
               - __MIN_OF_SetFinishedTime: 18ns
             - SetFinishingTime: 27ns
               - __MAX_OF_SetFinishingTime: 29ns
               - __MIN_OF_SetFinishingTime: 26ns
          UniqueMetrics:
        HASH_JOIN_PROBE (plan_node_id=3):
          CommonMetrics:
             - CloseTime: 10.147ms
               - __MAX_OF_CloseTime: 54.684ms
               - __MIN_OF_CloseTime: 1.423us
             - OperatorAllocatedMemoryUsage: 5.000 KB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 640.000 B
               - __MIN_OF_OperatorAllocatedMemoryUsage: 640.000 B
             - OperatorDeallocatedMemoryUsage: 23.139 GB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 6.454 GB
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 64.000 B
             - OperatorPeakMemoryUsage: 216.000 B
               - __MAX_OF_OperatorPeakMemoryUsage: 576.000 B
               - __MIN_OF_OperatorPeakMemoryUsage: 0.000 B
             - OperatorTotalTime: 10.147ms
               - __MAX_OF_OperatorTotalTime: 54.685ms
               - __MIN_OF_OperatorTotalTime: 1.664us
             - PrepareTime: 5.180us
               - __MAX_OF_PrepareTime: 7.369us
               - __MIN_OF_PrepareTime: 3.908us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - RuntimeBloomFilterNum: 0
             - RuntimeInFilterNum: 0
             - SetFinishedTime: 110ns
               - __MAX_OF_SetFinishedTime: 138ns
               - __MIN_OF_SetFinishedTime: 100ns
             - SetFinishingTime: 204ns
               - __MAX_OF_SetFinishingTime: 685ns
               - __MIN_OF_SetFinishingTime: 72ns
          UniqueMetrics:
             - DistributionMode: LOCAL_HASH_BUCKET
             - JoinType: INNER_JOIN
             - OtherJoinConjunctEvaluateTime: 0ns
             - OutputBuildColumnTime: 0ns
             - OutputProbeColumnTime: 0ns
             - OutputTupleColumnTime: 0ns
             - ProbeConjunctEvaluateTime: 0ns
             - SearchHashTableTime: 0ns
             - WhereConjunctEvaluateTime: 0ns
        CHUNK_ACCUMULATE (plan_node_id=0):
          CommonMetrics:
             - CloseTime: 201ns
               - __MAX_OF_CloseTime: 501ns
               - __MIN_OF_CloseTime: 94ns
             - OperatorAllocatedMemoryUsage: 0.000 B
             - OperatorDeallocatedMemoryUsage: 0.000 B
             - OperatorPeakMemoryUsage: 0.000 B
             - OperatorTotalTime: 313ns
               - __MAX_OF_OperatorTotalTime: 1.020us
               - __MIN_OF_OperatorTotalTime: 147ns
             - PrepareTime: 2.876us
               - __MAX_OF_PrepareTime: 4.038us
               - __MIN_OF_PrepareTime: 2.264us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - SetFinishedTime: 34ns
               - __MAX_OF_SetFinishedTime: 136ns
               - __MIN_OF_SetFinishedTime: 19ns
             - SetFinishingTime: 77ns
               - __MAX_OF_SetFinishingTime: 383ns
               - __MIN_OF_SetFinishingTime: 31ns
          UniqueMetrics:
        OLAP_SCAN (plan_node_id=0):
          CommonMetrics:
             - CloseTime: 32.149us
               - __MAX_OF_CloseTime: 174.717us
               - __MIN_OF_CloseTime: 4.672us
             - OperatorAllocatedMemoryUsage: 43.625 KB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 5.453 KB
               - __MIN_OF_OperatorAllocatedMemoryUsage: 5.453 KB
             - OperatorDeallocatedMemoryUsage: 25.750 KB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 3.219 KB
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 3.219 KB
             - OperatorPeakMemoryUsage: 2.234 KB
             - OperatorTotalTime: 32.564us
               - __MAX_OF_OperatorTotalTime: 175.048us
               - __MIN_OF_OperatorTotalTime: 4.944us
             - PrepareTime: 5.697us
               - __MAX_OF_PrepareTime: 7.337us
               - __MIN_OF_PrepareTime: 4.728us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - RuntimeBloomFilterNum: 0
             - RuntimeInFilterNum: 0
             - SetFinishedTime: 20ns
               - __MAX_OF_SetFinishedTime: 45ns
               - __MIN_OF_SetFinishedTime: 16ns
             - SetFinishingTime: 394ns
               - __MAX_OF_SetFinishingTime: 1.270us
               - __MIN_OF_SetFinishingTime: 194ns
          UniqueMetrics:
             - BufferUnplugThreshold: 32
             - MorselQueueType: fixed_morsel_queue
             - SharedScan: False
             - BufferUnplugCount: 0
             - ChunkBufferCapacity: 512
             - DefaultChunkBufferCapacity: 512
             - MorselsCount: 0
             - PeakChunkBufferSize: 0
             - PeakIOTasks: 0
             - PeakScanTaskQueueSize: 0
             - SubmitTaskCount: 0
             - TabletCount: 10
    Fragment 2:
       - BackendAddresses: 127.0.0.1:9060
       - InstanceIds: null
       - BackendNum: 1
       - FragmentInstancePrepareTime: 288.917us
         - prepare-fragment-ctx: 6.823us
         - prepare-pipeline-driver: 178.602us
         - prepare-query-ctx: 1.158us
         - prepare-runtime-state: 178.602us
       - InitialProcessDriverCount: 32
       - InitialProcessMem: 3.714 GB
       - InstanceAllocatedMemoryUsage: 119.489 GB
       - InstanceDeallocatedMemoryUsage: 119.399 GB
       - InstanceNum: 1
       - InstancePeakMemoryUsage: 1011.957 MB
       - QueryMemoryLimit: 38.880 GB
      Pipeline (id=0):
         - ActiveTime: 21.594us
           - __MAX_OF_ActiveTime: 49.072us
           - __MIN_OF_ActiveTime: 7.567us
         - BlockByInputEmpty: 0
         - BlockByOutputFull: 0
         - BlockByPrecondition: 0
         - DegreeOfParallelism: 8
         - DriverPrepareTime: 30.600us
           - __MAX_OF_DriverPrepareTime: 78.738us
           - __MIN_OF_DriverPrepareTime: 19.103us
         - DriverTotalTime: 9s999ms
           - __MAX_OF_DriverTotalTime: 9s999ms
           - __MIN_OF_DriverTotalTime: 9s999ms
         - GlobalScheduleCount: 64
           - __MAX_OF_GlobalScheduleCount: 9
           - __MIN_OF_GlobalScheduleCount: 2
         - GlobalScheduleTime: 115.223us
           - __MAX_OF_GlobalScheduleTime: 172.757us
           - __MIN_OF_GlobalScheduleTime: 38.027us
         - OverheadTime: 1.250us
           - __MAX_OF_OverheadTime: 3.575us
           - __MIN_OF_OverheadTime: 143ns
         - PeakDriverQueueSize: 28
           - __MAX_OF_PeakDriverQueueSize: 7
           - __MIN_OF_PeakDriverQueueSize: 0
         - PendingTime: 0ns
           - InputEmptyTime: 0ns
             - FirstInputEmptyTime: 0ns
             - FollowupInputEmptyTime: 0ns
           - OutputFullTime: 0ns
           - PendingFinishTime: 0ns
           - PreconditionBlockTime: 0ns
         - ScheduleCount: 8
           - __MAX_OF_ScheduleCount: 1
           - __MIN_OF_ScheduleCount: 1
         - ScheduleTime: 9s999ms
           - __MAX_OF_ScheduleTime: 9s999ms
           - __MIN_OF_ScheduleTime: 9s999ms
         - TotalDegreeOfParallelism: 8
         - YieldByLocalWait: 0
         - YieldByPreempt: 0
         - YieldByTimeLimit: 0
        NOOP_SINK (plan_node_id=1):
          CommonMetrics:
             - CloseTime: 79ns
               - __MAX_OF_CloseTime: 137ns
               - __MIN_OF_CloseTime: 40ns
             - OperatorAllocatedMemoryUsage: 0.000 B
             - OperatorDeallocatedMemoryUsage: 0.000 B
             - OperatorPeakMemoryUsage: 0.000 B
             - OperatorTotalTime: 132ns
               - __MAX_OF_OperatorTotalTime: 196ns
               - __MIN_OF_OperatorTotalTime: 82ns
             - PrepareTime: 7.807us
               - __MAX_OF_PrepareTime: 23.903us
               - __MIN_OF_PrepareTime: 4.477us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - SetFinishedTime: 14ns
               - __MAX_OF_SetFinishedTime: 18ns
               - __MIN_OF_SetFinishedTime: 13ns
             - SetFinishingTime: 39ns
               - __MAX_OF_SetFinishingTime: 67ns
               - __MIN_OF_SetFinishingTime: 25ns
          UniqueMetrics:
        OLAP_SCAN_PREPARE (plan_node_id=1):
          CommonMetrics:
             - CloseTime: 1.873us
               - __MAX_OF_CloseTime: 2.277us
               - __MIN_OF_CloseTime: 1.018us
             - OperatorAllocatedMemoryUsage: 22.438 KB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 2.828 KB
               - __MIN_OF_OperatorAllocatedMemoryUsage: 2.797 KB
             - OperatorDeallocatedMemoryUsage: 2.750 KB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 352.000 B
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 352.000 B
             - OperatorPeakMemoryUsage: 2.461 KB
               - __MAX_OF_OperatorPeakMemoryUsage: 2.484 KB
               - __MIN_OF_OperatorPeakMemoryUsage: 2.453 KB
             - OperatorTotalTime: 20.211us
               - __MAX_OF_OperatorTotalTime: 45.324us
               - __MIN_OF_OperatorTotalTime: 7.329us
             - PrepareTime: 11.887us
               - __MAX_OF_PrepareTime: 43.662us
               - __MIN_OF_PrepareTime: 5.347us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 18.243us
               - __MAX_OF_PullTotalTime: 43.126us
               - __MIN_OF_PullTotalTime: 6.256us
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - RuntimeBloomFilterNum: 0
             - RuntimeInFilterNum: 0
             - SetFinishedTime: 31ns
               - __MAX_OF_SetFinishedTime: 44ns
               - __MIN_OF_SetFinishedTime: 21ns
             - SetFinishingTime: 62ns
               - __MAX_OF_SetFinishingTime: 114ns
               - __MIN_OF_SetFinishingTime: 34ns
          UniqueMetrics:
      Pipeline (id=1):
         - ActiveTime: 6s556ms
           - __MAX_OF_ActiveTime: 6s624ms
           - __MIN_OF_ActiveTime: 6s504ms
         - BlockByInputEmpty: 14
           - __MAX_OF_BlockByInputEmpty: 3
           - __MIN_OF_BlockByInputEmpty: 1
         - BlockByOutputFull: 2.450K (2450)
           - __MAX_OF_BlockByOutputFull: 312
           - __MIN_OF_BlockByOutputFull: 301
         - BlockByPrecondition: 0
         - DegreeOfParallelism: 8
         - DriverPrepareTime: 42.127us
           - __MAX_OF_DriverPrepareTime: 47.935us
           - __MIN_OF_DriverPrepareTime: 35.758us
         - DriverTotalTime: 11s702ms
           - __MAX_OF_DriverTotalTime: 11s703ms
           - __MIN_OF_DriverTotalTime: 11s702ms
         - GlobalScheduleCount: 88.068K (88068)
           - __MAX_OF_GlobalScheduleCount: 11.012K (11012)
           - __MIN_OF_GlobalScheduleCount: 11.005K (11005)
         - GlobalScheduleTime: 1m36s
         - OverheadTime: 95.648ms
           - __MAX_OF_OverheadTime: 126.371ms
           - __MIN_OF_OverheadTime: 76.464ms
         - PeakDriverQueueSize: 136
           - __MAX_OF_PeakDriverQueueSize: 23
           - __MIN_OF_PeakDriverQueueSize: 12
         - PendingTime: 4s791ms
           - __MAX_OF_PendingTime: 4s816ms
           - __MIN_OF_PendingTime: 4s761ms
           - InputEmptyTime: 7.763ms
             - __MAX_OF_InputEmptyTime: 24.579ms
             - __MIN_OF_InputEmptyTime: 1.698ms
             - FirstInputEmptyTime: 116.666us
               - __MAX_OF_FirstInputEmptyTime: 138.944us
               - __MIN_OF_FirstInputEmptyTime: 45.193us
             - FollowupInputEmptyTime: 7.646ms
               - __MAX_OF_FollowupInputEmptyTime: 24.440ms
               - __MIN_OF_FollowupInputEmptyTime: 1.559ms
           - OutputFullTime: 4s427ms
             - __MAX_OF_OutputFullTime: 4s887ms
             - __MIN_OF_OutputFullTime: 3s839ms
           - PendingFinishTime: 421.362ms
             - __MAX_OF_PendingFinishTime: 969.505ms
             - __MIN_OF_PendingFinishTime: 0ns
           - PreconditionBlockTime: 0ns
         - ScheduleCount: 2.750K (2750)
           - __MAX_OF_ScheduleCount: 351
           - __MIN_OF_ScheduleCount: 338
         - ScheduleTime: 355.200ms
           - __MAX_OF_ScheduleTime: 404.774ms
           - __MIN_OF_ScheduleTime: 291.355ms
         - TotalDegreeOfParallelism: 8
         - YieldByLocalWait: 0
         - YieldByPreempt: 0
         - YieldByTimeLimit: 289
           - __MAX_OF_YieldByTimeLimit: 38
           - __MIN_OF_YieldByTimeLimit: 34
        EXCHANGE_SINK (plan_node_id=2):
          CommonMetrics:
             - CloseTime: 782ns
               - __MAX_OF_CloseTime: 4.006us
               - __MIN_OF_CloseTime: 181ns
             - OperatorAllocatedMemoryUsage: 23.898 GB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 3.119 GB
               - __MIN_OF_OperatorAllocatedMemoryUsage: 2.893 GB
             - OperatorDeallocatedMemoryUsage: 40.580 GB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 5.319 GB
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 4.905 GB
             - OperatorPeakMemoryUsage: 732.266 KB
               - __MAX_OF_OperatorPeakMemoryUsage: 840.016 KB
               - __MIN_OF_OperatorPeakMemoryUsage: 649.016 KB
             - OperatorTotalTime: 6s374ms
               - __MAX_OF_OperatorTotalTime: 6s416ms
               - __MIN_OF_OperatorTotalTime: 6s337ms
             - PrepareTime: 16.668us
               - __MAX_OF_PrepareTime: 21.228us
               - __MIN_OF_PrepareTime: 14.140us
             - PullChunkNum: 0
             - PullRowNum: 0
             - PullTotalTime: 0ns
             - PushChunkNum: 33.509K (33509)
               - __MAX_OF_PushChunkNum: 4.380K (4380)
               - __MIN_OF_PushChunkNum: 4.055K (4055)
             - PushRowNum: 137.253M (137252864)
               - __MAX_OF_PushRowNum: 17.940M (17940480)
               - __MIN_OF_PushRowNum: 16.609M (16609280)
             - PushTotalTime: 6s374ms
               - __MAX_OF_PushTotalTime: 6s416ms
               - __MIN_OF_PushTotalTime: 6s337ms
             - SetFinishedTime: 21ns
               - __MAX_OF_SetFinishedTime: 32ns
               - __MIN_OF_SetFinishedTime: 16ns
             - SetFinishingTime: 738ns
               - __MAX_OF_SetFinishingTime: 1.879us
               - __MIN_OF_SetFinishingTime: 154ns
          UniqueMetrics:
             - ChannelNum: 10
             - DestFragments: f0d556f6409211ee-87f302420a080273, f0d556f6409211ee-87f302420a080273, f0d556f6409211ee-87f302420a080273, f0d556f6409211ee-87f302420a080273, f0d556f6409211ee-87f302420a080273, f0d556f6409211ee-87f302420a080273, f0d556f6409211ee-87f302420a080273, f0d556f6409211ee-87f302420a080273, f0d556f6409211ee-87f302420a080273, f0d556f6409211ee-87f302420a080273
             - DestID: 2
             - PartType: BUCKET_SHUFFLE_HASH_PARTITIONED
             - PipelineLevelShuffle: Yes
             - ShuffleNumPerChannel: 1
             - TotalShuffleNum: 10
             - BytesPassThrough: 20.372 GB
               - __MAX_OF_BytesPassThrough: 2.661 GB
               - __MIN_OF_BytesPassThrough: 2.464 GB
             - BytesSent: 0.000 B
             - CompressTime: 0ns
             - NetworkBandwidth: 0.000 B/sec
             - NetworkTime: 725.748ms
             - OverallThroughput: 0.000 B/sec
             - OverallTime: 11s698ms
             - RequestSent: 0
             - RpcAvgTime: 930.375us
             - RpcCount: 33.501K (33501)
             - SerializeChunkTime: 0ns
             - ShuffleHashTime: 1s527ms
               - __MAX_OF_ShuffleHashTime: 1s590ms
               - __MIN_OF_ShuffleHashTime: 1s467ms
             - UncompressedBytes: 0.000 B
             - WaitTime: 3s901ms
        CHUNK_ACCUMULATE (plan_node_id=1):
          CommonMetrics:
             - CloseTime: 171ns
               - __MAX_OF_CloseTime: 239ns
               - __MIN_OF_CloseTime: 130ns
             - OperatorAllocatedMemoryUsage: 2.500 KB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 2.500 KB
               - __MIN_OF_OperatorAllocatedMemoryUsage: 0.000 B
             - OperatorDeallocatedMemoryUsage: 11.340 MB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 1.787 MB
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 34.219 KB
             - OperatorPeakMemoryUsage: 0.000 B
             - OperatorTotalTime: 5.878ms
               - __MAX_OF_OperatorTotalTime: 15.220ms
               - __MIN_OF_OperatorTotalTime: 2.746ms
             - PrepareTime: 5.225us
               - __MAX_OF_PrepareTime: 7.371us
               - __MIN_OF_PrepareTime: 4.635us
             - PullChunkNum: 33.509K (33509)
               - __MAX_OF_PullChunkNum: 4.380K (4380)
               - __MIN_OF_PullChunkNum: 4.055K (4055)
             - PullRowNum: 137.253M (137252864)
               - __MAX_OF_PullRowNum: 17.940M (17940480)
               - __MIN_OF_PullRowNum: 16.609M (16609280)
             - PullTotalTime: 2.050ms
               - __MAX_OF_PullTotalTime: 12.406ms
               - __MIN_OF_PullTotalTime: 508.355us
             - PushChunkNum: 33.516K (33516)
               - __MAX_OF_PushChunkNum: 4.380K (4380)
               - __MIN_OF_PushChunkNum: 4.056K (4056)
             - PushRowNum: 137.282M (137281536)
               - __MAX_OF_PushRowNum: 17.940M (17940480)
               - __MIN_OF_PushRowNum: 16.613M (16613376)
             - PushTotalTime: 3.821ms
               - __MAX_OF_PushTotalTime: 8.791ms
               - __MIN_OF_PushTotalTime: 2.232ms
             - SetFinishedTime: 5.804us
               - __MAX_OF_SetFinishedTime: 9.430us
               - __MIN_OF_SetFinishedTime: 19ns
             - SetFinishingTime: 186ns
               - __MAX_OF_SetFinishingTime: 748ns
               - __MIN_OF_SetFinishingTime: 33ns
          UniqueMetrics:
        OLAP_SCAN (plan_node_id=1):
          CommonMetrics:
             - CloseTime: 616.005us
               - __MAX_OF_CloseTime: 1.056ms
               - __MIN_OF_CloseTime: 392.161us
             - JoinRuntimeFilterEvaluate: 0
             - JoinRuntimeFilterHashTime: 0ns
             - JoinRuntimeFilterInputRows: 0
             - JoinRuntimeFilterOutputRows: 0
             - JoinRuntimeFilterTime: 0ns
             - OperatorAllocatedMemoryUsage: 119.221 GB
               - __MAX_OF_OperatorAllocatedMemoryUsage: 15.404 GB
               - __MIN_OF_OperatorAllocatedMemoryUsage: 14.393 GB
             - OperatorDeallocatedMemoryUsage: 66.609 GB
               - __MAX_OF_OperatorDeallocatedMemoryUsage: 8.625 GB
               - __MIN_OF_OperatorDeallocatedMemoryUsage: 8.045 GB
             - OperatorPeakMemoryUsage: 6.676 GB
               - __MAX_OF_OperatorPeakMemoryUsage: 6.929 GB
               - __MIN_OF_OperatorPeakMemoryUsage: 6.436 GB
             - OperatorTotalTime: 79.934ms
               - __MAX_OF_OperatorTotalTime: 115.855ms
               - __MIN_OF_OperatorTotalTime: 61.426ms
             - PrepareTime: 10.042us
               - __MAX_OF_PrepareTime: 13.346us
               - __MIN_OF_PrepareTime: 7.166us
             - PullChunkNum: 33.516K (33516)
               - __MAX_OF_PullChunkNum: 4.380K (4380)
               - __MIN_OF_PullChunkNum: 4.056K (4056)
             - PullRowNum: 137.282M (137281536)
               - __MAX_OF_PullRowNum: 17.940M (17940480)
               - __MIN_OF_PullRowNum: 16.613M (16613376)
             - PullTotalTime: 79.317ms
               - __MAX_OF_PullTotalTime: 115.416ms
               - __MIN_OF_PullTotalTime: 60.611ms
             - PushChunkNum: 0
             - PushRowNum: 0
             - PushTotalTime: 0ns
             - RuntimeBloomFilterNum: 0
             - RuntimeInFilterNum: 0
             - SetFinishedTime: 32ns
               - __MAX_OF_SetFinishedTime: 139ns
               - __MIN_OF_SetFinishedTime: 16ns
             - SetFinishingTime: 854ns
               - __MAX_OF_SetFinishingTime: 2.175us
               - __MIN_OF_SetFinishingTime: 427ns
          UniqueMetrics:
             - BufferUnplugThreshold: 32
             - MorselQueueType: fixed_morsel_queue
             - Predicates: 1: txid IS NOT NULL
             - Rollup: tx_in
             - SharedScan: False
             - Table: tx_in
             - BufferUnplugCount: 8
               - __MAX_OF_BufferUnplugCount: 1
               - __MIN_OF_BufferUnplugCount: 1
             - BytesRead: 20.668 GB
               - __MAX_OF_BytesRead: 2.665 GB
               - __MIN_OF_BytesRead: 1.247 GB
             - CachedPagesNum: 16
               - __MAX_OF_CachedPagesNum: 4
               - __MIN_OF_CachedPagesNum: 0
             - ChunkBufferCapacity: 512
             - CompressedBytesRead: 11.880 GB
               - __MAX_OF_CompressedBytesRead: 1.530 GB
               - __MIN_OF_CompressedBytesRead: 732.828 MB
             - DefaultChunkBufferCapacity: 512
             - IOTaskExecTime: 3s968ms
               - __MAX_OF_IOTaskExecTime: 4s814ms
               - __MIN_OF_IOTaskExecTime: 2s117ms
               - CreateSegmentIter: 62.529us
                 - __MAX_OF_CreateSegmentIter: 174.286us
                 - __MIN_OF_CreateSegmentIter: 33.769us
               - DictDecode: 505.322ms
                 - __MAX_OF_DictDecode: 651.243ms
                 - __MIN_OF_DictDecode: 281.977ms
               - GetDelVec: 0ns
               - GetDeltaColumnGroup: 4.252us
                 - __MAX_OF_GetDeltaColumnGroup: 10.631us
                 - __MIN_OF_GetDeltaColumnGroup: 1.526us
               - GetRowsets: 85ns
                 - __MAX_OF_GetRowsets: 170ns
                 - __MIN_OF_GetRowsets: 57ns
               - IOTime: 785.920ms
                 - __MAX_OF_IOTime: 1s1ms
                 - __MIN_OF_IOTime: 409.515ms
               - LateMaterialize: 3.367ms
                 - __MAX_OF_LateMaterialize: 7.111ms
                 - __MIN_OF_LateMaterialize: 319.671us
               - ReadPKIndex: 0ns
               - SegmentInit: 3.401ms
                 - __MAX_OF_SegmentInit: 4.633ms
                 - __MIN_OF_SegmentInit: 977.226us
                 - BitmapIndexFilter: 0ns
                 - BitmapIndexFilterRows: 0
                 - BitmapIndexIteratorInit: 4.878us
                   - __MAX_OF_BitmapIndexIteratorInit: 10.675us
                   - __MIN_OF_BitmapIndexIteratorInit: 1.159us
                 - BloomFilterFilter: 1.645us
                   - __MAX_OF_BloomFilterFilter: 2.738us
                   - __MIN_OF_BloomFilterFilter: 173ns
                 - BloomFilterFilterRows: 0
                 - ColumnIteratorInit: 61.858us
                   - __MAX_OF_ColumnIteratorInit: 94.641us
                   - __MIN_OF_ColumnIteratorInit: 7.118us
                 - SegmentRuntimeZoneMapFilterRows: 0
                 - SegmentZoneMapFilterRows: 0
                 - ShortKeyFilter: 120.852us
                   - __MAX_OF_ShortKeyFilter: 183.529us
                   - __MIN_OF_ShortKeyFilter: 36.605us
                 - ShortKeyFilterRows: 0
                 - ZoneMapIndexFilterRows: 0
                 - ZoneMapIndexFiter: 3.107ms
                   - __MAX_OF_ZoneMapIndexFiter: 4.278ms
                   - __MIN_OF_ZoneMapIndexFiter: 909.955us
               - SegmentRead: 3s344ms
                 - __MAX_OF_SegmentRead: 4s99ms
                 - __MIN_OF_SegmentRead: 1s762ms
                 - BlockFetch: 3s322ms
                   - __MAX_OF_BlockFetch: 4s74ms
                   - __MIN_OF_BlockFetch: 1s752ms
                 - BlockFetchCount: 33.968K (33968)
                   - __MAX_OF_BlockFetchCount: 4.383K (4383)
                   - __MIN_OF_BlockFetchCount: 2.048K (2048)
                 - BlockSeek: 1.373ms
                   - __MAX_OF_BlockSeek: 2.314ms
                   - __MIN_OF_BlockSeek: 80.437us
                 - BlockSeekCount: 306.884K (306884)
                   - __MAX_OF_BlockSeekCount: 39.571K (39571)
                   - __MIN_OF_BlockSeekCount: 18.512K (18512)
                 - ChunkCopy: 240.643us
                   - __MAX_OF_ChunkCopy: 287.127us
                   - __MIN_OF_ChunkCopy: 132.426us
                 - DecompressT: 1s32ms
                   - __MAX_OF_DecompressT: 1s278ms
                   - __MIN_OF_DecompressT: 547.882ms
                 - DelVecFilterRows: 0
                 - PredFilter: 4.280ms
                   - __MAX_OF_PredFilter: 6.194ms
                   - __MIN_OF_PredFilter: 2.324ms
                 - PredFilterRows: 0
                 - RowsetsReadCount: 10
                   - __MAX_OF_RowsetsReadCount: 1
                   - __MIN_OF_RowsetsReadCount: 1
                 - SegmentsReadCount: 60
                   - __MAX_OF_SegmentsReadCount: 6
                   - __MIN_OF_SegmentsReadCount: 6
                 - TotalColumnsDataPageCount: 407.669K (407669)
                   - __MAX_OF_TotalColumnsDataPageCount: 51.054K (51054)
                   - __MIN_OF_TotalColumnsDataPageCount: 25.465K (25465)
             - IOTaskWaitTime: 18.802ms
               - __MAX_OF_IOTaskWaitTime: 42.555ms
               - __MIN_OF_IOTaskWaitTime: 8.464ms
             - MorselsCount: 10
               - __MAX_OF_MorselsCount: 2
               - __MIN_OF_MorselsCount: 1
             - PeakChunkBufferSize: 512
             - PeakIOTasks: 1
               - __MAX_OF_PeakIOTasks: 2
               - __MIN_OF_PeakIOTasks: 1
             - PeakScanTaskQueueSize: 12
               - __MAX_OF_PeakScanTaskQueueSize: 2
               - __MIN_OF_PeakScanTaskQueueSize: 1
             - PushdownPredicates: 1
             - RawRowsRead: 139.133M (139132928)
               - __MAX_OF_RawRowsRead: 17.953M (17952768)
               - __MIN_OF_RawRowsRead: 8.389M (8388608)
             - ReadPagesNum: 307.021K (307021)
               - __MAX_OF_ReadPagesNum: 39.589K (39589)
               - __MIN_OF_ReadPagesNum: 18.520K (18520)
             - RowsRead: 139.133M (139132928)
               - __MAX_OF_RowsRead: 17.953M (17952768)
               - __MIN_OF_RowsRead: 8.389M (8388608)
             - ScanTime: 3s987ms
               - __MAX_OF_ScanTime: 4s834ms
               - __MIN_OF_ScanTime: 2s159ms
             - SubmitTaskCount: 586
               - __MAX_OF_SubmitTaskCount: 78
               - __MIN_OF_SubmitTaskCount: 69
             - TabletCount: 10
             - UncompressedBytesRead: 18.390 GB
               - __MAX_OF_UncompressedBytesRead: 2.372 GB
               - __MIN_OF_UncompressedBytesRead: 1.108 GB

How do you know if spill was enabled for this query?

set enable_spill=true; set spill_mode="force";

and if we enable_spill. the operator name should be SPILLABLE_HASH_JOIN_BUILD/PROBE

Any one know the reason for blank Finished Queries in the web server (GUI)

You have to find the exact FE. If you have multiple FEs, this page just show queries send to this FE, and some write operation will redirect to leader FE.