Query ff41f38805a70ab0:149ceded00000000

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:29.726 2025-09-18 18:19:30.056 329.584ms 0 0 183.61 MB 0 / 9 ( 0%) 0 / 3 ( 0%) 0 0 2048 root.default
Last updated:

Timeline

Query Compilation: 4.793ms
   - Metadata of all 1 tables cached: 1.349ms (1.349ms)
   - Analysis finished: 1.880ms (530.573us)
   - Authorization finished (noop): 2.055ms (174.877us)
   - Value transfer graph computed: 2.163ms (107.985us)
   - Single node plan created: 2.827ms (664.697us)
   - Runtime filters computed: 2.929ms (101.159us)
   - Distributed plan created: 2.952ms (23.713us)
   - Lineage info computed: 3.040ms (87.860us)
   - Planning finished: 4.793ms (1.753ms)
Query Timeline: 331.111ms
   - Query submitted: 45.155us (45.155us)
   - Planning finished: 5.822ms (5.777ms)
   - Submit for admission: 6.072ms (250.297us)
   - Completed admission: 16.143ms (10.071ms)
   - Ready to start on 1 backends: 16.271ms (128.030us)
   - All 1 execution backends (3 fragment instances) started: 17.666ms (1.394ms)
   - Rows available: 210.374ms (192.708ms)
   - First row fetched: 276.161ms (65.786ms)
   - Execution cancelled: 329.186ms (53.025ms)
   - Released admission control resources: 329.581ms (394.959us)
   - Unregister query: 329.695ms (114.681us)

Exec Summary

Operator                        #Hosts  #Inst  Avg Time  Max Time  #Rows  Est. #Rows  Peak Mem  Est. Peak Mem  Detail                                                                           
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
F04:ROOT                             1      1   0.000ns   0.000ns                            0        7.21 MB                                                                                   
06:EXCHANGE                          1      1   0.000ns   0.000ns      0      30.01K         0        7.46 MB  UNPARTITIONED                                                                    
F03:EXCHANGE SENDER                  1      1   0.000ns   0.000ns                            0        1.00 MB                                                                                   
04:UNION                             1      1   0.000ns   0.000ns      0      30.01K         0              0                                                                                   
|--02:DELETE EVENTS HASH JOIN        1      1   0.000ns   0.000ns      0      20.02K         0        4.75 MB  LEFT ANTI JOIN, BROADCAST                                                        
|  |--05:EXCHANGE                    1      1   0.000ns   0.000ns      0      20.02K         0        2.65 MB  BROADCAST                                                                        
|  |  F02:EXCHANGE SENDER            1      1   0.000ns   0.000ns                            0      544.00 KB                                                                                   
|  |  01:SCAN S3                     1      1   0.000ns   0.000ns      0      20.02K         0       32.00 MB  default.orders-POSITION-DELETE-01 c_64656661756c745f6f7264657273-position-delete 
|  00:SCAN S3                        1      1   0.000ns   0.000ns      0      20.02K         0      128.00 MB  default.orders c_64656661756c745f6f7264657273                                    
03:SCAN S3                           1      1   0.000ns   0.000ns      0       9.99K         0      128.00 MB  default.orders c_64656661756c745f6f7264657273