explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YgJ17

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 7.263 ↓ 1.2 10 1

Limit (cost=326.77..1,202.62 rows=8 width=660) (actual time=7.068..7.263 rows=10 loops=1)

2. 0.047 7.261 ↓ 1.2 10 1

WindowAgg (cost=326.77..1,202.62 rows=8 width=660) (actual time=7.068..7.261 rows=10 loops=1)

3. 0.016 6.984 ↓ 1.2 10 1

Sort (cost=326.77..326.79 rows=8 width=502) (actual time=6.984..6.984 rows=10 loops=1)

  • Sort Key: a.edassnbr
  • Sort Method: quicksort Memory: 30kB
4. 0.005 6.968 ↓ 1.2 10 1

Nested Loop (cost=197.21..326.65 rows=8 width=502) (actual time=6.850..6.968 rows=10 loops=1)

5. 0.000 0.127 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.10..47.34 rows=1 width=245) (actual time=0.122..0.127 rows=1 loops=1)

  • Join Filter: (((a.assnbri)::text = (abom.assnbri)::text) AND ((a.reg_name)::text = (abom.reg_name)::text))
6. 0.008 0.121 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.10..46.29 rows=1 width=230) (actual time=0.115..0.121 rows=1 loops=1)

  • Join Filter: (((a.assnbri)::text = (rpt.assnbri)::text) AND ((a.reg_name)::text = (rpt.reg_name)::text))
7. 0.006 0.096 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..37.84 rows=1 width=211) (actual time=0.092..0.096 rows=1 loops=1)

  • Join Filter: (((a.reg_name)::text = (au.reg_name)::text) AND ((a.assnbri)::text = (au.assnbri)::text))
8. 0.005 0.076 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.27..33.39 rows=1 width=204) (actual time=0.073..0.076 rows=1 loops=1)

  • Join Filter: ((a.asset_type)::text = (f1a_asset_type_sc0.code_id)::text)
9. 0.004 0.061 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.98..25.07 rows=1 width=187) (actual time=0.059..0.061 rows=1 loops=1)

10. 0.011 0.044 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.70..16.75 rows=1 width=170) (actual time=0.043..0.044 rows=1 loops=1)

11. 0.020 0.020 ↑ 1.0 1 1

Index Scan using f1fara_idx1 on f1asr_reg_asset a (cost=0.41..8.44 rows=1 width=153) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000011'::text))
  • Filter: ((asset_type)::text = 'S'::text)
12. 0.013 0.013 ↑ 1.0 1 1

Index Scan using f1fstc_idx1 on f1stc_code f1a_oper_asset_status_sc2 (cost=0.29..8.30 rows=1 width=21) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (((code_type)::text = 'F1A_OPER_ASSET_STATUS'::text) AND ((a.operating_asset_status)::text = (code_id)::text))
13. 0.013 0.013 ↑ 1.0 1 1

Index Scan using f1fstc_idx1 on f1stc_code f1a_asset_status_sc1 (cost=0.29..8.30 rows=1 width=21) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (((code_type)::text = 'F1A_ASSET_STATUS'::text) AND ((a.asset_status)::text = (code_id)::text))
14. 0.010 0.010 ↑ 1.0 1 1

Index Scan using f1fstc_idx1 on f1stc_code f1a_asset_type_sc0 (cost=0.29..8.30 rows=1 width=21) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (((code_type)::text = 'F1A_ASSET_TYPE'::text) AND ((code_id)::text = 'S'::text))
15. 0.014 0.014 ↑ 1.0 1 1

Index Only Scan using f1farauf_idx1 on f1asr_reg_asset_uf au (cost=0.41..4.43 rows=1 width=15) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: ((reg_name = 'ASSET'::text) AND (assnbri = '0000011'::text))
  • Heap Fetches: 0
16. 0.017 0.017 ↑ 1.0 1 1

