explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NFZV

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 9,157.511 ↓ 1.4 7 1
→

Limit (cost=2,067.60..2,615.01 rows=5 width=660) (actual time=9,157.360..9,157.511 rows=7 loops=1)

2. 0.050 9,157.510 ↓ 1.4 7 1
→

WindowAgg (cost=2,067.60..2,615.01 rows=5 width=660) (actual time=9,157.359..9,157.510 rows=7 loops=1)

3. 0.015 9,157.251 ↓ 1.4 7 1
→

Sort (cost=2,067.60..2,067.61 rows=5 width=502) (actual time=9,157.250..9,157.251 rows=7 loops=1)

  • Sort Key: a.edassnbr
  • Sort Method: quicksort Memory: 30kB
4. 0.007 9,157.236 ↓ 1.4 7 1
→

Nested Loop (cost=1,951.95..2,067.54 rows=5 width=502) (actual time=9,157.131..9,157.236 rows=7 loops=1)

5. 0.001 0.105 ↑ 1.0 1 1
→

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

  • Join Filter: (((a.assnbri)::text = (abom.assnbri)::text) AND ((a.reg_name)::text = (abom.reg_name)::text))
6. 0.005 0.097 ↑ 1.0 1 1
→

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

  • Join Filter: (((a.assnbri)::text = (rpt.assnbri)::text) AND ((a.reg_name)::text = (rpt.reg_name)::text))
7. 0.003 0.080 ↑ 1.0 1 1
→

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

  • Join Filter: (((a.reg_name)::text = (au.reg_name)::text) AND ((a.assnbri)::text = (au.assnbri)::text))
8. 0.006 0.065 ↑ 1.0 1 1
→

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

  • Join Filter: ((a.asset_type)::text = (f1a_asset_type_sc0.code_id)::text)
9. 0.005 0.053 ↑ 1.0 1 1
→

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

10. 0.005 0.040 ↑ 1.0 1 1
→

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

11. 0.025 0.025 ↑ 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.023..0.025 rows=1 loops=1)

  • Index Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000010'::text))
  • Filter: ((asset_type)::text = 'S'::text)
12. 0.010 0.010 ↑ 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.009..0.010 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.008 0.008 ↑ 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.007..0.008 rows=1 loops=1)

  • Index Cond: (((code_type)::text = 'F1A_ASSET_STATUS'::text) AND ((a.asset_status)::text = (code_id)::text))
14. 0.006 0.006 ↑ 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.006..0.006 rows=1 loops=1)

  • Index Cond: (((code_type)::text = 'F1A_ASSET_TYPE'::text) AND ((code_id)::text = 'S'::text))
15. 0.012 0.012 ↑ 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.011..0.012 rows=1 loops=1)

  • Index Cond: ((reg_name = 'ASSET'::text) AND (assnbri = '0000010'::text))
  • Heap Fetches: 0
16. 0.012 0.012 ↑ 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.011..0.012 rows=1 loops=1)

  • Index Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000010'::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 = '0000010'::text) AND (seqnbr = 1) AND ((reg_name)::text = 'ASSET'::text))
  • Rows Removed by Filter: 2
18. 0.013 9,157.124 ↓ 1.4 7 1
→

