# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 4,353.459 | 5,149,809.469 | ↓ 0.0 | 0 | 1 |
→
Update on "ITEMPLANNINGDATA" "IPD" (cost=60,266.22..64,179.32 rows=1 width=700) (actual time=5,149,809.469..5,149,809.469 rows=0 loops=1) |
2. | 366.724 | 5,145,456.010 | ↓ 85,949.0 | 85,949 | 1 |
→
Nested Loop (cost=60,266.22..64,179.32 rows=1 width=700) (actual time=2,319,870.718..5,145,456.010 rows=85,949 loops=1) |
3. | 845.377 | 2,320,289.452 | ↓ 85,949.0 | 85,949 | 1 |
→
HashAggregate (cost=60,265.80..60,265.81 rows=1 width=72) (actual time=2,319,837.885..2,320,289.452 rows=85,949 loops=1)
|
4. | 306.668 | 2,319,444.075 | ↓ 85,949.0 | 85,949 | 1 |
→
Nested Loop (cost=1.71..60,265.80 rows=1 width=72) (actual time=0.816..2,319,444.075 rows=85,949 loops=1)
|
5. | 416.443 | 4,187.041 | ↓ 85,949.0 | 85,949 | 1 |
→
Nested Loop (cost=1.29..56,352.84 rows=1 width=50) (actual time=0.336..4,187.041 rows=85,949 loops=1) |
6. | 90.030 | 1,363.208 | ↓ 481,478.0 | 481,478 | 1 |
→
Nested Loop (cost=0.86..56,352.32 rows=1 width=28) (actual time=0.152..1,363.208 rows=481,478 loops=1) |
7. | 0.233 | 0.233 | ↑ 1.0 | 1 | 1 |
→
Index Scan using "I10816RDNB600CIS00" on "PARTNER001" "P" (cost=0.43..2.48 rows=1 width=22) (actual time=0.086..0.233 rows=1 loops=1)
|
8. | 1,272.945 | 1,272.945 | ↓ 1.2 | 481,478 | 1 |
→
Index Scan using "SALESITEM_pkey" on "SALESITEM" "SI" (cost=0.43..52,201.15 rows=414,869 width=38) (actual time=0.063..1,272.945 rows=481,478 loops=1)
|
9. | 2,407.390 | 2,407.390 | ↓ 0.0 | 0 | 481,478 |
→
Index Scan using "ITEM001_pkey" on "ITEM001" "I" (cost=0.43..0.51 rows=1 width=22) (actual time=0.005..0.005 rows=0 loops=481,478)
|
10. | 2,314,950.366 | 2,314,950.366 | ↑ 1.0 | 1 | 85,949 |
→
Index Scan using "I00G2V4F66600CIS" on "ITEMPLANNINGDATA" "IPDA" (cost=0.42..3,912.94 rows=1 width=22) (actual time=18.285..26.934 rows=1 loops=85,949)
|
11. | 2,824,799.834 | 2,824,799.834 | ↑ 1.0 | 1 | 85,949 |
→
Index Scan using "I00G2V4F66600CIS" on "ITEMPLANNINGDATA" "IPD" (cost=0.42..3,913.50 rows=1 width=636) (actual time=21.572..32.866 rows=1 loops=85,949)
|
Planning time | : | 6.108 ms |
---|---|---|
Execution time | : | 5,149,811.185 ms |