Index Scan using amrpt_a_idx1 on amrpt_asset rpt (cost=0.41..8.43 rows=1 width=35) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000011'::text))
17. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on f1asr_reg_asset_bom abom (cost=0.00..1.03 rows=1 width=29) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (((assnbri)::text = '0000011'::text) AND (seqnbr = 1) AND ((reg_name)::text = 'ASSET'::text))
  • Rows Removed by Filter: 2
18. 0.017 6.836 ↓ 1.2 10 1

Merge Left Join (cost=195.11..279.24 rows=8 width=257) (actual time=6.727..6.836 rows=10 loops=1)

  • Merge Cond: ((msal.mnt_shd_code)::text = (msal_2.mnt_shd_code)::text)
  • Join Filter: (((msal_2.reg_name)::text = (msal.reg_name)::text) AND ((msal_2.assnbri)::text = (msal.assnbri)::text))
19. 0.011 4.383 ↓ 1.2 10 1

Merge Left Join (cost=104.36..180.38 rows=8 width=233) (actual time=4.296..4.383 rows=10 loops=1)

  • Merge Cond: ((msal.mnt_shd_code)::text = (msal_1.mnt_shd_code)::text)
  • Join Filter: (((msal_1.reg_name)::text = (msal.reg_name)::text) AND ((msal_1.assnbri)::text = (msal.assnbri)::text))
20. 0.005 0.170 ↓ 1.2 10 1

Nested Loop Left Join (cost=1.13..69.05 rows=8 width=217) (actual time=0.101..0.170 rows=10 loops=1)

  • Join Filter: ((msd.mnt_shd_basis_optn)::text = (aso_mnt_shd_basis_sc7.code_id)::text)
  • Rows Removed by Join Filter: 10
21. 0.006 0.145 ↓ 1.2 10 1

Nested Loop Left Join (cost=0.85..54.21 rows=8 width=200) (actual time=0.082..0.145 rows=10 loops=1)

  • Join Filter: ((msd.mnt_shd_type)::text = (aso_mnt_shd_type_sc6.code_id)::text)
  • Rows Removed by Join Filter: 30
22. 0.010 0.119 ↓ 1.2 10 1

Nested Loop Left Join (cost=0.56..39.37 rows=8 width=183) (actual time=0.066..0.119 rows=10 loops=1)

  • Join Filter: ((msal.mnt_shd_asset_link_status)::text = (aso_mnt_shd_asset_link44f21c76.code_id)::text)
23. 0.027 0.089 ↓ 1.2 10 1

Nested Loop (cost=0.28..30.95 rows=8 width=166) (actual time=0.046..0.089 rows=10 loops=1)

  • Join Filter: ((msal.mnt_shd_code)::text = (msd.mnt_shd_code)::text)
  • Rows Removed by Join Filter: 170
24. 0.032 0.032 ↑ 1.0 10 1

Index Scan using f1asomsal_idx1 on f1aso_mnt_shd_asset_link msal (cost=0.28..25.23 rows=10 width=131) (actual time=0.026..0.032 rows=10 loops=1)

  • Index Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000011'::text))
  • Filter: ((mnt_shd_asset_link_status)::text = 'A'::text)
25. 0.018 0.030 ↑ 1.2 18 10

Materialize (cost=0.00..2.47 rows=22 width=35) (actual time=0.001..0.003 rows=18 loops=10)

26. 0.012 0.012 ↑ 1.2 18 1

Seq Scan on f1aso_mnt_shd_ctl msd (cost=0.00..2.36 rows=22 width=35) (actual time=0.005..0.012 rows=18 loops=1)

  • Filter: ((reg_name)::text = 'ASSET'::text)
  • Rows Removed by Filter: 6
27. 0.004 0.020 ↑ 1.0 1 10

Materialize (cost=0.29..8.31 rows=1 width=21) (actual time=0.002..0.002 rows=1 loops=10)

28. 0.016 0.016 ↑ 1.0 1 1

