explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BPIQ

Settings
# exclusive inclusive rows x rows loops node
1. 5,564.246 10,408.836 ↓ 1.4 4,612,030 1

Merge Join (cost=1.57..161,660.42 rows=3,319,966 width=69) (actual time=0.304..10,408.836 rows=4,612,030 loops=1)

  • Merge Cond: (mser.mdu_id = minfo.mdu_info_id)
2. 510.031 510.031 ↑ 1.0 530,417 1

Index Scan using f_mdu_services_mdu_id_idx on f_mdu_services mser (cost=0.42..40,132.62 rows=530,417 width=20) (actual time=0.009..510.031 rows=530,417 loops=1)

3. 2,445.278 4,334.559 ↓ 28.2 4,621,023 1

Materialize (cost=1.15..135,601.25 rows=164,134 width=57) (actual time=0.077..4,334.559 rows=4,621,023 loops=1)

4. 520.886 1,889.281 ↓ 1.3 219,530 1

Nested Loop (cost=1.15..135,190.92 rows=164,134 width=57) (actual time=0.074..1,889.281 rows=219,530 loops=1)

5. 234.911 490.147 ↓ 1.3 219,562 1

Nested Loop (cost=0.71..35,822.89 rows=164,134 width=55) (actual time=0.066..490.147 rows=219,562 loops=1)

6. 46.023 94.876 ↑ 1.3 2,110 1

Nested Loop (cost=0.29..3,126.57 rows=2,786 width=47) (actual time=0.052..94.876 rows=2,110 loops=1)

  • Join Filter: (minfo.corp = geo.corp)
  • Rows Removed by Join Filter: 73850
7. 10.873 10.873 ↑ 1.2 2,110 1

Index Scan using f_mdu_info_pkey on f_mdu_info minfo (cost=0.29..1,660.39 rows=2,568 width=41) (actual time=0.014..10.873 rows=2,110 loops=1)

  • Filter: (contract_type_id = 15)
  • Rows Removed by Filter: 12350
8. 37.924 37.980 ↑ 1.1 36 2,110

Materialize (cost=0.00..2.52 rows=38 width=10) (actual time=0.001..0.018 rows=36 loops=2,110)

9. 0.056 0.056 ↑ 1.1 36 1

Seq Scan on stg_kom_d_geog_corp geo (cost=0.00..2.33 rows=38 width=10) (actual time=0.011..0.056 rows=36 loops=1)

  • Filter: (((metro_area_desc)::text = 'NYMA'::text) AND (now() >= begin_date) AND (now() <= end_date))
  • Rows Removed by Filter: 23
10. 160.360 160.360 ↓ 1.1 104 2,110

Index Scan using f_mdu_ci_address_link_mdu_id_idx on f_mdu_ci_address_link ciadd (cost=0.43..10.81 rows=93 width=8) (actual time=0.006..0.076 rows=104 loops=2,110)

  • Index Cond: (mdu_id = minfo.mdu_info_id)
11. 878.248 878.248 ↑ 1.0 1 219,562

Index Scan using f_ccip_addresses_pkey on f_ccip_addresses cci_add (cost=0.43..0.60 rows=1 width=10) (actual time=0.003..0.004 rows=1 loops=219,562)

  • Index Cond: (id_address = ciadd.address_id)
Planning time : 1.179 ms