explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DcMa

Settings
# exclusive inclusive rows x rows loops node
1. 18.776 1,064.947 ↓ 4.3 37,054 1

Hash Join (cost=67,138.14..79,389.33 rows=8,636 width=36) (actual time=727.313..1,064.947 rows=37,054 loops=1)

  • Buffers: shared hit=13020, temp read=1269 written=1269
2. 22.029 1,026.811 ↓ 4.2 47,389 1

Hash Join (cost=64,939.34..76,907.74 rows=11,225 width=36) (actual time=707.898..1,026.811 rows=47,389 loops=1)

  • Buffers: shared hit=12071, temp read=1269 written=1269
3. 0.467 984.157 ↓ 2.0 87 1

Merge Join (cost=62,971.62..73,705.14 rows=43 width=6) (actual time=683.861..984.157 rows=87 loops=1)

  • Buffers: shared hit=11278, temp read=1269 written=1269
4. 20.764 983.272 ↓ 3.8 5,867 1

Subquery Scan on vw (cost=62,937.45..73,658.93 rows=1,532 width=4) (actual time=683.465..983.272 rows=5,867 loops=1)

  • Filter: (vw.rk = 1)
  • Buffers: shared hit=11260, temp read=1269 written=1269
5. 104.216 962.508 ↑ 1.0 305,320 1

WindowAgg (cost=62,937.45..69,829.83 rows=306,328 width=323) (actual time=683.458..962.508 rows=305,320 loops=1)

  • Buffers: shared hit=11260, temp read=1269 written=1269
6. 629.766 858.292 ↑ 1.0 305,320 1

Sort (cost=62,937.45..63,703.27 rows=306,328 width=19) (actual time=683.451..858.292 rows=305,320 loops=1)

  • Sort Key: fm.firm_crd_nb, fm.flng_month DESC, fm.sbmt_on_dt DESC
  • Sort Method: external merge Disk: 10128kB
  • Buffers: shared hit=11260, temp read=1269 written=1269
7. 56.149 228.526 ↑ 1.0 305,320 1

Hash Join (cost=76.47..28,741.25 rows=306,328 width=19) (actual time=0.04..228.526 rows=305,320 loops=1)

  • Buffers: shared hit=11260
8. 78.856 172.370 ↑ 1.0 305,320 1

Hash Join (cost=24.85..24,477.61 rows=306,328 width=23) (actual time=0.027..172.37 rows=305,320 loops=1)

  • Buffers: shared hit=11259
9. 93.508 93.508 ↑ 1.0 305,320 1

Seq Scan on flng_meta fm (cost=0..20,240.75 rows=306,328 width=35) (actual time=0.013..93.508 rows=305,320 loops=1)

  • Filter: (fm.form_type_nb = ANY ('{1,2,3}'::integer[]))
  • Buffers: shared hit=11258
10. 0.003 0.006 ↑ 165.0 4 1

Hash (cost=16.6..16.6 rows=660 width=4) (actual time=0.005..0.006 rows=4 loops=1)

  • Buffers: shared hit=1
11. 0.003 0.003 ↑ 165.0 4 1

Seq Scan on prd_type_lk ptl (cost=0..16.6 rows=660 width=4) (actual time=0.003..0.003 rows=4 loops=1)

  • Buffers: shared hit=1
12. 0.001 0.007 ↑ 115.6 16 1

Hash (cost=28.5..28.5 rows=1,850 width=4) (actual time=0.007..0.007 rows=16 loops=1)

  • Buffers: shared hit=1
13. 0.006 0.006 ↑ 115.6 16 1

Seq Scan on form_type_lk ftl (cost=0..28.5 rows=1,850 width=4) (actual time=0.003..0.006 rows=16 loops=1)

  • Buffers: shared hit=1
14. 0.053 0.418 ↓ 2.0 87 1

Sort (cost=34.17..34.27 rows=43 width=6) (actual time=0.392..0.418 rows=87 loops=1)

  • Sort Key: ((dtl.firm_crd_nb)::integer)
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=18
15. 0.365 0.365 ↓ 2.0 87 1

Seq Scan on dncm_thrsh_lk dtl (cost=0..33 rows=43 width=6) (actual time=0.025..0.365 rows=87 loops=1)

  • Filter: ((dtl.firm_crd_nb IS NOT NULL) AND ((dtl.task_creat_fl)::text = 'Y'::text) AND (dtl.efctv_dt <= (clock_timestamp())::date) AND (COALESCE(dtl.trmnn_dt, (((clock_timestamp())::date + 99))::timestamp without time zone) > (clock_timestamp())::date))
  • Buffers: shared hit=18
16. 11.886 20.625 ↑ 1.0 52,140 1

Hash (cost=1,315.1..1,315.1 rows=52,210 width=36) (actual time=20.625..20.625 rows=52,140 loops=1)

  • Buffers: shared hit=793
17. 8.739 8.739 ↑ 1.0 52,140 1

Seq Scan on dncm_flng_cmptns_mstr dfc (cost=0..1,315.1 rows=52,210 width=36) (actual time=0.007..8.739 rows=52,140 loops=1)

  • Buffers: shared hit=793
18. 6.505 19.360 ↑ 1.0 39,840 1

Hash (cost=1,598.68..1,598.68 rows=40,008 width=8) (actual time=19.36..19.36 rows=39,840 loops=1)

  • Buffers: shared hit=949
19. 12.855 12.855 ↑ 1.0 39,840 1

Seq Scan on dncm_flng df (cost=0..1,598.68 rows=40,008 width=8) (actual time=0.007..12.855 rows=39,840 loops=1)

  • Filter: ((df.rgltr_cd)::text = 'CBOE'::text)
  • Buffers: shared hit=949
Planning time : 0.703 ms
Execution time : 1,077.121 ms