Index Scan using f1fstc_idx1 on f1stc_code aso_mnt_shd_asset_link44f21c76 (cost=0.29..8.30 rows=1 width=21) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (((code_type)::text = 'ASO_MNT_SHD_ASSET_LINK_STATUS'::text) AND ((code_id)::text = 'A'::text))
29. 0.005 0.020 ↑ 1.0 4 10

Materialize (cost=0.29..14.37 rows=4 width=21) (actual time=0.001..0.002 rows=4 loops=10)

30. 0.015 0.015 ↑ 1.0 4 1

Index Scan using f1fstc_idx1 on f1stc_code aso_mnt_shd_type_sc6 (cost=0.29..14.35 rows=4 width=21) (actual time=0.012..0.015 rows=4 loops=1)

  • Index Cond: ((code_type)::text = 'ASO_MNT_SHD_TYPE'::text)
31. 0.006 0.020 ↑ 2.0 2 10

Materialize (cost=0.29..14.37 rows=4 width=21) (actual time=0.001..0.002 rows=2 loops=10)

32. 0.014 0.014 ↑ 2.0 2 1

Index Scan using f1fstc_idx1 on f1stc_code aso_mnt_shd_basis_sc7 (cost=0.29..14.35 rows=4 width=21) (actual time=0.012..0.014 rows=2 loops=1)

  • Index Cond: ((code_type)::text = 'ASO_MNT_SHD_BASIS'::text)
33. 0.003 4.202 ↓ 4.0 4 1

Materialize (cost=103.22..111.29 rows=1 width=37) (actual time=4.191..4.202 rows=4 loops=1)

34. 0.005 4.199 ↓ 4.0 4 1

Nested Loop Left Join (cost=103.22..111.29 rows=1 width=37) (actual time=4.189..4.199 rows=4 loops=1)

35. 0.004 4.182 ↓ 4.0 4 1

GroupAggregate (cost=102.95..102.97 rows=1 width=29) (actual time=4.181..4.182 rows=4 loops=1)

  • Group Key: msal_1.reg_name, msal_1.assnbri, msal_1.mnt_shd_code
36. 0.008 4.178 ↓ 4.0 4 1

Sort (cost=102.95..102.95 rows=1 width=29) (actual time=4.178..4.178 rows=4 loops=1)

  • Sort Key: msal_1.mnt_shd_code
  • Sort Method: quicksort Memory: 25kB
37. 0.000 4.170 ↓ 4.0 4 1

Hash Join (cost=39.86..102.94 rows=1 width=29) (actual time=1.746..4.170 rows=4 loops=1)

  • Hash Cond: (tc.est_start_datei = (SubPlan 8))
  • Join Filter: ((CASE WHEN ((msc.mnt_shd_type)::text = 'N'::text) THEN mh.aso_nest_mnt_shd_code ELSE mh.aso_mnt_shd_code END)::text = (msc.mnt_shd_code)::text)
  • Rows Removed by Join Filter: 6
38. 0.021 0.165 ↓ 13.0 13 1

Nested Loop (cost=32.53..70.65 rows=1 width=43) (actual time=0.069..0.165 rows=13 loops=1)

39. 0.019 0.079 ↓ 13.0 13 1

Merge Join (cost=32.25..63.01 rows=1 width=43) (actual time=0.058..0.079 rows=13 loops=1)

  • Merge Cond: (mh.unique_id = ta.mnt_hist_unique_id)
40. 0.014 0.014 ↓ 1.1 13 1

Index Scan using f1faramh_idx1 on f1asr_reg_asset_mh mh (cost=0.28..30.95 rows=12 width=35) (actual time=0.013..0.014 rows=13 loops=1)

  • Index Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000011'::text))
41. 0.017 0.046 ↑ 1.0 18 1

Sort (cost=31.93..31.97 rows=18 width=38) (actual time=0.042..0.046 rows=18 loops=1)

  • Sort Key: ta.mnt_hist_unique_id
  • Sort Method: quicksort Memory: 26kB
42. 0.012 0.029 ↑ 1.0 18 1

