explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 3Hv

options
# exclusive inclusive rows x rows loops node
1. 10.053 7479.445 ↑ 2.1 8 1
→

GroupAggregate (cost=303459.34..303511.83 rows=17 width=41) (actual time=7462.920..7479.445 rows=8 loops=1)

2. 14.992 7463.472 ↓ 657.8 11182 1
→

Sort (cost=303459.34..303459.38 rows=17 width=41) (actual time=7461.583..7463.472 rows=11182 loops=1)

  • Sort Key: (CASE WHEN (hr.miss_root_cause_id IS NULL) THEN NULL::character varying ELSE (SubPlan 1) END), ((hr.hit)::integer)
  • Sort Method: external merge Disk: 416kB
3. 336.028 7448.480 ↓ 657.8 11182 1
→

Hash Join (cost=120749.21..303458.99 rows=17 width=41) (actual time=4217.970..7448.480 rows=11182 loops=1)

  • Hash Cond: (((scr.region)::text = (vw_param_region.region_code)::text) AND ((m.code)::text = (m.code)::text))
4. 199.994 6024.568 ↓ 1.1 566493 1
→

Hash Left Join (cost=99949.85..278921.73 rows=494959 width=24) (actual time=2968.976..6024.568 rows=566493 loops=1)

  • Hash Cond: ((ira.dc_pc_id)::text = (dc_pc.pc_id)::text)
5. 208.809 5824.569 ↓ 1.1 566493 1
→

Hash Left Join (cost=99948.65..272114.84 rows=494959 width=30) (actual time=2968.966..5824.569 rows=566493 loops=1)

  • Hash Cond: ((ira.supply_pc_id)::text = (supply_pc.pc_id)::text)
6. 201.466 5615.755 ↓ 1.1 566493 1
→

Hash Left Join (cost=99947.44..265307.95 rows=494959 width=36) (actual time=2968.957..5615.755 rows=566493 loops=1)

  • Hash Cond: ((ira.field_pc_id)::text = (field_pc.pc_id)::text)
7. 225.753 5414.271 ↓ 1.1 566493 1
→

Hash Left Join (cost=99946.24..258501.06 rows=494959 width=42) (actual time=2968.934..5414.271 rows=566493 loops=1)

  • Hash Cond: (((m.code)::text = (lma.mat_code)::text) AND ((ldm.log_div)::text = (lma.log_div)::text))
8. 169.455 5188.305 ↓ 1.1 566493 1
→

Hash Left Join (cost=99930.87..249822.29 rows=494959 width=42) (actual time=2968.709..5188.305 rows=566493 loops=1)

  • Hash Cond: ((m.id = cma.material_id) AND (scr.cid = cma.cid))
9. 182.126 5018.849 ↓ 1.1 566493 1
→

Hash Left Join (cost=99906.87..178029.08 rows=494959 width=50) (actual time=2968.701..5018.849 rows=566493 loops=1)

  • Hash Cond: (((ldm.log_div)::text = (igm.region)::text) AND ((ma.part_group)::text = (igm.item_group_code)::text))
10. 189.614 4836.705 ↓ 1.1 566493 1
→

Hash Left Join (cost=99905.34..172777.44 rows=494959 width=52) (actual time=2968.677..4836.705 rows=566493 loops=1)

  • Hash Cond: (((ldm.log_div)::text = (lcm.log_div)::text) AND ((ma.com_code)::text = (lcm.com_code)::text))
11. 608.224 4646.945 ↓ 1.1 566493 1
→

Merge Right Join (cost=99896.24..161269.41 rows=494959 width=54) (actual time=2968.512..4646.945 rows=566493 loops=1)

  • Merge Cond: (((ira.region)::text = (ldm.log_div)::text) AND ((ira.item_code)::text = (m.code)::text))
12. 338.129 338.129 ↑ 1.0 566493 1
→

Index Scan using item_region_attr_pkey on item_region_attr ira (cost=0.00..47858.61 rows=566493 width=36) (actual time=0.040..338.129 rows=566493 loops=1)

13. 103.160 3700.592 ↓ 1.1 566493 1
→

Materialize (cost=99896.24..106083.23 rows=494959 width=36) (actual time=2968.463..3700.592 rows=566493 loops=1)

14. 3054.270 3597.432 ↓ 1.1 566493 1
→

