Query be4e7100835021e7:a7a24f3e00000000

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-18 18:19:36.023 2025-09-18 18:19:36.506 483.314ms 0 23.19 MB 183.61 MB 9 / 9 ( 100%) 3 / 3 ( 100%) 1.49 MB 8.11 MB 9994 root.default
Last updated:

Timeline

Query Compilation: 5.225ms
   - Metadata of all 1 tables cached: 1.575ms (1.575ms)
   - Analysis finished: 2.231ms (655.767us)
   - Authorization finished (noop): 2.372ms (141.274us)
   - Value transfer graph computed: 2.440ms (67.553us)
   - Single node plan created: 3.106ms (666.293us)
   - Runtime filters computed: 3.210ms (104.143us)
   - Distributed plan created: 3.233ms (22.584us)
   - Lineage info computed: 3.318ms (85.161us)
   - Planning finished: 5.225ms (1.906ms)
Query Timeline: 533.058ms
   - Query submitted: 47.561us (47.561us)
   - Planning finished: 6.347ms (6.300ms)
   - Submit for admission: 6.663ms (315.874us)
   - Completed admission: 16.813ms (10.149ms)
   - Ready to start on 1 backends: 16.948ms (135.826us)
   - All 1 execution backends (3 fragment instances) started: 18.298ms (1.349ms)
   - Rows available: 171.291ms (152.992ms)
   - First row fetched: 235.721ms (64.430ms)
   - Last row fetched: 480.738ms (245.016ms)
   - Released admission control resources: 483.312ms (2.573ms)
   - Unregister query: 529.593ms (46.281ms)

Exec Summary

Operator                        #Hosts  #Inst   Avg Time   Max Time   #Rows  Est. #Rows   Peak Mem  Est. Peak Mem  Detail                                                                           
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
F04:ROOT                             1      1    3.576ms    3.576ms                        6.01 MB        7.21 MB                                                                                   
06:EXCHANGE                          1      1  185.302us  185.302us   9.99K      30.01K    3.02 MB        7.46 MB  UNPARTITIONED                                                                    
F03:EXCHANGE SENDER                  1      1    4.700ms    4.700ms                        2.24 MB        1.00 MB                                                                                   
04:UNION                             1      1    0.000ns    0.000ns   9.99K      30.01K          0              0                                                                                   
|--02:DELETE EVENTS HASH JOIN        1      1    6.608ms    6.608ms       0      20.02K    5.18 MB        4.75 MB  LEFT ANTI JOIN, BROADCAST                                                        
|  |--05:EXCHANGE                    1      1  225.536us  225.536us  20.02K      20.02K    4.94 MB        2.65 MB  BROADCAST                                                                        
|  |  F02:EXCHANGE SENDER            1      1    1.702ms    1.702ms                      274.43 KB      544.00 KB                                                                                   
|  |  01:SCAN S3                     1      1   31.439ms   31.439ms  20.02K      20.02K  859.23 KB       32.00 MB  default.orders-POSITION-DELETE-01 c_64656661756c745f6f7264657273-position-delete 
|  00:SCAN S3                        1      1   78.804ms   78.804ms  20.02K      20.02K    3.58 MB      128.00 MB  default.orders c_64656661756c745f6f7264657273                                    
03:SCAN S3                           1      1  106.059ms  106.059ms   9.99K       9.99K    3.48 MB      128.00 MB  default.orders c_64656661756c745f6f7264657273