Bitmap Heap Scan on f1wrk_task_ctl_ass ta (cost=4.46..31.55 rows=18 width=38) (actual time=0.023..0.029 rows=18 loops=1)

  • Recheck Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000011'::text))
  • Heap Blocks: exact=6
43. 0.017 0.017 ↑ 1.0 18 1

Bitmap Index Scan on f1wtcass_idx2 (cost=0.00..4.46 rows=18 width=0) (actual time=0.017..0.017 rows=18 loops=1)

  • Index Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000011'::text))
44. 0.065 0.065 ↑ 1.0 1 13

Index Scan using f1wtc_idx1 on f1wrk_task_ctl tc (cost=0.28..7.63 rows=1 width=33) (actual time=0.005..0.005 rows=1 loops=13)

  • Index Cond: (((work_sys_name)::text = (ta.work_sys_name)::text) AND ((task_nbri)::text = (ta.task_nbri)::text))
45. 1.420 1.484 ↑ 2.0 4 1

Hash (cost=7.23..7.23 rows=8 width=32) (actual time=1.484..1.484 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
46. 0.018 0.064 ↓ 1.2 10 1

Hash Join (cost=2.91..7.23 rows=8 width=32) (actual time=0.056..0.064 rows=10 loops=1)

  • Hash Cond: ((msal_1.mnt_shd_code)::text = (msc.mnt_shd_code)::text)
47. 0.022 0.022 ↑ 1.0 10 1

Index Only Scan using f1asomsal_idx1 on f1aso_mnt_shd_asset_link msal_1 (cost=0.28..4.48 rows=10 width=21) (actual time=0.019..0.022 rows=10 loops=1)

  • Index Cond: ((reg_name = 'ASSET'::text) AND (assnbri = '0000011'::text))
  • Heap Fetches: 0
48. 0.007 0.024 ↑ 1.2 18 1

Hash (cost=2.36..2.36 rows=22 width=17) (actual time=0.024..0.024 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
49. 0.017 0.017 ↑ 1.2 18 1

Seq Scan on f1aso_mnt_shd_ctl msc (cost=0.00..2.36 rows=22 width=17) (actual time=0.006..0.017 rows=18 loops=1)

  • Filter: ((reg_name)::text = 'ASSET'::text)
  • Rows Removed by Filter: 6
50.          

SubPlan (for Hash Join)

51. 0.000 3.900 ↑ 1.0 1 20

Aggregate (cost=49.86..49.87 rows=1 width=8) (actual time=0.195..0.195 rows=1 loops=20)

52.          

Initplan (for Aggregate)

53. 0.014 1.694 ↑ 1.0 1 14

Aggregate (cost=24.92..24.94 rows=1 width=8) (actual time=0.121..0.121 rows=1 loops=14)

54. 0.014 1.680 ↑ 1.0 1 14

Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=0.092..0.120 rows=1 loops=14)

55. 0.154 1.316 ↓ 4.0 4 14

Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.026..0.094 rows=4 loops=14)

56. 0.154 0.154 ↓ 18.0 18 14

Index Scan using f1wtcass_idx2 on f1wrk_task_ctl_ass ta_2 (cost=0.28..8.30 rows=1 width=38) (actual time=0.007..0.011 rows=18 loops=14)

  • Index Cond: (((reg_name)::text = (msal_1.reg_name)::text) AND ((assnbri)::text = (msal_1.assnbri)::text))
57. 1.008 1.008 ↓ 0.0 0 252

Index Scan using f1faramh_idx1 on f1asr_reg_asset_mh mh3 (cost=0.28..8.30 rows=1 width=22) (actual time=0.004..0.004 rows=0 loops=252)

  • Index Cond: (((reg_name)::text = (msal_1.reg_name)::text) AND ((assnbri)::text = (msal_1.assnbri)::text) AND (unique_id = ta_2.mnt_hist_unique_id))
  • Filter: ((msal_1.mnt_shd_code)::text = (CASE WHEN ((msc.mnt_shd_type)::text = 'N'::text) THEN aso_nest_mnt_shd_code ELSE aso_mnt_shd_code END)::text)
  • Rows Removed by Filter: 1