Merge Left Join (cost=1,949.85..2,020.16 rows=5 width=257) (actual time=9,157.031..9,157.124 rows=7 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.016 5,786.331 ↓ 1.4 7 1
→

Merge Left Join (cost=1,238.79..1,301.00 rows=5 width=233) (actual time=5,786.249..5,786.331 rows=7 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.007 0.135 ↓ 1.4 7 1
→

Nested Loop Left Join (cost=3.99..58.11 rows=5 width=217) (actual time=0.084..0.135 rows=7 loops=1)

  • Join Filter: ((msd.mnt_shd_basis_optn)::text = (aso_mnt_shd_basis_sc7.code_id)::text)
  • Rows Removed by Join Filter: 7
21. 0.007 0.114 ↓ 1.4 7 1
→

Nested Loop Left Join (cost=3.70..43.45 rows=5 width=200) (actual time=0.071..0.114 rows=7 loops=1)

  • Join Filter: ((msd.mnt_shd_type)::text = (aso_mnt_shd_type_sc6.code_id)::text)
  • Rows Removed by Join Filter: 21
22. 0.008 0.093 ↓ 1.4 7 1
→

Nested Loop Left Join (cost=3.42..28.79 rows=5 width=183) (actual time=0.061..0.093 rows=7 loops=1)

  • Join Filter: ((msal.mnt_shd_asset_link_status)::text = (aso_mnt_shd_asset_link44f21c76.code_id)::text)
23. 0.013 0.071 ↓ 1.4 7 1
→

Merge Join (cost=3.13..20.41 rows=5 width=166) (actual time=0.048..0.071 rows=7 loops=1)

  • Merge Cond: ((msal.mnt_shd_code)::text = (msd.mnt_shd_code)::text)
24. 0.023 0.023 ↓ 1.2 7 1
→

Index Scan using f1asomsal_idx1 on f1aso_mnt_shd_asset_link msal (cost=0.28..17.40 rows=6 width=131) (actual time=0.013..0.023 rows=7 loops=1)

  • Index Cond: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000010'::text))
  • Filter: ((mnt_shd_asset_link_status)::text = 'A'::text)
25. 0.021 0.035 ↑ 1.4 16 1
→

Sort (cost=2.85..2.91 rows=22 width=35) (actual time=0.033..0.035 rows=16 loops=1)

  • Sort Key: msd.mnt_shd_code
  • Sort Method: quicksort Memory: 26kB
26. 0.014 0.014 ↑ 1.2 18 1
→

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

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

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

28. 0.010 0.010 ↑ 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.009..0.010 rows=1 loops=1)

  • Index Cond: (((code_type)::text = 'ASO_MNT_SHD_ASSET_LINK_STATUS'::text) AND ((code_id)::text = 'A'::text))
29. 0.001 0.014 ↑ 1.0 4 7
→

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

30. 0.013 0.013 ↑ 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.008..0.013 rows=4 loops=1)

  • Index Cond: ((code_type)::text = 'ASO_MNT_SHD_TYPE'::text)
31. 0.004 0.014 ↑ 2.0 2 7
→

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

32. 0.010 0.010 ↑ 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.008..0.010 rows=2 loops=1)

  • Index Cond: ((code_type)::text = 'ASO_MNT_SHD_BASIS'::text)
33. 0.005 5,786.180 ↓ 4.0 4 1
→

Materialize (cost=1,234.80..1,242.87 rows=1 width=37) (actual time=5,786.156..5,786.180 rows=4 loops=1)

34. 0.005 5,786.175 ↓ 4.0 4 1
→

Nested Loop Left Join (cost=1,234.80..1,242.86 rows=1 width=37) (actual time=5,786.153..5,786.175 rows=4 loops=1)

35. 0.006 5,786.150 ↓ 4.0 4 1
→

GroupAggregate (cost=1,234.52..1,234.55 rows=1 width=29) (actual time=5,786.138..5,786.150 rows=4 loops=1)

  • Group Key: msal_1.reg_name, msal_1.assnbri, msal_1.mnt_shd_code
36. 0.022 5,786.144 ↓ 4.0 4 1
→

Sort (cost=1,234.52..1,234.53 rows=1 width=29) (actual time=5,786.134..5,786.144 rows=4 loops=1)

  • Sort Key: msal_1.mnt_shd_code
  • Sort Method: quicksort Memory: 25kB
37. 2.341 5,786.122 ↓ 4.0 4 1
→

Nested Loop (cost=82.11..1,234.51 rows=1 width=29) (actual time=5.997..5,786.122 rows=4 loops=1)

  • Join Filter: ((SubPlan 8) = tc.est_start_datei)
  • Rows Removed by Join Filter: 448
38. 0.865 2.701 ↓ 21.5 452 1
→

Hash Join (cost=81.84..132.31 rows=21 width=39) (actual time=1.210..2.701 rows=452 loops=1)

  • Hash Cond: (ta.mnt_hist_unique_id = mh.unique_id)
39. 0.710 0.710 ↓ 1.0 756 1
→

Seq Scan on f1wrk_task_ctl_ass ta (cost=0.00..47.51 rows=735 width=38) (actual time=0.009..0.710 rows=756 loops=1)

  • Filter: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000010'::text))
  • Rows Removed by Filter: 485
40. 0.116 1.126 ↓ 41.4 455 1
→

