explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VQc7

Settings
# exclusive inclusive rows x rows loops node
1. 0.063 9.086 ↑ 1.0 1,000 1

Limit (cost=6.11..899.40 rows=1,000 width=132) (actual time=0.070..9.086 rows=1,000 loops=1)

2. 1.101 9.023 ↑ 667.3 1,000 1

Nested Loop Semi Join (cost=6.11..596,126.08 rows=667,333 width=132) (actual time=0.070..9.023 rows=1,000 loops=1)

3. 2.850 2.850 ↑ 661.4 1,009 1

Seq Scan on tbl_vesdw_dw_circuit_integrated cir (cost=0.00..301,846.60 rows=667,333 width=40) (actual time=0.009..2.850 rows=1,009 loops=1)

  • Filter: (lvl_2_prod_name = ANY ('{"Strategic Networking","Core Data Networking"}'::text[]))
  • Rows Removed by Filter: 1683
4. 5.045 5.045 ↑ 925.0 1 1,009

Index Only Scan using tbl_business_identifiers_nasp_idx on tbl_business_identifiers (cost=0.43..16.94 rows=925 width=1) (actual time=0.005..0.005 rows=1 loops=1,009)

  • Index Cond: (nasp_id = cir.nasp_id)
  • Heap Fetches: 1000
5.          

SubPlan (forNested Loop Semi Join)

6. 0.013 0.013 ↑ 1.0 46 1

Seq Scan on source_system_mapping (cost=0.00..1.84 rows=46 width=4) (actual time=0.006..0.013 rows=46 loops=1)

  • Filter: (network = 'VZB'::text)
  • Rows Removed by Filter: 21
7. 0.008 0.008 ↑ 1.0 20 1

Seq Scan on source_system_mapping source_system_mapping_1 (cost=0.00..1.84 rows=20 width=4) (actual time=0.005..0.008 rows=20 loops=1)

  • Filter: (network = 'VZT'::text)
  • Rows Removed by Filter: 47
8. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on source_system_mapping source_system_mapping_2 (cost=0.00..1.84 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)

  • Filter: (network = 'XO'::text)
  • Rows Removed by Filter: 66
Planning time : 0.446 ms
Execution time : 9.205 ms