Query e141b0860377a3ae:a108a2de00000000

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:30:02.804 2025-09-01 17:30:02.938 134.031ms 0 74.32 MB 358.63 MB 5 / 5 ( 100%) 4 / 4 ( 100%) 5.70 KB 318.00 B 1 root.default
Last updated:

Timeline

Query Compilation: 4.747ms
   - Metadata of all 1 tables cached: 833.948us (833.948us)
   - Analysis finished: 1.413ms (579.638us)
   - Authorization finished (noop): 1.541ms (127.558us)
   - Value transfer graph computed: 1.614ms (73.616us)
   - Single node plan created: 3.183ms (1.568ms)
   - Runtime filters computed: 3.323ms (139.963us)
   - Distributed plan created: 3.342ms (19.374us)
   - Lineage info computed: 3.385ms (42.399us)
   - Planning finished: 4.747ms (1.362ms)
Query Timeline: 164.959ms
   - Query submitted: 48.169us (48.169us)
   - Planning finished: 5.672ms (5.624ms)
   - Submit for admission: 5.904ms (231.648us)
   - Completed admission: 16.444ms (10.540ms)
   - Ready to start on 1 backends: 16.601ms (156.657us)
   - All 1 execution backends (4 fragment instances) started: 17.740ms (1.139ms)
   - Rows available: 88.215ms (70.474ms)
   - First row fetched: 130.833ms (42.618ms)
   - Last row fetched: 130.837ms (4.067us)
   - Released admission control resources: 134.028ms (3.191ms)
   - Unregister query: 161.036ms (27.007ms)

Exec Summary

Operator                        #Hosts  #Inst   Avg Time   Max Time  #Rows  Est. #Rows   Peak Mem  Est. Peak Mem  Detail                                                                           
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
F05:ROOT                             1      1   44.796us   44.796us                       4.01 MB        4.00 MB                                                                                   
09:EXCHANGE                          1      1   14.361us   14.361us      1           2   16.00 KB       16.00 KB  UNPARTITIONED                                                                    
F04:EXCHANGE SENDER                  1      1   85.037us   85.037us                       9.87 KB       64.00 KB                                                                                   
08:AGGREGATE                         1      1  674.557us  674.557us      1           2   34.02 MB      128.00 MB  FINALIZE                                                                         
07:EXCHANGE                          1      1   13.775us   13.775us      1           2   16.00 KB       16.00 KB  HASH(C_0)                                                                        
F03:EXCHANGE SENDER                  1      1   74.974us   74.974us                       9.87 KB       64.00 KB                                                                                   
05:AGGREGATE                         1      1  312.962us  312.962us      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  715.328us  715.328us      0           1    2.01 MB        1.94 MB  LEFT ANTI JOIN, BROADCAST                                                        
|  |--06:EXCHANGE                    1      1   14.352us   14.352us      2           2   32.00 KB       16.00 KB  BROADCAST                                                                        
|  |  F02:EXCHANGE SENDER            1      1  109.277us  109.277us                       6.36 KB      548.00 KB                                                                                   
|  |  01:SCAN S3                     1      1   20.736ms   20.736ms      2           2  138.02 KB       32.00 MB  default.people-POSITION-DELETE-01 c_64656661756c745f70656f706c65-position-delete 
|  00:SCAN S3                        1      1    5.694ms    5.694ms      0           1   64.00 KB       64.00 MB  default.people c_64656661756c745f70656f706c65                                    
03:SCAN S3                           1      1   24.413ms   24.413ms      1           1  137.00 KB       64.00 MB  default.people c_64656661756c745f70656f706c65