Hash (cost=81.70..81.70 rows=11 width=45) (actual time=1.126..1.126 rows=455 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 47kB
41. 0.868 1.010 ↓ 41.4 455 1
→

Nested Loop (cost=2.91..81.70 rows=11 width=45) (actual time=0.063..1.010 rows=455 loops=1)

  • 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: 2,632
42. 0.142 0.142 ↓ 1.0 441 1
→

Seq Scan on f1asr_reg_asset_mh mh (cost=0.00..37.74 rows=421 width=35) (actual time=0.023..0.142 rows=441 loops=1)

  • Filter: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000010'::text))
  • Rows Removed by Filter: 91
43. 0.000 0.000 ↓ 1.4 7 441
→

Materialize (cost=2.91..7.13 rows=5 width=32) (actual time=0.000..0.000 rows=7 loops=441)

44. 0.011 0.035 ↓ 1.4 7 1
→

Hash Join (cost=2.91..7.11 rows=5 width=32) (actual time=0.032..0.035 rows=7 loops=1)

  • Hash Cond: ((msal_1.mnt_shd_code)::text = (msc.mnt_shd_code)::text)
45. 0.009 0.009 ↓ 1.2 7 1
→

Index Only Scan using f1asomsal_idx1 on f1aso_mnt_shd_asset_link msal_1 (cost=0.28..4.40 rows=6 width=21) (actual time=0.008..0.009 rows=7 loops=1)

  • Index Cond: ((reg_name = 'ASSET'::text) AND (assnbri = '0000010'::text))
  • Heap Fetches: 0
46. 0.008 0.015 ↑ 1.2 18 1
→

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
47. 0.007 0.007 ↑ 1.2 18 1
→

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

  • Filter: ((reg_name)::text = 'ASSET'::text)
  • Rows Removed by Filter: 6
48. 3.164 3.164 ↑ 1.0 1 452
→

Index Scan using f1wtc_idx1 on f1wrk_task_ctl tc (cost=0.28..2.60 rows=1 width=33) (actual time=0.007..0.007 rows=1 loops=452)

  • Index Cond: (((work_sys_name)::text = (ta.work_sys_name)::text) AND ((task_nbri)::text = (ta.task_nbri)::text))
49.          

SubPlan (for Nested Loop)
50. 0.000 5,777.916 ↑ 1.0 1 452
→

Aggregate (cost=49.86..49.87 rows=1 width=8) (actual time=12.783..12.783 rows=1 loops=452)

51.          

Initplan (for Aggregate)
52. 3.164 2,858.448 ↑ 1.0 1 452
→

Aggregate (cost=24.92..24.94 rows=1 width=8) (actual time=6.324..6.324 rows=1 loops=452)

53. 149.454 2,855.284 ↓ 0.0 0 452
→

Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=6.291..6.317 rows=0 loops=452)

54. 381.488 1,538.608 ↓ 369.0 369 452
→

Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.275..3.404 rows=369 loops=452)

55. 131.984 131.984 ↓ 756.0 756 452
→

Index Scan using f1wtcass_idx2 on f1wrk_task_ctl_ass ta_2 (cost=0.28..8.30 rows=1 width=38) (actual time=0.037..0.292 rows=756 loops=452)

  • Index Cond: (((reg_name)::text = (msal_1.reg_name)::text) AND ((assnbri)::text = (msal_1.assnbri)::text))
56. 1,025.136 1,025.136 ↓ 0.0 0 341,712
→

Index Scan using f1faramh_idx1 on f1asr_reg_asset_mh mh3 (cost=0.28..8.30 rows=1 width=22) (actual time=0.003..0.003 rows=0 loops=341,712)

  • 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: 0
57. 1,167.222 1,167.222 ↓ 0.0 0 166,746
→

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=166,746)

  • 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
58. 59.358 5,759.836 ↓ 367.0 367 452
→

Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=6.601..12.743 rows=367 loops=452)

59. 388.268 1,531.828 ↓ 369.0 369 452
→

Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.265..3.389 rows=369 loops=452)

60. 118.424 118.424 ↓ 756.0 756 452
→

Index Scan using f1wtcass_idx2 on f1wrk_task_ctl_ass ta_3 (cost=0.28..8.30 rows=1 width=38) (actual time=0.026..0.262 rows=756 loops=452)

  • Index Cond: (((reg_name)::text = (msal_1.reg_name)::text) AND ((assnbri)::text = (msal_1.assnbri)::text))
61. 1,025.136 1,025.136 ↓ 0.0 0 341,712
→

