# | 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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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.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)
|
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.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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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.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.008..0.010 rows=2 loops=1)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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.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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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.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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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,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)
|
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)
|
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)
|
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)
|
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)
|
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.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)
|
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)
|
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.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)
|
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)
|
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)
|
Planning time | : | 10.266 ms |
---|---|---|
Execution time | : | 9,158.983 ms |