# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=311,594,675.76..311,594,802.26 rows=50,601 width=964) (actual rows= loops=)
|
||
2. | 0.000 | 0.000 | ↓ 0.0 |
→
Append (cost=0.43..311,572,338.08 rows=50,601 width=964) (actual rows= loops=) |
||
3. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=0.43..308,173,989.66 rows=50,050 width=964) (actual rows= loops=)
|
||
4. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=0.43..29,410.98 rows=50,050 width=940) (actual rows= loops=) |
||
5. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=0.43..27,989.61 rows=50,050 width=886) (actual rows= loops=) |
||
6. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=0.43..26,598.23 rows=50,050 width=876) (actual rows= loops=) |
||
7. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=0.43..25,188.86 rows=50,050 width=840) (actual rows= loops=) |
||
8. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=0.29..16,519.07 rows=50,050 width=324) (actual rows= loops=) |
||
9. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=0.29..15,127.63 rows=50,050 width=311) (actual rows= loops=) |
||
10. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan Backward using empresas_sucursales_nro_patronal_key on empresas_sucursales (cost=0.29..7,037.64 rows=50,053 width=237) (actual rows= loops=)
|
||
11. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empresas_id_idx on empresas emp (cost=0.00..0.15 rows=1 width=82) (actual rows= loops=)
|
||
12. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empresas_types_id_idx on empresas_types (cost=0.00..0.02 rows=1 width=21) (actual rows= loops=)
|
||
13. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empresas_categorias_pkey on empresas_categorias (cost=0.14..0.16 rows=1 width=520) (actual rows= loops=)
|
||
14. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using city_id_idx on city (cost=0.00..0.02 rows=1 width=40) (actual rows= loops=)
|
||
15. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using distritos_id_idx on distritos (cost=0.00..0.02 rows=1 width=18) (actual rows= loops=)
|
||
16. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using actividad_econ_id_activ_econ_idx on actividad_econ (cost=0.00..0.02 rows=1 width=58) (actual rows= loops=)
|
||
17. | 0.000 | 0.000 | ↓ 0.0 |
→
Materialize (cost=0.00..1.04 rows=1 width=40) (actual rows= loops=) |
||
18. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on empresas_sucursales_types (cost=0.00..1.04 rows=1 width=40) (actual rows= loops=)
|
||
19. |
SubPlan (forNested Loop Left Join) |
|||||
20. | 0.000 | 0.000 | ↓ 0.0 |
→
Aggregate (cost=1,393.61..1,393.62 rows=1 width=8) (actual rows= loops=) |
||
21. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=4.17..1,393.46 rows=58 width=8) (actual rows= loops=) |
||
22. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales es_3 (cost=0.29..3.31 rows=1 width=4) (actual rows= loops=)
|
||
23. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on empleados empleados_3 (cost=3.88..1,389.58 rows=58 width=24) (actual rows= loops=)
|
||
24. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on empleados_npatronal_idx (cost=0.00..3.87 rows=116 width=0) (actual rows= loops=)
|
||
25. |
SubPlan (forBitmap Heap Scan) |
|||||
26. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=9.06..9.06 rows=1 width=20) (actual rows= loops=) |
||
27. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=9.06..9.06 rows=2 width=20) (actual rows= loops=)
|
||
28. | 0.000 | 0.000 | ↓ 0.0 |
→
Result (cost=0.00..9.05 rows=2 width=20) (actual rows= loops=)
|
||
29. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos empleados_movimientos_4 (cost=0.00..9.04 rows=2 width=20) (actual rows= loops=)
|
||
30. | 0.000 | 0.000 | ↓ 0.0 |
→
Aggregate (cost=1,269.60..1,269.63 rows=1 width=16) (actual rows= loops=) |
||
31. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using empleados_empresa_id_id_idx on empleados emplea_1 (cost=0.43..1,268.20 rows=70 width=16) (actual rows= loops=)
|
||
32. |
SubPlan (forIndex Only Scan) |
|||||
33. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=9.05..9.06 rows=1 width=20) (actual rows= loops=) |
||
34. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=9.05..9.06 rows=2 width=20) (actual rows= loops=)
|
||
35. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos empleados_movimientos_5 (cost=0.00..9.04 rows=2 width=20) (actual rows= loops=)
|
||
36. | 0.000 | 0.000 | ↓ 0.0 |
→
Aggregate (cost=1,743.24..1,743.25 rows=1 width=8) (actual rows= loops=) |
||
37. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=4.17..1,743.15 rows=38 width=8) (actual rows= loops=) |
||
38. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales es_4 (cost=0.29..3.31 rows=1 width=4) (actual rows= loops=)
|
||
39. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=3.88..1,739.46 rows=38 width=16) (actual rows= loops=) |
||
40. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on empleados empleados_4 (cost=3.88..1,389.58 rows=58 width=24) (actual rows= loops=)
|
||
41. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on empleados_npatronal_idx (cost=0.00..3.87 rows=116 width=0) (actual rows= loops=)
|
||
42. |
SubPlan (forBitmap Heap Scan) |
|||||
43. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=9.06..9.06 rows=1 width=20) (actual rows= loops=) |
||
44. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=9.06..9.06 rows=2 width=20) (actual rows= loops=)
|
||
45. | 0.000 | 0.000 | ↓ 0.0 |
→
Result (cost=0.00..9.05 rows=2 width=20) (actual rows= loops=)
|
||
46. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos empleados_movimientos_6 (cost=0.00..9.04 rows=2 width=20) (actual rows= loops=)
|
||
47. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using persons_id_idx on persons persons_2 (cost=0.00..6.02 rows=1 width=8) (actual rows= loops=)
|
||
48. | 0.000 | 0.000 | ↓ 0.0 |
→
Aggregate (cost=1,743.02..1,743.03 rows=1 width=8) (actual rows= loops=) |
||
49. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=4.17..1,742.97 rows=20 width=8) (actual rows= loops=) |
||
50. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales es_5 (cost=0.29..3.31 rows=1 width=4) (actual rows= loops=)
|
||
51. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=3.88..1,739.46 rows=20 width=16) (actual rows= loops=) |
||
52. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on empleados empleados_5 (cost=3.88..1,389.58 rows=58 width=24) (actual rows= loops=)
|
||
53. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on empleados_npatronal_idx (cost=0.00..3.87 rows=116 width=0) (actual rows= loops=)
|
||
54. |
SubPlan (forBitmap Heap Scan) |
|||||
55. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=9.06..9.06 rows=1 width=20) (actual rows= loops=) |
||
56. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=9.06..9.06 rows=2 width=20) (actual rows= loops=)
|
||
57. | 0.000 | 0.000 | ↓ 0.0 |
→
Result (cost=0.00..9.05 rows=2 width=20) (actual rows= loops=)
|
||
58. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos empleados_movimientos_7 (cost=0.00..9.04 rows=2 width=20) (actual rows= loops=)
|
||
59. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using persons_id_idx on persons persons_3 (cost=0.00..6.02 rows=1 width=8) (actual rows= loops=)
|
||
60. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=7.19..7.19 rows=1 width=134) (actual rows= loops=) |
||
61. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=7.19..7.19 rows=1 width=134) (actual rows= loops=)
|
||
62. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=0.00..7.18 rows=1 width=134) (actual rows= loops=)
|
||
63. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using cambio_situacion_empresa_nro_patronal_idx on cambio_situacion_empresa cambio_situacion_empresa_1 (cost=0.00..6.02 rows=1 width=20) (actual rows= loops=)
|
||
64. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on situacion_emp situacion_emp_1 (cost=0.00..1.07 rows=7 width=122) (actual rows= loops=) |
||
65. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=3,397,841.03..3,397,842.41 rows=551 width=966) (actual rows= loops=)
|
||
66. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=13.15..3,397,815.95 rows=551 width=966) (actual rows= loops=)
|
||
67. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=13.15..5,437.49 rows=551 width=942) (actual rows= loops=) |
||
68. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=13.15..5,377.34 rows=551 width=888) (actual rows= loops=) |
||
69. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=13.15..5,347.19 rows=551 width=878) (actual rows= loops=) |
||
70. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Left Join (cost=13.15..5,299.04 rows=551 width=842) (actual rows= loops=)
|
||
71. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=0.00..5,283.77 rows=551 width=326) (actual rows= loops=) |
||
72. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=0.00..5,268.45 rows=551 width=313) (actual rows= loops=) |
||
73. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on empresas_sucursales empresas_sucursales_1 (cost=0.00..2,751.79 rows=551 width=301) (actual rows= loops=)
|
||
74. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empresas_id_idx on empresas emp_1 (cost=0.00..4.56 rows=1 width=20) (actual rows= loops=)
|
||
75. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empresas_types_id_idx on empresas_types empresas_types_1 (cost=0.00..0.02 rows=1 width=21) (actual rows= loops=)
|
||
76. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=11.40..11.40 rows=140 width=520) (actual rows= loops=) |
||
77. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on empresas_categorias empresas_categorias_1 (cost=0.00..11.40 rows=140 width=520) (actual rows= loops=) |
||
78. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using city_id_idx on city city_1 (cost=0.00..0.08 rows=1 width=40) (actual rows= loops=)
|
||
79. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using distritos_id_idx on distritos distritos_1 (cost=0.00..0.04 rows=1 width=18) (actual rows= loops=)
|
||
80. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using actividad_econ_id_activ_econ_idx on actividad_econ actividad_econ_1 (cost=0.00..0.10 rows=1 width=58) (actual rows= loops=)
|
||
81. | 0.000 | 0.000 | ↓ 0.0 |
→
Materialize (cost=0.00..1.04 rows=3 width=40) (actual rows= loops=) |
||
82. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on empresas_sucursales_types empresas_sucursales_types_1 (cost=0.00..1.03 rows=3 width=40) (actual rows= loops=) |
||
83. |
SubPlan (forNested Loop Left Join) |
|||||
84. | 0.000 | 0.000 | ↓ 0.0 |
→
Aggregate (cost=1,393.61..1,393.62 rows=1 width=8) (actual rows= loops=) |
||
85. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=4.17..1,393.46 rows=58 width=8) (actual rows= loops=) |
||
86. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales es (cost=0.29..3.31 rows=1 width=4) (actual rows= loops=)
|
||
87. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on empleados (cost=3.88..1,389.58 rows=58 width=24) (actual rows= loops=)
|
||
88. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on empleados_npatronal_idx (cost=0.00..3.87 rows=116 width=0) (actual rows= loops=)
|
||
89. |
SubPlan (forBitmap Heap Scan) |
|||||
90. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=9.06..9.06 rows=1 width=20) (actual rows= loops=) |
||
91. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=9.06..9.06 rows=2 width=20) (actual rows= loops=)
|
||
92. | 0.000 | 0.000 | ↓ 0.0 |
→
Result (cost=0.00..9.05 rows=2 width=20) (actual rows= loops=)
|
||
93. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos (cost=0.00..9.04 rows=2 width=20) (actual rows= loops=)
|
||
94. | 0.000 | 0.000 | ↓ 0.0 |
→
Aggregate (cost=1,269.60..1,269.63 rows=1 width=16) (actual rows= loops=) |
||
95. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using empleados_empresa_id_id_idx on empleados emplea (cost=0.43..1,268.20 rows=70 width=16) (actual rows= loops=)
|
||
96. |
SubPlan (forIndex Only Scan) |
|||||
97. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=9.05..9.06 rows=1 width=20) (actual rows= loops=) |
||
98. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=9.05..9.06 rows=2 width=20) (actual rows= loops=)
|
||
99. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos empleados_movimientos_1 (cost=0.00..9.04 rows=2 width=20) (actual rows= loops=)
|
||
100. | 0.000 | 0.000 | ↓ 0.0 |
→
Aggregate (cost=1,743.24..1,743.25 rows=1 width=8) (actual rows= loops=) |
||
101. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=4.17..1,743.15 rows=38 width=8) (actual rows= loops=) |
||
102. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales es_1 (cost=0.29..3.31 rows=1 width=4) (actual rows= loops=)
|
||
103. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=3.88..1,739.46 rows=38 width=16) (actual rows= loops=) |
||
104. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on empleados empleados_1 (cost=3.88..1,389.58 rows=58 width=24) (actual rows= loops=)
|
||
105. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on empleados_npatronal_idx (cost=0.00..3.87 rows=116 width=0) (actual rows= loops=)
|
||
106. |
SubPlan (forBitmap Heap Scan) |
|||||
107. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=9.06..9.06 rows=1 width=20) (actual rows= loops=) |
||
108. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=9.06..9.06 rows=2 width=20) (actual rows= loops=)
|
||
109. | 0.000 | 0.000 | ↓ 0.0 |
→
Result (cost=0.00..9.05 rows=2 width=20) (actual rows= loops=)
|
||
110. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos empleados_movimientos_2 (cost=0.00..9.04 rows=2 width=20) (actual rows= loops=)
|
||
111. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using persons_id_idx on persons (cost=0.00..6.02 rows=1 width=8) (actual rows= loops=)
|
||
112. | 0.000 | 0.000 | ↓ 0.0 |
→
Aggregate (cost=1,743.02..1,743.03 rows=1 width=8) (actual rows= loops=) |
||
113. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=4.17..1,742.97 rows=20 width=8) (actual rows= loops=) |
||
114. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales es_2 (cost=0.29..3.31 rows=1 width=4) (actual rows= loops=)
|
||
115. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=3.88..1,739.46 rows=20 width=16) (actual rows= loops=) |
||
116. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on empleados empleados_2 (cost=3.88..1,389.58 rows=58 width=24) (actual rows= loops=)
|
||
117. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on empleados_npatronal_idx (cost=0.00..3.87 rows=116 width=0) (actual rows= loops=)
|
||
118. |
SubPlan (forBitmap Heap Scan) |
|||||
119. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=9.06..9.06 rows=1 width=20) (actual rows= loops=) |
||
120. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=9.06..9.06 rows=2 width=20) (actual rows= loops=)
|
||
121. | 0.000 | 0.000 | ↓ 0.0 |
→
Result (cost=0.00..9.05 rows=2 width=20) (actual rows= loops=)
|
||
122. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos empleados_movimientos_3 (cost=0.00..9.04 rows=2 width=20) (actual rows= loops=)
|
||
123. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using persons_id_idx on persons persons_1 (cost=0.00..6.02 rows=1 width=8) (actual rows= loops=)
|
||
124. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=7.19..7.19 rows=1 width=134) (actual rows= loops=) |
||
125. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=7.19..7.19 rows=1 width=134) (actual rows= loops=)
|
||
126. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=0.00..7.18 rows=1 width=134) (actual rows= loops=)
|
||
127. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using cambio_situacion_empresa_nro_patronal_idx on cambio_situacion_empresa (cost=0.00..6.02 rows=1 width=20) (actual rows= loops=)
|
||
128. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on situacion_emp (cost=0.00..1.07 rows=7 width=122) (actual rows= loops=) |