explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9YD8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Seq Scan on tbl_vesdw_dw_circuit_integrated cir (cost=5.68..306,857.28 rows=667,333 width=132) (actual rows= loops=)

  • Filter: (lvl_2_prod_name = ANY ('{"Strategic Networking","Core Data Networking"}'::text[]))
2.          

SubPlan (forSeq Scan)

3. 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)
4. 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)
5. 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=)