# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 6.465 | ↓ 1.2 | 10 | 1 |
→
Limit (cost=326.77..1,202.62 rows=8 width=660) (actual time=6.280..6.465 rows=10 loops=1) |
2. | 0.036 | 6.465 | ↓ 1.2 | 10 | 1 |
→
WindowAgg (cost=326.77..1,202.62 rows=8 width=660) (actual time=6.280..6.465 rows=10 loops=1) |
3. | 0.018 | 6.189 | ↓ 1.2 | 10 | 1 |
→
Sort (cost=326.77..326.79 rows=8 width=502) (actual time=6.186..6.189 rows=10 loops=1)
|
4. | 0.004 | 6.171 | ↓ 1.2 | 10 | 1 |
→
Nested Loop (cost=197.21..326.65 rows=8 width=502) (actual time=6.065..6.171 rows=10 loops=1) |
5. | 0.001 | 0.103 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=2.10..47.34 rows=1 width=245) (actual time=0.098..0.103 rows=1 loops=1)
|
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.093..0.097 rows=1 loops=1)
|
7. | 0.002 | 0.080 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=1.69..37.84 rows=1 width=211) (actual time=0.077..0.080 rows=1 loops=1)
|
8. | 0.003 | 0.057 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=1.27..33.39 rows=1 width=204) (actual time=0.055..0.057 rows=1 loops=1)
|
9. | 0.004 | 0.047 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=0.98..25.07 rows=1 width=187) (actual time=0.045..0.047 rows=1 loops=1) |
10. | 0.006 | 0.033 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=0.70..16.75 rows=1 width=170) (actual time=0.032..0.033 rows=1 loops=1) |
11. | 0.016 | 0.016 | ↑ 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.016..0.016 rows=1 loops=1)
|
12. | 0.011 | 0.011 | ↑ 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.010..0.011 rows=1 loops=1)
|
13. | 0.010 | 0.010 | ↑ 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.009..0.010 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.007..0.007 rows=1 loops=1)
|
15. | 0.021 | 0.021 | ↑ 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.019..0.021 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.005 | 0.005 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on f1asr_reg_asset_bom abom (cost=0.00..1.03 rows=1 width=29) (actual time=0.005..0.005 rows=0 loops=1)
|
18. | 0.012 | 6.064 | ↓ 1.2 | 10 | 1 |
→
Merge Left Join (cost=195.11..279.24 rows=8 width=257) (actual time=5.965..6.064 rows=10 loops=1)
|
19. | 0.008 | 3.983 | ↓ 1.2 | 10 | 1 |
→
Merge Left Join (cost=104.36..180.38 rows=8 width=233) (actual time=3.901..3.983 rows=10 loops=1)
|
20. | 0.014 | 0.144 | ↓ 1.2 | 10 | 1 |
→
Nested Loop Left Join (cost=1.13..69.05 rows=8 width=217) (actual time=0.077..0.144 rows=10 loops=1)
|
21. | 0.013 | 0.120 | ↓ 1.2 | 10 | 1 |
→
Nested Loop Left Join (cost=0.85..54.21 rows=8 width=200) (actual time=0.061..0.120 rows=10 loops=1)
|
22. | 0.008 | 0.097 | ↓ 1.2 | 10 | 1 |
→
Nested Loop Left Join (cost=0.56..39.37 rows=8 width=183) (actual time=0.050..0.097 rows=10 loops=1)
|
23. | 0.029 | 0.079 | ↓ 1.2 | 10 | 1 |
→
Nested Loop (cost=0.28..30.95 rows=8 width=166) (actual time=0.037..0.079 rows=10 loops=1)
|
24. | 0.030 | 0.030 | ↑ 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.021..0.030 rows=10 loops=1)
|
25. | 0.010 | 0.020 | ↑ 1.2 | 18 | 10 |
→
Materialize (cost=0.00..2.47 rows=22 width=35) (actual time=0.001..0.002 rows=18 loops=10) |
26. | 0.010 | 0.010 | ↑ 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.010 rows=18 loops=1)
|
27. | 0.000 | 0.010 | ↑ 1.0 | 1 | 10 |
→
Materialize (cost=0.29..8.31 rows=1 width=21) (actual time=0.001..0.001 rows=1 loops=10) |
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.010..0.010 rows=1 loops=1)
|
29. | 0.000 | 0.010 | ↑ 1.0 | 4 | 10 |
→
Materialize (cost=0.29..14.37 rows=4 width=21) (actual time=0.001..0.001 rows=4 loops=10) |
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.002 | 0.010 | ↑ 2.0 | 2 | 10 |
→
Materialize (cost=0.29..14.37 rows=4 width=21) (actual time=0.001..0.001 rows=2 loops=10) |
32. | 0.008 | 0.008 | ↑ 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.008 rows=2 loops=1)
|
33. | 0.002 | 3.831 | ↓ 4.0 | 4 | 1 |
→
Materialize (cost=103.22..111.29 rows=1 width=37) (actual time=3.821..3.831 rows=4 loops=1) |
34. | 0.003 | 3.829 | ↓ 4.0 | 4 | 1 |
→
Nested Loop Left Join (cost=103.22..111.29 rows=1 width=37) (actual time=3.821..3.829 rows=4 loops=1) |
35. | 0.001 | 3.814 | ↓ 4.0 | 4 | 1 |
→
GroupAggregate (cost=102.95..102.97 rows=1 width=29) (actual time=3.813..3.814 rows=4 loops=1)
|
36. | 0.008 | 3.813 | ↓ 4.0 | 4 | 1 |
→
Sort (cost=102.95..102.95 rows=1 width=29) (actual time=3.811..3.813 rows=4 loops=1)
|
37. | 0.000 | 3.805 | ↓ 4.0 | 4 | 1 |
→
Hash Join (cost=39.86..102.94 rows=1 width=29) (actual time=1.701..3.805 rows=4 loops=1)
|
38. | 0.024 | 0.154 | ↓ 13.0 | 13 | 1 |
→
Nested Loop (cost=32.53..70.65 rows=1 width=43) (actual time=0.072..0.154 rows=13 loops=1) |
39. | 0.012 | 0.078 | ↓ 13.0 | 13 | 1 |
→
Merge Join (cost=32.25..63.01 rows=1 width=43) (actual time=0.061..0.078 rows=13 loops=1)
|
40. | 0.013 | 0.013 | ↓ 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.009..0.013 rows=13 loops=1)
|
41. | 0.025 | 0.053 | ↑ 1.0 | 18 | 1 |
→
Sort (cost=31.93..31.97 rows=18 width=38) (actual time=0.049..0.053 rows=18 loops=1)
|
42. | 0.011 | 0.028 | ↑ 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.022..0.028 rows=18 loops=1)
|
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)
|
44. | 0.052 | 0.052 | ↑ 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.004..0.004 rows=1 loops=13)
|
45. | 1.382 | 1.427 | ↑ 2.0 | 4 | 1 |
→
Hash (cost=7.23..7.23 rows=8 width=32) (actual time=1.427..1.427 rows=4 loops=1)
|
46. | 0.009 | 0.045 | ↓ 1.2 | 10 | 1 |
→
Hash Join (cost=2.91..7.23 rows=8 width=32) (actual time=0.043..0.045 rows=10 loops=1)
|
47. | 0.020 | 0.020 | ↑ 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.020 rows=10 loops=1)
|
48. | 0.008 | 0.016 | ↑ 1.2 | 18 | 1 |
→
Hash (cost=2.36..2.36 rows=22 width=17) (actual time=0.016..0.016 rows=18 loops=1)
|
49. | 0.008 | 0.008 | ↑ 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.008 rows=18 loops=1)
|
50. |
SubPlan (for Hash Join) |
|||||
51. | 0.000 | 3.560 | ↑ 1.0 | 1 | 20 |
→
Aggregate (cost=49.86..49.87 rows=1 width=8) (actual time=0.178..0.178 rows=1 loops=20) |
52. |
Initplan (for Aggregate) |
|||||
53. | 0.014 | 1.554 | ↑ 1.0 | 1 | 14 |
→
Aggregate (cost=24.92..24.94 rows=1 width=8) (actual time=0.111..0.111 rows=1 loops=14) |
54. | 0.050 | 1.540 | ↑ 1.0 | 1 | 14 |
→
Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=0.086..0.110 rows=1 loops=14) |
55. | 0.042 | 1.190 | ↓ 4.0 | 4 | 14 |
→
Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.024..0.085 rows=4 loops=14) |
56. | 0.140 | 0.140 | ↓ 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.006..0.010 rows=18 loops=14)
|
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)
|
58. | 0.300 | 0.300 | ↓ 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.006..0.006 rows=0 loops=50)
|
59. | 0.050 | 3.540 | ↓ 2.0 | 2 | 20 |
→
Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=0.124..0.177 rows=2 loops=20) |
60. | 0.000 | 1.640 | ↓ 2.0 | 2 | 20 |
→
Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.041..0.082 rows=2 loops=20) |
61. | 0.200 | 0.200 | ↓ 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.007..0.010 rows=18 loops=20)
|
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)
|
63. | 1.850 | 1.850 | ↑ 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.037..0.037 rows=1 loops=50)
|
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.002..0.003 rows=1 loops=4)
|
65. | 0.001 | 2.069 | ↓ 3.0 | 3 | 1 |
→
Materialize (cost=90.75..98.82 rows=1 width=45) (actual time=2.062..2.069 rows=3 loops=1) |
66. | 0.000 | 2.068 | ↓ 3.0 | 3 | 1 |
→
Nested Loop Left Join (cost=90.75..98.82 rows=1 width=45) (actual time=2.062..2.068 rows=3 loops=1) |
67. | 0.004 | 2.059 | ↓ 3.0 | 3 | 1 |
→
GroupAggregate (cost=90.48..90.50 rows=1 width=29) (actual time=2.057..2.059 rows=3 loops=1)
|
68. | 0.007 | 2.055 | ↓ 3.0 | 3 | 1 |
→
Sort (cost=90.48..90.48 rows=1 width=29) (actual time=2.055..2.055 rows=3 loops=1)
|
69. | 0.000 | 2.048 | ↓ 3.0 | 3 | 1 |
→
Hash Join (cost=39.86..90.47 rows=1 width=29) (actual time=1.138..2.048 rows=3 loops=1)
|
70. | 0.023 | 0.141 | ↓ 13.0 | 13 | 1 |
→
Nested Loop (cost=32.53..70.65 rows=1 width=43) (actual time=0.064..0.141 rows=13 loops=1) |
71. | 0.014 | 0.066 | ↓ 13.0 | 13 | 1 |
→
Merge Join (cost=32.25..63.01 rows=1 width=43) (actual time=0.051..0.066 rows=13 loops=1)
|
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)
|
73. | 0.012 | 0.041 | ↑ 1.0 | 18 | 1 |
→
Sort (cost=31.93..31.97 rows=18 width=38) (actual time=0.039..0.041 rows=18 loops=1)
|
74. | 0.013 | 0.029 | ↑ 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.022..0.029 rows=18 loops=1)
|
75. | 0.016 | 0.016 | ↑ 1.0 | 18 | 1 |
→
Bitmap Index Scan on f1wtcass_idx2 (cost=0.00..4.46 rows=18 width=0) (actual time=0.016..0.016 rows=18 loops=1)
|
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)
|
77. | 0.899 | 0.948 | ↑ 2.7 | 3 | 1 |
→
Hash (cost=7.23..7.23 rows=8 width=32) (actual time=0.947..0.948 rows=3 loops=1)
|
78. | 0.013 | 0.049 | ↓ 1.2 | 10 | 1 |
→
Hash Join (cost=2.91..7.23 rows=8 width=32) (actual time=0.043..0.049 rows=10 loops=1)
|
79. | 0.020 | 0.020 | ↑ 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.020..0.020 rows=10 loops=1)
|
80. | 0.005 | 0.016 | ↑ 1.2 | 18 | 1 |
→
Hash (cost=2.36..2.36 rows=22 width=17) (actual time=0.016..0.016 rows=18 loops=1)
|
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)
|
82. |
SubPlan (for Hash Join) |
|||||
83. | 0.000 | 1.824 | ↑ 1.0 | 1 | 19 |
→
Aggregate (cost=24.92..24.93 rows=1 width=8) (actual time=0.096..0.096 rows=1 loops=19) |
84. | 0.010 | 1.824 | ↑ 1.0 | 1 | 19 |
→
Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=0.080..0.096 rows=1 loops=19) |
85. | 0.304 | 1.520 | ↓ 3.0 | 3 | 19 |
→
Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.039..0.080 rows=3 loops=19) |
86. | 0.190 | 0.190 | ↓ 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.007..0.010 rows=18 loops=19)
|
87. | 1.026 | 1.026 | ↓ 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.003..0.003 rows=0 loops=342)
|
88. | 0.294 | 0.294 | ↓ 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.006..0.006 rows=0 loops=49)
|
89. | 0.009 | 0.009 | ↑ 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.003..0.003 rows=1 loops=3)
|
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)
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
99. | 0.000 | 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.080 | ↓ 0.0 | 0 | 10 |
→
Nested Loop Anti Join (cost=8.72..44.38 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=10)
|
101. | 0.070 | 0.070 | ↓ 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.007..0.007 rows=0 loops=10)
|
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)
|
|
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)
|
|
104. | 0.000 | 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.020 | 0.070 | ↑ 1.0 | 1 | 10 |
→
Nested Loop (cost=0.54..12.59 rows=1 width=0) (actual time=0.006..0.007 rows=1 loops=10) |
106. | 0.030 | 0.030 | ↑ 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.003 rows=1 loops=10)
|
107. | 0.020 | 0.020 | ↑ 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.002..0.002 rows=1 loops=10)
|
108. | 0.020 | 0.050 | ↑ 1.0 | 1 | 10 |
→
Aggregate (cost=4.29..4.30 rows=1 width=8) (actual time=0.005..0.005 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)
|
Planning time | : | 11.169 ms |
---|---|---|
Execution time | : | 7.914 ms |