Sort (cost=99896.24..101133.64 rows=494959 width=36) (actual time=2968.452..3597.432 rows=566493 loops=1)

  • Sort Key: scr.region, m.code
  • Sort Method: external merge Disk: 26856kB
15. 151.623 543.162 ↓ 1.1 566493 1
→

Hash Join (cost=9042.37..26011.67 rows=494959 width=36) (actual time=112.303..543.162 rows=566493 loops=1)

  • Hash Cond: (ma.region_id = ldm.material_master_region_id)
16. 105.179 391.446 ↑ 1.0 93477 1
→

Hash Join (cost=9038.37..20006.46 rows=93477 width=24) (actual time=112.164..391.446 rows=93477 loops=1)

  • Hash Cond: (ma.material_id = m.id)
17. 22.579 246.535 ↑ 1.0 93477 1
→

Hash Left Join (cost=5965.58..14048.67 rows=93477 width=12) (actual time=72.246..246.535 rows=93477 loops=1)

  • Hash Cond: (ma.similar_material_id = m2.id)
18. 92.873 187.883 ↑ 1.0 93477 1
→

Hash Join (cost=2982.79..8855.10 rows=93477 width=16) (actual time=36.124..187.883 rows=93477 loops=1)

  • Hash Cond: (ma.master_material_id = m1.id)
19. 58.973 58.973 ↑ 1.0 93477 1
→

Seq Scan on material_attr ma (cost=0.00..2544.77 rows=93477 width=20) (actual time=0.014..58.973 rows=93477 loops=1)

20. 21.518 36.037 ↑ 1.0 92524 1
→

Hash (cost=1464.24..1464.24 rows=92524 width=4) (actual time=36.037..36.037 rows=92524 loops=1)

21. 14.519 14.519 ↑ 1.0 92524 1
→

Seq Scan on material m1 (cost=0.00..1464.24 rows=92524 width=4) (actual time=0.006..14.519 rows=92524 loops=1)

22. 20.313 36.073 ↑ 1.0 92524 1
→

Hash (cost=1464.24..1464.24 rows=92524 width=4) (actual time=36.073..36.073 rows=92524 loops=1)

23. 15.760 15.760 ↑ 1.0 92524 1
→

Seq Scan on material m2 (cost=0.00..1464.24 rows=92524 width=4) (actual time=0.006..15.760 rows=92524 loops=1)

24. 22.439 39.732 ↑ 1.0 92524 1
→

Hash (cost=1464.24..1464.24 rows=92524 width=16) (actual time=39.732..39.732 rows=92524 loops=1)

25. 17.293 17.293 ↑ 1.0 92524 1
→

Seq Scan on material m (cost=0.00..1464.24 rows=92524 width=16) (actual time=0.015..17.293 rows=92524 loops=1)

26. 0.006 0.093 ↑ 1.0 12 1
→

Hash (cost=3.85..3.85 rows=12 width=20) (actual time=0.093..0.093 rows=12 loops=1)

27. 0.022 0.087 ↑ 1.0 12 1
→

Hash Join (cost=2.36..3.85 rows=12 width=20) (actual time=0.072..0.087 rows=12 loops=1)

  • Hash Cond: (scr.cid = cda.cid)
28. 0.036 0.049 ↑ 1.0 12 1
→

Hash Join (cost=1.27..2.60 rows=12 width=20) (actual time=0.035..0.049 rows=12 loops=1)

  • Hash Cond: ((ldm.log_div)::text = (scr.region)::text)
29. 0.004 0.004 ↑ 1.0 15 1
→

Seq Scan on log_div_mast ldm (cost=0.00..1.15 rows=15 width=10) (actual time=0.002..0.004 rows=15 loops=1)

30. 0.005 0.009 ↑ 1.0 12 1
→

Hash (cost=1.12..1.12 rows=12 width=10) (actual time=0.009..0.009 rows=12 loops=1)

31. 0.004 0.004 ↑ 1.0 12 1
→

Seq Scan on sys_co_regs scr (cost=0.00..1.12 rows=12 width=10) (actual time=0.003..0.004 rows=12 loops=1)

32. 0.002 0.016 ↑ 1.0 4 1
→

Hash (cost=1.04..1.04 rows=4 width=4) (actual time=0.016..0.016 rows=4 loops=1)

33. 0.014 0.014 ↑ 1.0 4 1
→

