explain.depesz.com

PostgreSQL's explain analyze made readable

Result: deCU

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 16,855.563 ↑ 1.5 4 1

Unique (cost=191,330.44..824,920.50 rows=6 width=814) (actual time=15,337.285..16,855.563 rows=4 loops=1)

2. 0.311 16,855.541 ↑ 1.5 4 1

Nested Loop Left Join (cost=191,330.44..824,920.49 rows=6 width=814) (actual time=15,337.280..16,855.541 rows=4 loops=1)

3. 0.017 16,855.202 ↑ 1.5 4 1

Nested Loop Left Join (cost=191,330.16..824,767.24 rows=6 width=775) (actual time=15,337.095..16,855.202 rows=4 loops=1)

4. 0.016 16,854.325 ↑ 1.5 4 1

Nested Loop Left Join (cost=191,329.88..824,748.37 rows=6 width=765) (actual time=15,336.286..16,854.325 rows=4 loops=1)

5. 0.031 16,854.305 ↑ 1.5 4 1

Nested Loop Left Join (cost=191,329.45..824,728.43 rows=6 width=705) (actual time=15,336.278..16,854.305 rows=4 loops=1)

6. 46.506 16,854.154 ↑ 1.5 4 1

Merge Left Join (cost=191,329.02..824,677.70 rows=6 width=651) (actual time=15,336.223..16,854.154 rows=4 loops=1)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pkgpmta_t.pmtrqst_pkg_uid)
7. 0.171 15,432.721 ↑ 1.5 4 1

Nested Loop Left Join (cost=156,725.57..732,481.30 rows=6 width=619) (actual time=13,914.857..15,432.721 rows=4 loops=1)

8. 69.575 12,800.158 ↑ 1.5 4 1

Merge Left Join (cost=6,327.62..581,680.94 rows=6 width=587) (actual time=12,786.553..12,800.158 rows=4 loops=1)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pmtrqstevid_t.pmtrqst_pkg_uid)
9. 9.005 11,351.979 ↑ 1.5 4 1

Nested Loop Left Join (cost=6,327.20..428,926.16 rows=6 width=563) (actual time=11,338.523..11,351.979 rows=4 loops=1)

  • Join Filter: (ceappt_t.ce_appt_uid = "ceHist"."ceApptUid")
  • Rows Removed by Join Filter: 88,196
10. 0.021 11,282.934 ↑ 1.5 4 1

Nested Loop Left Join (cost=523.94..420,738.92 rows=6 width=555) (actual time=11,282.479..11,282.934 rows=4 loops=1)

  • Join Filter: (((pmtrqstpkg_t.rqst_typ_cd)::text = 'TRAH'::text) OR ((pmtrqstpkg_t.rqst_typ_cd)::text = 'INTH'::text))
11. 0.029 11,282.909 ↑ 1.5 4 1

Nested Loop Left Join (cost=523.65..420,693.03 rows=6 width=518) (actual time=11,282.470..11,282.909 rows=4 loops=1)

  • Join Filter: ((ceappt_t.spcarg_cd IS NULL) AND ((pmtrqstpkg_t.rqst_typ_cd)::text = 'CE'::text))
12. 0.025 11,282.856 ↑ 1.5 4 1

Nested Loop Left Join (cost=519.94..420,646.44 rows=6 width=514) (actual time=11,282.455..11,282.856 rows=4 loops=1)

  • 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))
13. 56.796 11,282.815 ↑ 1.5 4 1

Merge Left Join (cost=519.52..420,595.66 rows=6 width=445) (actual time=11,282.432..11,282.815 rows=4 loops=1)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pmtrqavt_t_1.pmtrqst_pkg_uid)
14. 0.018 2.111 ↑ 1.5 4 1

Sort (cost=519.08..519.10 rows=6 width=397) (actual time=2.109..2.111 rows=4 loops=1)

  • Sort Key: pmtrqstpkg_t.pmtrqst_pkg_uid
  • Sort Method: quicksort Memory: 26kB
15. 0.017 2.093 ↑ 1.5 4 1

Hash Left Join (cost=9.51..519.01 rows=6 width=397) (actual time=1.991..2.093 rows=4 loops=1)

  • Hash Cond: (pmtrqstpkg_t.rqst_uid = spcarg_t.spcarg_uid)
