| exclusive | inclusive | rows x | rows | loops | node |
|---|---|---|---|---|---|
| 0.000 | 0.000 | ↓ 0.0 |
→
Unique (cost=11781052.85..12001629.17 rows=5624600 width=37) (actual time=.. rows= loops=) |
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=11781052.85..11836196.93 rows=22057632 width=37) (actual time=.. rows= loops=)
|
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=397033.35..7539664.05 rows=22057632 width=37) (actual time=.. rows= loops=)
|
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Merge Left Join (cost=397016.34..6290301.66 rows=44115265 width=37) (actual time=.. rows= loops=)
|
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Merge Join (cost=20868.68..5781521.08 rows=44115265 width=33) (actual time=.. rows= loops=)
|
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using cdseml_m_new_pkey1 on cdseml_m ce (cost=0.00..1107554.31 rows=20368035 width=13) (actual time=.. rows= loops=) |
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using lsteml_m_emal_id_idx_new on lsteml_m le (cost=0.00..4083015.31 rows=44115265 width=33) (actual time=.. rows= loops=) |
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Materialize (cost=376147.67..376947.36 rows=159939 width=30) (actual time=.. rows= loops=) |
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=376147.67..376547.51 rows=159939 width=30) (actual time=.. rows= loops=)
|
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on pe2_fast_lookup fl (cost=0.00..359041.21 rows=159939 width=30) (actual time=.. rows= loops=)
|
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=14.50..14.50 rows=200 width=32) (actual time=.. rows= loops=) |
||
| 0.000 | 0.000 | ↓ 0.0 |
→
HashAggregate (cost=12.50..14.50 rows=200 width=32) (actual time=.. rows= loops=) |
||
| 0.000 | 0.000 | ↓ 0.0 |
→
Function Scan on regexp_split_to_table (cost=0.00..10.00 rows=1000 width=32) (actual time=.. rows= loops=) |