Seq Scan on co_def_attr cda (cost=0.00..1.04 rows=4 width=4) (actual time=0.013..0.014 rows=4 loops=1)

34. 0.068 0.146 ↑ 1.0 284 1
→

Hash (cost=4.84..4.84 rows=284 width=10) (actual time=0.146..0.146 rows=284 loops=1)

35. 0.078 0.078 ↑ 1.0 284 1
→

Seq Scan on ld_cc_master lcm (cost=0.00..4.84 rows=284 width=10) (actual time=0.027..0.078 rows=284 loops=1)

36. 0.006 0.018 ↑ 1.0 21 1
→

Hash (cost=1.21..1.21 rows=21 width=11) (actual time=0.018..0.018 rows=21 loops=1)

37. 0.012 0.012 ↑ 1.0 21 1
→

Seq Scan on item_group_mast igm (cost=0.00..1.21 rows=21 width=11) (actual time=0.009..0.012 rows=21 loops=1)

38. 0.000 0.001 ↓ 0.0 0 1
→

Hash (cost=15.60..15.60 rows=560 width=8) (actual time=0.001..0.001 rows=0 loops=1)

39. 0.001 0.001 ↓ 0.0 0 1
→

Seq Scan on co_mc_attr cma (cost=0.00..15.60 rows=560 width=8) (actual time=0.001..0.001 rows=0 loops=1)

40. 0.114 0.213 ↑ 1.0 455 1
→

Hash (cost=8.55..8.55 rows=455 width=12) (actual time=0.213..0.213 rows=455 loops=1)

41. 0.099 0.099 ↑ 1.0 455 1
→

Seq Scan on ld_mc_attr lma (cost=0.00..8.55 rows=455 width=12) (actual time=0.009..0.099 rows=455 loops=1)

42. 0.002 0.018 ↑ 1.0 9 1
→

Hash (cost=1.09..1.09 rows=9 width=21) (actual time=0.018..0.018 rows=9 loops=1)

43. 0.016 0.016 ↑ 1.0 9 1
→

Seq Scan on pc_mast field_pc (cost=0.00..1.09 rows=9 width=21) (actual time=0.013..0.016 rows=9 loops=1)

44. 0.003 0.005 ↑ 1.0 9 1
→

Hash (cost=1.09..1.09 rows=9 width=21) (actual time=0.005..0.005 rows=9 loops=1)

45. 0.002 0.002 ↑ 1.0 9 1
→

Seq Scan on pc_mast supply_pc (cost=0.00..1.09 rows=9 width=21) (actual time=0.002..0.002 rows=9 loops=1)

46. 0.003 0.005 ↑ 1.0 9 1
→

Hash (cost=1.09..1.09 rows=9 width=21) (actual time=0.005..0.005 rows=9 loops=1)

47. 0.002 0.002 ↑ 1.0 9 1
→

Seq Scan on pc_mast dc_pc (cost=0.00..1.09 rows=9 width=21) (actual time=0.001..0.002 rows=9 loops=1)

48. 10.052 1080.484 ↓ 286.7 11182 1
→

Hash (cost=20798.77..20798.77 rows=39 width=89) (actual time=1080.484..1080.484 rows=11182 loops=1)

49. 13.374 1070.432 ↓ 286.7 11182 1
→

Hash Left Join (cost=7477.47..20798.77 rows=39 width=89) (actual time=549.369..1070.432 rows=11182 loops=1)

  • Hash Cond: ((hr.ddemand_key)::text = (hr.ddemand_key)::text)
50. 5.664 623.288 ↓ 286.7 11182 1
→

Hash Left Join (cost=3751.25..17072.40 rows=39 width=86) (actual time=115.563..623.288 rows=11182 loops=1)

  • Hash Cond: ((hr.ddemand_key)::text = (hr.ddemand_key)::text)
51. 0.565 503.174 ↓ 286.7 11182 1
→

Nested Loop (cost=25.03..13346.02 rows=39 width=74) (actual time=1.089..503.174 rows=11182 loops=1)

52. 2.551 480.245 ↓ 286.7 11182 1
→

Nested Loop (cost=25.03..13332.59 rows=39 width=66) (actual time=1.083..480.245 rows=11182 loops=1)

53. 6.469 455.330 ↓ 286.7 11182 1
→

