explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d9Tl

Settings
# exclusive inclusive rows x rows loops node
1. 63.993 22,447.286 ↓ 8.7 76,341 1

Unique (cost=977,142.82..1,185,490.39 rows=8,745 width=814) (actual time=20,868.160..22,447.286 rows=76,341 loops=1)

2. 898.742 22,383.293 ↓ 8.8 77,098 1

Merge Left Join (cost=977,142.82..1,185,468.53 rows=8,745 width=814) (actual time=20,868.155..22,383.293 rows=77,098 loops=1)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pkgpmta_t.pmtrqst_pkg_uid)
3. 252.409 20,459.452 ↓ 8.8 77,098 1

Sort (cost=942,539.37..942,561.23 rows=8,745 width=753) (actual time=20,438.052..20,459.452 rows=77,098 loops=1)

  • Sort Key: pmtrqstpkg_t.pmtrqst_pkg_uid
  • Sort Method: external merge Disk: 24,264kB
4. 134.158 20,207.043 ↓ 8.8 77,098 1

Hash Left Join (cost=343,219.89..941,966.82 rows=8,745 width=753) (actual time=6,620.910..20,207.043 rows=77,098 loops=1)

  • Hash Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pmtrqavt_t.pmtrqst_pkg_uid)
5. 0.000 19,062.173 ↓ 8.8 77,098 1

Gather (cost=168,827.60..767,541.60 rows=8,745 width=721) (actual time=5,610.181..19,062.173 rows=77,098 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 39.364 19,155.098 ↓ 7.1 25,699 3 / 3

Hash Left Join (cost=167,827.60..765,667.10 rows=3,644 width=721) (actual time=5,546.324..19,155.098 rows=25,699 loops=3)

  • Hash Cond: ((pmtrqstpkg_t.lu_pin)::text = (dcpsuser_t_2.pin)::text)
7. 40.012 19,109.606 ↓ 7.1 25,699 3 / 3

Hash Left Join (cost=167,600.36..765,385.21 rows=3,643 width=711) (actual time=5,540.153..19,109.606 rows=25,699 loops=3)

  • Hash Cond: ((pmtrqst_t.lu_pin)::text = (dcpsuser_t_1.pin)::text)
8. 35.290 19,063.133 ↓ 7.1 25,699 3 / 3

Nested Loop Left Join (cost=167,373.13..765,103.33 rows=3,643 width=701) (actual time=5,533.427..19,063.133 rows=25,699 loops=3)

9. 158.480 18,722.479 ↓ 7.3 25,447 3 / 3

Merge Left Join (cost=167,372.28..741,660.40 rows=3,501 width=587) (actual time=5,532.251..18,722.479 rows=25,447 loops=3)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pmtrqavt_t_1.pmtrqst_pkg_uid)
10. 206.969 8,663.687 ↓ 7.3 25,447 3 / 3

Merge Left Join (cost=167,371.85..320,161.64 rows=3,501 width=539) (actual time=5,529.019..8,663.687 rows=25,447 loops=3)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pmtrqstevid_t.pmtrqst_pkg_uid)
11. 71.964 5,538.290 ↓ 7.3 25,447 3 / 3

Sort (cost=167,371.42..167,380.17 rows=3,501 width=515) (actual time=5,528.016..5,538.290 rows=25,447 loops=3)

  • Sort Key: pmtrqstpkg_t.pmtrqst_pkg_uid
  • Sort Method: quicksort Memory: 7,764kB
  • Worker 0: Sort Method: quicksort Memory: 7,367kB
  • Worker 1: Sort Method: quicksort Memory: 8,165kB
12. 27.016 5,466.326 ↓ 7.3 25,447 3 / 3

Hash Left Join (cost=12,039.36..167,165.32 rows=3,501 width=515) (actual time=2,685.966..5,466.326 rows=25,447 loops=3)

  • Hash Cond: (ceappt_t.ce_appt_uid = "ceHist"."ceApptUid")
13. 32.014 2,851.044 ↓ 7.3 25,447 3 / 3