Index Scan using f1faramh_idx1 on f1asr_reg_asset_mh mh2_1 (cost=0.28..8.30 rows=1 width=22) (actual time=0.003..0.003 rows=0 loops=341,712)

  • 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: 0
62. 4,168.650 4,168.650 ↑ 1.0 1 166,746
→

Index Scan using f1wtc_idx1 on f1wrk_task_ctl tc_3 (cost=0.28..8.30 rows=1 width=25) (actual time=0.025..0.025 rows=1 loops=166,746)

  • 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
63. 0.020 0.020 ↑ 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.005..0.005 rows=1 loops=4)

  • Index Cond: (task_rid = (min(tc.task_rid)))
64. 0.004 3,370.780 ↑ 1.0 1 1
→

Materialize (cost=711.06..719.13 rows=1 width=45) (actual time=3,370.779..3,370.780 rows=1 loops=1)

65. 0.002 3,370.776 ↑ 1.0 1 1
→

Nested Loop Left Join (cost=711.06..719.12 rows=1 width=45) (actual time=3,370.775..3,370.776 rows=1 loops=1)

66. 0.004 3,370.768 ↑ 1.0 1 1
→

GroupAggregate (cost=710.78..710.81 rows=1 width=29) (actual time=3,370.768..3,370.768 rows=1 loops=1)

  • Group Key: msal_2.reg_name, msal_2.assnbri, msal_2.mnt_shd_code
67. 0.013 3,370.764 ↑ 1.0 1 1
→

Sort (cost=710.78..710.79 rows=1 width=29) (actual time=3,370.764..3,370.764 rows=1 loops=1)

  • Sort Key: msal_2.mnt_shd_code
  • Sort Method: quicksort Memory: 25kB
68. 1.749 3,370.751 ↑ 1.0 1 1
→

Nested Loop (cost=82.11..710.77 rows=1 width=29) (actual time=419.986..3,370.751 rows=1 loops=1)

  • Join Filter: ((SubPlan 6) = tc_1.est_start_datei)
  • Rows Removed by Join Filter: 451
69. 0.945 3.862 ↓ 21.5 452 1
→

Hash Join (cost=81.84..132.31 rows=21 width=39) (actual time=2.245..3.862 rows=452 loops=1)

  • Hash Cond: (ta_1.mnt_hist_unique_id = mh_1.unique_id)
70. 0.815 0.815 ↓ 1.0 756 1
→

Seq Scan on f1wrk_task_ctl_ass ta_1 (cost=0.00..47.51 rows=735 width=38) (actual time=0.017..0.815 rows=756 loops=1)

  • Filter: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000010'::text))
  • Rows Removed by Filter: 485
71. 0.198 2.102 ↓ 41.4 455 1
→

Hash (cost=81.70..81.70 rows=11 width=45) (actual time=2.102..2.102 rows=455 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 47kB
72. 1.268 1.904 ↓ 41.4 455 1
→

Nested Loop (cost=2.91..81.70 rows=11 width=45) (actual time=0.104..1.904 rows=455 loops=1)

  • 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: 2,632
73. 0.195 0.195 ↓ 1.0 441 1
→

Seq Scan on f1asr_reg_asset_mh mh_1 (cost=0.00..37.74 rows=421 width=35) (actual time=0.030..0.195 rows=441 loops=1)

  • Filter: (((reg_name)::text = 'ASSET'::text) AND ((assnbri)::text = '0000010'::text))
  • Rows Removed by Filter: 91
74. 0.376 0.441 ↓ 1.4 7 441
→

Materialize (cost=2.91..7.13 rows=5 width=32) (actual time=0.000..0.001 rows=7 loops=441)

75. 0.019 0.065 ↓ 1.4 7 1
→

Hash Join (cost=2.91..7.11 rows=5 width=32) (actual time=0.060..0.065 rows=7 loops=1)

  • Hash Cond: ((msal_2.mnt_shd_code)::text = (msc_1.mnt_shd_code)::text)
76. 0.020 0.020 ↓ 1.2 7 1
→

Index Only Scan using f1asomsal_idx1 on f1aso_mnt_shd_asset_link msal_2 (cost=0.28..4.40 rows=6 width=21) (actual time=0.017..0.020 rows=7 loops=1)

  • Index Cond: ((reg_name = 'ASSET'::text) AND (assnbri = '0000010'::text))
  • Heap Fetches: 0
77. 0.011 0.026 ↑ 1.2 18 1
→

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
78. 0.015 0.015 ↑ 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.015 rows=18 loops=1)

  • Filter: ((reg_name)::text = 'ASSET'::text)
  • Rows Removed by Filter: 6