58. 0.350 0.350 ↓ 0.0 0 50

Index Scan using f1wtc_idx1 on f1wrk_task_ctl tc_2 (cost=0.28..8.30 rows=1 width=25) (actual time=0.007..0.007 rows=0 loops=50)

  • Index Cond: (((work_sys_name)::text = (ta_2.work_sys_name)::text) AND ((task_nbri)::text = (ta_2.task_nbri)::text))
  • Filter: ((task_stage)::text = ANY ('{W,C,R}'::text[]))
  • Rows Removed by Filter: 1
59. 0.010 3.880 ↓ 2.0 2 20

Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=0.135..0.194 rows=2 loops=20)

60. 0.140 1.820 ↓ 2.0 2 20

Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.044..0.091 rows=2 loops=20)

61. 0.240 0.240 ↓ 18.0 18 20

Index Scan using f1wtcass_idx2 on f1wrk_task_ctl_ass ta_3 (cost=0.28..8.30 rows=1 width=38) (actual time=0.008..0.012 rows=18 loops=20)

  • Index Cond: (((reg_name)::text = (msal_1.reg_name)::text) AND ((assnbri)::text = (msal_1.assnbri)::text))
62. 1.440 1.440 ↓ 0.0 0 360

Index Scan using f1faramh_idx1 on f1asr_reg_asset_mh mh2_1 (cost=0.28..8.30 rows=1 width=22) (actual time=0.004..0.004 rows=0 loops=360)

  • Index Cond: (((reg_name)::text = (msal_1.reg_name)::text) AND ((assnbri)::text = (msal_1.assnbri)::text) AND (unique_id = ta_3.mnt_hist_unique_id))
  • Filter: ((msal_1.mnt_shd_code)::text = (CASE WHEN ((msc.mnt_shd_type)::text = 'N'::text) THEN aso_nest_mnt_shd_code ELSE aso_mnt_shd_code END)::text)
  • Rows Removed by Filter: 1
63. 2.050 2.050 ↑ 1.0 1 50

Index Scan using f1wtc_idx1 on f1wrk_task_ctl tc_3 (cost=0.28..8.30 rows=1 width=25) (actual time=0.041..0.041 rows=1 loops=50)

  • Index Cond: (((work_sys_name)::text = (ta_3.work_sys_name)::text) AND ((task_nbri)::text = (ta_3.task_nbri)::text))
  • Filter: (((task_stage)::text = ANY ('{A,D}'::text[])) AND (est_start_datei > $27))
  • Rows Removed by Filter: 0
64. 0.012 0.012 ↑ 1.0 1 4

Index Scan using f1wtc_idx5 on f1wrk_task_ctl next_wo (cost=0.28..8.29 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=4)

  • Index Cond: (task_rid = (min(tc.task_rid)))
65. 0.003 2.436 ↓ 3.0 3 1

Materialize (cost=90.75..98.82 rows=1 width=45) (actual time=2.428..2.436 rows=3 loops=1)

66. 0.002 2.433 ↓ 3.0 3 1

Nested Loop Left Join (cost=90.75..98.82 rows=1 width=45) (actual time=2.426..2.433 rows=3 loops=1)

67. 0.001 2.419 ↓ 3.0 3 1

GroupAggregate (cost=90.48..90.50 rows=1 width=29) (actual time=2.418..2.419 rows=3 loops=1)

  • Group Key: msal_2.reg_name, msal_2.assnbri, msal_2.mnt_shd_code
68. 0.011 2.418 ↓ 3.0 3 1

Sort (cost=90.48..90.48 rows=1 width=29) (actual time=2.417..2.418 rows=3 loops=1)

  • Sort Key: msal_2.mnt_shd_code
  • Sort Method: quicksort Memory: 25kB
69. 0.000 2.407 ↓ 3.0 3 1