16. 0.004 2.019 ↑ 1.5 4 1

Nested Loop Left Join (cost=2.83..512.31 rows=6 width=389) (actual time=1.919..2.019 rows=4 loops=1)

17. 0.006 1.979 ↑ 1.5 4 1

Nested Loop Left Join (cost=2.27..341.95 rows=6 width=261) (actual time=1.903..1.979 rows=4 loops=1)

18. 0.006 0.129 ↑ 1.5 4 1

Nested Loop Left Join (cost=1.70..171.49 rows=6 width=220) (actual time=0.096..0.129 rows=4 loops=1)

19. 0.004 0.111 ↑ 1.5 4 1

Nested Loop Left Join (cost=1.42..121.69 rows=6 width=207) (actual time=0.083..0.111 rows=4 loops=1)

20. 0.006 0.099 ↑ 1.5 4 1

Nested Loop (cost=1.14..71.87 rows=6 width=207) (actual time=0.076..0.099 rows=4 loops=1)

21. 0.009 0.085 ↑ 1.5 4 1

Nested Loop (cost=0.85..22.06 rows=6 width=200) (actual time=0.068..0.085 rows=4 loops=1)

22. 0.038 0.038 ↑ 1.0 1 1

Index Scan using ixpk_dcpscase_t on dcpscase_t (cost=0.42..8.44 rows=1 width=40) (actual time=0.038..0.038 rows=1 loops=1)

  • Index Cond: (dcps_case_uid = 439,305)
23. 0.038 0.038 ↑ 1.5 4 1

Index Scan using ixn02_pmtrqstpkg_t on pmtrqstpkg_t (cost=0.43..13.56 rows=6 width=164) (actual time=0.024..0.038 rows=4 loops=1)

  • Index Cond: (dcps_case_uid = 439,305)
24. 0.008 0.008 ↑ 1.0 1 4

Index Scan using ixpk_organization_t on organization_t (cost=0.29..8.30 rows=1 width=11) (actual time=0.002..0.002 rows=1 loops=4)

  • Index Cond: (org_uid = pmtrqstpkg_t.initg_org_uid)
25. 0.008 0.008 ↑ 1.0 1 4

Index Scan using ixpk_organization_t on organization_t organization_t_1 (cost=0.29..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=4)

  • Index Cond: (org_uid = pmtrqstpkg_t.initg_disb_exmr_org_uid)
26. 0.012 0.012 ↑ 1.0 1 4

Index Scan using ixpk_dcpsuser_t on dcpsuser_t (cost=0.28..8.30 rows=1 width=21) (actual time=0.003..0.003 rows=1 loops=4)

  • Index Cond: (user_uid = pmtrqstpkg_t.initg_disb_exmr_user_uid)
27. 1.844 1.844 ↑ 1.0 1 4

Index Scan using ixf01_todoitemlistprnt on todoitemlist_t (cost=0.56..28.40 rows=1 width=53) (actual time=0.461..0.461 rows=1 loops=4)

  • 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: 0
28. 0.036 0.036 ↓ 0.0 0 4

Index Scan using ixf01_todoitemlistprnt on todoitemlist_t todoitemlist_t_1 (cost=0.56..28.38 rows=1 width=140) (actual time=0.009..0.009 rows=0 loops=4)

  • 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: 2
29. 0.022 0.057 ↑ 1.0 147 1

