explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G3p5

Settings
# exclusive inclusive rows x rows loops node
1. 0.217 482.873 ↓ 68.0 68 1

Hash Right Join (cost=19,815.59..19,827.40 rows=1 width=757) (actual time=360.181..482.873 rows=68 loops=1)

  • Hash Cond: (ppo.ptab_case_id = pd.ptab_case_id)
2.          

CTE related_ptabs

3. 0.019 352.987 ↓ 3.6 209 1

Append (cost=47.02..19,169.54 rows=58 width=36) (actual time=0.144..352.987 rows=209 loops=1)

4.          

CTE all_aliases

5. 0.044 0.814 ↓ 8.0 376 1

Append (cost=1.17..46.73 rows=47 width=4) (actual time=0.048..0.814 rows=376 loops=1)

6. 0.079 0.763 ↓ 8.2 376 1

Nested Loop Left Join (cost=1.17..10.44 rows=46 width=4) (actual time=0.048..0.763 rows=376 loops=1)

7. 0.004 0.063 ↓ 3.0 3 1

Nested Loop (cost=0.73..9.55 rows=1 width=8) (actual time=0.030..0.063 rows=3 loops=1)

8. 0.005 0.035 ↓ 3.0 3 1

Nested Loop (cost=0.29..6.89 rows=1 width=4) (actual time=0.020..0.035 rows=3 loops=1)

  • Join Filter: (pp_drv.ptab_party_type_id = ppt_drv.id)
  • Rows Removed by Join Filter: 9
9. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on ptab_party_types ppt_drv (cost=0.00..1.05 rows=1 width=4) (actual time=0.002..0.004 rows=1 loops=1)

  • Filter: ((name)::text = 'Patent Owner'::text)
  • Rows Removed by Filter: 3
10. 0.026 0.026 ↓ 3.0 12 1

Index Scan using ptab_parties_ptab_case_id_idx on ptab_parties pp_drv (cost=0.29..5.79 rows=4 width=8) (actual time=0.009..0.026 rows=12 loops=1)

  • Index Cond: (ptab_case_id = 4,138)
11. 0.024 0.024 ↑ 1.0 1 3

Index Scan using alias_ent_details_alias_id_idx on alias_ent_details al_drv (cost=0.44..2.66 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: (alias_id = pp_drv.alias_id)
12. 0.621 0.621 ↓ 8.3 125 3

Index Scan using alias_ent_details_ultimate_parent_id_idx on alias_ent_details al (cost=0.44..0.74 rows=15 width=8) (actual time=0.013..0.207 rows=125 loops=3)

  • Index Cond: (al_drv.ultimate_parent_id = ultimate_parent_id)
13. 0.001 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.45..35.81 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

14. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.01..34.92 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=1)

15. 0.000 0.006 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..8.32 rows=1 width=25) (actual time=0.006..0.006 rows=0 loops=1)

  • Join Filter: (pp.ptab_case_id = ap.ptab_case_id)
16. 0.006 0.006 ↓ 0.0 0 1

Index Scan using all_ptab_ptab_case_id_is_likely_patent_owner_idx on all_ptab ap (cost=0.29..2.50 rows=1 width=29) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((ptab_case_id = 4,138) AND (is_likely_patent_owner = true))
  • Filter: is_likely_patent_owner
17. 0.000 0.000 ↓ 0.0 0

Index Scan using ptab_parties_ptab_case_id_idx on ptab_parties pp (cost=0.29..5.80 rows=1 width=4) (never executed)

  • Index Cond: (ptab_case_id = 4,138)
  • Filter: (ptab_party_type_id = 2)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using alias_ent_details_alias_id_idx on alias_ent_details al_drv_1 (cost=0.44..26.51 rows=10 width=8) (never executed)

  • Index Cond: (alias_id = ANY (ap.patent_owner_alias_ids))
19. 0.000 0.000 ↓ 0.0 0

Index Scan using alias_ent_details_ultimate_parent_id_idx on alias_ent_details al_1 (cost=0.44..0.74 rows=15 width=8) (never executed)

  • Index Cond: (al_drv_1.ultimate_parent_id = ultimate_parent_id)