Hash Join (cost=39.86..90.47 rows=1 width=29) (actual time=1.245..2.407 rows=3 loops=1)

  • Hash Cond: (tc_1.est_start_datei = (SubPlan 6))
  • Join Filter: ((CASE WHEN ((msc_1.mnt_shd_type)::text = 'N'::text) THEN mh_1.aso_nest_mnt_shd_code ELSE mh_1.aso_mnt_shd_code END)::text = (msc_1.mnt_shd_code)::text)
  • Rows Removed by Join Filter: 6
70. 0.025 0.145 ↓ 13.0 13 1

Nested Loop (cost=32.53..70.65 rows=1 width=43) (actual time=0.061..0.145 rows=13 loops=1)

71. 0.018 0.068 ↓ 13.0 13 1

Merge Join (cost=32.25..63.01 rows=1 width=43) (actual time=0.050..0.068 rows=13 loops=1)

  • Merge Cond: (mh_1.unique_id = ta_1.mnt_hist_unique_id)
72. 0.011 0.011 ↓ 1.1 13 1

Index Scan using f1faramh_idx1 on f1asr_reg_asset_mh mh_1 (cost=0.28..30.95 rows=12 width=35) (actual time=0.008..0.011 rows=13 loops=1)

  • Index Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000011'::text))
73. 0.009 0.039 ↑ 1.0 18 1

Sort (cost=31.93..31.97 rows=18 width=38) (actual time=0.038..0.039 rows=18 loops=1)

  • Sort Key: ta_1.mnt_hist_unique_id
  • Sort Method: quicksort Memory: 26kB
74. 0.013 0.030 ↑ 1.0 18 1

Bitmap Heap Scan on f1wrk_task_ctl_ass ta_1 (cost=4.46..31.55 rows=18 width=38) (actual time=0.023..0.030 rows=18 loops=1)

  • Recheck Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000011'::text))
  • Heap Blocks: exact=6
75. 0.017 0.017 ↑ 1.0 18 1

Bitmap Index Scan on f1wtcass_idx2 (cost=0.00..4.46 rows=18 width=0) (actual time=0.017..0.017 rows=18 loops=1)

  • Index Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000011'::text))
76. 0.052 0.052 ↑ 1.0 1 13

Index Scan using f1wtc_idx1 on f1wrk_task_ctl tc_1 (cost=0.28..7.63 rows=1 width=33) (actual time=0.004..0.004 rows=1 loops=13)

  • Index Cond: (((work_sys_name)::text = (ta_1.work_sys_name)::text) AND ((task_nbri)::text = (ta_1.task_nbri)::text))
77. 0.926 0.972 ↑ 2.7 3 1

Hash (cost=7.23..7.23 rows=8 width=32) (actual time=0.972..0.972 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
78. 0.013 0.046 ↓ 1.2 10 1

Hash Join (cost=2.91..7.23 rows=8 width=32) (actual time=0.041..0.046 rows=10 loops=1)

  • Hash Cond: ((msal_2.mnt_shd_code)::text = (msc_1.mnt_shd_code)::text)
79. 0.016 0.016 ↑ 1.0 10 1

Index Only Scan using f1asomsal_idx1 on f1aso_mnt_shd_asset_link msal_2 (cost=0.28..4.48 rows=10 width=21) (actual time=0.015..0.016 rows=10 loops=1)

  • Index Cond: ((reg_name = 'ASSET'::text) AND (assnbri = '0000011'::text))
  • Heap Fetches: 0
80. 0.006 0.017 ↑ 1.2 18 1

Hash (cost=2.36..2.36 rows=22 width=17) (actual time=0.017..0.017 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
81. 0.011 0.011 ↑ 1.2 18 1

Seq Scan on f1aso_mnt_shd_ctl msc_1 (cost=0.00..2.36 rows=22 width=17) (actual time=0.005..0.011 rows=18 loops=1)

  • Filter: ((reg_name)::text = 'ASSET'::text)
  • Rows Removed by Filter: 6
82.          

SubPlan (for Hash Join)

83. 0.019 2.185 ↑ 1.0 1 19

Aggregate (cost=24.92..24.93 rows=1 width=8) (actual time=0.114..0.115 rows=1 loops=19)

84. 0.018 2.166 ↑ 1.0 1 19

Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=0.094..0.114 rows=1 loops=19)

85. 0.209 1.805 ↓ 3.0 3 19

Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.044..0.095 rows=3 loops=19)