Hash (cost=4.84..4.84 rows=147 width=12) (actual time=0.057..0.057 rows=147 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
30. 0.035 0.035 ↑ 1.0 147 1

Seq Scan on spcarg_t (cost=0.00..4.84 rows=147 width=12) (actual time=0.010..0.035 rows=147 loops=1)

  • Filter: ((spcarg_cd)::text = 'INTP'::text)
31. 1,169.960 11,223.908 ↑ 1.1 757,867 1

GroupAggregate (cost=0.43..410,126.05 rows=796,038 width=52) (actual time=0.085..11,223.908 rows=757,867 loops=1)

  • Group Key: pmtrqavt_t_1.pmtrqst_pkg_uid
32. 10,053.948 10,053.948 ↑ 1.0 2,005,978 1

Index Scan using ibx03_pmtrqavt_t on pmtrqavt_t pmtrqavt_t_1 (cost=0.43..334,891.06 rows=2,069,988 width=16) (actual time=0.049..10,053.948 rows=2,005,978 loops=1)

  • Filter: ((fscl_stus_cd)::text = ANY ('{APRV,SBMT,PAID}'::text[]))
  • Rows Removed by Filter: 4,018,881
33. 0.016 0.016 ↓ 0.0 0 4

Index Scan using ceappt_pkey on ceappt_t (cost=0.43..8.45 rows=1 width=73) (actual time=0.004..0.004 rows=0 loops=4)

  • Index Cond: (ce_appt_uid = 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)
34. 0.012 0.024 ↓ 0.0 0 4

Bitmap Heap Scan on ceappt_t ceappt_t_1 (cost=3.71..7.74 rows=2 width=8) (actual time=0.006..0.006 rows=0 loops=4)

  • Recheck Cond: ((ce_appt_uid = ceappt_t.prnt_appt_uid) OR (ceappt_t.ce_appt_uid = prnt_appt_uid))
  • Filter: (spcarg_cd IS NULL)
35. 0.012 0.012 ↓ 0.0 0 4

BitmapOr (cost=3.71..3.71 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=4)

36. 0.000 0.000 ↓ 0.0 0 4

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

  • Index Cond: (ce_appt_uid = ceappt_t.prnt_appt_uid)
37. 0.000 0.000 ↓ 0.0 0 4

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=4)

  • Index Cond: (prnt_appt_uid = ceappt_t.ce_appt_uid)
38. 0.004 0.004 ↓ 0.0 0 4

Index Scan using ixpk_hrgschinfo_t on hrgschinfo_t (cost=0.28..7.63 rows=1 width=41) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (hrg_schg_info_uid = 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)
39. 10.627 60.040 ↓ 1.0 22,049 4

Materialize (cost=5,803.26..6,333.04 rows=21,191 width=12) (actual time=10.871..15.010 rows=22,049 loops=4)

40. 2.085 49.413 ↓ 1.0 22,049 1

Subquery Scan on ceHist (cost=5,803.26..6,227.08 rows=21,191 width=12) (actual time=43.439..49.413 rows=22,049 loops=1)

41. 16.039 47.328 ↓ 1.0 22,049 1

HashAggregate (cost=5,803.26..6,015.17 rows=21,191 width=12) (actual time=43.437..47.328 rows=22,049 loops=1)

  • Group Key: ceappthist_t.ce_appt_uid
42. 29.193 31.289 ↓ 1.0 22,243 1

Bitmap Heap Scan on ceappthist_t (cost=415.33..5,693.00 rows=22,053 width=12) (actual time=2.628..31.289 rows=22,243 loops=1)

  • Recheck Cond: ((appt_stus_cd)::text = 'NOKT'::text)
  • Heap Blocks: exact=4,581
43. 2.096 2.096 ↓ 1.0 22,243 1

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

  • Index Cond: ((appt_stus_cd)::text = 'NOKT'::text)
44. 716.227 1,378.604 ↓ 1.3 985,444 1

GroupAggregate (cost=0.43..143,190.76 rows=765,118 width=28) (actual time=0.036..1,378.604 rows=985,444 loops=1)

  • Group Key: pmtrqstevid_t.pmtrqst_pkg_uid
45. 662.377 662.377 ↑ 1.1 1,226,317 1

Index Scan using ix2_pmtrqstevid_t on pmtrqstevid_t (cost=0.43..119,356.55 rows=1,294,642 width=130) (actual time=0.028..662.377 rows=1,226,317 loops=1)

46. 16.916 2,632.392 ↓ 0.0 0 4

Hash Join (cost=150,397.95..150,465.01 rows=1 width=36) (actual time=657.965..658.098 rows=0 loops=4)

  • Hash Cond: ((max(pmtrqavt_t_2.pmtrqah_uid)) = pmtrqavt_t.pmtrqah_uid)
47. 80.596 2,615.340 ↓ 17.3 38,447 4

GroupAggregate (cost=150,373.21..150,412.17 rows=2,226 width=8) (actual time=628.277..653.835 rows=38,447 loops=4)

  • Group Key: pmtrqavt_t_2.pmtrqst_pkg_uid
