explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pgnt

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 4,965.072 ↑ 1.5 4 1

Unique (cost=194,712.27..405,862.83 rows=6 width=814) (actual time=3,792.499..4,965.072 rows=4 loops=1)

2. 0.153 4,965.054 ↑ 1.5 4 1

Nested Loop Left Join (cost=194,712.27..405,862.82 rows=6 width=814) (actual time=3,792.495..4,965.054 rows=4 loops=1)

3. 0.016 4,964.881 ↑ 1.5 4 1

Nested Loop Left Join (cost=194,711.98..405,709.57 rows=6 width=775) (actual time=3,792.441..4,964.881 rows=4 loops=1)

4. 0.015 4,964.813 ↑ 1.5 4 1

Nested Loop Left Join (cost=194,711.70..405,690.70 rows=6 width=765) (actual time=3,792.423..4,964.813 rows=4 loops=1)

5. 0.024 4,964.794 ↑ 1.5 4 1

Nested Loop Left Join (cost=194,711.28..405,670.76 rows=6 width=705) (actual time=3,792.416..4,964.794 rows=4 loops=1)

6. 37.489 4,964.658 ↑ 1.5 4 1

Merge Left Join (cost=194,710.85..405,620.03 rows=6 width=651) (actual time=3,792.369..4,964.658 rows=4 loops=1)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pkgpmta_t.pmtrqst_pkg_uid)
7. 0.050 3,769.524 ↑ 1.5 4 1

Nested Loop Left Join (cost=160,107.39..313,423.63 rows=6 width=619) (actual time=2,597.302..3,769.524 rows=4 loops=1)

8. 0.014 1,490.218 ↑ 1.5 4 1

Merge Left Join (cost=6,949.86..159,793.20 rows=6 width=587) (actual time=1,490.066..1,490.218 rows=4 loops=1)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pmtrqavt_t_1.pmtrqst_pkg_uid)
9. 0.017 1,490.116 ↑ 1.5 4 1

Nested Loop Left Join (cost=6,880.91..159,723.76 rows=6 width=539) (actual time=1,489.976..1,490.116 rows=4 loops=1)

  • Join Filter: (((pmtrqstpkg_t.rqst_typ_cd)::text = 'TRAH'::text) OR ((pmtrqstpkg_t.rqst_typ_cd)::text = 'INTH'::text))
10. 0.030 1,490.095 ↑ 1.5 4 1

Nested Loop Left Join (cost=6,880.63..159,677.87 rows=6 width=502) (actual time=1,489.966..1,490.095 rows=4 loops=1)

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

Merge Left Join (cost=6,876.92..159,631.28 rows=6 width=498) (actual time=1,489.948..1,490.045 rows=4 loops=1)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pmtrqstevid_t.pmtrqst_pkg_uid)
12. 0.012 42.648 ↑ 1.5 4 1

Sort (cost=6,876.49..6,876.51 rows=6 width=474) (actual time=42.647..42.648 rows=4 loops=1)

  • Sort Key: pmtrqstpkg_t.pmtrqst_pkg_uid
  • Sort Method: quicksort Memory: 26kB
13. 1.345 42.636 ↑ 1.5 4 1

Hash Right Join (cost=6,373.12..6,876.41 rows=6 width=474) (actual time=42.632..42.636 rows=4 loops=1)

  • Hash Cond: (ceappthist_t.ce_appt_uid = ceappt_t.ce_appt_uid)
14. 12.957 40.891 ↓ 1.0 22,049 1

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

  • Group Key: ceappthist_t.ce_appt_uid
15. 25.081 27.934 ↓ 1.0 22,243 1

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

  • Recheck Cond: ((appt_stus_cd)::text = 'NOKT'::text)
  • Heap Blocks: exact=4,581
16. 2.853 2.853 ↓ 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.852..2.853 rows=22,243 loops=1)

  • Index Cond: ((appt_stus_cd)::text = 'NOKT'::text)
17. 0.008 0.400 ↑ 1.5 4 1

Hash (cost=569.78..569.78 rows=6 width=466) (actual time=0.400..0.400 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
18. 0.010 0.392 ↑ 1.5 4 1

Nested Loop Left Join (cost=9.94..569.78 rows=6 width=466) (actual time=0.251..0.392 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))
19. 0.009 0.382 ↑ 1.5 4 1

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

  • Hash Cond: (pmtrqstpkg_t.rqst_uid = spcarg_t.spcarg_uid)
20. 0.007 0.292 ↑ 1.5 4 1

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

21. 0.008 0.233 ↑ 1.5 4 1

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

22. 0.004 0.117 ↑ 1.5 4 1

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

23. 0.007 0.097 ↑ 1.5 4 1

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

24. 0.007 0.078 ↑ 1.5 4 1

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

25. 0.009 0.055 ↑ 1.5 4 1

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

26. 0.033 0.033 ↑ 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.032..0.033 rows=1 loops=1)

  • Index Cond: (dcps_case_uid = 439,305)
