explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a5aT

Settings
# exclusive inclusive rows x rows loops node
1. 280.602 2,730.030 ↓ 1.4 210,391 1

Hash Join (cost=15,013.36..87,064.26 rows=153,824 width=69) (actual time=127.734..2,730.030 rows=210,391 loops=1)

  • Hash Cond: (minfo.corp = geo.corp)
2. 253.988 2,449.339 ↓ 1.5 210,391 1

Merge Join (cost=15,010.56..84,813.93 rows=141,805 width=63) (actual time=127.633..2,449.339 rows=210,391 loops=1)

  • Merge Cond: (mser.mdu_id = minfo.mdu_info_id)
3. 30.302 140.343 ↑ 1.0 24,454 1

Sort (cost=15,009.41..15,070.85 rows=24,576 width=20) (actual time=127.551..140.343 rows=24,454 loops=1)

  • Sort Key: mser.mdu_id
  • Sort Method: quicksort Memory: 2679kB
4. 110.041 110.041 ↑ 1.0 24,454 1

Seq Scan on f_mdu_services mser (cost=0.00..13,217.21 rows=24,576 width=20) (actual time=89.742..110.041 rows=24,454 loops=1)

  • Filter: (end_of_month_date = '2019-10-31 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 505963
5. 271.500 2,055.008 ↓ 1.5 219,530 1

Materialize (cost=1.15..123,768.67 rows=151,290 width=51) (actual time=0.068..2,055.008 rows=219,530 loops=1)

6. 492.935 1,783.508 ↓ 1.5 219,530 1

Nested Loop (cost=1.15..123,390.44 rows=151,290 width=51) (actual time=0.063..1,783.508 rows=219,530 loops=1)

7. 240.085 412.325 ↓ 1.5 219,562 1

Nested Loop (cost=0.71..31,798.27 rows=151,290 width=49) (actual time=0.051..412.325 rows=219,562 loops=1)

8. 9.770 9.770 ↑ 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.029..9.770 rows=2,110 loops=1)

  • Filter: (contract_type_id = 15)
  • Rows Removed by Filter: 12350
9. 162.470 162.470 ↓ 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.077 rows=104 loops=2,110)

  • Index Cond: (mdu_id = minfo.mdu_info_id)
10. 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)
11. 0.027 0.089 ↑ 1.1 36 1

Hash (cost=2.33..2.33 rows=38 width=10) (actual time=0.089..0.089 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
12. 0.062 0.062 ↑ 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.021..0.062 rows=36 loops=1)

  • Filter: (((metro_area_desc)::text = 'NYMA'::text) AND (now() >= begin_date) AND (now() <= end_date))
  • Rows Removed by Filter: 23
Planning time : 1.040 ms