explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ppq9

Settings
# exclusive inclusive rows x rows loops node
1. 0.080 8,952.970 ↑ 1.6 20 1

Unique (cost=255,808.08..452,495.28 rows=33 width=757) (actual time=5,559.139..8,952.970 rows=20 loops=1)

2. 0.000 8,952.890 ↑ 1.7 20 1

Nested Loop Left Join (cost=255,808.08..452,495.19 rows=34 width=757) (actual time=5,559.136..8,952.890 rows=20 loops=1)

3. 114.388 5,443.424 ↑ 1.7 20 1

Gather Merge (cost=177,452.84..371,781.92 rows=34 width=722) (actual time=5,383.676..5,443.424 rows=20 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.022 5,329.036 ↑ 2.0 7 3 / 3

Nested Loop Left Join (cost=176,452.82..370,777.97 rows=14 width=722) (actual time=5,179.476..5,329.036 rows=7 loops=3)

5. 0.026 5,328.974 ↑ 2.0 7 3 / 3

Nested Loop Left Join (cost=176,452.54..370,710.88 rows=14 width=712) (actual time=5,179.460..5,328.974 rows=7 loops=3)

6. 0.024 5,328.881 ↑ 2.0 7 3 / 3

Nested Loop Left Join (cost=176,452.26..370,706.57 rows=14 width=702) (actual time=5,179.437..5,328.881 rows=7 loops=3)

7. 0.031 5,328.850 ↑ 2.0 7 3 / 3

Nested Loop Left Join (cost=176,451.84..370,699.64 rows=14 width=641) (actual time=5,179.424..5,328.850 rows=7 loops=3)

8. 0.016 5,328.759 ↑ 2.0 7 3 / 3

Merge Left Join (cost=176,451.41..370,581.30 rows=14 width=586) (actual time=5,179.404..5,328.759 rows=7 loops=3)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pkgpmta_t.pmtrqst_pkg_uid)
9. 42.390 5,328.636 ↑ 2.0 7 3 / 3

Merge Left Join (cost=175,995.27..370,123.40 rows=14 width=554) (actual time=5,179.291..5,328.636 rows=7 loops=3)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pmtrqavt_t_1.pmtrqst_pkg_uid)
10. 0.021 1,332.472 ↑ 2.0 7 3 / 3

Merge Left Join (cost=175,994.84..176,241.91 rows=14 width=506) (actual time=1,332.456..1,332.472 rows=7 loops=3)

  • Merge Cond: (pmtrqstpkg_t.pmtrqst_pkg_uid = pmtrqstevid_t.pmtrqst_pkg_uid)
11. 0.040 1,332.368 ↑ 2.0 7 3 / 3

Sort (cost=175,994.41..175,994.45 rows=14 width=490) (actual time=1,332.366..1,332.368 rows=7 loops=3)

  • Sort Key: pmtrqstpkg_t.pmtrqst_pkg_uid
  • Sort Method: quicksort Memory: 26kB
  • Worker 0: Sort Method: quicksort Memory: 26kB
  • Worker 1: Sort Method: quicksort Memory: 27kB
12. 0.034 1,332.328 ↑ 2.0 7 3 / 3

Hash Left Join (cost=148,314.19..175,994.15 rows=14 width=490) (actual time=1,295.072..1,332.328 rows=7 loops=3)

  • Hash Cond: (ceappt_t.ce_appt_uid = "ceHist"."ceApptUid")
13. 0.023 1,307.382 ↑ 2.0 7 3 / 3

Nested Loop Left Join (cost=145,257.22..172,937.14 rows=14 width=482) (actual time=1,270.134..1,307.382 rows=7 loops=3)

  • Join Filter: ((pmtrqstpkg_t.rqst_typ_cd)::text = 'TRAH'::text)
14. 1.372 1,307.346 ↑ 2.0 7 3 / 3

Nested Loop Left Join (cost=145,256.95..172,888.71 rows=14 width=441) (actual time=1,270.122..1,307.346 rows=7 loops=3)

  • Join Filter: ((ceappt_t.spcarg_cd IS NULL) AND ((pmtrqstpkg_t.rqst_typ_cd)::text = 'CE'::text))
