explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LEWb

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,229.858 ↓ 1.8 41,161 1

Gather (cost=1,154.78..1,157,461.89 rows=23,137 width=465) (actual time=2.481..1,229.858 rows=41,161 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 19.095 801.787 ↓ 1.4 13,720 3 / 3

Nested Loop Left Join (cost=154.78..50,483.29 rows=9,640 width=389) (actual time=0.650..801.787 rows=13,720 loops=3)

3. 14.329 700.370 ↓ 1.4 13,720 3 / 3

Nested Loop (cost=154.35..44,361.67 rows=9,578 width=335) (actual time=0.638..700.370 rows=13,720 loops=3)

4. 27.381 603.719 ↓ 1.4 13,720 3 / 3

Nested Loop Left Join (cost=153.93..38,819.73 rows=9,578 width=311) (actual time=0.626..603.719 rows=13,720 loops=3)

5. 42.753 494.152 ↓ 1.4 13,698 3 / 3

Nested Loop (cost=153.50..32,718.34 rows=9,578 width=286) (actual time=0.611..494.152 rows=13,698 loops=3)

6. 38.471 382.911 ↓ 1.4 13,698 3 / 3

Nested Loop (cost=153.08..27,477.18 rows=9,578 width=251) (actual time=0.597..382.911 rows=13,698 loops=3)

7. 80.662 158.015 ↓ 1.8 37,285 3 / 3

Hash Join (cost=152.66..14,771.41 rows=20,978 width=54) (actual time=0.426..158.015 rows=37,285 loops=3)

  • Hash Cond: (pmtrqstpkg_t.initg_org_uid = organization_t.org_uid)
8. 76.996 76.996 ↓ 0.0 177,927 3 / 3

Parallel Seq Scan on pmtrqstpkg_t (cost=0.00..14032.82 rows=223035width=55) (cost=0..0 rows=0 width=0) (actual time=0.007..76.996 rows=177,927 loops=3)

  • Filter: ((rqst_typ_cd)::text = 'MER'::text)
  • Rows Removed by Filter: 37358
9. 0.105 0.357 ↑ 1.0 500 3 / 3

Hash (cost=146.41..146.41 rows=500 width=7) (actual time=0.357..0.357 rows=500 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
10. 0.193 0.252 ↑ 1.0 500 3 / 3

Bitmap Heap Scan on organization_t (cost=12.16..146.41 rows=500 width=7) (actual time=0.068..0.252 rows=500 loops=3)

  • Recheck Cond: ((st_cd)::text = 'OH'::text)
  • Heap Blocks: exact=48
11. 0.059 0.059 ↑ 1.0 500 3 / 3

Bitmap Index Scan on ixb01_orgainzation_t (cost=0.00..12.03 rows=500 width=0) (actual time=0.059..0.059 rows=500 loops=3)

  • Index Cond: ((st_cd)::text = 'OH'::text)
12. 186.425 186.425 ↓ 0.0 0 111,855 / 3

Index Scan using ixf02_pmtrqstpkguid on pmtrqst_t (cost=0.42..0.60 rows=1 width=201) (actual time=0.005..0.005 rows=0 loops=111,855)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t.pmtrqst_pkg_uid)
  • Filter: (((rqst_typ_cd)::text = 'MER'::text) AND (((pmtrqstpkg_t.fscl_stus_cd)::text = ANY ('{OBLG,NEW,APRV}'::text[])) OR(((pmtrqstpkg_t.fscl_stus_cd)::text = ANY ('{DEND,REJT}'::text[])) AND (xmitd_ts < pmtrqstpkg_t.stus_chg_ts)) OR (xmitd_ts IS NULL)))
  • Rows Removed by Filter: 1
13. 68.488 68.488 ↑ 1.0 1 41,093 / 3

Index Scan using ixpk_dcpscase_t on dcpscase_t (cost=0.42..0.55 rows=1 width=35) (actual time=0.005..0.005 rows=1 loops=41,093)

  • Index Cond: (dcps_case_uid = pmtrqst_t.dcps_case_uid)
14. 82.186 82.186 ↓ 0.0 0 41,093 / 3

Index Scan using ix_cccntct_t_dcps_case_uid on cccntct_t (cost=0.42..0.63 rows=1 width=29) (actual time=0.006..0.006 rows=0 loops=41,093)

  • Index Cond: (dcpscase_t.dcps_case_uid = dcps_case_uid)
  • Filter: ((cntct_dactvd_dt IS NULL) AND ((cntct_typ_cd)::text = '3'::text))
  • Rows Removed by Filter: 1
15. 82.322 82.322 ↑ 1.0 1 41,161 / 3

Index Scan using evrqst_pkey on evrqst_t (cost=0.43..0.58 rows=1 width=24) (actual time=0.006..0.006 rows=1 loops=41,161)

  • Index Cond: (ev_rqst_uid = pmtrqstpkg_t.rqst_uid)
16. 82.322 82.322 ↑ 1.0 1 41,161 / 3

Index Scan using ixf01_clntaddr on clntaddr_t (cost=0.42..0.63 rows=1 width=58) (actual time=0.005..0.006 rows=1 loops=41,161)

  • Index Cond: (dcpscase_t.dcps_case_uid = dcps_case_uid)
  • Filter: ((addr_subtyp)::text = 'M'::text)
  • Rows Removed by Filter: 1
17.          

SubPlan (for Gather)

18. 194.075 370.449 ↑ 1.0 1 41,161

Nested Loop Left Join (cost=0.42..9.71 rows=1 width=32) (actual time=0.007..0.009 rows=1 loops=41,161)

  • Join Filter: ((caseclm_t.clm_typ)::text = (t2clmcd_t.cd)::text)
  • Rows Removed by Join Filter: 9
19. 123.483 123.483 ↑ 1.0 1 41,161

Index Scan using ixf01_caseclm on caseclm_t (cost=0.42..8.44 rows=1 width=3) (actual time=0.003..0.003 rows=1 loops=41,161)

  • Index Cond: (dcps_case_uid = dcpscase_t.dcps_case_uid)
20. 52.891 52.891 ↑ 1.5 8 52,891

Seq Scan on t2clmcd_t (cost=0.00..1.12 rows=12 width=4) (actual time=0.001..0.001 rows=8 loops=52,891)

21. 41.161 370.449 ↑ 1.0 1 41,161

Aggregate (cost=27.65..27.66 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=41,161)

22. 41.176 329.288 ↑ 1.0 1 41,161

Nested Loop (cost=0.85..27.65 rows=1 width=8) (actual time=0.007..0.008 rows=1 loops=41,161)

23. 164.644 164.644 ↑ 2.0 1 41,161

Index Scan using ixf03_rqstuid on corrtrkg_t (cost=0.43..10.74 rows=2 width=4) (actual time=0.004..0.004 rows=1 loops=41,161)

  • Index Cond: (rqst_uid = evrqst_t.ev_rqst_uid)
  • Filter: ((rqst_typ_cd)::text = 'MER'::text)
  • Rows Removed by Filter: 0
24. 123.468 123.468 ↑ 1.0 1 41,156

Index Scan using ixf01_barcdtrkg_t_corrtrkg on barcdtrkg_t (cost=0.43..8.45 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=41,156)

  • Index Cond: (crsp_trkg_uid = corrtrkg_t.crsp_trkg_uid)
25. 41.161 164.644 ↑ 1.0 1 41,161

Result (cost=10.32..10.33 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=41,161)

26.          

Initplan (for Result)

27. 123.483 123.483 ↓ 0.0 0 41,161

Index Scan using ix2_pmtrqstevid_t on pmtrqstevid_t (cost=0.42..10.32 rows=2 width=32) (actual time=0.003..0.003 rows=0 loops=41,161)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t.pmtrqst_pkg_uid)
  • Filter: ((docu_chnl_typ_cd)::text = ANY ('{DMA,EREINV}'::text[]))
Planning time : 3.306 ms
Execution time : 1,232.850 ms