# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 79.877 | 1,153.078 | ↑ 1.0 | 75 | 1 |
→
Limit (cost=4,398,737.29..4,398,737.85 rows=75 width=49) (actual time=1,073.183..1,153.078 rows=75 loops=1)
|
2. | 0.016 | 1,073.201 | ↑ 16.7 | 75 | 1 |
→
Unique (cost=4,398,737.29..4,398,746.69 rows=1,253 width=49) (actual time=1,073.181..1,073.201 rows=75 loops=1)
|
3. | 0.000 | 1,073.185 | ↑ 15.3 | 82 | 1 |
→
Sort (cost=4,398,737.29..4,398,740.42 rows=1,253 width=49) (actual time=1,073.180..1,073.185 rows=82 loops=1)
|
4. | 86.618 | 1,152.814 | ↑ 5.7 | 221 | 1 |
→
Gather (cost=68,453.81..4,398,672.82 rows=1,253 width=49) (actual time=320.125..1,152.814 rows=221 loops=1)
|
5. | 0.621 | 1,066.196 | ↑ 7.1 | 74 | 3 |
→
Nested Loop Anti Join (cost=67,453.81..4,397,547.52 rows=522 width=49) (actual time=305.573..1,066.196 rows=74 loops=3)
|
6. | 1.177 | 1,065.568 | ↑ 6.4 | 81 | 3 |
→
Nested Loop (cost=67,453.39..4,394,011.09 rows=522 width=82) (actual time=305.549..1,065.568 rows=81 loops=3)
|
7. | 4.309 | 1,064.378 | ↑ 6.4 | 81 | 3 |
→
Nested Loop (cost=67,452.83..4,390,319.71 rows=522 width=66) (actual time=305.516..1,064.378 rows=81 loops=3)
|
8. | 27.470 | 1,060.056 | ↑ 121.3 | 316 | 3 |
→
Hash Join (cost=67,452.27..4,105,707.42 rows=38,335 width=66) (actual time=295.594..1,060.056 rows=316 loops=3)
|
9. | 739.215 | 859.088 | ↑ 19.6 | 27,314 | 3 |
→
Parallel Bitmap Heap Scan on c_orderline orderline0_ (cost=47,258.61..4,064,955.82 rows=535,356 width=99) (actual time=92.834..859.088 rows=27,314 loops=3)
|
10. | 119.873 | 119.873 | ↓ 1.1 | 1,397,419 | 1 |
→
Bitmap Index Scan on em_oborpre_ordline_org (cost=0.00..46,937.39 rows=1,291,310 width=0) (actual time=119.873..119.873 rows=1,397,419 loops=1)
|
11. | 46.424 | 173.498 | ↓ 1.0 | 188,948 | 3 |
→
Hash (cost=16,458.06..16,458.06 rows=183,888 width=33) (actual time=173.497..173.498 rows=188,948 loops=3)
|
12. | 74.518 | 127.074 | ↓ 1.0 | 188,948 | 3 |
→
Nested Loop (cost=110.09..16,458.06 rows=183,888 width=33) (actual time=17.542..127.074 rows=188,948 loops=3)
|
13. | 0.074 | 0.242 | ↑ 1.0 | 2 | 3 |
→
HashAggregate (cost=24.29..24.31 rows=2 width=33) (actual time=0.239..0.242 rows=2 loops=3)
|
14. | 0.168 | 0.168 | ↑ 1.0 | 343 | 3 |
→
Seq Scan on obre_resource obre_resou4_ (cost=0.00..23.43 rows=343 width=33) (actual time=0.016..0.168 rows=343 loops=3)
|
15. | 45.389 | 52.314 | ↓ 42.5 | 94,474 | 6 |
→
Bitmap Heap Scan on m_product product2_ (cost=85.80..8,194.63 rows=2,225 width=66) (actual time=8.740..52.314 rows=94,474 loops=6)
|
16. | 6.925 | 6.925 | ↓ 42.5 | 94,474 | 6 |
→
Bitmap Index Scan on m_product_productcategory (cost=0.00..85.24 rows=2,225 width=0) (actual time=6.925..6.925 rows=94,474 loops=6)
|
17. | 0.013 | 0.013 | ↓ 0.0 | 0 | 947 |
→
Index Scan using c_order_key on c_order order1_ (cost=0.56..7.42 rows=1 width=66) (actual time=0.013..0.013 rows=0 loops=947)
|
18. | 0.013 | 0.013 | ↑ 1.0 | 1 | 242 |
→
Index Scan using c_bpartner_key on c_bpartner businesspa3_ (cost=0.56..7.07 rows=1 width=49) (actual time=0.013..0.013 rows=1 loops=242)
|
19. | 0.007 | 0.007 | ↓ 0.0 | 0 | 242 |
→
Index Only Scan using obre_reservation_cordline_idx on obre_reservation obre_reser5_ (cost=0.42..6.76 rows=1 width=33) (actual time=0.007..0.007 rows=0 loops=242)
|
Planning time | : | 2.178 ms |
---|---|---|
Execution time | : | 1,153.216 ms |