15. 0.016 1,305.954 ↑ 2.0 7 3 / 3

Nested Loop Left Join (cost=145,256.32..172,823.22 rows=14 width=437) (actual time=1,268.767..1,305.954 rows=7 loops=3)

  • Join Filter: (((pmtrqstpkg_t.rqst_typ_cd)::text = 'CE'::text) OR ((pmtrqstpkg_t.rqst_typ_cd)::text = 'TRA'::text))
16. 0.025 1,305.918 ↑ 2.0 7 3 / 3

Hash Left Join (cost=145,256.03..172,710.06 rows=14 width=379) (actual time=1,268.753..1,305.918 rows=7 loops=3)

  • Hash Cond: (((pmtrqstpkg_t.pmtrqst_pkg_uid)::character varying)::text = (todoitemlist_t_1.prnt_tbl_seq_id)::text)
17. 0.017 1,300.769 ↑ 2.0 7 3 / 3

Nested Loop Left Join (cost=141,813.71..169,267.39 rows=14 width=252) (actual time=1,263.615..1,300.769 rows=7 loops=3)

18. 0.014 1,300.725 ↑ 2.0 7 3 / 3

Nested Loop Left Join (cost=141,813.43..169,262.68 rows=14 width=239) (actual time=1,263.604..1,300.725 rows=7 loops=3)

19. 0.016 1,300.691 ↑ 2.0 7 3 / 3

Nested Loop Left Join (cost=141,813.15..169,257.34 rows=14 width=239) (actual time=1,263.596..1,300.691 rows=7 loops=3)

20. 0.039 1,300.648 ↑ 2.0 7 3 / 3

Nested Loop (cost=141,812.87..169,253.11 rows=14 width=235) (actual time=1,263.584..1,300.648 rows=7 loops=3)

21. 0.016 1,300.569 ↑ 2.0 7 3 / 3

Nested Loop (cost=141,812.45..169,134.98 rows=14 width=196) (actual time=1,263.567..1,300.569 rows=7 loops=3)

22. 51.814 1,300.513 ↑ 2.0 7 3 / 3

Parallel Hash Left Join (cost=141,812.17..169,051.02 rows=14 width=189) (actual time=1,263.549..1,300.513 rows=7 loops=3)

  • Hash Cond: (((pmtrqstpkg_t.pmtrqst_pkg_uid)::character varying)::text = (todoitemlist_t.prnt_tbl_seq_id)::text)
23. 144.953 144.953 ↑ 2.0 7 3 / 3

Parallel Seq Scan on pmtrqstpkg_t (cost=0.00..24,460.67 rows=14 width=149) (actual time=121.639..144.953 rows=7 loops=3)

  • Filter: (pmtrqst_pkg_uid = ANY ('{581029,582510,598205,599199,599204,604588,611690,616614,623194,629932,632759,635504,636043,639624,639771,643143,645680,650042,651249,654071,656037,656684,656735,657955,658969,659008,659021,660620,664698,664714,665274,665486,665577}'::integer[]))
  • Rows Removed by Filter: 215,278
24. 136.908 1,103.746 ↑ 1.3 226,323 3 / 3

Parallel Hash (cost=135,483.42..135,483.42 rows=284,220 width=52) (actual time=1,103.745..1,103.746 rows=226,323 loops=3)

  • Buckets: 65,536 Batches: 32 Memory Usage: 2,016kB
25. 966.838 966.838 ↑ 1.3 226,323 3 / 3

Parallel Seq Scan on todoitemlist_t (cost=0.00..135,483.42 rows=284,220 width=52) (actual time=0.017..966.838 rows=226,323 loops=3)

  • Filter: ((todo_itm_cd)::text = ANY ('{EVPR,CSPR,CTPR}'::text[]))
  • Rows Removed by Filter: 1,486,339
26. 0.040 0.040 ↑ 1.0 1 20 / 3

