Changes between Version 92 and Version 93 of QueryOptimization
- Timestamp:
- 06/30/26 23:42:27 (5 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
QueryOptimization
v92 v93 177 177 }}} 178 178 179 ||= QUERY PLAN = = = = =||179 ||= QUERY PLAN =|| 180 180 ||Gather (cost\=110699.49..459840.66 rows\=4 width\=145) (actual time\=370.701..375.993 rows\=0.00 loops\=1)|| 181 181 ||Workers Planned 2|| … … 245 245 }}} 246 246 247 ||= QUERY PLAN = = =||247 ||= QUERY PLAN =|| 248 248 ||Insert on ""Ticket_Order_Item"" (cost\=0.00..0.01 rows\=0 width\=0) (actual time\=0.049..0.049 rows\=0.00 loops\=1)|| 249 249 ||Buffers shared hit\=5 dirtied\=1|| … … 264 264 }}} 265 265 266 ||= QUERY PLAN = = =||266 ||= QUERY PLAN =|| 267 267 ||Update on ""Ticket_Order_Item"" (cost\=0.44..8.46 rows\=0 width\=0) (actual time\=0.085..0.086 rows\=0.00 loops\=1)|| 268 268 ||Buffers shared hit\=7|| … … 316 316 }}} 317 317 318 ||= QUERY PLAN = = =||318 ||= QUERY PLAN =|| 319 319 ||Nested Loop Left Join (cost\=3.59..75.95 rows\=4 width\=145) (actual time\=1.244..1.247 rows\=0.00 loops\=1)|| 320 320 ||Buffers shared hit\=1 read\=10|| … … 358 358 }}} 359 359 360 ||= QUERY PLAN = = =||360 ||= QUERY PLAN =|| 361 361 ||Insert on ""Ticket_Order_Item"" (cost\=0.00..0.01 rows\=0 width\=0) (actual time\=0.273..0.273 rows\=0.00 loops\=1)|| 362 362 ||Buffers shared hit\=11 read\=3 dirtied\=3|| … … 376 376 }}} 377 377 378 ||= QUERY PLAN = = =||378 ||= QUERY PLAN =|| 379 379 ||Update on ""Ticket_Order_Item"" (cost\=0.44..8.46 rows\=0 width\=0) (actual time\=0.102..0.103 rows\=0.00 loops\=1)|| 380 380 ||Buffers shared hit\=7||
