explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n7FL

Settings
# exclusive inclusive rows x rows loops node
1. 18.474 1,062.646 ↓ 4.3 37,054 1

Hash Join (cost=67,486.89..79,821.48 rows=8,636 width=36) (actual time=705.354..1,062.646 rows=37,054 loops=1)

  • Buffers: shared hit=13023, temp read=1269 written=1269
2. 23.396 1,025.622 ↓ 4.2 47,388 1

Hash Join (cost=65,288.1..77,339.89 rows=11,225 width=36) (actual time=686.614..1,025.622 rows=47,388 loops=1)

  • Buffers: shared hit=12074, temp read=1269 written=1269
3. 0.468 980.166 ↓ 2.0 87 1

Merge Join (cost=63,320.37..74,137.29 rows=43 width=6) (actual time=660.913..980.166 rows=87 loops=1)

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

Subquery Scan on vw (cost=63,286.2..74,090.98 rows=1,544 width=4) (actual time=660.524..979.288 rows=5,867 loops=1)

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

WindowAgg (cost=63,286.2..70,232.13 rows=308,708 width=323) (actual time=660.518..956.736 rows=305,320 loops=1)

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

Sort (cost=63,286.2..64,057.97 rows=308,708 width=19) (actual time=660.511..845.557 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.237 229.617 ↑ 1.0 305,320 1

Hash Join (cost=76.47..28,806.89 rows=308,708 width=19) (actual time=0.055..229.617 rows=305,320 loops=1)

  • Buffers: shared hit=11260
8. 79.843 173.367 ↑ 1.0 305,320 1

Hash Join (cost=24.85..24,510.53 rows=308,708 width=23) (actual time=0.029..173.367 rows=305,320 loops=1)

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

Seq Scan on flng_meta fm (cost=0..20,240.94 rows=308,708 width=35) (actual time=0.01..93.518 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.006..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.010 0.013 ↑ 115.6 16 1

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

  • Buffers: shared hit=1
13. 0.003 0.003 ↑ 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.003 rows=16 loops=1)

  • Buffers: shared hit=1
14. 0.054 0.410 ↓ 2.0 87 1

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

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

Seq Scan on dncm_thrsh_lk dtl (cost=0..33 rows=43 width=6) (actual time=0.024..0.356 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. 13.216 22.060 ↑ 1.0 52,139 1

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

  • Buffers: shared hit=793
17. 8.844 8.844 ↑ 1.0 52,139 1

Seq Scan on dncm_flng_cmptns_mstr dfc (cost=0..1,315.1 rows=52,210 width=36) (actual time=0.004..8.844 rows=52,139 loops=1)

  • Buffers: shared hit=793
18. 6.262 18.550 ↑ 1.0 39,840 1

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

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

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

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