explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BO0

Settings
# 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=)

  • Filter: (lvl_2_prod_name = ANY ('{"Strategic Networking","Core Data Networking"}'::text[]))
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=)

  • Index Cond: (nasp_id = cir.nasp_id)
4.          

SubPlan (forNested 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=)

  • Filter: (network = 'VZB'::text)
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=)

  • Filter: (network = 'VZT'::text)
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=)