# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 25,937.836 | 25,937.836 | ↓ 60,228.0 | 60,228 | 1 |
→
CTE Scan on dbg_mrt (cost=918.25..918.27 rows=1 width=52) (actual time=25,811.704..25,937.836 rows=60,228 loops=1)
|
2. |
CTE dbg_mrt |
|||||
3. | 75.322 | 25,900.626 | ↓ 110,790.0 | 110,790 | 1 |
→
GroupAggregate (cost=918.21..918.25 rows=1 width=75) (actual time=25,811.695..25,900.626 rows=110,790 loops=1)
|
4. | 275.129 | 25,825.304 | ↓ 150,533.0 | 150,533 | 1 |
→
Sort (cost=918.21..918.22 rows=1 width=54) (actual time=25,811.675..25,825.304 rows=150,533 loops=1)
|
5. | 7,233.106 | 25,550.175 | ↓ 150,533.0 | 150,533 | 1 |
→
Nested Loop (cost=1.50..918.20 rows=1 width=54) (actual time=0.294..25,550.175 rows=150,533 loops=1)
|
6. | 1,978.233 | 16,809.201 | ↓ 753,934.0 | 753,934 | 1 |
→
Nested Loop (cost=1.50..915.76 rows=1 width=72) (actual time=0.283..16,809.201 rows=753,934 loops=1) |
7. | 337.526 | 1,671.908 | ↓ 2,631,812.0 | 2,631,812 | 1 |
→
Nested Loop (cost=0.56..910.52 rows=1 width=34) (actual time=0.062..1,671.908 rows=2,631,812 loops=1) |
8. | 0.014 | 0.014 | ↑ 1.0 | 32 | 1 |
→
Seq Scan on uit_tuib02 b02_1 (cost=0.00..1.32 rows=32 width=132) (actual time=0.006..0.014 rows=32 loops=1) |
9. | 1,334.368 | 1,334.368 | ↓ 6,853.7 | 82,244 | 32 |
→
Index Scan using uit_tuil02_staging_pkey1 on uit_tuil02 l02 (cost=0.56..28.29 rows=12 width=52) (actual time=0.036..41.699 rows=82,244 loops=32)
|
10. | 0.000 | 13,159.060 | ↓ 0.0 | 0 | 2,631,812 |
→
Bitmap Heap Scan on uit_tuil09 l09 (cost=0.94..5.12 rows=12 width=49) (actual time=0.005..0.005 rows=0 loops=2,631,812)
|
11. | 0.000 | 13,159.060 | ↓ 0.0 | 0 | 2,631,812 |
→
BitmapOr (cost=0.94..0.94 rows=12 width=0) (actual time=0.005..0.005 rows=0 loops=2,631,812) |
12. | 10,527.248 | 10,527.248 | ↓ 0.0 | 0 | 2,631,812 |
→
Bitmap Index Scan on uit_tuil09_staging_sachnr_idx (cost=0.00..0.47 rows=6 width=0) (actual time=0.004..0.004 rows=0 loops=2,631,812)
|
13. | 2,631.812 | 2,631.812 | ↓ 0.0 | 0 | 2,631,812 |
→
Bitmap Index Scan on uit_tuil09_staging_sachnr_idx (cost=0.00..0.47 rows=6 width=0) (actual time=0.001..0.001 rows=0 loops=2,631,812)
|
14. | 1,507.868 | 1,507.868 | ↑ 1.0 | 32 | 753,934 |
→
Seq Scan on uit_tuib02 b02 (cost=0.00..1.32 rows=32 width=132) (actual time=0.000..0.002 rows=32 loops=753,934) |
Planning time | : | 1.584 ms |
---|---|---|
Execution time | : | 25,941.850 ms |