# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.001 | 10,186.679 | ↓ 1.4 | 7 | 1 |
→
Limit (cost=2,067.60..2,615.01 rows=5 width=660) (actual time=10,186.445..10,186.679 rows=7 loops=1) |
2. | 0.077 | 10,186.678 | ↓ 1.4 | 7 | 1 |
→
WindowAgg (cost=2,067.60..2,615.01 rows=5 width=660) (actual time=10,186.444..10,186.678 rows=7 loops=1) |
3. | 0.018 | 10,186.338 | ↓ 1.4 | 7 | 1 |
→
Sort (cost=2,067.60..2,067.61 rows=5 width=502) (actual time=10,186.337..10,186.338 rows=7 loops=1)
|
4. | 0.002 | 10,186.320 | ↓ 1.4 | 7 | 1 |
→
Nested Loop (cost=1,951.95..2,067.54 rows=5 width=502) (actual time=10,186.218..10,186.320 rows=7 loops=1) |
5. | 0.000 | 0.106 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=2.10..47.34 rows=1 width=245) (actual time=0.097..0.106 rows=1 loops=1)
|
6. | 0.007 | 0.099 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=2.10..46.29 rows=1 width=230) (actual time=0.090..0.099 rows=1 loops=1)
|
7. | 0.005 | 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)
|
8. | 0.004 | 0.063 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=1.27..33.39 rows=1 width=204) (actual time=0.058..0.063 rows=1 loops=1)
|
9. | 0.004 | 0.052 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=0.98..25.07 rows=1 width=187) (actual time=0.048..0.052 rows=1 loops=1) |
10. | 0.006 | 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.024 | 0.024 | ↑ 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.024 rows=1 loops=1)
|
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)
|
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)
|
14. | 0.007 | 0.007 | ↑ 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.007 rows=1 loops=1)
|
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)
|
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)
|
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)
|
18. | 0.015 | 10,186.212 | ↓ 1.4 | 7 | 1 |
→
Merge Left Join (cost=1,949.85..2,020.16 rows=5 width=257) (actual time=10,186.119..10,186.212 rows=7 loops=1)
|
19. | 0.014 | 7,155.388 | ↓ 1.4 | 7 | 1 |
→
Merge Left Join (cost=1,238.79..1,301.00 rows=5 width=233) (actual time=7,155.307..7,155.388 rows=7 loops=1)
|
20. | 0.008 | 0.195 | ↓ 1.4 | 7 | 1 |
→
Nested Loop Left Join (cost=3.99..58.11 rows=5 width=217) (actual time=0.143..0.195 rows=7 loops=1)
|
21. | 0.007 | 0.110 | ↓ 1.4 | 7 | 1 |
→
Nested Loop Left Join (cost=3.70..43.45 rows=5 width=200) (actual time=0.067..0.110 rows=7 loops=1)
|
22. | 0.005 | 0.089 | ↓ 1.4 | 7 | 1 |
→
Nested Loop Left Join (cost=3.42..28.79 rows=5 width=183) (actual time=0.057..0.089 rows=7 loops=1)
|
23. | 0.016 | 0.070 | ↓ 1.4 | 7 | 1 |
→
Merge Join (cost=3.13..20.41 rows=5 width=166) (actual time=0.044..0.070 rows=7 loops=1)
|
24. | 0.020 | 0.020 | ↓ 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.011..0.020 rows=7 loops=1)
|
25. | 0.023 | 0.034 | ↑ 1.4 | 16 | 1 |
→
Sort (cost=2.85..2.91 rows=22 width=35) (actual time=0.032..0.034 rows=16 loops=1)
|
26. | 0.011 | 0.011 | ↑ 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.011 rows=18 loops=1)
|
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)
|
29. | 0.004 | 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.010 | 0.010 | ↑ 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.007..0.010 rows=4 loops=1)
|
31. | 0.006 | 0.077 | ↑ 2.0 | 2 | 7 |
→
Materialize (cost=0.29..14.37 rows=4 width=21) (actual time=0.002..0.011 rows=2 loops=7) |
32. | 0.071 | 0.071 | ↑ 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.007..0.071 rows=2 loops=1)
|
33. | 0.004 | 7,155.179 | ↓ 4.0 | 4 | 1 |
→
Materialize (cost=1,234.80..1,242.87 rows=1 width=37) (actual time=7,155.158..7,155.179 rows=4 loops=1) |
34. | 0.005 | 7,155.175 | ↓ 4.0 | 4 | 1 |
→
Nested Loop Left Join (cost=1,234.80..1,242.86 rows=1 width=37) (actual time=7,155.155..7,155.175 rows=4 loops=1) |
35. | 0.006 | 7,155.150 | ↓ 4.0 | 4 | 1 |
→
GroupAggregate (cost=1,234.52..1,234.55 rows=1 width=29) (actual time=7,155.141..7,155.150 rows=4 loops=1)
|
36. | 0.019 | 7,155.144 | ↓ 4.0 | 4 | 1 |
→
Sort (cost=1,234.52..1,234.53 rows=1 width=29) (actual time=7,155.138..7,155.144 rows=4 loops=1)
|
37. | 3.086 | 7,155.125 | ↓ 4.0 | 4 | 1 |
→
Nested Loop (cost=82.11..1,234.51 rows=1 width=29) (actual time=6.751..7,155.125 rows=4 loops=1)
|
38. | 1.444 | 3.659 | ↓ 21.5 | 452 | 1 |
→
Hash Join (cost=81.84..132.31 rows=21 width=39) (actual time=1.269..3.659 rows=452 loops=1)
|
39. | 1.077 | 1.077 | ↓ 1.0 | 756 | 1 |
→
Seq Scan on f1wrk_task_ctl_ass ta (cost=0.00..47.51 rows=735 width=38) (actual time=0.014..1.077 rows=756 loops=1)
|
40. | 0.121 | 1.138 | ↓ 41.4 | 455 | 1 |
→
Hash (cost=81.70..81.70 rows=11 width=45) (actual time=1.138..1.138 rows=455 loops=1)
|
41. | 0.894 | 1.017 | ↓ 41.4 | 455 | 1 |
→
Nested Loop (cost=2.91..81.70 rows=11 width=45) (actual time=0.066..1.017 rows=455 loops=1)
|
42. | 0.123 | 0.123 | ↓ 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.123 rows=441 loops=1)
|
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.013 | 0.040 | ↓ 1.4 | 7 | 1 |
→
Hash Join (cost=2.91..7.11 rows=5 width=32) (actual time=0.036..0.040 rows=7 loops=1)
|
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)
|
46. | 0.006 | 0.018 | ↑ 1.2 | 18 | 1 |
→
Hash (cost=2.36..2.36 rows=22 width=17) (actual time=0.018..0.018 rows=18 loops=1)
|
47. | 0.012 | 0.012 | ↑ 1.2 | 18 | 1 |
→
Seq Scan on f1aso_mnt_shd_ctl msc (cost=0.00..2.36 rows=22 width=17) (actual time=0.007..0.012 rows=18 loops=1)
|
48. | 4.068 | 4.068 | ↑ 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.008..0.009 rows=1 loops=452)
|
49. |
SubPlan (for Nested Loop) |
|||||
50. | 0.000 | 7,144.312 | ↑ 1.0 | 1 | 452 |
→
Aggregate (cost=49.86..49.87 rows=1 width=8) (actual time=15.806..15.806 rows=1 loops=452) |
51. |
Initplan (for Aggregate) |
|||||
52. | 3.164 | 3,559.500 | ↑ 1.0 | 1 | 452 |
→
Aggregate (cost=24.92..24.94 rows=1 width=8) (actual time=7.874..7.875 rows=1 loops=452) |
53. | 174.850 | 3,556.336 | ↓ 0.0 | 0 | 452 |
→
Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=7.843..7.868 rows=0 loops=452) |
54. | 365.216 | 1,880.772 | ↓ 369.0 | 369 | 452 |
→
Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.293..4.161 rows=369 loops=452) |
55. | 148.708 | 148.708 | ↓ 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.038..0.329 rows=756 loops=452)
|
56. | 1,366.848 | 1,366.848 | ↓ 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.004..0.004 rows=0 loops=341,712)
|
57. | 1,500.714 | 1,500.714 | ↓ 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.009..0.009 rows=0 loops=166,746)
|
58. | 79.046 | 7,121.712 | ↓ 367.0 | 367 | 452 |
→
Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=8.159..15.756 rows=367 loops=452) |
59. | 348.492 | 1,873.540 | ↓ 369.0 | 369 | 452 |
→
Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.270..4.145 rows=369 loops=452) |
60. | 158.200 | 158.200 | ↓ 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.032..0.350 rows=756 loops=452)
|
61. | 1,366.848 | 1,366.848 | ↓ 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.004..0.004 rows=0 loops=341,712)
|
62. | 5,169.126 | 5,169.126 | ↑ 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.030..0.031 rows=1 loops=166,746)
|
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)
|
64. | 0.003 | 3,030.809 | ↑ 1.0 | 1 | 1 |
→
Materialize (cost=711.06..719.13 rows=1 width=45) (actual time=3,030.808..3,030.809 rows=1 loops=1) |
65. | 0.003 | 3,030.806 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=711.06..719.12 rows=1 width=45) (actual time=3,030.805..3,030.806 rows=1 loops=1) |
66. | 0.003 | 3,030.798 | ↑ 1.0 | 1 | 1 |
→
GroupAggregate (cost=710.78..710.81 rows=1 width=29) (actual time=3,030.797..3,030.798 rows=1 loops=1)
|
67. | 0.010 | 3,030.795 | ↑ 1.0 | 1 | 1 |
→
Sort (cost=710.78..710.79 rows=1 width=29) (actual time=3,030.794..3,030.795 rows=1 loops=1)
|
68. | 1.667 | 3,030.785 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=82.11..710.77 rows=1 width=29) (actual time=263.116..3,030.785 rows=1 loops=1)
|
69. | 0.910 | 2.978 | ↓ 21.5 | 452 | 1 |
→
Hash Join (cost=81.84..132.31 rows=21 width=39) (actual time=1.467..2.978 rows=452 loops=1)
|
70. | 0.695 | 0.695 | ↓ 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.013..0.695 rows=756 loops=1)
|
71. | 0.156 | 1.373 | ↓ 41.4 | 455 | 1 |
→
Hash (cost=81.70..81.70 rows=11 width=45) (actual time=1.373..1.373 rows=455 loops=1)
|
72. | 0.633 | 1.217 | ↓ 41.4 | 455 | 1 |
→
Nested Loop (cost=2.91..81.70 rows=11 width=45) (actual time=0.089..1.217 rows=455 loops=1)
|
73. | 0.143 | 0.143 | ↓ 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.023..0.143 rows=441 loops=1)
|
74. | 0.383 | 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.014 | 0.058 | ↓ 1.4 | 7 | 1 |
→
Hash Join (cost=2.91..7.11 rows=5 width=32) (actual time=0.052..0.058 rows=7 loops=1)
|
76. | 0.017 | 0.017 | ↓ 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.014..0.017 rows=7 loops=1)
|
77. | 0.008 | 0.027 | ↑ 1.2 | 18 | 1 |
→
Hash (cost=2.36..2.36 rows=22 width=17) (actual time=0.027..0.027 rows=18 loops=1)
|
78. | 0.019 | 0.019 | ↑ 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.008..0.019 rows=18 loops=1)
|
79. | 3.616 | 3.616 | ↑ 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.007..0.008 rows=1 loops=452)
|
80. |
SubPlan (for Nested Loop) |
|||||
81. | 0.904 | 3,022.524 | ↑ 1.0 | 1 | 452 |
→
Aggregate (cost=24.92..24.93 rows=1 width=8) (actual time=6.687..6.687 rows=1 loops=452) |
82. | 109.720 | 3,021.620 | ↓ 0.0 | 0 | 452 |
→
Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=6.664..6.685 rows=0 loops=452) |
83. | 86.784 | 1,577.932 | ↓ 369.0 | 369 | 452 |
→
Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.237..3.491 rows=369 loops=452) |
84. | 124.300 | 124.300 | ↓ 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.027..0.275 rows=756 loops=452)
|
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)
|
86. | 1,333.968 | 1,333.968 | ↓ 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.008..0.008 rows=0 loops=166,746)
|
87. | 0.005 | 0.005 | ↑ 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.005 rows=1 loops=1)
|
88. |
SubPlan (for WindowAgg) |
|||||
89. | 0.042 | 0.042 | ↑ 1.0 | 1 | 7 |
→
Seq Scan on f1aso_mnt_shd_ctl msc1 (cost=0.00..2.44 rows=1 width=2) (actual time=0.004..0.006 rows=1 loops=7)
|
90. | 0.002 | 0.029 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=45.69..45.70 rows=1 width=8) (actual time=0.029..0.029 rows=1 loops=1) |
91. | 0.001 | 0.027 | ↓ 0.0 | 0 | 1 |
→
Nested Loop Anti Join (cost=8.73..45.69 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=1)
|
92. | 0.012 | 0.026 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=0.28..9.39 rows=1 width=20) (actual time=0.026..0.026 rows=0 loops=1) |
93. | 0.014 | 0.014 | ↓ 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.014..0.014 rows=0 loops=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)
|
|
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)
|
|
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)
|
|
97. | 0.000 | 0.066 | ↑ 1.0 | 1 | 6 |
→
Aggregate (cost=44.38..44.39 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=6) |
98. | 0.012 | 0.066 | ↓ 0.0 | 0 | 6 |
→
Nested Loop Anti Join (cost=8.72..44.38 rows=1 width=0) (actual time=0.011..0.011 rows=0 loops=6)
|
99. | 0.054 | 0.054 | ↓ 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.009..0.009 rows=0 loops=6)
|
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)
|
|
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)
|
|
102. | 0.007 | 0.084 | ↑ 1.0 | 1 | 7 |
→
Aggregate (cost=12.59..12.60 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=7) |
103. | 0.014 | 0.077 | ↓ 7.0 | 7 | 7 |
→
Nested Loop (cost=0.54..12.59 rows=1 width=0) (actual time=0.009..0.011 rows=7 loops=7) |
104. | 0.035 | 0.035 | ↑ 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.005..0.005 rows=1 loops=7)
|
105. | 0.028 | 0.028 | ↓ 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.004 rows=7 loops=7)
|
106. | 0.014 | 0.042 | ↑ 1.0 | 1 | 7 |
→
Aggregate (cost=4.29..4.30 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=7) |
107. | 0.028 | 0.028 | ↑ 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.004..0.004 rows=1 loops=7)
|
Planning time | : | 12.661 ms |
---|---|---|
Execution time | : | 10,188.410 ms |