79. 4.068 4.068 ↑ 1.0 1 452
→

Index Scan using f1wtc_idx1 on f1wrk_task_ctl tc_1 (cost=0.28..2.60 rows=1 width=33) (actual time=0.008..0.009 rows=1 loops=452)

  • Index Cond: (((work_sys_name)::text = (ta_1.work_sys_name)::text) AND ((task_nbri)::text = (ta_1.task_nbri)::text))
80.          

SubPlan (for Nested Loop)
81. 0.904 3,361.072 ↑ 1.0 1 452
→

Aggregate (cost=24.92..24.93 rows=1 width=8) (actual time=7.436..7.436 rows=1 loops=452)

82. 78.122 3,360.168 ↓ 0.0 0 452
→

Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=7.401..7.434 rows=0 loops=452)

83. 280.692 1,781.332 ↓ 369.0 369 452
→

Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.386..3.941 rows=369 loops=452)

84. 133.792 133.792 ↓ 756.0 756 452
→

Index Scan using f1wtcass_idx2 on f1wrk_task_ctl_ass ta2 (cost=0.28..8.30 rows=1 width=38) (actual time=0.030..0.296 rows=756 loops=452)

  • Index Cond: (((reg_name)::text = (msal_2.reg_name)::text) AND ((assnbri)::text = (msal_2.assnbri)::text))
85. 1,366.848 1,366.848 ↓ 0.0 0 341,712
→

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=341,712)

  • 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: 0
86. 1,500.714 1,500.714 ↓ 0.0 0 166,746
→

Index Scan using f1wtc_idx1 on f1wrk_task_ctl tc2 (cost=0.28..8.30 rows=1 width=25) (actual time=0.009..0.009 rows=0 loops=166,746)

  • 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
87. 0.006 0.006 ↑ 1.0 1 1
→

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

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

SubPlan (for WindowAgg)
89. 0.035 0.035 ↑ 1.0 1 7
→

Seq Scan on f1aso_mnt_shd_ctl msc1 (cost=0.00..2.44 rows=1 width=2) (actual time=0.003..0.005 rows=1 loops=7)

  • Filter: (((reg_name)::text = (msal.reg_name)::text) AND ((mnt_shd_code)::text = (msal.mnt_shd_code)::text))
  • Rows Removed by Filter: 23
90. 0.001 0.015 ↑ 1.0 1 1
→

Aggregate (cost=45.69..45.70 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

91. 0.001 0.014 ↓ 0.0 0 1
→

Nested Loop Anti Join (cost=8.73..45.69 rows=1 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • 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))
92. 0.003 0.013 ↓ 0.0 0 1
→

Nested Loop (cost=0.28..9.39 rows=1 width=20) (actual time=0.013..0.013 rows=0 loops=1)

93. 0.010 0.010 ↓ 0.0 0 1
→

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

  • 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
94. 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))
95. 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))
96. 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))
97. 0.006 0.054 ↑ 1.0 1 6
→

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

98. 0.006 0.048 ↓ 0.0 0 6
→

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

  • 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))
99. 0.042 0.042 ↓ 0.0 0 6
→

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.007..0.007 rows=0 loops=6)

  • 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
100. 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)
101. 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))
102. 0.007 0.070 ↑ 1.0 1 7
→

Aggregate (cost=12.59..12.60 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=7)

103. 0.014 0.063 ↓ 7.0 7 7
→

Nested Loop (cost=0.54..12.59 rows=1 width=0) (actual time=0.007..0.009 rows=7 loops=7)

104. 0.028 0.028 ↑ 1.0 1 7
→

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

  • Index Cond: (((entity_type)::text = 'F1ASSNBR'::text) AND ((entity_key_1)::text = (a.reg_name)::text) AND ((entity_key_2)::text = (a.assnbri)::text))
105. 0.021 0.021 ↓ 7.0 7 7
→

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

  • Index Cond: (unique_nbr = attc.unique_nbr)
  • Heap Fetches: 14
106. 0.014 0.035 ↑ 1.0 1 7
→

Aggregate (cost=4.29..4.30 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=7)

107. 0.021 0.021 ↑ 1.0 1 7
→

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=7)

  • 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 : 10.266 ms
Execution time : 9,158.983 ms