Index Scan using ixpk_organization_t on organization_t (cost=0.28..6.00 rows=1 width=11) (actual time=0.006..0.006 rows=1 loops=20)

  • Index Cond: (org_uid = pmtrqstpkg_t.initg_org_uid)
27. 0.040 0.040 ↑ 1.0 1 20 / 3

Index Scan using ixpk_dcpscase_t on dcpscase_t (cost=0.42..8.44 rows=1 width=43) (actual time=0.006..0.006 rows=1 loops=20)

  • Index Cond: (dcps_case_uid = pmtrqstpkg_t.dcps_case_uid)
28. 0.027 0.027 ↑ 1.0 1 20 / 3

Index Scan using ixpk_userorganization_t on userorganization_t (cost=0.28..0.30 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=20)

  • Index Cond: (dcpscase_t.asgnd_user_org_uid = user_org_uid)
29. 0.020 0.020 ↑ 1.0 1 20 / 3

Index Scan using ixpk_organization_t on organization_t organization_t_1 (cost=0.28..0.38 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=20)

  • Index Cond: (userorganization_t.org_uid = org_uid)
30. 0.027 0.027 ↑ 1.0 1 20 / 3

Index Scan using ixpk_dcpsuser_t on dcpsuser_t (cost=0.28..0.34 rows=1 width=21) (actual time=0.004..0.004 rows=1 loops=20)

  • Index Cond: (userorganization_t.user_uid = user_uid)
31. 0.295 5.124 ↓ 1.0 792 3 / 3