48. 90.356 2,534.744 ↓ 18.8 41,824 4

Sort (cost=150,373.21..150,378.78 rows=2,226 width=8) (actual time=628.269..633.686 rows=41,824 loops=4)

  • Sort Key: pmtrqavt_t_2.pmtrqst_pkg_uid
  • Sort Method: quicksort Memory: 3,497kB
49. 186.788 2,444.388 ↓ 18.8 41,824 4

Nested Loop (cost=131,798.41..150,249.44 rows=2,226 width=8) (actual time=413.925..611.097 rows=41,824 loops=4)

50. 30.376 1,755.712 ↓ 18.8 41,824 4

Group (cost=131,797.97..132,021.48 rows=2,226 width=4) (actual time=413.754..438.928 rows=41,824 loops=4)

  • Group Key: pmtrqavt_t_3.pmtrqah_uid
51. 113.492 1,725.336 ↓ 22.5 41,824 4

Gather Merge (cost=131,797.97..132,016.84 rows=1,856 width=4) (actual time=413.753..431.334 rows=41,824 loops=4)

  • Workers Planned: 2
  • Workers Launched: 2
52. 14.380 1,611.844 ↓ 15.0 13,941 12 / 3

Group (cost=130,797.95..130,802.59 rows=928 width=4) (actual time=397.276..402.961 rows=13,941 loops=12)

  • Group Key: pmtrqavt_t_3.pmtrqah_uid
53. 45.632 1,597.464 ↓ 15.0 13,941 12 / 3

Sort (cost=130,797.95..130,800.27 rows=928 width=4) (actual time=397.274..399.366 rows=13,941 loops=12)

  • Sort Key: pmtrqavt_t_3.pmtrqah_uid
  • Sort Method: quicksort Memory: 998kB
  • Worker 0: Sort Method: quicksort Memory: 1,097kB
  • Worker 1: Sort Method: quicksort Memory: 1,019kB
54. 39.752 1,551.832 ↓ 15.0 13,941 12 / 3

Nested Loop (cost=760.67..130,752.21 rows=928 width=4) (actual time=4.828..387.958 rows=13,941 loops=12)

55. 782.828 793.320 ↑ 1.3 12,835 12 / 3

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

  • Recheck Cond: ((fscl_stus_cd)::text = ANY ('{REJT,ERR,NCOR,HOLD}'::text[]))
  • Heap Blocks: exact=18,335
56. 10.492 10.492 ↑ 1.0 38,705 4 / 3

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

  • Index Cond: ((fscl_stus_cd)::text = ANY ('{REJT,ERR,NCOR,HOLD}'::text[]))
57. 718.760 718.760 ↑ 1.0 1 154,020 / 3

Index Scan using ibx03_pmtrqavt_t on pmtrqavt_t pmtrqavt_t_3 (cost=0.43..6.05 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=154,020)

  • 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
58. 501.888 501.888 ↑ 1.0 1 167,296

Index Scan using pmtrqavt_t_pkey on pmtrqavt_t pmtrqavt_t_2 (cost=0.43..8.18 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=167,296)

  • Index Cond: (pmtrqah_uid = pmtrqavt_t_3.pmtrqah_uid)
59. 0.024 0.136 ↑ 1.6 5 4

Hash (cost=24.64..24.64 rows=8 width=40) (actual time=0.034..0.034 rows=5 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
60. 0.085 0.112 ↑ 1.6 5 4

Index Scan using ibx03_pmtrqavt_t on pmtrqavt_t (cost=0.43..24.64 rows=8 width=40) (actual time=0.014..0.028 rows=5 loops=4)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t.pmtrqst_pkg_uid)
61.          

SubPlan (for Index Scan)

62. 0.027 0.027 ↑ 1.0 1 1

Seq Scan on prqactrsncd_t (cost=0.00..1.93 rows=1 width=32) (actual time=0.023..0.027 rows=1 loops=1)

  • Filter: ((pmtrqact_rsn_cd)::text = (pmtrqavt_t.pmtrqact_rsn_cd)::text)
  • Rows Removed by Filter: 73
