# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 826.108 | 138,854.621 | ↓ 1.0 | 49,997 | 1 |
→
Hash Left Join (cost=3,024.43..435,692,500.52 rows=49,893 width=1,489) (actual time=92.916..138,854.621 rows=49,997 loops=1)
|
2. | 111.854 | 936.723 | ↓ 1.0 | 49,997 | 1 |
→
Hash Left Join (cost=3,023.38..13,446.55 rows=49,893 width=1,465) (actual time=92.448..936.723 rows=49,997 loops=1)
|
3. | 98.643 | 823.943 | ↓ 1.0 | 49,997 | 1 |
→
Hash Left Join (cost=2,998.61..12,735.77 rows=49,893 width=1,411) (actual time=91.504..823.943 rows=49,997 loops=1)
|
4. | 102.510 | 725.263 | ↓ 1.0 | 49,997 | 1 |
→
Hash Left Join (cost=2,997.21..12,048.73 rows=49,893 width=1,379) (actual time=91.456..725.263 rows=49,997 loops=1)
|
5. | 80.121 | 622.407 | ↓ 1.0 | 49,997 | 1 |
→
Hash Left Join (cost=2,988.56..11,356.55 rows=49,893 width=1,343) (actual time=91.094..622.407 rows=49,997 loops=1)
|
6. | 95.529 | 542.265 | ↓ 1.0 | 49,997 | 1 |
→
Hash Left Join (cost=2,987.47..11,163.70 rows=49,893 width=827) (actual time=91.059..542.265 rows=49,997 loops=1)
|
7. | 287.879 | 446.678 | ↓ 1.0 | 49,997 | 1 |
→
Hash Join (cost=2,985.79..10,476.00 rows=49,893 width=311) (actual time=90.981..446.678 rows=49,997 loops=1)
|
8. | 68.339 | 68.339 | ↓ 1.0 | 49,999 | 1 |
→
Seq Scan on empresas_sucursales (cost=0.00..2,594.31 rows=49,896 width=237) (actual time=0.038..68.339 rows=49,999 loops=1)
|
9. | 44.208 | 90.460 | ↓ 1.0 | 49,859 | 1 |
→
Hash (cost=1,680.57..1,680.57 rows=49,858 width=82) (actual time=90.460..90.460 rows=49,859 loops=1)
|
10. | 46.252 | 46.252 | ↓ 1.0 | 49,859 | 1 |
→
Seq Scan on empresas emp (cost=0.00..1,680.57 rows=49,858 width=82) (actual time=0.019..46.252 rows=49,859 loops=1)
|
11. | 0.023 | 0.058 | ↑ 1.0 | 30 | 1 |
→
Hash (cost=1.30..1.30 rows=30 width=524) (actual time=0.058..0.058 rows=30 loops=1)
|
12. | 0.035 | 0.035 | ↑ 1.0 | 30 | 1 |
→
Seq Scan on empresas_types (cost=0.00..1.30 rows=30 width=524) (actual time=0.018..0.035 rows=30 loops=1) |
13. | 0.005 | 0.021 | ↑ 1.0 | 4 | 1 |
→
Hash (cost=1.04..1.04 rows=4 width=520) (actual time=0.021..0.021 rows=4 loops=1)
|
14. | 0.016 | 0.016 | ↑ 1.0 | 4 | 1 |
→
Seq Scan on empresas_categorias (cost=0.00..1.04 rows=4 width=520) (actual time=0.014..0.016 rows=4 loops=1) |
15. | 0.173 | 0.346 | ↑ 1.0 | 251 | 1 |
→
Hash (cost=5.51..5.51 rows=251 width=40) (actual time=0.346..0.346 rows=251 loops=1)
|
16. | 0.173 | 0.173 | ↑ 1.0 | 251 | 1 |
→
Seq Scan on city (cost=0.00..5.51 rows=251 width=40) (actual time=0.004..0.173 rows=251 loops=1) |
17. | 0.013 | 0.037 | ↑ 1.0 | 18 | 1 |
→
Hash (cost=1.18..1.18 rows=18 width=40) (actual time=0.037..0.037 rows=18 loops=1)
|
18. | 0.024 | 0.024 | ↑ 1.0 | 18 | 1 |
→
Seq Scan on distritos (cost=0.00..1.18 rows=18 width=40) (actual time=0.014..0.024 rows=18 loops=1) |
19. | 0.476 | 0.926 | ↑ 1.0 | 701 | 1 |
→
Hash (cost=16.01..16.01 rows=701 width=58) (actual time=0.926..0.926 rows=701 loops=1)
|
20. | 0.450 | 0.450 | ↑ 1.0 | 701 | 1 |
→
Seq Scan on actividad_econ (cost=0.00..16.01 rows=701 width=58) (actual time=0.004..0.450 rows=701 loops=1) |
21. | 0.002 | 0.016 | ↑ 1.0 | 1 | 1 |
→
Hash (cost=1.04..1.04 rows=1 width=40) (actual time=0.016..0.016 rows=1 loops=1)
|
22. | 0.014 | 0.014 | ↑ 1.0 | 1 | 1 |
→
Seq Scan on empresas_sucursales_types (cost=0.00..1.04 rows=1 width=40) (actual time=0.013..0.014 rows=1 loops=1)
|
23. |
SubPlan (forHash Left Join) |
|||||
24. | 499.970 | 43,847.369 | ↑ 1.0 | 1 | 49,997 |
→
Aggregate (cost=1,859.34..1,859.35 rows=1 width=8) (actual time=0.877..0.877 rows=1 loops=49,997) |
25. | 999.940 | 43,347.399 | ↑ 5.8 | 10 | 49,997 |
→
Nested Loop (cost=5.61..1,859.19 rows=58 width=8) (actual time=0.128..0.867 rows=10 loops=49,997) |
26. | 499.970 | 499.970 | ↑ 1.0 | 1 | 49,997 |
→
Index Only Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales es (cost=0.29..8.31 rows=1 width=4) (actual time=0.008..0.010 rows=1 loops=49,997)
|
27. | 8,925.540 | 41,847.489 | ↑ 5.8 | 10 | 49,997 |
→
Bitmap Heap Scan on empleados (cost=5.32..1,850.31 rows=58 width=24) (actual time=0.110..0.837 rows=10 loops=49,997)
|
28. | 899.946 | 899.946 | ↑ 5.3 | 22 | 49,997 |
→
Bitmap Index Scan on empleados_npatronal_id_idx (cost=0.00..5.30 rows=117 width=0) (actual time=0.018..0.018 rows=22 loops=49,997)
|
29. |
SubPlan (forBitmap Heap Scan) |
|||||
30. | 3,312.621 | 32,022.003 | ↑ 1.0 | 1 | 1,104,207 |
→
Limit (cost=12.06..12.06 rows=1 width=20) (actual time=0.029..0.029 rows=1 loops=1,104,207) |
31. | 4,416.828 | 28,709.382 | ↑ 2.0 | 1 | 1,104,207 |
→
Sort (cost=12.06..12.06 rows=2 width=20) (actual time=0.026..0.026 rows=1 loops=1,104,207)
|
32. | 5,525.489 | 24,292.554 | ↑ 1.0 | 2 | 1,104,207 |
→
Result (cost=0.00..12.05 rows=2 width=20) (actual time=0.015..0.022 rows=2 loops=1,104,207)
|
33. | 18,767.065 | 18,767.065 | ↑ 1.0 | 2 | 1,103,945 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos (cost=0.00..12.04 rows=2 width=20) (actual time=0.013..0.017 rows=2 loops=1,103,945)
|
34. | 799.952 | 26,148.431 | ↑ 1.0 | 1 | 49,997 |
→
Aggregate (cost=2,210.20..2,210.23 rows=1 width=16) (actual time=0.523..0.523 rows=1 loops=49,997) |
35. | 5,246.149 | 25,348.479 | ↑ 5.8 | 12 | 49,997 |
→
Bitmap Heap Scan on empleados emplea (cost=5.50..2,208.80 rows=70 width=16) (actual time=0.057..0.507 rows=12 loops=49,997)
|
36. | 1,099.934 | 1,099.934 | ↑ 5.2 | 27 | 49,997 |
→
Bitmap Index Scan on empleados_empresa_id_npatronal_idx (cost=0.00..5.48 rows=140 width=0) (actual time=0.022..0.022 rows=27 loops=49,997)
|
37. |
SubPlan (forBitmap Heap Scan) |
|||||
38. | 2,714.628 | 19,002.396 | ↑ 1.0 | 1 | 1,357,314 |
→
Limit (cost=12.06..12.06 rows=1 width=20) (actual time=0.014..0.014 rows=1 loops=1,357,314) |
39. | 6,786.570 | 16,287.768 | ↑ 2.0 | 1 | 1,357,314 |
→
Sort (cost=12.06..12.06 rows=2 width=20) (actual time=0.012..0.012 rows=1 loops=1,357,314)
|
40. | 9,501.198 | 9,501.198 | ↑ 1.0 | 2 | 1,357,314 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos empleados_movimientos_1 (cost=0.00..12.05 rows=2 width=20) (actual time=0.005..0.007 rows=2 loops=1,357,314)
|
41. | 399.976 | 37,847.729 | ↑ 1.0 | 1 | 49,997 |
→
Aggregate (cost=2,324.97..2,324.98 rows=1 width=8) (actual time=0.756..0.757 rows=1 loops=49,997) |
42. | 649.961 | 37,447.753 | ↑ 6.3 | 6 | 49,997 |
→
Nested Loop (cost=5.61..2,324.88 rows=38 width=8) (actual time=0.101..0.749 rows=6 loops=49,997) |
43. | 199.988 | 199.988 | ↑ 1.0 | 1 | 49,997 |
→
Index Only Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales es_1 (cost=0.29..8.31 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=49,997)
|
44. | 1,901.145 | 36,597.804 | ↑ 6.3 | 6 | 49,997 |
→
Nested Loop (cost=5.32..2,316.19 rows=38 width=16) (actual time=0.092..0.732 rows=6 loops=49,997) |
45. | 3,277.158 | 22,348.659 | ↑ 5.8 | 10 | 49,997 |
→
Bitmap Heap Scan on empleados empleados_1 (cost=5.32..1,850.31 rows=58 width=24) (actual time=0.045..0.447 rows=10 loops=49,997)
|
46. | 299.982 | 299.982 | ↑ 5.3 | 22 | 49,997 |
→
Bitmap Index Scan on empleados_npatronal_id_idx (cost=0.00..5.30 rows=117 width=0) (actual time=0.006..0.006 rows=22 loops=49,997)
|
47. |
SubPlan (forBitmap Heap Scan) |
|||||
48. | 3,312.621 | 18,771.519 | ↑ 1.0 | 1 | 1,104,207 |
→
Limit (cost=12.06..12.06 rows=1 width=20) (actual time=0.016..0.017 rows=1 loops=1,104,207) |
49. | 4,416.828 | 15,458.898 | ↑ 2.0 | 1 | 1,104,207 |
→
Sort (cost=12.06..12.06 rows=2 width=20) (actual time=0.014..0.014 rows=1 loops=1,104,207)
|
50. | 5,522.345 | 11,042.070 | ↑ 1.0 | 2 | 1,104,207 |
→
Result (cost=0.00..12.05 rows=2 width=20) (actual time=0.006..0.010 rows=2 loops=1,104,207)
|
51. | 5,519.725 | 5,519.725 | ↑ 1.0 | 2 | 1,103,945 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos empleados_movimientos_2 (cost=0.00..12.04 rows=2 width=20) (actual time=0.003..0.005 rows=2 loops=1,103,945)
|
52. | 12,348.000 | 12,348.000 | ↑ 1.0 | 1 | 493,920 |
→
Index Scan using persons_id_idx on persons (cost=0.00..8.02 rows=1 width=8) (actual time=0.024..0.025 rows=1 loops=493,920)
|
53. | 299.982 | 25,948.443 | ↑ 1.0 | 1 | 49,997 |
→
Aggregate (cost=2,324.75..2,324.76 rows=1 width=8) (actual time=0.518..0.519 rows=1 loops=49,997) |
54. | 399.976 | 25,648.461 | ↑ 6.7 | 3 | 49,997 |
→
Nested Loop (cost=5.61..2,324.70 rows=20 width=8) (actual time=0.115..0.513 rows=3 loops=49,997) |
55. | 199.988 | 199.988 | ↑ 1.0 | 1 | 49,997 |
→
Index Only Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales es_2 (cost=0.29..8.31 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=49,997)
|
56. | 1,724.098 | 25,048.497 | ↑ 6.7 | 3 | 49,997 |
→
Nested Loop (cost=5.32..2,316.19 rows=20 width=16) (actual time=0.107..0.501 rows=3 loops=49,997) |
57. | 3,431.422 | 21,348.719 | ↑ 5.8 | 10 | 49,997 |
→
Bitmap Heap Scan on empleados empleados_2 (cost=5.32..1,850.31 rows=58 width=24) (actual time=0.044..0.427 rows=10 loops=49,997)
|
58. | 249.985 | 249.985 | ↑ 5.3 | 22 | 49,997 |
→
Bitmap Index Scan on empleados_npatronal_id_idx (cost=0.00..5.30 rows=117 width=0) (actual time=0.005..0.005 rows=22 loops=49,997)
|
59. |
SubPlan (forBitmap Heap Scan) |
|||||
60. | 3,312.621 | 17,667.312 | ↑ 1.0 | 1 | 1,104,207 |
→
Limit (cost=12.06..12.06 rows=1 width=20) (actual time=0.016..0.016 rows=1 loops=1,104,207) |
61. | 4,416.828 | 14,354.691 | ↑ 2.0 | 1 | 1,104,207 |
→
Sort (cost=12.06..12.06 rows=2 width=20) (actual time=0.013..0.013 rows=1 loops=1,104,207)
|
62. | 4,418.138 | 9,937.863 | ↑ 1.0 | 2 | 1,104,207 |
→
Result (cost=0.00..12.05 rows=2 width=20) (actual time=0.006..0.009 rows=2 loops=1,104,207)
|
63. | 5,519.725 | 5,519.725 | ↑ 1.0 | 2 | 1,103,945 |
→
Index Scan using empleados_movimientos_empleado_id_idx on empleados_movimientos empleados_movimientos_3 (cost=0.00..12.04 rows=2 width=20) (actual time=0.003..0.005 rows=2 loops=1,103,945)
|
64. | 1,975.680 | 1,975.680 | ↓ 0.0 | 0 | 493,920 |
→
Index Scan using persons_id_idx on persons persons_1 (cost=0.00..8.02 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=493,920)
|
65. | 199.988 | 3,299.802 | ↑ 1.0 | 1 | 49,997 |
→
Limit (cost=12.92..12.93 rows=1 width=134) (actual time=0.065..0.066 rows=1 loops=49,997) |
66. | 549.967 | 3,099.814 | ↑ 2.0 | 1 | 49,997 |
→
Sort (cost=12.92..12.93 rows=2 width=134) (actual time=0.062..0.062 rows=1 loops=49,997)
|
67. | 547.625 | 2,549.847 | ↑ 2.0 | 1 | 49,997 |
→
Hash Join (cost=11.79..12.91 rows=2 width=134) (actual time=0.048..0.051 rows=1 loops=49,997)
|
68. | 202.330 | 202.330 | ↑ 1.0 | 7 | 40,466 |
→
Seq Scan on situacion_emp (cost=0.00..1.07 rows=7 width=122) (actual time=0.002..0.005 rows=7 loops=40,466) |
69. | 349.979 | 1,799.892 | ↑ 2.0 | 1 | 49,997 |
→
Hash (cost=11.76..11.76 rows=2 width=20) (actual time=0.036..0.036 rows=1 loops=49,997)
|
70. | 899.946 | 1,449.913 | ↑ 2.0 | 1 | 49,997 |
→
Bitmap Heap Scan on cambio_situacion_empresa (cost=4.02..11.76 rows=2 width=20) (actual time=0.025..0.029 rows=1 loops=49,997)
|
71. | 549.967 | 549.967 | ↑ 2.0 | 1 | 49,997 |
→
Bitmap Index Scan on cambio_situacion_empresa_nro_patronal_idx (cost=0.00..4.01 rows=2 width=0) (actual time=0.011..0.011 rows=1 loops=49,997)
|