86. 0.228 0.228 ↓ 18.0 18 19

Index Scan using f1wtcass_idx2 on f1wrk_task_ctl_ass ta2 (cost=0.28..8.30 rows=1 width=38) (actual time=0.009..0.012 rows=18 loops=19)

  • Index Cond: (((reg_name)::text = (msal_2.reg_name)::text) AND ((assnbri)::text = (msal_2.assnbri)::text))
87. 1.368 1.368 ↓ 0.0 0 342

Index Scan using f1faramh_idx1 on f1asr_reg_asset_mh mh2 (cost=0.28..8.30 rows=1 width=22) (actual time=0.004..0.004 rows=0 loops=342)

  • Index Cond: (((reg_name)::text = (msal_2.reg_name)::text) AND ((assnbri)::text = (msal_2.assnbri)::text) AND (unique_id = ta2.mnt_hist_unique_id))
  • Filter: ((msal_2.mnt_shd_code)::text = (CASE WHEN ((msc_1.mnt_shd_type)::text = 'N'::text) THEN aso_nest_mnt_shd_code ELSE aso_mnt_shd_code END)::text)
  • Rows Removed by Filter: 1
88. 0.343 0.343 ↓ 0.0 0 49

Index Scan using f1wtc_idx1 on f1wrk_task_ctl tc2 (cost=0.28..8.30 rows=1 width=25) (actual time=0.007..0.007 rows=0 loops=49)

  • Index Cond: (((work_sys_name)::text = (ta2.work_sys_name)::text) AND ((task_nbri)::text = (ta2.task_nbri)::text))
  • Filter: ((task_stage)::text = ANY ('{W,C,R}'::text[]))
  • Rows Removed by Filter: 1
89. 0.012 0.012 ↑ 1.0 1 3

Index Scan using f1wtc_idx5 on f1wrk_task_ctl prev_wo (cost=0.28..8.29 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=3)

  • Index Cond: (task_rid = (max(tc_1.task_rid)))
90.          

SubPlan (for WindowAgg)

91. 0.040 0.040 ↑ 1.0 1 10

Seq Scan on f1aso_mnt_shd_ctl msc1 (cost=0.00..2.44 rows=1 width=2) (actual time=0.002..0.004 rows=1 loops=10)

  • Filter: (((reg_name)::text = (msal.reg_name)::text) AND ((mnt_shd_code)::text = (msal.mnt_shd_code)::text))
  • Rows Removed by Filter: 23
92. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=45.69..45.70 rows=1 width=8) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=8.73..45.69 rows=1 width=0) (never executed)

  • Join Filter: (((mh_2.reg_name)::text = (al.reg_name)::text) AND ((mh_2.assnbri)::text = (al.assnbri)::text) AND ((mh_2.aso_mnt_shd_code)::text = (n.sub_mnt_shd_code)::text))
94. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..9.39 rows=1 width=20) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Index Scan using f1asomsal_idx1 on f1aso_mnt_shd_asset_link al (cost=0.28..8.30 rows=1 width=21) (never executed)

  • Index Cond: (((reg_name)::text = (msal.reg_name)::text) AND ((assnbri)::text = (msal.assnbri)::text) AND ((mnt_shd_code)::text = (msal.mnt_shd_code)::text))
  • Filter: (mnt_shd_start_date = to_timestamp('1900-01-01 00:00:00'::text, 'YYYY-MM-DD hh24:mi:ss'::text))
96. 0.000 0.000 ↓ 0.0 0