20. 0.012 2.084 ↑ 1.7 33 1

Nested Loop (cost=0.29..302.29 rows=55 width=36) (actual time=0.143..2.084 rows=33 loops=1)

  • Join Filter: (pp_1.ptab_party_type_id = ppt.id)
  • Rows Removed by Join Filter: 21
21. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on ptab_party_types ppt (cost=0.00..1.05 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=1)

  • Filter: ((name)::text = 'Patent Owner'::text)
  • Rows Removed by Filter: 3
22. 0.000 2.067 ↑ 4.1 54 1

Nested Loop (cost=0.29..298.49 rows=220 width=8) (actual time=0.137..2.067 rows=54 loops=1)

23. 0.963 0.963 ↓ 8.0 376 1

CTE Scan on all_aliases aa (cost=0.00..0.94 rows=47 width=4) (actual time=0.049..0.963 rows=376 loops=1)

24. 1.128 1.128 ↓ 0.0 0 376

Index Scan using ptab_parties_alias_id_idx on ptab_parties pp_1 (cost=0.29..6.28 rows=5 width=12) (actual time=0.002..0.003 rows=0 loops=376)

  • Index Cond: (alias_id = aa.alias_id)
  • Filter: (ptab_case_id <> 4138)
  • Rows Removed by Filter: 0
25. 1.503 3.169 ↓ 0.0 0 1

Nested Loop (cost=0.57..303.80 rows=1 width=36) (actual time=3.169..3.169 rows=0 loops=1)

  • Join Filter: (aa_1.alias_id = ANY (ap_1.patent_owner_alias_ids))
  • Rows Removed by Join Filter: 7,144
26. 0.021 0.735 ↓ 19.0 19 1

Nested Loop Anti Join (cost=0.57..301.80 rows=1 width=29) (actual time=0.287..0.735 rows=19 loops=1)

27. 0.657 0.657 ↓ 1.6 19 1

Index Scan using all_ptab_ptab_case_id_is_likely_patent_owner_idx on all_ptab ap_1 (cost=0.29..242.20 rows=12 width=29) (actual time=0.278..0.657 rows=19 loops=1)

  • Index Cond: (is_likely_patent_owner = true)
  • Filter: (is_likely_patent_owner AND (ptab_case_id <> 4138))
28. 0.057 0.057 ↓ 0.0 0 19

Index Scan using ptab_parties_ptab_case_id_idx on ptab_parties pp_2 (cost=0.29..5.71 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=19)

  • Index Cond: (ptab_case_id = ap_1.ptab_case_id)
  • Filter: (ptab_party_type_id = 2)
  • Rows Removed by Filter: 1
29. 0.931 0.931 ↓ 8.0 376 19

CTE Scan on all_aliases aa_1 (cost=0.00..0.94 rows=47 width=4) (actual time=0.000..0.049 rows=376 loops=19)

30. 228.056 303.322 ↓ 154.0 154 1

Nested Loop (cost=11.67..11,172.06 rows=1 width=36) (actual time=157.799..303.322 rows=154 loops=1)

  • Join Filter: ((((rpc.stripped_patnum)::text = (pats.stripped_patnum)::text) AND ((rpc.country_code)::text = (pfp.country_code)::text)) OR ((pats.app_num_country)::text = (('US'::text || (rpc.application_num)::text))::text))
  • Rows Removed by Join Filter: 1,505,534
31.          

Initplan (for Nested Loop)

32. 2.748 2.748 ↑ 1,000.0 1 1

Function Scan on get_ptab_campaign (cost=0.25..10.25 rows=1,000 width=4) (actual time=2.748..2.748 rows=1 loops=1)

33. 2.486 2.486 ↑ 1.0 11,672 1

Seq Scan on ptab_cases rpc (cost=0.00..532.91 rows=11,672 width=24) (actual time=0.009..2.486 rows=11,672 loops=1)

  • Filter: (id <> 4138)
  • Rows Removed by Filter: 1
34. 65.226 70.032 ↓ 3.3 129 11,672