Hash (cost=3,432.45..3,432.45 rows=789 width=139) (actual time=5.123..5.124 rows=792 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
32. 4.388 4.829 ↓ 1.0 792 3 / 3

Bitmap Heap Scan on todoitemlist_t todoitemlist_t_1 (cost=19.51..3,432.45 rows=789 width=139) (actual time=0.719..4.829 rows=792 loops=3)

  • Recheck Cond: ((fup_typ)::text = 'FSCL'::text)
  • Filter: (deld_ts IS NULL)
  • Rows Removed by Filter: 1,441
  • Heap Blocks: exact=1,985
33. 0.441 0.441 ↓ 2.4 2,233 3 / 3

Bitmap Index Scan on ixf04_todoitmcmplddt (cost=0.00..19.31 rows=917 width=0) (actual time=0.441..0.441 rows=2,233 loops=3)

  • Index Cond: ((fup_typ)::text = 'FSCL'::text)
34. 0.020 0.020 ↓ 0.0 0 20 / 3

Index Scan using ceappt_pkey on ceappt_t (cost=0.29..8.07 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=20)

  • Index Cond: (pmtrqstpkg_t.rqst_uid = ce_appt_uid)
35. 0.007 0.020 ↓ 0.0 0 20 / 3

Bitmap Heap Scan on ceappt_t ceappt_t_1 (cost=0.62..4.65 rows=2 width=8) (actual time=0.003..0.003 rows=0 loops=20)

  • Recheck Cond: ((ce_appt_uid = ceappt_t.prnt_appt_uid) OR (ceappt_t.ce_appt_uid = prnt_appt_uid))
  • Filter: (spcarg_cd IS NULL)
36. 0.013 0.013 ↓ 0.0 0 20 / 3

BitmapOr (cost=0.62..0.62 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=20)

37. 0.000 0.000 ↓ 0.0 0 20 / 3

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

  • Index Cond: (ce_appt_uid = ceappt_t.prnt_appt_uid)
38. 0.000 0.000 ↓ 0.0 0 20 / 3

Bitmap Index Scan on ixf01_ceappt_t (cost=0.00..0.31 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=20)

  • Index Cond: (ceappt_t.ce_appt_uid = prnt_appt_uid)
39. 0.013 0.013 ↓ 0.0 0 20 / 3

Index Scan using ixpk_hrgschinfo_t on hrgschinfo_t (cost=0.28..3.45 rows=1 width=41) (actual time=0.002..0.002 rows=0 loops=20)

  • Index Cond: (pmtrqstpkg_t.rqst_uid = hrg_schg_info_uid)
40. 2.393 24.912 ↓ 1.0 10,327 3 / 3

Hash (cost=2,932.20..2,932.20 rows=9,982 width=12) (actual time=24.911..24.912 rows=10,327 loops=3)

  • Buckets: 16,384 Batches: 1 Memory Usage: 572kB
41. 1.530 22.519 ↓ 1.0 10,327 3 / 3

Subquery Scan on ceHist (cost=2,732.56..2,932.20 rows=9,982 width=12) (actual time=18.359..22.519 rows=10,327 loops=3)

42. 9.582 20.989 ↓ 1.0 10,327 3 / 3

HashAggregate (cost=2,732.56..2,832.38 rows=9,982 width=12) (actual time=18.358..20.989 rows=10,327 loops=3)

  • Group Key: ceappthist_t.ce_appt_uid
43. 10.236 11.407 ↓ 1.0 10,432 3 / 3

Bitmap Heap Scan on ceappthist_t (cost=196.57..2,680.85 rows=10,342 width=12) (actual time=1.470..11.407 rows=10,432 loops=3)

  • Recheck Cond: ((appt_stus_cd)::text = 'NOKT'::text)
  • Heap Blocks: exact=2,231
44. 1.171 1.171 ↓ 1.0 10,432 3 / 3

Bitmap Index Scan on ixb01_appt_stus_cd (cost=0.00..193.98 rows=10,342 width=0) (actual time=1.171..1.171 rows=10,432 loops=3)

  • Index Cond: ((appt_stus_cd)::text = 'NOKT'::text)
45. 0.001 0.083 ↓ 0.0 0 3 / 3

GroupAggregate (cost=0.42..246.77 rows=52 width=20) (actual time=0.083..0.083 rows=0 loops=3)

  • Group Key: pmtrqstevid_t.pmtrqst_pkg_uid
46. 0.082 0.082 ↓ 0.0 0 3 / 3

Index Scan using ix2_pmtrqstevid_t on pmtrqstevid_t (cost=0.42..245.86 rows=52 width=128) (actual time=0.082..0.082 rows=0 loops=3)

  • Index Cond: (pmtrqst_pkg_uid = ANY ('{581029,582510,598205,599199,599204,604588,611690,616614,623194,629932,632759,635504,636043,639624,639771,643143,645680,650042,651249,654071,656037,656684,656735,657955,658969,659008,659021,660620,664698,664714,665274,665486,665577}'::integer[]))
47. 989.715 3,953.774 ↑ 1.1 364,909 3 / 3

GroupAggregate (cost=0.43..188,787.88 rows=407,479 width=52) (actual time=0.042..3,953.774 rows=364,909 loops=3)

  • Group Key: pmtrqavt_t_1.pmtrqst_pkg_uid
48. 2,964.059 2,964.059 ↑ 1.0 939,363 3 / 3

Index Scan using pmtrqavt_t_pmtrqst_pkg_uid_idx on pmtrqavt_t pmtrqavt_t_1 (cost=0.43..153,939.78 rows=946,871 width=16) (actual time=0.020..2,964.059 rows=939,363 loops=3)

  • Filter: ((fscl_stus_cd)::text = ANY ('{APRV,SBMT,PAID}'::text[]))
  • Rows Removed by Filter: 1,935,677
49. 0.001 0.107 ↓ 0.0 0 3 / 3

GroupAggregate (cost=456.14..457.40 rows=36 width=36) (actual time=0.107..0.107 rows=0 loops=3)

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid
50. 0.000 0.106 ↓ 0.0 0 3 / 3

Group (cost=456.14..456.41 rows=36 width=24) (actual time=0.106..0.106 rows=0 loops=3)

  • Group Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
51. 0.048 0.106 ↓ 0.0 0 3 / 3

Sort (cost=456.14..456.23 rows=36 width=24) (actual time=0.106..0.106 rows=0 loops=3)

  • Sort Key: pkgpmta_t.pmtrqst_pkg_uid, pmt_t.pmt_num
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
52. 0.000 0.058 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.84..455.21 rows=36 width=24) (actual time=0.058..0.058 rows=0 loops=3)