Nested Loop Left Join (cost=25.03..13319.16 rows=39 width=70) (actual time=1.001..455.330 rows=11182 loops=1)

54. 6.605 448.861 ↓ 286.7 11182 1
→

Hash Join (cost=25.03..13308.14 rows=39 width=74) (actual time=0.998..448.861 rows=11182 loops=1)

  • Hash Cond: ((om.log_div)::text = (vw_param_region.region_code)::text)
55. 7.900 441.542 ↓ 115.1 11284 1
→

Nested Loop (cost=0.00..13282.35 rows=98 width=42) (actual time=0.270..441.542 rows=11284 loops=1)

56. 19.881 411.074 ↓ 115.1 11284 1
→

Nested Loop (cost=0.00..13254.66 rows=98 width=42) (actual time=0.224..411.074 rows=11284 loops=1)

57. 348.716 348.716 ↓ 58.5 14159 1
→

Seq Scan on daily_demand dd (cost=0.00..11720.64 rows=242 width=11) (actual time=0.163..348.716 rows=14159 loops=1)

  • Filter: ((date_trunc('month'::text, to_timestamp(((order_date)::text || lpad((order_time)::text, 6, '0'::text)), 'YYYYMMDDHH24MISS'::text)) = '2011-12-01 00:00:00-06'::timestamp with time zone) AND (to_timestamp(((order_date)::text || lpad((order_time)::text, 6, '0'::text)), 'YYYYMMDDHH24MISS'::text) <= ('now'::text)::date))
58. 42.477 42.477 ↑ 1.0 1 14159
→

Index Scan using hr_dk on hit_rate hr (cost=0.00..6.33 rows=1 width=42) (actual time=0.003..0.003 rows=1 loops=14159)

  • Index Cond: ((hr.ddemand_key)::text = (dd.ddemand_key)::text)
59. 22.568 22.568 ↑ 1.0 1 11284
→

Index Scan using office_mast_pkey on office_mast om (cost=0.00..0.27 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=11284)

  • Index Cond: (om.id = hr.site_id)
60. 0.002 0.714 ↓ 2.0 8 1
→

Hash (cost=24.98..24.98 rows=4 width=32) (actual time=0.714..0.714 rows=8 loops=1)

61. 0.002 0.712 ↓ 2.0 8 1
→

Subquery Scan vw_param_region (cost=24.93..24.98 rows=4 width=32) (actual time=0.709..0.712 rows=8 loops=1)

62. 0.023 0.710 ↓ 2.0 8 1
→

Sort (cost=24.93..24.94 rows=4 width=32) (actual time=0.709..0.710 rows=8 loops=1)

  • Sort Key: log_div_mast.description
  • Sort Method: quicksort Memory: 25kB
63. 0.002 0.687 ↓ 2.0 8 1
→

Append (cost=6.91..24.89 rows=4 width=32) (actual time=0.631..0.687 rows=8 loops=1)

64. 0.017 0.671 ↓ 2.3 7 1
→

Hash Join (cost=6.91..17.53 rows=3 width=37) (actual time=0.631..0.671 rows=7 loops=1)

  • Hash Cond: ((sys_user_regions.region)::text = (log_div_mast.log_div)::text)
65. 0.005 0.624 ↓ 2.3 7 1
→

Nested Loop (cost=5.57..16.15 rows=3 width=27) (actual time=0.585..0.624 rows=7 loops=1)

  • Join Filter: (sys_co_regs.cid = plan.sys_user.cid)
66. 0.092 0.092 ↑ 1.0 1 1
→

Seq Scan on sys_user (cost=0.00..7.33 rows=1 width=16) (actual time=0.059..0.092 rows=1 loops=1)

  • Filter: (uid = 13)
67. 0.026 0.527 ↓ 1.2 7 1
→

Hash Join (cost=5.57..8.75 rows=6 width=19) (actual time=0.522..0.527 rows=7 loops=1)

  • Hash Cond: ((sys_user_regions.region)::text = (sys_co_regs.region)::text)
68. 0.014 0.483 ↑ 1.0 7 1
→

Bitmap Heap Scan on sys_user_regions (cost=4.30..7.39 rows=7 width=9) (actual time=0.481..0.483 rows=7 loops=1)

  • Recheck Cond: (uid = 13)
69. 0.469 0.469 ↑ 1.0 7 1
→