Materialize (cost=1.42..386.81 rows=39 width=22) (actual time=0.000..0.006 rows=129 loops=11,672)

35. 0.068 4.806 ↓ 3.3 129 1

Nested Loop (cost=1.42..386.62 rows=39 width=22) (actual time=2.794..4.806 rows=129 loops=1)

36. 0.023 3.061 ↓ 3.3 129 1

Nested Loop (cost=0.86..361.62 rows=39 width=12) (actual time=2.772..3.061 rows=129 loops=1)

37. 2.768 2.768 ↓ 3.0 9 1

Index Scan using campaign_patents__campaign_id_patnum_uniq_idx on campaign_patents cpc (cost=0.29..4.74 rows=3 width=4) (actual time=2.758..2.768 rows=9 loops=1)

  • Index Cond: (campaign_id = $5)
38. 0.270 0.270 ↓ 1.1 14 9

Index Scan using pat_family_pats_pat_family_id_idx_1 on pat_family_pats pfp (cost=0.57..118.83 rows=13 width=16) (actual time=0.007..0.030 rows=14 loops=9)

  • Index Cond: (pat_family_id = cpc.pat_family_id)
  • Filter: ((country_code)::text = 'US'::text)
  • Rows Removed by Filter: 19
39. 1.677 1.677 ↑ 1.0 1 129

Index Scan using idx_pats_stripped_patnum on pats (cost=0.56..0.63 rows=1 width=22) (actual time=0.013..0.013 rows=1 loops=129)

  • Index Cond: ((stripped_patnum)::text = (pfp.stripped_patnum)::text)
  • Filter: ((country_code)::text = 'US'::text)
40. 31.643 44.393 ↓ 22.0 22 1

Nested Loop (cost=1.99..7,344.09 rows=1 width=36) (actual time=22.396..44.393 rows=22 loops=1)

  • Join Filter: ((rpc_1.id <> pc.id) AND ((((rpc_1.stripped_patnum)::text = (pats_1.stripped_patnum)::text) AND ((rpc_1.country_code)::text = (pats_1.country_code)::text)) OR ((pats_1.app_num_country)::text = ('US'::text || (rpc_1.application_num)::text))))
  • Rows Removed by Join Filter: 198,419
41. 1.077 1.077 ↑ 1.0 11,673 1

Seq Scan on ptab_cases rpc_1 (cost=0.00..503.73 rows=11,673 width=24) (actual time=0.007..1.077 rows=11,673 loops=1)

42. 11.225 11.673 ↑ 1.4 17 11,673

Materialize (cost=1.99..128.45 rows=23 width=26) (actual time=0.000..0.001 rows=17 loops=11,673)

43. 0.010 0.448 ↑ 1.4 17 1

Nested Loop (cost=1.99..128.33 rows=23 width=26) (actual time=0.081..0.448 rows=17 loops=1)

44. 0.006 0.078 ↑ 4.6 40 1

Nested Loop (cost=1.43..18.80 rows=183 width=16) (actual time=0.042..0.078 rows=40 loops=1)

45. 0.003 0.031 ↑ 1.0 1 1

Nested Loop (cost=0.86..15.32 rows=1 width=8) (actual time=0.030..0.031 rows=1 loops=1)

46. 0.008 0.008 ↑ 1.0 1 1

Index Scan using ptab_cases_pkey on ptab_cases pc (cost=0.29..2.50 rows=1 width=15) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = 4,138)
47. 0.020 0.020 ↑ 1.0 1 1

Index Scan using pat_family_pats_stripped_patnum_idx_1 on pat_family_pats pfp_drv (cost=0.57..12.81 rows=1 width=16) (actual time=0.018..0.020 rows=1 loops=1)

  • Index Cond: ((stripped_patnum)::text = (pc.stripped_patnum)::text)
  • Filter: ((pc.country_code)::text = (country_code)::text)
  • Rows Removed by Filter: 1
48. 0.041 0.041 ↑ 2.6 40 1

