# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.002 | 10,603.239 | ↓ 1.4 | 7 | 1 |
→
Limit (cost=2,067.60..2,615.01 rows=5 width=660) (actual time=10,602.958..10,603.239 rows=7 loops=1) |
2. | 0.066 | 10,603.237 | ↓ 1.4 | 7 | 1 |
→
WindowAgg (cost=2,067.60..2,615.01 rows=5 width=660) (actual time=10,602.958..10,603.237 rows=7 loops=1) |
3. | 0.020 | 10,602.847 | ↓ 1.4 | 7 | 1 |
→
Sort (cost=2,067.60..2,067.61 rows=5 width=502) (actual time=10,602.846..10,602.847 rows=7 loops=1)
|
4. | 0.004 | 10,602.827 | ↓ 1.4 | 7 | 1 |
→
Nested Loop (cost=1,951.95..2,067.54 rows=5 width=502) (actual time=10,602.709..10,602.827 rows=7 loops=1) |
5. | 0.002 | 0.136 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=2.10..47.34 rows=1 width=245) (actual time=0.126..0.136 rows=1 loops=1)
|
6. | 0.007 | 0.126 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=2.10..46.29 rows=1 width=230) (actual time=0.117..0.126 rows=1 loops=1)
|
7. | 0.006 | 0.103 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=1.69..37.84 rows=1 width=211) (actual time=0.096..0.103 rows=1 loops=1)
|
8. | 0.003 | 0.081 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=1.27..33.39 rows=1 width=204) (actual time=0.076..0.081 rows=1 loops=1)
|
9. | 0.010 | 0.066 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=0.98..25.07 rows=1 width=187) (actual time=0.061..0.066 rows=1 loops=1) |
10. | 0.006 | 0.046 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=0.70..16.75 rows=1 width=170) (actual time=0.044..0.046 rows=1 loops=1) |
11. | 0.028 | 0.028 | ↑ 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.027..0.028 rows=1 loops=1)
|
12. | 0.012 | 0.012 | ↑ 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.011..0.012 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.010..0.010 rows=1 loops=1)
|
14. | 0.012 | 0.012 | ↑ 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.011..0.012 rows=1 loops=1)
|
15. | 0.016 | 0.016 | ↑ 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.015..0.016 rows=1 loops=1)
|
16. | 0.016 | 0.016 | ↑ 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.016 rows=1 loops=1)
|
17. | 0.008 | 0.008 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on f1asr_reg_asset_bom abom (cost=0.00..1.03 rows=1 width=29) (actual time=0.008..0.008 rows=0 loops=1)
|
18. | 0.012 | 10,602.687 | ↓ 1.4 | 7 | 1 |
→
Merge Left Join (cost=1,949.85..2,020.16 rows=5 width=257) (actual time=10,602.580..10,602.687 rows=7 loops=1)
|
19. | 0.028 | 6,578.313 | ↓ 1.4 | 7 | 1 |
→
Merge Left Join (cost=1,238.79..1,301.00 rows=5 width=233) (actual time=6,578.215..6,578.313 rows=7 loops=1)
|
20. | 0.005 | 0.146 | ↓ 1.4 | 7 | 1 |
→
Nested Loop Left Join (cost=3.99..58.11 rows=5 width=217) (actual time=0.087..0.146 rows=7 loops=1)
|
21. | 0.013 | 0.127 | ↓ 1.4 | 7 | 1 |
→
Nested Loop Left Join (cost=3.70..43.45 rows=5 width=200) (actual time=0.075..0.127 rows=7 loops=1)
|
22. | 0.010 | 0.100 | ↓ 1.4 | 7 | 1 |
→
Nested Loop Left Join (cost=3.42..28.79 rows=5 width=183) (actual time=0.064..0.100 rows=7 loops=1)
|
23. | 0.015 | 0.076 | ↓ 1.4 | 7 | 1 |
→
Merge Join (cost=3.13..20.41 rows=5 width=166) (actual time=0.049..0.076 rows=7 loops=1)
|
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.014..0.023 rows=7 loops=1)
|
25. | 0.027 | 0.038 | ↑ 1.4 | 16 | 1 |
→
Sort (cost=2.85..2.91 rows=22 width=35) (actual time=0.032..0.038 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.003 | 0.014 | ↑ 1.0 | 1 | 7 |
→
Materialize (cost=0.29..8.31 rows=1 width=21) (actual time=0.002..0.002 rows=1 loops=7) |
28. | 0.011 | 0.011 | ↑ 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.011 rows=1 loops=1)
|
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)
|
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.007..0.010 rows=2 loops=1)
|
33. | 0.005 | 6,578.139 | ↓ 4.0 | 4 | 1 |
→
Materialize (cost=1,234.80..1,242.87 rows=1 width=37) (actual time=6,578.111..6,578.139 rows=4 loops=1) |
34. | 0.007 | 6,578.134 | ↓ 4.0 | 4 | 1 |
→
Nested Loop Left Join (cost=1,234.80..1,242.86 rows=1 width=37) (actual time=6,578.109..6,578.134 rows=4 loops=1) |
35. | 0.009 | 6,578.099 | ↓ 4.0 | 4 | 1 |
→
GroupAggregate (cost=1,234.52..1,234.55 rows=1 width=29) (actual time=6,578.086..6,578.099 rows=4 loops=1)
|
36. | 0.019 | 6,578.090 | ↓ 4.0 | 4 | 1 |
→
Sort (cost=1,234.52..1,234.53 rows=1 width=29) (actual time=6,578.081..6,578.090 rows=4 loops=1)
|
37. | 2.454 | 6,578.071 | ↓ 4.0 | 4 | 1 |
→
Nested Loop (cost=82.11..1,234.51 rows=1 width=29) (actual time=7.284..6,578.071 rows=4 loops=1)
|
38. | 2.834 | 5.345 | ↓ 21.5 | 452 | 1 |
→
Hash Join (cost=81.84..132.31 rows=21 width=39) (actual time=1.698..5.345 rows=452 loops=1)
|
39. | 0.905 | 0.905 | ↓ 1.0 | 756 | 1 |
→
Seq Scan on f1wrk_task_ctl_ass ta (cost=0.00..47.51 rows=735 width=38) (actual time=0.013..0.905 rows=756 loops=1)
|
40. | 0.187 | 1.606 | ↓ 41.4 | 455 | 1 |
→
Hash (cost=81.70..81.70 rows=11 width=45) (actual time=1.605..1.606 rows=455 loops=1)
|
41. | 0.792 | 1.419 | ↓ 41.4 | 455 | 1 |
→
Nested Loop (cost=2.91..81.70 rows=11 width=45) (actual time=0.060..1.419 rows=455 loops=1)
|
42. | 0.186 | 0.186 | ↓ 1.0 | 441 | 1 |
→
Seq Scan on f1asr_reg_asset_mh mh (cost=0.00..37.74 rows=421 width=35) (actual time=0.020..0.186 rows=441 loops=1)
|
43. | 0.406 | 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) |
44. | 0.012 | 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)
|
45. | 0.008 | 0.008 | ↓ 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.007..0.008 rows=7 loops=1)
|
46. | 0.007 | 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)
|
47. | 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.003..0.008 rows=18 loops=1)
|
48. | 3.616 | 3.616 | ↑ 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.008 rows=1 loops=452)
|
49. |
SubPlan (for Nested Loop) |
|||||
50. | 0.000 | 6,566.656 | ↑ 1.0 | 1 | 452 |
→
Aggregate (cost=49.86..49.87 rows=1 width=8) (actual time=14.528..14.528 rows=1 loops=452) |
51. |
Initplan (for Aggregate) |
|||||
52. | 2.260 | 3,228.184 | ↑ 1.0 | 1 | 452 |
→
Aggregate (cost=24.92..24.94 rows=1 width=8) (actual time=7.142..7.142 rows=1 loops=452) |
53. | 140.004 | 3,225.924 | ↓ 0.0 | 0 | 452 |
→
Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=7.115..7.137 rows=0 loops=452) |
54. | 226.000 | 1,751.952 | ↓ 369.0 | 369 | 452 |
→
Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.228..3.876 rows=369 loops=452) |
55. | 159.104 | 159.104 | ↓ 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.027..0.352 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,333.968 | 1,333.968 | ↓ 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.008..0.008 rows=0 loops=166,746)
|
58. | 119.600 | 6,547.220 | ↓ 367.0 | 367 | 452 |
→
Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=7.390..14.485 rows=367 loops=452) |
59. | 249.504 | 1,758.732 | ↓ 369.0 | 369 | 452 |
→
Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.234..3.891 rows=369 loops=452) |
60. | 142.380 | 142.380 | ↓ 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.315 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. | 4,668.888 | 4,668.888 | ↑ 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.028..0.028 rows=1 loops=166,746)
|
63. | 0.028 | 0.028 | ↑ 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.007..0.007 rows=1 loops=4)
|
64. | 0.003 | 4,024.362 | ↑ 1.0 | 1 | 1 |
→
Materialize (cost=711.06..719.13 rows=1 width=45) (actual time=4,024.361..4,024.362 rows=1 loops=1) |
65. | 0.003 | 4,024.359 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=711.06..719.12 rows=1 width=45) (actual time=4,024.359..4,024.359 rows=1 loops=1) |
66. | 0.003 | 4,024.351 | ↑ 1.0 | 1 | 1 |
→
GroupAggregate (cost=710.78..710.81 rows=1 width=29) (actual time=4,024.351..4,024.351 rows=1 loops=1)
|
67. | 0.013 | 4,024.348 | ↑ 1.0 | 1 | 1 |
→
Sort (cost=710.78..710.79 rows=1 width=29) (actual time=4,024.347..4,024.348 rows=1 loops=1)
|
68. | 1.670 | 4,024.335 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=82.11..710.77 rows=1 width=29) (actual time=366.350..4,024.335 rows=1 loops=1)
|
69. | 1.101 | 5.289 | ↓ 21.5 | 452 | 1 |
→
Hash Join (cost=81.84..132.31 rows=21 width=39) (actual time=3.419..5.289 rows=452 loops=1)
|
70. | 0.972 | 0.972 | ↓ 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.022..0.972 rows=756 loops=1)
|
71. | 0.340 | 3.216 | ↓ 41.4 | 455 | 1 |
→
Hash (cost=81.70..81.70 rows=11 width=45) (actual time=3.216..3.216 rows=455 loops=1)
|
72. | 2.044 | 2.876 | ↓ 41.4 | 455 | 1 |
→
Nested Loop (cost=2.91..81.70 rows=11 width=45) (actual time=0.130..2.876 rows=455 loops=1)
|
73. | 0.391 | 0.391 | ↓ 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.043..0.391 rows=441 loops=1)
|
74. | 0.364 | 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.020 | 0.077 | ↓ 1.4 | 7 | 1 |
→
Hash Join (cost=2.91..7.11 rows=5 width=32) (actual time=0.071..0.077 rows=7 loops=1)
|
76. | 0.024 | 0.024 | ↓ 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.022..0.024 rows=7 loops=1)
|
77. | 0.009 | 0.033 | ↑ 1.2 | 18 | 1 |
→
Hash (cost=2.36..2.36 rows=22 width=17) (actual time=0.033..0.033 rows=18 loops=1)
|
78. | 0.024 | 0.024 | ↑ 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.007..0.024 rows=18 loops=1)
|
79. | 4.520 | 4.520 | ↑ 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.009..0.010 rows=1 loops=452)
|
80. |
SubPlan (for Nested Loop) |
|||||
81. | 0.904 | 4,012.856 | ↑ 1.0 | 1 | 452 |
→
Aggregate (cost=24.92..24.93 rows=1 width=8) (actual time=8.877..8.878 rows=1 loops=452) |
82. | 29.390 | 4,011.952 | ↓ 0.0 | 0 | 452 |
→
Nested Loop (cost=0.83..24.92 rows=1 width=8) (actual time=8.846..8.876 rows=0 loops=452) |
83. | 258.544 | 2,148.356 | ↓ 369.0 | 369 | 452 |
→
Nested Loop (cost=0.55..16.61 rows=1 width=16) (actual time=0.316..4.753 rows=369 loops=452) |
84. | 181.252 | 181.252 | ↓ 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.036..0.401 rows=756 loops=452)
|
85. | 1,708.560 | 1,708.560 | ↓ 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.005..0.005 rows=0 loops=341,712)
|
86. | 1,834.206 | 1,834.206 | ↓ 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.011..0.011 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.056 | 0.056 | ↑ 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.008 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.006 | 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.020 | 0.020 | ↓ 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.020..0.020 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.006 | 0.078 | ↑ 1.0 | 1 | 6 |
→
Aggregate (cost=44.38..44.39 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=6) |
98. | 0.006 | 0.072 | ↓ 0.0 | 0 | 6 |
→
Nested Loop Anti Join (cost=8.72..44.38 rows=1 width=0) (actual time=0.012..0.012 rows=0 loops=6)
|
99. | 0.066 | 0.066 | ↓ 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.011..0.011 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.014 | 0.105 | ↑ 1.0 | 1 | 7 |
→
Aggregate (cost=12.59..12.60 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=7) |
103. | 0.021 | 0.091 | ↓ 7.0 | 7 | 7 |
→
Nested Loop (cost=0.54..12.59 rows=1 width=0) (actual time=0.010..0.013 rows=7 loops=7) |
104. | 0.042 | 0.042 | ↑ 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.006..0.006 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.003..0.004 rows=7 loops=7)
|
106. | 0.021 | 0.056 | ↑ 1.0 | 1 | 7 |
→
Aggregate (cost=4.29..4.30 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=7) |
107. | 0.035 | 0.035 | ↑ 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.005..0.005 rows=1 loops=7)
|
Planning time | : | 10.882 ms |
---|---|---|
Execution time | : | 10,604.824 ms |