Bitmap Index Scan on uid_rg (cost=0.00..4.30 rows=7 width=0) (actual time=0.469..0.469 rows=7 loops=1)

  • Index Cond: (uid = 13)
70. 0.002 0.018 ↑ 1.0 12 1
→

Hash (cost=1.12..1.12 rows=12 width=10) (actual time=0.018..0.018 rows=12 loops=1)

71. 0.016 0.016 ↑ 1.0 12 1
→

Seq Scan on sys_co_regs (cost=0.00..1.12 rows=12 width=10) (actual time=0.014..0.016 rows=12 loops=1)

72. 0.007 0.030 ↑ 1.0 15 1
→

Hash (cost=1.15..1.15 rows=15 width=21) (actual time=0.030..0.030 rows=15 loops=1)

73. 0.023 0.023 ↑ 1.0 15 1
→

Seq Scan on log_div_mast (cost=0.00..1.15 rows=15 width=21) (actual time=0.022..0.023 rows=15 loops=1)

74. 0.000 0.014 ↑ 1.0 1 1
→

Subquery Scan "*SELECT* 2" (cost=0.00..7.33 rows=1 width=16) (actual time=0.008..0.014 rows=1 loops=1)

75. 0.014 0.014 ↑ 1.0 1 1
→

Seq Scan on sys_user (cost=0.00..7.33 rows=1 width=16) (actual time=0.008..0.014 rows=1 loops=1)

  • Filter: (uid = 13)
76. 0.000 0.000 ↓ 0.0 0 11182
→

Index Scan using office_mast_pkey on office_mast om1 (cost=0.00..0.27 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=11182)

  • Index Cond: (hr.alt_site_id = om1.id)
77. 22.364 22.364 ↑ 1.0 1 11182
→

Index Scan using material_pkey on material m1 (cost=0.00..0.33 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=11182)

  • Index Cond: (m1.id = hr.master_material_id)
78. 22.364 22.364 ↑ 1.0 1 11182
→

Index Scan using material_pkey on material m (cost=0.00..0.33 rows=1 width=16) (actual time=0.001..0.002 rows=1 loops=11182)

  • Index Cond: (m.id = hr.material_id)
79. 0.933 114.450 ↓ 1490.0 1490 1
→

Hash (cost=3726.21..3726.21 rows=1 width=21) (actual time=114.450..114.450 rows=1490 loops=1)

80. 0.178 113.517 ↓ 1490.0 1490 1
→

Nested Loop (cost=0.00..3726.21 rows=1 width=21) (actual time=5.096..113.517 rows=1490 loops=1)

81. 0.195 110.359 ↓ 1490.0 1490 1
→

Nested Loop (cost=0.00..3725.46 rows=1 width=25) (actual time=5.067..110.359 rows=1490 loops=1)

82. 0.438 107.184 ↓ 1490.0 1490 1
→

Nested Loop (cost=0.00..3719.47 rows=1 width=29) (actual time=5.064..107.184 rows=1490 loops=1)

83. 1.224 102.276 ↓ 1490.0 1490 1
→

Nested Loop Left Join (cost=0.00..3713.47 rows=1 width=21) (actual time=5.027..102.276 rows=1490 loops=1)

84. 6.719 101.052 ↓ 1490.0 1490 1
→

Nested Loop (cost=0.00..3712.72 rows=1 width=25) (actual time=5.025..101.052 rows=1490 loops=1)

85. 17.773 17.773 ↓ 26.1 7656 1
→

Seq Scan on hit_rate hr (cost=0.00..1549.13 rows=293 width=25) (actual time=0.365..17.773 rows=7656 loops=1)

  • Filter: ((hit)::integer = 0)
86. 76.560 76.560 ↓ 0.0 0 7656
→

Index Scan using dd_dk on daily_demand dd (cost=0.00..7.37 rows=1 width=11) (actual time=0.010..0.010 rows=0 loops=7656)

  • Index Cond: ((dd.ddemand_key)::text = (hr.ddemand_key)::text)
  • Filter: (date_trunc('month'::text, to_timestamp(((dd.order_date)::text || lpad((dd.order_time)::text, 6, '0'::text)), 'YYYYMMDDHH24MISS'::text)) = '2011-12-01 00:00:00-06'::timestamp with time zone)
87. 0.000 0.000 ↓ 0.0 0 1490
→