Hash Left Join (cost=5,547.39..160,664.16 rows=3,501 width=507) (actual time=97.582..2,851.044 rows=25,447 loops=3)

  • Hash Cond: (CASE WHEN ((pmtrqstpkg_t.rqst_typ_cd)::text = 'TRAH'::text) THEN pmtrqstpkg_t.rqst_uid WHEN ((pmtrqstpkg_t.rqst_typ_cd)::text = 'INTH'::text) THEN spcarg_t.hrg_schg_info_uid ELSE NULL::integer END = hrgschinfo_t.hrg_schg_info_uid)
  • Join Filter: (((pmtrqstpkg_t.rqst_typ_cd)::text = 'TRAH'::text) OR ((pmtrqstpkg_t.rqst_typ_cd)::text = 'INTH'::text))
14. 48.677 2,816.749 ↓ 7.3 25,447 3 / 3

Nested Loop Left Join (cost=5,459.91..160,566.62 rows=3,501 width=470) (actual time=95.282..2,816.749 rows=25,447 loops=3)

  • Join Filter: ((ceappt_t.spcarg_cd IS NULL) AND ((pmtrqstpkg_t.rqst_typ_cd)::text = 'CE'::text))
15. 36.752 2,717.178 ↓ 7.3 25,447 3 / 3

Parallel Hash Left Join (cost=5,456.20..133,383.32 rows=3,501 width=466) (actual time=95.267..2,717.178 rows=25,447 loops=3)

  • Hash Cond: (CASE WHEN (((pmtrqstpkg_t.rqst_typ_cd)::text = 'CE'::text) OR ((pmtrqstpkg_t.rqst_typ_cd)::text = 'TRA'::text)) THEN pmtrqstpkg_t.rqst_uid WHEN ((pmtrqstpkg_t.rqst_typ_cd)::text = 'INTC'::text) THEN spcarg_t.ce_appt_uid ELSE NULL::integer END = ceappt_t.ce_appt_uid)
  • Join Filter: (((pmtrqstpkg_t.rqst_typ_cd)::text = 'CE'::text) OR ((pmtrqstpkg_t.rqst_typ_cd)::text = 'TRA'::text) OR ((pmtrqstpkg_t.rqst_typ_cd)::text = 'INTC'::text))
16. 21.367 2,628.554 ↓ 7.3 25,447 3 / 3

Hash Left Join (cost=733.35..128,649.97 rows=3,501 width=397) (actual time=42.642..2,628.554 rows=25,447 loops=3)

  • Hash Cond: (pmtrqstpkg_t.rqst_uid = spcarg_t.spcarg_uid)
17. 43.278 2,606.819 ↓ 7.3 25,447 3 / 3

Nested Loop Left Join (cost=726.67..128,634.10 rows=3,501 width=389) (actual time=42.259..2,606.819 rows=25,447 loops=3)

18. 41.848 1,622.002 ↓ 7.3 25,447 3 / 3

Nested Loop Left Join (cost=726.11..87,536.04 rows=3,501 width=261) (actual time=38.353..1,622.002 rows=25,447 loops=3)

19. 22.122 714.956 ↓ 7.3 25,447 3 / 3

Hash Left Join (cost=725.54..46,385.46 rows=3,501 width=220) (actual time=32.578..714.956 rows=25,447 loops=3)

  • Hash Cond: (pmtrqstpkg_t.initg_disb_exmr_user_uid = dcpsuser_t.user_uid)
20. 23.123 685.937 ↓ 7.3 25,447 3 / 3

Hash Left Join (cost=498.31..46,149.02 rows=3,501 width=207) (actual time=25.642..685.937 rows=25,447 loops=3)

  • Hash Cond: (pmtrqstpkg_t.initg_disb_exmr_org_uid = organization_t_1.org_uid)
21. 87.308 655.196 ↓ 7.3 25,447 3 / 3

Nested Loop (cost=115.77..45,757.29 rows=3,501 width=207) (actual time=17.963..655.196 rows=25,447 loops=3)

22. 187.090 364.312 ↓ 7.3 25,447 3 / 3

Hash Join (cost=115.35..34,110.15 rows=3,501 width=171) (actual time=16.058..364.312 rows=25,447 loops=3)

  • Hash Cond: (pmtrqstpkg_t.initg_org_uid = organization_t.org_uid)