53. 0.058 0.058 ↓ 0.0 0 3 / 3

Index Scan using ixf01_pkgpmta_t on pkgpmta_t (cost=0.42..155.46 rows=36 width=8) (actual time=0.058..0.058 rows=0 loops=3)

  • Index Cond: (pmtrqst_pkg_uid = ANY ('{581029,582510,598205,599199,599204,604588,611690,616614,623194,629932,632759,635504,636043,639624,639771,643143,645680,650042,651249,654071,656037,656684,656735,657955,658969,659008,659021,660620,664698,664714,665274,665486,665577}'::integer[]))
54. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using ixpk_pmt_t on pmt_t (cost=0.42..8.33 rows=1 width=24) (never executed)

  • Index Cond: (pmt_uid = pkgpmta_t.pmt_uid)
55. 0.060 0.060 ↑ 1.0 1 20 / 3

Index Scan using ixf02_pmtrqstpkguid on pmtrqst_t (cost=0.42..8.44 rows=1 width=59) (actual time=0.008..0.009 rows=1 loops=20)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t.pmtrqst_pkg_uid)
  • Filter: (fscl_stus_cd IS NULL)
56. 0.007 0.007 ↓ 0.0 0 20 / 3

Index Scan using cccntct_pkey on cccntct_t (cost=0.42..0.49 rows=1 width=65) (actual time=0.001..0.001 rows=0 loops=20)

  • Index Cond: (pmtrqst_t.tp_pye_uid = clnt_cntct_uid)
57. 0.067 0.067 ↑ 1.0 1 20 / 3

Index Scan using ixf02_pin on dcpsuser_t dcpsuser_t_1 (cost=0.28..0.30 rows=1 width=23) (actual time=0.010..0.010 rows=1 loops=20)

  • Index Cond: ((pmtrqst_t.lu_pin)::text = (pin)::text)
58. 0.040 0.040 ↑ 1.0 1 20 / 3

Index Scan using ixf02_pin on dcpsuser_t dcpsuser_t_2 (cost=0.28..4.78 rows=1 width=23) (actual time=0.005..0.006 rows=1 loops=20)

  • Index Cond: ((pmtrqstpkg_t.lu_pin)::text = (pin)::text)
59. 28.280 3,519.940 ↓ 0.0 0 20

Hash Join (cost=78,355.24..78,406.91 rows=1 width=36) (actual time=175.997..175.997 rows=0 loops=20)

  • Hash Cond: ((max(pmtrqavt_t_2.pmtrqah_uid)) = pmtrqavt_t.pmtrqah_uid)
60. 99.120 3,491.420 ↓ 13.0 22,329 20

GroupAggregate (cost=78,332.72..78,362.73 rows=1,715 width=8) (actual time=168.177..174.571 rows=22,329 loops=20)

  • Group Key: pmtrqavt_t_2.pmtrqst_pkg_uid
61. 156.840 3,392.300 ↓ 14.0 24,072 20

Sort (cost=78,332.72..78,337.01 rows=1,715 width=8) (actual time=168.173..169.615 rows=24,072 loops=20)

  • Sort Key: pmtrqavt_t_2.pmtrqst_pkg_uid
  • Sort Method: quicksort Memory: 1,897kB
62. 126.100 3,235.460 ↓ 14.0 24,072 20

Nested Loop (cost=64,324.20..78,240.59 rows=1,715 width=8) (actual time=97.299..161.773 rows=24,072 loops=20)

63. 76.300 2,146.480 ↓ 14.0 24,072 20

Group (cost=64,323.77..64,495.98 rows=1,715 width=4) (actual time=97.287..107.324 rows=24,072 loops=20)

  • Group Key: pmtrqavt_t_3.pmtrqah_uid
64. 256.140 2,070.180 ↓ 16.8 24,072 20

Gather Merge (cost=64,323.77..64,492.40 rows=1,430 width=4) (actual time=97.286..103.509 rows=24,072 loops=20)

  • Workers Planned: 2
  • Workers Launched: 2
