Query cf4d6bb50fc9bba7:118d247500000000

User: psantos

State: FINISHED

Status: OK

Default Db Query Type Start Time End Time Duration Queued Duration Mem Usage Mem Estimate Scan Progress Query Progress Bytes Read Bytes Sent # rows fetched Resource Pool
default QUERY 2025-09-01 17:29:52.454 2025-09-01 17:29:52.588 133.216ms 0 74.31 MB 358.63 MB 5 / 5 ( 100%) 4 / 4 ( 100%) 5.73 KB 318.00 B 1 root.default
Last updated:

Timeline

Query Compilation: 4.572ms
   - Metadata of all 1 tables cached: 856.394us (856.394us)
   - Analysis finished: 1.350ms (493.928us)
   - Authorization finished (noop): 1.470ms (119.894us)
   - Value transfer graph computed: 1.541ms (71.185us)
   - Single node plan created: 3.048ms (1.507ms)
   - Runtime filters computed: 3.180ms (131.339us)
   - Distributed plan created: 3.199ms (19.673us)
   - Lineage info computed: 3.241ms (41.416us)
   - Planning finished: 4.572ms (1.331ms)
Query Timeline: 161.844ms
   - Query submitted: 56.439us (56.439us)
   - Planning finished: 5.444ms (5.388ms)
   - Submit for admission: 5.648ms (203.886us)
   - Completed admission: 18.573ms (12.925ms)
   - Ready to start on 1 backends: 18.771ms (198.283us)
   - All 1 execution backends (4 fragment instances) started: 19.667ms (896.129us)
   - Rows available: 92.854ms (73.186ms)
   - First row fetched: 130.112ms (37.257ms)
   - Last row fetched: 130.116ms (3.687us)
   - Released admission control resources: 133.213ms (3.097ms)
   - Unregister query: 158.242ms (25.028ms)

Exec Summary

Operator                        #Hosts  #Inst   Avg Time   Max Time  #Rows  Est. #Rows   Peak Mem  Est. Peak Mem  Detail                                                                           
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
F05:ROOT                             1      1   68.389us   68.389us                       4.01 MB        4.00 MB                                                                                   
09:EXCHANGE                          1      1   10.884us   10.884us      1           2   16.00 KB       16.00 KB  UNPARTITIONED                                                                    
F04:EXCHANGE SENDER                  1      1   83.559us   83.559us                       9.87 KB       64.00 KB                                                                                   
08:AGGREGATE                         1      1    1.407ms    1.407ms      1           2   34.02 MB      128.00 MB  FINALIZE                                                                         
07:EXCHANGE                          1      1   13.887us   13.887us      1           2   16.00 KB       16.00 KB  HASH(C_0)                                                                        
F03:EXCHANGE SENDER                  1      1   58.851us   58.851us                       9.87 KB       64.00 KB                                                                                   
05:AGGREGATE                         1      1  801.126us  801.126us      1           2   34.08 MB      128.00 MB  STREAMING                                                                        
04:UNION                             1      1    0.000ns    0.000ns      1           2          0              0                                                                                   
|--02:DELETE EVENTS HASH JOIN        1      1  659.531us  659.531us      0           1    2.01 MB        1.94 MB  LEFT ANTI JOIN, BROADCAST                                                        
|  |--06:EXCHANGE                    1      1   21.709us   21.709us      2           2   24.00 KB       16.00 KB  BROADCAST                                                                        
|  |  F02:EXCHANGE SENDER            1      1  145.497us  145.497us                       6.36 KB      548.00 KB                                                                                   
|  |  01:SCAN S3                     1      1   30.774ms   30.774ms      2           2   89.02 KB       32.00 MB  default.people-POSITION-DELETE-01 c_64656661756c745f70656f706c65-position-delete 
|  00:SCAN S3                        1      1    7.430ms    7.430ms      0           1   64.00 KB       64.00 MB  default.people c_64656661756c745f70656f706c65                                    
03:SCAN S3                           1      1   23.087ms   23.087ms      1           1  129.02 KB       64.00 MB  default.people c_64656661756c745f70656f706c65