Seq Scan on f1aso_mnt_shd_ctl_nest n (cost=0.00..1.07 rows=1 width=21) (never executed)

  • Filter: (((reg_name)::text = (msal.reg_name)::text) AND ((mnt_shd_code)::text = (msal.mnt_shd_code)::text))
97. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on f1asr_reg_asset_mh mh_2 (cost=8.45..36.01 rows=17 width=26) (never executed)

  • Recheck Cond: (((reg_name)::text = (msal.reg_name)::text) AND ((assnbri)::text = (msal.assnbri)::text))
98. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on f1faramh_idx2 (cost=0.00..8.45 rows=17 width=0) (never executed)

  • Index Cond: (((reg_name)::text = (msal.reg_name)::text) AND ((assnbri)::text = (msal.assnbri)::text))
99. 0.010 0.080 ↑ 1.0 1 10

Aggregate (cost=44.38..44.39 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=10)

100. 0.010 0.070 ↓ 0.0 0 10

Nested Loop Anti Join (cost=8.72..44.38 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=10)

  • Join Filter: (((mh_3.reg_name)::text = (al_1.reg_name)::text) AND ((mh_3.assnbri)::text = (al_1.assnbri)::text) AND ((mh_3.aso_mnt_shd_code)::text = (al_1.mnt_shd_code)::text))
101. 0.060 0.060 ↓ 0.0 0 10

Index Scan using f1asomsal_idx1 on f1aso_mnt_shd_asset_link al_1 (cost=0.28..8.30 rows=1 width=21) (actual time=0.006..0.006 rows=0 loops=10)

  • Index Cond: (((reg_name)::text = (msal.reg_name)::text) AND ((assnbri)::text = (msal.assnbri)::text) AND ((mnt_shd_code)::text = (msal.mnt_shd_code)::text))
  • Filter: (mnt_shd_start_date = to_timestamp('1900-01-01 00:00:00'::text, 'YYYY-MM-DD hh24:mi:ss'::text))
  • Rows Removed by Filter: 1
102. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on f1asr_reg_asset_mh mh_3 (cost=8.45..36.05 rows=2 width=26) (never executed)

  • Recheck Cond: (((reg_name)::text = (msal.reg_name)::text) AND ((assnbri)::text = (msal.assnbri)::text))
  • Filter: ((aso_mnt_shd_code)::text = (msal.mnt_shd_code)::text)
103. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on f1faramh_idx2 (cost=0.00..8.45 rows=17 width=0) (never executed)

  • Index Cond: (((reg_name)::text = (msal.reg_name)::text) AND ((assnbri)::text = (msal.assnbri)::text))
104. 0.010 0.070 ↑ 1.0 1 10

Aggregate (cost=12.59..12.60 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=10)

105. 0.010 0.060 ↑ 1.0 1 10

Nested Loop (cost=0.54..12.59 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=10)

106. 0.040 0.040 ↑ 1.0 1 10

Index Scan using tbfatc_idx4 on tbatt_attchmts_ctl attc (cost=0.27..8.29 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=10)

  • Index Cond: (((entity_type)::text = 'F1ASSNBR'::text) AND ((entity_key_1)::text = (a.reg_name)::text) AND ((entity_key_2)::text = (a.assnbri)::text))
107. 0.010 0.010 ↑ 1.0 1 10

Index Only Scan using tbfatd_idx1 on tbatt_attchmts_dtl attd (cost=0.27..4.29 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=10)

  • Index Cond: (unique_nbr = attc.unique_nbr)
  • Heap Fetches: 0
108. 0.010 0.040 ↑ 1.0 1 10

Aggregate (cost=4.29..4.30 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=10)

109. 0.030 0.030 ↑ 1.0 1 10

Index Only Scan using tbfatc_idx4 on tbatt_attchmts_ctl (cost=0.27..4.29 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: ((entity_type = 'F1ASSNBR'::text) AND (entity_key_1 = (a.reg_name)::text) AND (entity_key_2 = (a.assnbri)::text))
  • Heap Fetches: 0
Planning time : 12.402 ms
Execution time : 8.778 ms