Index Scan using pat_family_pats_pat_family_id_idx_1 on pat_family_pats pfp_all (cost=0.57..2.42 rows=105 width=16) (actual time=0.011..0.041 rows=40 loops=1)

  • Index Cond: (pat_family_id = pfp_drv.pat_family_id)
49. 0.360 0.360 ↓ 0.0 0 40

Index Scan using idx_pats_stripped_patnum on pats pats_1 (cost=0.56..0.59 rows=1 width=22) (actual time=0.009..0.009 rows=0 loops=40)

  • Index Cond: ((stripped_patnum)::text = (pfp_all.stripped_patnum)::text)
  • Filter: ((pfp_all.country_code)::text = (country_code)::text)
  • Rows Removed by Filter: 0
50.          

CTE ptab_patent_owners

51. 0.046 0.443 ↑ 2.0 32 1

HashAggregate (cost=627.81..628.46 rows=65 width=41) (actual time=0.417..0.443 rows=32 loops=1)

  • Group Key: related_ptabs.ptab_case_id, (COALESCE(aed.ultimate_parent_name, aed.ent_name, aed.alias_name)), (COALESCE(aed.ultimate_parent_id, aed.ent_id, aed.alias_id)), (CASE WHEN (aed.ent_id IS NULL) THEN false ELSE true END)
52. 0.005 0.397 ↑ 1.7 39 1

Append (cost=2.03..627.16 rows=65 width=41) (actual time=0.066..0.397 rows=39 loops=1)

53. 0.024 0.314 ↑ 1.6 39 1

Nested Loop (cost=2.03..459.80 rows=64 width=41) (actual time=0.066..0.314 rows=39 loops=1)

54. 0.012 0.173 ↑ 1.6 39 1

Nested Loop (cost=1.59..316.66 rows=64 width=8) (actual time=0.057..0.173 rows=39 loops=1)

  • Join Filter: (pp_3.ptab_party_type_id = ppt_1.id)
  • Rows Removed by Join Filter: 99
55. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on ptab_party_types ppt_1 (cost=0.00..1.05 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=1)

  • Filter: ((name)::text = 'Patent Owner'::text)
  • Rows Removed by Filter: 3
56. 0.031 0.157 ↑ 1.8 138 1

Nested Loop (cost=1.59..312.43 rows=255 width=12) (actual time=0.051..0.157 rows=138 loops=1)

57. 0.035 0.050 ↑ 3.1 19 1

HashAggregate (cost=1.30..1.88 rows=58 width=4) (actual time=0.046..0.050 rows=19 loops=1)

  • Group Key: related_ptabs.ptab_case_id
58. 0.015 0.015 ↓ 3.6 209 1

CTE Scan on related_ptabs (cost=0.00..1.16 rows=58 width=4) (actual time=0.000..0.015 rows=209 loops=1)

59. 0.076 0.076 ↓ 1.8 7 19

Index Scan using ptab_parties_ptab_case_id_idx on ptab_parties pp_3 (cost=0.29..5.30 rows=4 width=12) (actual time=0.002..0.004 rows=7 loops=19)

  • Index Cond: (ptab_case_id = related_ptabs.ptab_case_id)
60. 0.117 0.117 ↑ 1.0 1 39

Index Scan using alias_ent_details_alias_id_idx on alias_ent_details aed (cost=0.44..2.23 rows=1 width=69) (actual time=0.003..0.003 rows=1 loops=39)

  • Index Cond: (alias_id = pp_3.alias_id)
61. 0.000 0.078 ↓ 0.0 0 1

Nested Loop (cost=2.32..166.71 rows=1 width=41) (actual time=0.078..0.078 rows=0 loops=1)

62. 0.000 0.078 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.88..140.10 rows=1 width=29) (actual time=0.078..0.078 rows=0 loops=1)

63. 0.009 0.078 ↓ 0.0 0 1

Nested Loop (cost=1.59..135.14 rows=1 width=33) (actual time=0.078..0.078 rows=0 loops=1)

64. 0.035 0.050 ↑ 3.1 19 1

HashAggregate (cost=1.30..1.88 rows=58 width=4) (actual time=0.048..0.050 rows=19 loops=1)

  • Group Key: related_ptabs_1.ptab_case_id