27. 0.013 0.013 ↑ 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.008..0.013 rows=4 loops=1)

  • Index Cond: (dcps_case_uid = 439,305)
28. 0.016 0.016 ↑ 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.004..0.004 rows=1 loops=4)

  • Index Cond: (org_uid = pmtrqstpkg_t.initg_org_uid)
29. 0.012 0.012 ↑ 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.003..0.003 rows=1 loops=4)

  • Index Cond: (org_uid = pmtrqstpkg_t.initg_disb_exmr_org_uid)
30. 0.016 0.016 ↑ 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.004..0.004 rows=1 loops=4)

  • Index Cond: (user_uid = pmtrqstpkg_t.initg_disb_exmr_user_uid)
31. 0.108 0.108 ↑ 1.0 1 4

Index Scan using ixf01_todoitemlistprnt on todoitemlist_t (cost=0.56..28.40 rows=1 width=53) (actual time=0.027..0.027 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
32. 0.052 0.052 ↓ 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.013..0.013 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
33. 0.030 0.081 ↑ 1.0 147 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
34. 0.051 0.051 ↑ 1.0 147 1

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

  • Filter: ((spcarg_cd)::text = 'INTP'::text)
35. 0.000 0.000 ↓ 0.0 0 4

Index Scan using ceappt_pkey on ceappt_t (cost=0.43..8.45 rows=1 width=73) (actual time=0.000..0.000 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)
36. 641.497 1,384.332 ↓ 1.3 985,444 1

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

  • Group Key: pmtrqstevid_t.pmtrqst_pkg_uid
37. 742.835 742.835 ↑ 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.032..742.835 rows=1,226,317 loops=1)

38. 0.008 0.020 ↓ 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.005..0.005 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)
39. 0.008 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)

40. 0.004 0.004 ↓ 0.0 0 4

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

  • Index Cond: (ce_appt_uid = ceappt_t.prnt_appt_uid)
41. 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)
42. 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)
43. 0.014 0.088 ↑ 4.0 2 1

GroupAggregate (cost=68.95..69.31 rows=8 width=52) (actual time=0.083..0.088 rows=2 loops=1)

  • Group Key: pmtrqavt_t_1.pmtrqst_pkg_uid
44. 0.013 0.074 ↑ 1.3 6 1

Sort (cost=68.95..68.97 rows=8 width=16) (actual time=0.072..0.074 rows=6 loops=1)

  • Sort Key: pmtrqavt_t_1.pmtrqst_pkg_uid
  • Sort Method: quicksort Memory: 25kB
45. 0.008 0.061 ↑ 1.3 6 1

Nested Loop (cost=0.86..68.83 rows=8 width=16) (actual time=0.036..0.061 rows=6 loops=1)

46. 0.013 0.013 ↑ 1.5 4 1

Index Scan using ixn02_pmtrqstpkg_t on pmtrqstpkg_t pmtrqstpkg_t_1 (cost=0.43..13.56 rows=6 width=4) (actual time=0.010..0.013 rows=4 loops=1)

  • Index Cond: (dcps_case_uid = 439,305)
47. 0.040 0.040 ↑ 1.5 2 4

Index Scan using ibx03_pmtrqavt_t on pmtrqavt_t pmtrqavt_t_1 (cost=0.43..9.18 rows=3 width=16) (actual time=0.008..0.010 rows=2 loops=4)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t_1.pmtrqst_pkg_uid)
  • Filter: ((fscl_stus_cd)::text = ANY ('{APRV,SBMT,PAID}'::text[]))
  • Rows Removed by Filter: 3
48. 11.280 2,279.256 ↓ 0.0 0 4

Hash Join (cost=153,157.53..153,236.34 rows=1 width=36) (actual time=569.681..569.814 rows=0 loops=4)

  • Hash Cond: ((max(pmtrqavt_t_2.pmtrqah_uid)) = pmtrqavt_t.pmtrqah_uid)
49. 55.164 2,267.896 ↓ 14.7 38,447 4

GroupAggregate (cost=153,132.86..153,178.64 rows=2,616 width=8) (actual time=549.104..566.974 rows=38,447 loops=4)

  • Group Key: pmtrqavt_t_2.pmtrqst_pkg_uid
50. 69.248 2,212.732 ↓ 16.0 41,824 4

Sort (cost=153,132.86..153,139.40 rows=2,616 width=8) (actual time=549.095..553.183 rows=41,824 loops=4)

  • Sort Key: pmtrqavt_t_2.pmtrqst_pkg_uid
  • Sort Method: quicksort Memory: 3,497kB
51. 24.588 2,143.484 ↓ 16.0 41,824 4

Nested Loop (cost=131,418.91..152,984.36 rows=2,616 width=8) (actual time=385.552..535.871 rows=41,824 loops=4)

52. 22.508 1,617.008 ↓ 16.0 41,824 4

Group (cost=131,418.47..131,681.00 rows=2,616 width=4) (actual time=385.533..404.252 rows=41,824 loops=4)

  • Group Key: pmtrqavt_t_3.pmtrqah_uid
