# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=6.11..92,089,589.18 rows=9,907,941,936 width=122) (actual rows= loops=) |
||
2. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on tbl_vesdw_dw_circuit_integrated cir (cost=0.00..301,846.60 rows=667,333 width=36) (actual rows= loops=)
|
||
3. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using tbl_business_identifiers_nasp_idx on tbl_business_identifiers biz (cost=0.43..16.94 rows=925 width=1) (actual rows= loops=)
|
||
4. |
SubPlan (for Nested Loop) |
|||||
5. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on source_system_mapping (cost=0.00..1.84 rows=46 width=4) (actual rows= loops=)
|
||
6. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on source_system_mapping source_system_mapping_1 (cost=0.00..1.84 rows=20 width=4) (actual rows= loops=)
|
||
7. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on source_system_mapping source_system_mapping_2 (cost=0.00..1.84 rows=1 width=4) (actual rows= loops=) |