65. 39.920 1,814.040 ↓ 11.2 8,024 60 / 3

Group (cost=63,323.74..63,327.32 rows=715 width=4) (actual time=87.957..90.702 rows=8,024 loops=60)

  • Group Key: pmtrqavt_t_3.pmtrqah_uid
66. 98.420 1,774.120 ↓ 11.2 8,024 60 / 3

Sort (cost=63,323.74..63,325.53 rows=715 width=4) (actual time=87.885..88.706 rows=8,024 loops=60)

  • Sort Key: pmtrqavt_t_3.pmtrqah_uid
  • Sort Method: quicksort Memory: 480kB
  • Worker 0: Sort Method: quicksort Memory: 451kB
  • Worker 1: Sort Method: quicksort Memory: 967kB
67. 144.280 1,675.700 ↓ 11.2 8,024 60 / 3

Nested Loop (cost=424.48..63,289.85 rows=715 width=4) (actual time=1.466..83.785 rows=8,024 loops=60)

68. 169.053 188.200 ↑ 1.2 7,462 60 / 3

Parallel Bitmap Heap Scan on pmtrqstpkg_t pmtrqstpkg_t_1 (cost=424.05..11,230.43 rows=9,159 width=4) (actual time=1.444..9.410 rows=7,462 loops=60)

  • Recheck Cond: ((fscl_stus_cd)::text = ANY ('{REJT,ERR,NCOR,HOLD}'::text[]))
  • Heap Blocks: exact=46,177
69. 19.147 19.147 ↓ 1.0 22,387 20 / 3

Bitmap Index Scan on ixb01_pmtrqstpkg_t (cost=0.00..418.55 rows=21,981 width=0) (actual time=2.872..2.872 rows=22,387 loops=20)

  • Index Cond: ((fscl_stus_cd)::text = ANY ('{REJT,ERR,NCOR,HOLD}'::text[]))
70. 1,343.220 1,343.220 ↑ 1.0 1 447,740 / 3

Index Scan using pmtrqavt_t_pmtrqst_pkg_uid_idx on pmtrqavt_t pmtrqavt_t_3 (cost=0.43..5.67 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=447,740)

  • Index Cond: (pmtrqst_pkg_uid = pmtrqstpkg_t_1.pmtrqst_pkg_uid)
  • Filter: ((pmtrqact_cd)::text = ANY ('{REJCT,COERR,RERCT,POHLD}'::text[]))
  • Rows Removed by Filter: 2
71. 962.880 962.880 ↑ 1.0 1 481,440

Index Scan using pmtrqavt_t_pkey on pmtrqavt_t pmtrqavt_t_2 (cost=0.43..8.00 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=481,440)

  • Index Cond: (pmtrqah_uid = pmtrqavt_t_3.pmtrqah_uid)
72. 0.080 0.240 ↑ 7.0 1 20

Hash (cost=22.44..22.44 rows=7 width=40) (actual time=0.012..0.012 rows=1 loops=20)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
73. 0.160 0.160 ↑ 7.0 1 20

Index Scan using pmtrqavt_t_pmtrqst_pkg_uid_idx on pmtrqavt_t (cost=0.43..22.44 rows=7 width=40) (actual time=0.008..0.008 rows=1 loops=20)

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

SubPlan (for Index Scan)

75. 0.000 0.000 ↓ 0.0 0

Seq Scan on prqactrsncd_t (cost=0.00..1.88 rows=1 width=33) (never executed)

  • Filter: ((pmtrqact_rsn_cd)::text = (pmtrqavt_t.pmtrqact_rsn_cd)::text)
76.          

SubPlan (for Nested Loop Left Join)

77. 0.000 0.000 ↓ 0.0 0

Result (cost=17.59..17.60 rows=1 width=32) (never executed)

78.          

Initplan (for Result)

79. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.99..17.59 rows=100 width=32) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..17.08 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.42..8.44 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.28..0.34 rows=1 width=37) (never executed)

  • Index Cond: (prod_uid = stcatlgprod_t.prod_uid)
Planning time : 14.651 ms
Execution time : 8,965.786 ms