Index Scan using office_mast_pkey on office_mast om1 (cost=0.00..0.73 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1490)

  • Index Cond: (hr.alt_site_id = om1.id)
88. 4.470 4.470 ↑ 1.0 1 1490
→

Index Scan using material_pkey on material m1 (cost=0.00..5.98 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1490)

  • Index Cond: (m1.id = hr.master_material_id)
89. 2.980 2.980 ↑ 1.0 1 1490
→

Index Scan using material_pkey on material m (cost=0.00..5.98 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1490)

  • Index Cond: (m.id = hr.material_id)
90. 2.980 2.980 ↑ 1.0 1 1490
→

Index Scan using office_mast_pkey on office_mast om (cost=0.00..0.73 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1490)

  • Index Cond: (om.id = hr.site_id)
91. 5.518 433.770 ↓ 9794.0 9794 1
→

Hash (cost=3726.21..3726.21 rows=1 width=21) (actual time=433.770..433.770 rows=9794 loops=1)

92. 9.106 428.252 ↓ 9794.0 9794 1
→

Nested Loop (cost=0.00..3726.21 rows=1 width=21) (actual time=11.578..428.252 rows=9794 loops=1)

93. 0.000 409.352 ↓ 9794.0 9794 1
→

Nested Loop (cost=0.00..3725.46 rows=1 width=25) (actual time=11.572..409.352 rows=9794 loops=1)

94. 5.174 390.029 ↓ 9794.0 9794 1
→

Nested Loop (cost=0.00..3719.47 rows=1 width=29) (actual time=11.570..390.029 rows=9794 loops=1)

95. 6.786 365.267 ↓ 9794.0 9794 1
→

Nested Loop Left Join (cost=0.00..3713.47 rows=1 width=21) (actual time=11.563..365.267 rows=9794 loops=1)

96. 33.361 358.481 ↓ 9794.0 9794 1
→

Nested Loop (cost=0.00..3712.72 rows=1 width=25) (actual time=11.560..358.481 rows=9794 loops=1)

97. 19.804 19.804 ↓ 173.7 50886 1
→

Seq Scan on hit_rate hr (cost=0.00..1549.13 rows=293 width=25) (actual time=0.008..19.804 rows=50886 loops=1)

  • Filter: ((hit)::integer = 1)
98. 305.316 305.316 ↓ 0.0 0 50886
→

Index Scan using dd_dk on daily_demand dd (cost=0.00..7.37 rows=1 width=11) (actual time=0.006..0.006 rows=0 loops=50886)

  • Index Cond: ((dd.ddemand_key)::text = (hr.ddemand_key)::text)
  • Filter: (date_trunc('month'::text, to_timestamp(((dd.order_date)::text || lpad((dd.order_time)::text, 6, '0'::text)), 'YYYYMMDDHH24MISS'::text)) = '2011-12-01 00:00:00-06'::timestamp with time zone)
99. 0.000 0.000 ↓ 0.0 0 9794
→

Index Scan using office_mast_pkey on office_mast om1 (cost=0.00..0.73 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=9794)

  • Index Cond: (hr.alt_site_id = om1.id)
100. 19.588 19.588 ↑ 1.0 1 9794
→

Index Scan using material_pkey on material m1 (cost=0.00..5.98 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=9794)

  • Index Cond: (m1.id = hr.master_material_id)
101. 19.588 19.588 ↑ 1.0 1 9794
→

Index Scan using material_pkey on material m (cost=0.00..5.98 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=9794)

  • Index Cond: (m.id = hr.material_id)
102. 9.794 9.794 ↑ 1.0 1 9794
→

Index Scan using office_mast_pkey on office_mast om (cost=0.00..0.73 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=9794)

  • Index Cond: (om.id = hr.site_id)
103.          

SubPlan (forHash Join)
104. 7.400 7.400 ↑ 1.0 1 1480
→

Seq Scan on miss_root_cause mrc (cost=0.00..1.50 rows=1 width=43) (actual time=0.004..0.005 rows=1 loops=1480)

  • Filter: ($0 = id)
105.          

SubPlan (forGroupAggregate)
106. 5.920 5.920 ↑ 1.0 1 1480
→

Seq Scan on miss_root_cause mrc (cost=0.00..1.50 rows=1 width=43) (actual time=0.004..0.004 rows=1 loops=1480)

  • Filter: ($0 = id)