65. 0.015 0.015 ↓ 3.6 209 1

CTE Scan on related_ptabs related_ptabs_1 (cost=0.00..1.16 rows=58 width=4) (actual time=0.000..0.015 rows=209 loops=1)

66. 0.019 0.019 ↓ 0.0 0 19

Index Scan using all_ptab_ptab_case_id_is_likely_patent_owner_idx on all_ptab ap_2 (cost=0.29..2.28 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=19)

  • Index Cond: ((ptab_case_id = related_ptabs_1.ptab_case_id) AND (is_likely_patent_owner = true))
  • Filter: is_likely_patent_owner
67. 0.000 0.000 ↓ 0.0 0

Index Scan using ptab_parties_ptab_case_id_idx on ptab_parties pp_4 (cost=0.29..5.71 rows=1 width=4) (never executed)

  • Index Cond: (ptab_case_id = ap_2.ptab_case_id)
  • Filter: (ptab_party_type_id = 2)
68. 0.000 0.000 ↓ 0.0 0

Index Scan using alias_ent_details_alias_id_idx on alias_ent_details aed_1 (cost=0.44..26.51 rows=10 width=69) (never executed)

  • Index Cond: (alias_id = ANY (ap_2.patent_owner_alias_ids))
69.          

CTE ptab_dtls

70. 0.019 357.588 ↓ 38.0 38 1

Unique (cost=17.55..17.56 rows=1 width=648) (actual time=357.563..357.588 rows=38 loops=1)

71. 0.091 357.569 ↓ 133.0 133 1

Sort (cost=17.55..17.55 rows=1 width=648) (actual time=357.563..357.569 rows=133 loops=1)

  • Sort Key: pc_1.id, (COALESCE(aed_2.ultimate_parent_id, aed_2.ent_id, aed_2.alias_id)), pats_2.id DESC
  • Sort Method: quicksort Memory: 60kB
72. 0.086 357.478 ↓ 133.0 133 1

Nested Loop (cost=4.64..17.54 rows=1 width=648) (actual time=353.170..357.478 rows=133 loops=1)

73. 0.021 1.617 ↓ 133.0 133 1

Nested Loop (cost=4.20..13.98 rows=1 width=98) (actual time=0.223..1.617 rows=133 loops=1)

74. 0.069 1.322 ↓ 68.5 274 1

Nested Loop (cost=4.07..13.37 rows=4 width=102) (actual time=0.218..1.322 rows=274 loops=1)

75. 0.032 1.022 ↓ 33.0 33 1

Nested Loop Left Join (cost=3.78..12.84 rows=1 width=94) (actual time=0.212..1.022 rows=33 loops=1)

76. 0.000 0.396 ↓ 33.0 33 1

Nested Loop Left Join (cost=0.57..6.26 rows=1 width=77) (actual time=0.163..0.396 rows=33 loops=1)

77. 0.022 0.264 ↓ 33.0 33 1

Nested Loop (cost=0.29..3.74 rows=1 width=50) (actual time=0.153..0.264 rows=33 loops=1)

78. 0.176 0.176 ↓ 33.0 33 1

CTE Scan on related_ptabs rp (cost=0.00..1.23 rows=1 width=4) (actual time=0.146..0.176 rows=33 loops=1)

  • Filter: (relation_type = ANY ('{"By Patent Owner"}'::text[]))
  • Rows Removed by Filter: 176
79. 0.066 0.066 ↑ 1.0 1 33

Index Scan using ptab_cases_pkey on ptab_cases pc_1 (cost=0.29..2.50 rows=1 width=46) (actual time=0.002..0.002 rows=1 loops=33)

  • Index Cond: (id = rp.ptab_case_id)
80. 0.033 0.132 ↑ 1.0 1 33

Limit (cost=0.29..2.50 rows=1 width=27) (actual time=0.003..0.004 rows=1 loops=33)

81. 0.099 0.099 ↑ 1.0 1 33

Index Scan using all_ptab_ptab_case_id_is_likely_patent_owner_idx on all_ptab ap_3 (cost=0.29..2.50 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=33)

  • Index Cond: (ptab_case_id = pc_1.id)