23. 162.219 162.219 ↑ 1.3 479,489 3 / 3

Parallel Seq Scan on pmtrqstpkg_t (cost=0.00..32,364.09 rows=620,909 width=164) (actual time=0.788..162.219 rows=479,489 loops=3)

24. 0.021 15.003 ↑ 1.0 46 3 / 3

Hash (cost=114.76..114.76 rows=47 width=11) (actual time=15.002..15.003 rows=46 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
25. 13.882 14.982 ↑ 1.0 46 3 / 3

Bitmap Heap Scan on organization_t (cost=4.65..114.76 rows=47 width=11) (actual time=1.759..14.982 rows=46 loops=3)

  • Recheck Cond: ((st_cd)::text = 'DE'::text)
  • Heap Blocks: exact=21
26. 1.100 1.100 ↑ 1.0 46 3 / 3

Bitmap Index Scan on ixb01_orgainzation_t (cost=0.00..4.64 rows=47 width=0) (actual time=1.100..1.100 rows=46 loops=3)

  • Index Cond: ((st_cd)::text = 'DE'::text)
27. 203.576 203.576 ↑ 1.0 1 76,341 / 3

Index Scan using ixpk_dcpscase_t on dcpscase_t (cost=0.42..3.33 rows=1 width=40) (actual time=0.008..0.008 rows=1 loops=76,341)

  • Index Cond: (dcps_case_uid = pmtrqstpkg_t.dcps_case_uid)
28. 1.730 7.618 ↑ 1.0 8,276 3 / 3

Hash (cost=278.35..278.35 rows=8,335 width=8) (actual time=7.618..7.618 rows=8,276 loops=3)

  • Buckets: 16,384 Batches: 1 Memory Usage: 425kB
29. 5.888 5.888 ↑ 1.0 8,276 3 / 3

Seq Scan on organization_t organization_t_1 (cost=0.00..278.35 rows=8,335 width=8) (actual time=0.005..5.888 rows=8,276 loops=3)

30. 1.522 6.897 ↓ 1.0 5,480 3 / 3

Hash (cost=158.77..158.77 rows=5,477 width=21) (actual time=6.897..6.897 rows=5,480 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 346kB
31. 5.375 5.375 ↓ 1.0 5,480 3 / 3

Seq Scan on dcpsuser_t (cost=0.00..158.77 rows=5,477 width=21) (actual time=0.013..5.375 rows=5,480 loops=3)

32. 865.198 865.198 ↑ 1.0 1 76,341 / 3

Index Scan using ixf01_todoitemlistprnt on todoitemlist_t (cost=0.56..11.74 rows=1 width=53) (actual time=0.030..0.034 rows=1 loops=76,341)

  • Index Cond: ((prnt_tbl_seq_id)::text = ((pmtrqstpkg_t.pmtrqst_pkg_uid)::character varying)::text)
  • Filter: ((todo_itm_cd)::text = ANY ('{EVPR,CSPR,CTPR,HTPR}'::text[]))
  • Rows Removed by Filter: 5
33. 941.539 941.539 ↓ 0.0 0 76,341 / 3

Index Scan using ixf01_todoitemlistprnt on todoitemlist_t todoitemlist_t_1 (cost=0.56..11.73 rows=1 width=140) (actual time=0.037..0.037 rows=0 loops=76,341)

  • Index Cond: ((prnt_tbl_seq_id)::text = ((pmtrqstpkg_t.pmtrqst_pkg_uid)::character varying)::text)
  • Filter: ((deld_ts IS NULL) AND ((fup_typ)::text = 'FSCL'::text))
  • Rows Removed by Filter: 6
34. 0.039 0.368 ↑ 1.0 147 3 / 3

Hash (cost=4.84..4.84 rows=147 width=12) (actual time=0.368..0.368 rows=147 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
35. 0.329 0.329 ↑ 1.0 147 3 / 3

Seq Scan on spcarg_t (cost=0.00..4.84 rows=147 width=12) (actual time=0.281..0.329 rows=147 loops=3)

  • Filter: ((spcarg_cd)::text = 'INTP'::text)
36. 17.315 51.872 ↑ 1.3 52,420 3 / 3

Parallel Hash (cost=3,897.38..3,897.38 rows=66,038 width=73) (actual time=51.871..51.872 rows=52,420 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 16,160kB
37. 34.557 34.557 ↑ 1.3 52,420 3 / 3

Parallel Seq Scan on ceappt_t (cost=0.00..3,897.38 rows=66,038 width=73) (actual time=1.125..34.557 rows=52,420 loops=3)

38. 25.447 50.894 ↓ 0.0 0 76,341 / 3

Bitmap Heap Scan on ceappt_t ceappt_t_1 (cost=3.71..7.74 rows=2 width=8) (actual time=0.002..0.002 rows=0 loops=76,341)

  • Recheck Cond: ((ce_appt_uid = ceappt_t.prnt_appt_uid) OR (ceappt_t.ce_appt_uid = prnt_appt_uid))
  • Filter: (spcarg_cd IS NULL)
  • Heap Blocks: exact=24
39. 25.447 25.447 ↓ 0.0 0 76,341 / 3

BitmapOr (cost=3.71..3.71 rows=2 width=0) (actual time=0.001..0.001 rows=0 loops=76,341)

40. 0.000 0.000 ↓ 0.0 0 76,341 / 3

Bitmap Index Scan on ceappt_pkey (cost=0.00..1.85 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=76,341)

  • Index Cond: (ce_appt_uid = ceappt_t.prnt_appt_uid)
41. 0.000 0.000 ↓ 0.0 0 76,341 / 3

Bitmap Index Scan on ixf01_ceappt_t (cost=0.00..1.86 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=76,341)

  • Index Cond: (prnt_appt_uid = ceappt_t.ce_appt_uid)
42. 0.517 2.281 ↑ 1.0 1,941 3 / 3

Hash (cost=62.77..62.77 rows=1,977 width=41) (actual time=2.281..2.281 rows=1,941 loops=3)

  • Buckets: 2,048 Batches: 1 Memory Usage: 170kB
43. 1.764 1.764 ↑ 1.0 1,941 3 / 3

Seq Scan on hrgschinfo_t (cost=0.00..62.77 rows=1,977 width=41) (actual time=0.570..1.764 rows=1,941 loops=3)

44. 5.440 2,588.266 ↓ 1.0 22,049 3 / 3

Hash (cost=6,227.08..6,227.08 rows=21,191 width=12) (actual time=2,588.266..2,588.266 rows=22,049 loops=3)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,204kB
45. 2.911 2,582.826 ↓ 1.0 22,049 3 / 3

Subquery Scan on ceHist (cost=5,803.26..6,227.08 rows=21,191 width=12) (actual time=2,565.594..2,582.826 rows=22,049 loops=3)

46. 29.786 2,579.915 ↓ 1.0 22,049 3 / 3

HashAggregate (cost=5,803.26..6,015.17 rows=21,191 width=12) (actual time=2,565.592..2,579.915 rows=22,049 loops=3)

  • Group Key: ceappthist_t.ce_appt_uid
47. 2,543.954 2,550.129 ↓ 1.0 22,243 3 / 3

Bitmap Heap Scan on ceappthist_t (cost=415.33..5,693.00 rows=22,053 width=12) (actual time=7.244..2,550.129 rows=22,243 loops=3)

  • Recheck Cond: ((appt_stus_cd)::text = 'NOKT'::text)
  • Heap Blocks: exact=4,581
48. 6.175 6.175 ↓ 1.0 22,243 3 / 3

Bitmap Index Scan on ixb01_appt_stus_cd (cost=0.00..409.82 rows=22,053 width=0) (actual time=6.175..6.175 rows=22,243 loops=3)

  • Index Cond: ((appt_stus_cd)::text = 'NOKT'::text)
49. 1,371.850 2,918.428 ↓ 1.4 1,033,660 3 / 3

GroupAggregate (cost=0.43..143,190.76 rows=765,118 width=28) (actual time=0.899..2,918.428 rows=1,033,660 loops=3)

  • Group Key: pmtrqstevid_t.pmtrqst_pkg_uid
50. 1,546.578 1,546.578 ↑ 1.0 1,283,789 3 / 3

Index Scan using ix2_pmtrqstevid_t on pmtrqstevid_t (cost=0.43..119,356.55 rows=1,294,642 width=130) (actual time=0.888..1,546.578 rows=1,283,789 loops=3)

51. 2,371.071 9,900.312 ↑ 1.0 780,816 3 / 3

GroupAggregate (cost=0.43..411,542.38 rows=794,318 width=52) (actual time=2.995..9,900.312 rows=780,816 loops=3)

  • Group Key: pmtrqavt_t_1.pmtrqst_pkg_uid
52. 7,529.241 7,529.241 ↑ 1.0 2,053,586 3 / 3

Index Scan using ibx03_pmtrqavt_t on pmtrqavt_t pmtrqavt_t_1 (cost=0.43..335,327.62 rows=2,100,664 width=16) (actual time=2.821..7,529.241 rows=2,053,586 loops=3)

  • Filter: ((fscl_stus_cd)::text = ANY ('{APRV,SBMT,PAID}'::text[]))
  • Rows Removed by Filter: 4,252,810
53. 76.341 305.364 ↑ 1.0 1 76,341 / 3

Nested Loop Left Join (cost=0.85..6.69 rows=1 width=118) (actual time=0.011..0.012 rows=1 loops=76,341)

54. 229.023 229.023 ↑ 1.0 1 76,341 / 3

Index Scan using ibx01_pmtrqst_t on pmtrqst_t (cost=0.43..3.36 rows=1 width=58) (actual time=0.008..0.009 rows=1 loops=76,341)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t.pmtrqst_pkg_uid)
  • Filter: (fscl_stus_cd IS NULL)
  • Rows Removed by Filter: 0
55. 0.000 0.000 ↓ 0.0 0 77,098 / 3

Index Scan using cccntct_pkey on cccntct_t (cost=0.42..3.32 rows=1 width=64) (actual time=0.000..0.000 rows=0 loops=77,098)

  • Index Cond: (clnt_cntct_uid = pmtrqst_t.tp_pye_uid)
56. 1.879 6.461 ↓ 1.0 5,480 3 / 3

Hash (cost=158.77..158.77 rows=5,477 width=23) (actual time=6.460..6.461 rows=5,480 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 355kB
57. 4.582 4.582 ↓ 1.0 5,480 3 / 3

Seq Scan on dcpsuser_t dcpsuser_t_1 (cost=0.00..158.77 rows=5,477 width=23) (actual time=0.696..4.582 rows=5,480 loops=3)

58. 4.823 6.128 ↓ 1.0 5,480 3 / 3

Hash (cost=158.77..158.77 rows=5,477 width=23) (actual time=6.128..6.128 rows=5,480 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 355kB
59. 1.305 1.305 ↓ 1.0 5,480 3 / 3

Seq Scan on dcpsuser_t dcpsuser_t_2 (cost=0.00..158.77 rows=5,477 width=23) (actual time=0.005..1.305 rows=5,480 loops=3)

60. 7.812 1,010.712 ↓ 16.6 38,447 1

Hash (cost=174,363.35..174,363.35 rows=2,315 width=36) (actual time=1,010.712..1,010.712 rows=38,447 loops=1)

  • Buckets: 65,536 (originally 4096) Batches: 1 (originally 1) Memory Usage: 2,548kB
61. 12.766 1,002.900 ↓ 16.6 38,447 1

Nested Loop (cost=150,932.21..174,363.35 rows=2,315 width=36) (actual time=661.000..1,002.900 rows=38,447 loops=1)

62. 15.814 682.558 ↓ 16.6 38,447 1

GroupAggregate (cost=150,931.78..150,972.29 rows=2,315 width=8) (actual time=660.959..682.558 rows=38,447 loops=1)

  • Group Key: pmtrqavt_t_2.pmtrqst_pkg_uid
63. 17.567 666.744 ↓ 18.1 41,824 1

Sort (cost=150,931.78..150,937.57 rows=2,315 width=8) (actual time=660.949..666.744 rows=41,824 loops=1)

  • Sort Key: pmtrqavt_t_2.pmtrqst_pkg_uid
  • Sort Method: quicksort Memory: 3,497kB
64. 12.629 649.177 ↓ 18.1 41,824 1

Nested Loop (cost=131,641.52..150,802.41 rows=2,315 width=8) (actual time=494.033..649.177 rows=41,824 loops=1)

65. 4.456 511.076 ↓ 18.1 41,824 1

Group (cost=131,641.09..131,873.51 rows=2,315 width=4) (actual time=493.532..511.076 rows=41,824 loops=1)

  • Group Key: pmtrqavt_t_3.pmtrqah_uid
66. 49.130 506.620 ↓ 21.7 41,824 1

Gather Merge (cost=131,641.09..131,868.68 rows=1,930 width=4) (actual time=493.531..506.620 rows=41,824 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
67. 3.023 457.490 ↓ 14.4 13,941 3 / 3

Group (cost=130,641.06..130,645.89 rows=965 width=4) (actual time=452.559..457.490 rows=13,941 loops=3)

  • Group Key: pmtrqavt_t_3.pmtrqah_uid
68. 10.462 454.467 ↓ 14.4 13,941 3 / 3

Sort (cost=130,641.06..130,643.47 rows=965 width=4) (actual time=452.557..454.467 rows=13,941 loops=3)

  • Sort Key: pmtrqavt_t_3.pmtrqah_uid
  • Sort Method: quicksort Memory: 1,598kB
  • Worker 0: Sort Method: quicksort Memory: 1,002kB
  • Worker 1: Sort Method: quicksort Memory: 898kB
69. 8.196 444.005 ↓ 14.4 13,941 3 / 3

Nested Loop (cost=760.67..130,593.23 rows=965 width=4) (actual time=5.109..444.005 rows=13,941 loops=3)

70. 22.415 25.089 ↑ 1.3 12,835 3 / 3

Parallel Bitmap Heap Scan on pmtrqstpkg_t pmtrqstpkg_t_1 (cost=760.24..28,340.33 rows=16,910 width=4) (actual time=3.976..25.089 rows=12,835 loops=3)

  • Recheck Cond: ((fscl_stus_cd)::text = ANY ('{REJT,ERR,NCOR,HOLD}'::text[]))
  • Heap Blocks: exact=6,135
71. 2.674 2.674 ↑ 1.0 38,705 1 / 3

Bitmap Index Scan on ixb01_pmtrqstpkg_t (cost=0.00..750.09 rows=40,583 width=0) (actual time=8.021..8.021 rows=38,705 loops=1)

  • Index Cond: ((fscl_stus_cd)::text = ANY ('{REJT,ERR,NCOR,HOLD}'::text[]))
72. 410.720 410.720 ↑ 1.0 1 38,505 / 3

Index Scan using ibx03_pmtrqavt_t on pmtrqavt_t pmtrqavt_t_3 (cost=0.43..6.04 rows=1 width=8) (actual time=0.029..0.032 rows=1 loops=38,505)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t_1.pmtrqst_pkg_uid)
  • Filter: ((pmtrqact_cd)::text = ANY ('{REJCT,COERR,RERCT,POHLD,MERRO}'::text[]))
  • Rows Removed by Filter: 2
73. 125.472 125.472 ↑ 1.0 1 41,824

Index Scan using pmtrqavt_t_pkey on pmtrqavt_t pmtrqavt_t_2 (cost=0.43..8.17 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=41,824)

  • Index Cond: (pmtrqah_uid = pmtrqavt_t_3.pmtrqah_uid)
74. 110.836 307.576 ↑ 1.0 1 38,447

Index Scan using pmtrqavt_t_pkey on pmtrqavt_t (cost=0.43..10.09 rows=1 width=40) (actual time=0.008..0.008 rows=1 loops=38,447)

  • Index Cond: (pmtrqah_uid = (max(pmtrqavt_t_2.pmtrqah_uid)))
75.          

SubPlan (for Index Scan)

76. 196.740 196.740 ↑ 1.0 1 32,790

Seq Scan on prqactrsncd_t (cost=0.00..1.93 rows=1 width=32) (actual time=0.003..0.006 rows=1 loops=32,790)

  • Filter: ((pmtrqact_rsn_cd)::text = (pmtrqavt_t.pmtrqact_rsn_cd)::text)
  • Rows Removed by Filter: 73
77. 273.252 961.599 ↓ 2,326.1 465,220 1

GroupAggregate (cost=34,603.45..92,193.88 rows=200 width=36) (actual time=429.903..961.599 rows=465,220 loops=1)

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid
78. 95.327 688.347 ↑ 1.0 466,687 1

Group (cost=34,603.45..84,900.46 rows=486,061 width=22) (actual time=429.885..688.347 rows=466,687 loops=1)

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
79. 113.572 593.020 ↓ 1.2 466,923 1

Gather Merge (cost=34,603.45..82,875.21 rows=405,050 width=22) (actual time=429.883..593.020 rows=466,923 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
80. 47.977 479.448 ↑ 1.3 155,641 3 / 3

Group (cost=33,603.43..35,122.37 rows=202,525 width=22) (actual time=406.272..479.448 rows=155,641 loops=3)

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
81. 166.328 431.471 ↑ 1.3 158,783 3 / 3

Sort (cost=33,603.43..34,109.74 rows=202,525 width=22) (actual time=406.269..431.471 rows=158,783 loops=3)

  • Sort Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
  • Sort Method: external merge Disk: 5,864kB
  • Worker 0: Sort Method: external merge Disk: 4,328kB
  • Worker 1: Sort Method: external merge Disk: 4,064kB
82. 120.242 265.143 ↑ 1.3 158,783 3 / 3

Parallel Hash Join (cost=8,653.25..15,753.14 rows=202,525 width=22) (actual time=109.643..265.143 rows=158,783 loops=3)

  • Hash Cond: (pkgpmta_t.pmt_uid = pmt_t.pmt_uid)
83. 37.274 37.274 ↑ 1.3 158,783 3 / 3

Parallel Seq Scan on pkgpmta_t (cost=0.00..6,568.25 rows=202,525 width=8) (actual time=0.019..37.274 rows=158,783 loops=3)

84. 71.056 107.627 ↑ 1.3 129,954 3 / 3

Parallel Hash (cost=6,588.11..6,588.11 rows=165,211 width=22) (actual time=107.627..107.627 rows=129,954 loops=3)

  • Buckets: 524,288 Batches: 1 Memory Usage: 25,856kB
85. 36.571 36.571 ↑ 1.3 129,954 3 / 3

Parallel Seq Scan on pmt_t (cost=0.00..6,588.11 rows=165,211 width=22) (actual time=0.015..36.571 rows=129,954 loops=3)

86.          

SubPlan (for Merge Left Join)

87. 6.350 63.500 ↑ 1.0 1 6,350

Result (cost=17.11..17.12 rows=1 width=32) (actual time=0.010..0.010 rows=1 loops=6,350)

88.          

Initplan (for Result)

89. 6.350 57.150 ↓ 1.5 3 6,350

ProjectSet (cost=1.00..17.11 rows=2 width=32) (actual time=0.008..0.009 rows=3 loops=6,350)

90. 4.682 50.800 ↑ 1.0 1 6,350

Nested Loop (cost=1.00..17.09 rows=1 width=33) (actual time=0.007..0.008 rows=1 loops=6,350)

91. 4.682 38.100 ↑ 1.0 1 6,350

Nested Loop (cost=0.71..16.75 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=6,350)

92. 25.400 25.400 ↑ 1.0 1 6,350

Index Scan using ixf02_pmtrqstpkguid on pmtrqst_t pmtrqst_t_1 (cost=0.43..8.45 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=6,350)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t.pmtrqst_pkg_uid)
93. 8.018 8.018 ↑ 1.0 1 8,018

Index Scan using catalog_product_uid_pkey on stcatlgprod_t (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=8,018)

  • Index Cond: (st_catlg_prod_uid = pmtrqst_t_1.st_catlg_prod_uid)
94. 8.018 8.018 ↑ 1.0 1 8,018

Index Scan using prod_uid_pkey on product_t (cost=0.29..0.34 rows=1 width=37) (actual time=0.001..0.001 rows=1 loops=8,018)

  • Index Cond: (prod_uid = stcatlgprod_t.prod_uid)
Planning time : 53.182 ms
Execution time : 22,461.018 ms