53. 85.004 1,594.500 ↓ 19.2 41,824 4

Gather Merge (cost=131,418.47..131,675.55 rows=2,180 width=4) (actual time=385.532..398.625 rows=41,824 loops=4)

  • Workers Planned: 2
  • Workers Launched: 2
54. 13.496 1,509.496 ↓ 12.8 13,941 12 / 3

Group (cost=130,418.45..130,423.90 rows=1,090 width=4) (actual time=371.742..377.374 rows=13,941 loops=12)

  • Group Key: pmtrqavt_t_3.pmtrqah_uid
55. 44.332 1,496.000 ↓ 12.8 13,941 12 / 3

Sort (cost=130,418.45..130,421.18 rows=1,090 width=4) (actual time=371.740..374.000 rows=13,941 loops=12)

  • Sort Key: pmtrqavt_t_3.pmtrqah_uid
  • Sort Method: quicksort Memory: 919kB
  • Worker 0: Sort Method: quicksort Memory: 1,066kB
  • Worker 1: Sort Method: quicksort Memory: 1,129kB
56. 47.500 1,451.668 ↓ 12.8 13,941 12 / 3

Nested Loop (cost=760.67..130,363.46 rows=1,090 width=4) (actual time=3.822..362.917 rows=13,941 loops=12)

57. 163.193 172.008 ↑ 1.3 12,835 12 / 3

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

  • Recheck Cond: ((fscl_stus_cd)::text = ANY ('{REJT,ERR,NCOR,HOLD}'::text[]))
  • Heap Blocks: exact=17,421
58. 8.815 8.815 ↑ 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=6.611..6.611 rows=38,705 loops=4)

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

Index Scan using ibx03_pmtrqavt_t on pmtrqavt_t pmtrqavt_t_3 (cost=0.43..6.02 rows=1 width=8) (actual time=0.023..0.024 rows=1 loops=154,020)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t_2.pmtrqst_pkg_uid)
  • Filter: ((pmtrqact_cd)::text = ANY ('{REJCT,COERR,RERCT,POHLD,MERRO}'::text[]))
  • Rows Removed by Filter: 2
60. 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.13 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=167,296)

  • Index Cond: (pmtrqah_uid = pmtrqavt_t_3.pmtrqah_uid)
61. 0.020 0.080 ↑ 1.6 5 4

Hash (cost=24.57..24.57 rows=8 width=40) (actual time=0.020..0.020 rows=5 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
62. 0.045 0.060 ↑ 1.6 5 4

Index Scan using ibx03_pmtrqavt_t on pmtrqavt_t (cost=0.43..24.57 rows=8 width=40) (actual time=0.008..0.015 rows=5 loops=4)

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

SubPlan (for Index Scan)

64. 0.015 0.015 ↑ 1.0 1 1

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

  • Filter: ((pmtrqact_rsn_cd)::text = (pmtrqavt_t.pmtrqact_rsn_cd)::text)
  • Rows Removed by Filter: 73
65. 334.656 1,157.645 ↓ 2,298.5 459,691 1

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

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid
66. 97.742 822.989 ↑ 1.1 461,151 1

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

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
67. 144.730 725.247 ↓ 1.1 461,389 1

Gather Merge (cost=34,603.45..82,875.21 rows=405,050 width=22) (actual time=521.462..725.247 rows=461,389 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
68. 49.378 580.517 ↑ 1.3 154,105 3 / 3

Group (cost=33,603.43..35,122.37 rows=202,525 width=22) (actual time=503.958..580.517 rows=154,105 loops=3)

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
69. 243.019 531.139 ↑ 1.3 157,230 3 / 3

Sort (cost=33,603.43..34,109.74 rows=202,525 width=22) (actual time=503.955..531.139 rows=157,230 loops=3)

  • Sort Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
  • Sort Method: external merge Disk: 5,352kB
  • Worker 0: Sort Method: external merge Disk: 4,008kB
  • Worker 1: Sort Method: external merge Disk: 4,896kB
70. 121.129 288.120 ↑ 1.3 158,783 3 / 3

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

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

72. 73.537 124.098 ↑ 1.3 129,954 3 / 3

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

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

74. 0.112 0.112 ↑ 1.0 1 4

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

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t.pmtrqst_pkg_uid)
  • Filter: (fscl_stus_cd IS NULL)
75. 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)
76. 0.052 0.052 ↑ 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.013..0.013 rows=1 loops=4)

  • Index Cond: ((pin)::text = (pmtrqst_t.lu_pin)::text)
77. 0.020 0.020 ↑ 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.004..0.005 rows=1 loops=4)

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

SubPlan (for Nested Loop Left Join)

79. 0.000 0.000 ↓ 0.0 0

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

80.          

Initplan (for Result)

81. 0.000 0.000 ↓ 0.0 0

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

82. 0.000 0.000 ↓ 0.0 0

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

83. 0.000 0.000 ↓ 0.0 0

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

84. 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)
85. 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)
86. 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 : 20.867 ms
Execution time : 4,989.676 ms