82. 0.099 0.594 ↑ 1.0 1 33

Bitmap Heap Scan on pats pats_2 (cost=3.21..6.57 rows=1 width=51) (actual time=0.017..0.018 rows=1 loops=33)

  • Recheck Cond: (((pc_1.stripped_patnum)::text = (stripped_patnum)::text) OR ((app_num_country)::text = ('US'::text || (pc_1.application_num)::text)))
  • Filter: ((((pc_1.stripped_patnum)::text = (stripped_patnum)::text) AND ((pc_1.country_code)::text = (country_code)::text)) OR ((pc_1.stripped_patnum IS NULL) AND ((app_num_country)::text = ('US'::text || (pc_1.application_num)::text))))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=65
83. 0.033 0.495 ↓ 0.0 0 33

BitmapOr (cost=3.21..3.21 rows=3 width=0) (actual time=0.015..0.015 rows=0 loops=33)

84. 0.198 0.198 ↑ 1.0 1 33

Bitmap Index Scan on idx_pats_stripped_patnum (cost=0.00..1.60 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=33)

  • Index Cond: ((pc_1.stripped_patnum)::text = (stripped_patnum)::text)
85. 0.264 0.264 ↑ 1.0 2 33

Bitmap Index Scan on idx_pats_app_num_country (cost=0.00..1.61 rows=2 width=0) (actual time=0.008..0.008 rows=2 loops=33)

  • Index Cond: ((app_num_country)::text = ('US'::text || (pc_1.application_num)::text))
86. 0.231 0.231 ↓ 2.0 8 33

Index Scan using ptab_parties_ptab_case_id_idx on ptab_parties pp_5 (cost=0.29..0.49 rows=4 width=12) (actual time=0.003..0.007 rows=8 loops=33)

  • Index Cond: (ptab_case_id = pc_1.id)
87. 0.274 0.274 ↓ 0.0 0 274

Index Scan using ptab_party_types_pkey on ptab_party_types ppt_2 (cost=0.13..0.15 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=274)

  • Index Cond: (id = pp_5.ptab_party_type_id)
  • Filter: ((name)::text = 'Petitioner'::text)
  • Rows Removed by Filter: 1
88. 0.399 0.399 ↑ 1.0 1 133

Index Scan using alias_ent_details_alias_id_idx on alias_ent_details aed_2 (cost=0.44..2.23 rows=1 width=69) (actual time=0.002..0.003 rows=1 loops=133)

  • Index Cond: (alias_id = pp_5.alias_id)
89.          

SubPlan (for Nested Loop)

90. 0.665 355.376 ↑ 1.0 1 133

Aggregate (cost=1.31..1.32 rows=1 width=32) (actual time=2.672..2.672 rows=1 loops=133)

91. 354.711 354.711 ↓ 17.0 17 133

CTE Scan on related_ptabs r2 (cost=0.00..1.30 rows=1 width=32) (actual time=0.001..2.667 rows=17 loops=133)

  • Filter: (ptab_case_id = rp.ptab_case_id)
  • Rows Removed by Filter: 192
92. 0.467 0.467 ↑ 2.0 32 1

CTE Scan on ptab_patent_owners ppo (cost=0.00..1.30 rows=65 width=41) (actual time=0.418..0.467 rows=32 loops=1)

93. 0.012 357.613 ↓ 38.0 38 1

Hash (cost=0.02..0.02 rows=1 width=688) (actual time=357.613..357.613 rows=38 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
94. 357.601 357.601 ↓ 38.0 38 1

CTE Scan on ptab_dtls pd (cost=0.00..0.02 rows=1 width=688) (actual time=357.565..357.601 rows=38 loops=1)

95.          

SubPlan (for Hash Right Join)

96. 124.576 124.576 ↑ 1,000.0 1 68

Function Scan on get_ptab_case_name (cost=0.25..10.25 rows=1,000 width=32) (actual time=1.832..1.832 rows=1 loops=68)

Planning time : 8.048 ms
Execution time : 483.432 ms