63. 426.206 1,374.927 ↓ 2,298.5 459,691 1

GroupAggregate (cost=34,603.45..92,193.88 rows=200 width=36) (actual time=516.238..1,374.927 rows=459,691 loops=1)

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid
64. 139.380 948.721 ↑ 1.1 461,151 1

Group (cost=34,603.45..84,900.46 rows=486,061 width=22) (actual time=516.218..948.721 rows=461,151 loops=1)

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
65. 230.616 809.341 ↓ 1.1 461,375 1

Gather Merge (cost=34,603.45..82,875.21 rows=405,050 width=22) (actual time=516.216..809.341 rows=461,375 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
66. 53.895 578.725 ↑ 1.3 154,571 3 / 3

Group (cost=33,603.43..35,122.37 rows=202,525 width=22) (actual time=495.723..578.725 rows=154,571 loops=3)

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
67. 212.527 524.830 ↑ 1.3 157,703 3 / 3

Sort (cost=33,603.43..34,109.74 rows=202,525 width=22) (actual time=495.720..524.830 rows=157,703 loops=3)

  • Sort Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
  • Sort Method: external merge Disk: 4,008kB
  • Worker 0: Sort Method: external merge Disk: 5,688kB
  • Worker 1: Sort Method: external merge Disk: 4,568kB
68. 129.614 312.303 ↑ 1.3 158,783 3 / 3

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

  • Hash Cond: (pkgpmta_t.pmt_uid = pmt_t.pmt_uid)
69. 53.561 53.561 ↑ 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.021..53.561 rows=158,783 loops=3)

70. 83.276 129.128 ↑ 1.3 129,954 3 / 3

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

  • Buckets: 524,288 Batches: 1 Memory Usage: 25,856kB
71. 45.852 45.852 ↑ 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.014..45.852 rows=129,954 loops=3)

72. 0.120 0.120 ↑ 1.0 1 4

Index Scan using ixf02_pmtrqstpkguid on pmtrqst_t (cost=0.43..8.45 rows=1 width=58) (actual time=0.030..0.030 rows=1 loops=4)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t.pmtrqst_pkg_uid)
  • Filter: (fscl_stus_cd IS NULL)
73. 0.004 0.004 ↓ 0.0 0 4

Index Scan using cccntct_pkey on cccntct_t (cost=0.42..3.32 rows=1 width=64) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (clnt_cntct_uid = pmtrqst_t.tp_pye_uid)
74. 0.860 0.860 ↑ 1.0 1 4

Index Scan using ixf02_pin on dcpsuser_t dcpsuser_t_1 (cost=0.28..3.13 rows=1 width=23) (actual time=0.214..0.215 rows=1 loops=4)

  • Index Cond: ((pin)::text = (pmtrqst_t.lu_pin)::text)
75. 0.028 0.028 ↑ 1.0 1 4

Index Scan using ixf02_pin on dcpsuser_t dcpsuser_t_2 (cost=0.28..8.30 rows=1 width=23) (actual time=0.006..0.007 rows=1 loops=4)

  • Index Cond: ((pin)::text = (pmtrqstpkg_t.lu_pin)::text)
76.          

SubPlan (for Nested Loop Left Join)

77. 0.000 0.000 ↓ 0.0 0

Result (cost=17.11..17.12 rows=1 width=32) (never executed)

78.          

Initplan (for Result)

79. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=1.00..17.11 rows=2 width=32) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.00..17.09 rows=1 width=33) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.75 rows=1 width=4) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Index Scan using ixf02_pmtrqstpkguid on pmtrqst_t pmtrqst_t_1 (cost=0.43..8.45 rows=1 width=4) (never executed)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t.pmtrqst_pkg_uid)
83. 0.000 0.000 ↓ 0.0 0

Index Scan using catalog_product_uid_pkey on stcatlgprod_t (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (st_catlg_prod_uid = pmtrqst_t_1.st_catlg_prod_uid)
84. 0.000 0.000 ↓ 0.0 0

Index Scan using prod_uid_pkey on product_t (cost=0.29..0.34 rows=1 width=37) (never executed)

  • Index Cond: (prod_uid = stcatlgprod_t.prod_uid)
Planning time : 52.888 ms
Execution time : 16,867.935 ms