#	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) Hash Cond: (empresas_sucursales.type = empresas_sucursales_types.id)
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) Hash Cond: (empresas_sucursales.id_activ_econ = actividad_econ.id_activ_econ)
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) Hash Cond: (empresas_sucursales.distrito_id = distritos.id)
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) Hash Cond: (empresas_sucursales.city_id = city.id)
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) Hash Cond: (emp.id_categoria_empresa = empresas_categorias.id_categoria_empresa)
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) Hash Cond: (emp.type = empresas_types.id)
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) Hash Cond: (empresas_sucursales.empresa_id = emp.id)
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) Filter: (type = 1) Rows Removed by Filter: 5625
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) Buckets: 1024 Batches: 8 Memory Usage: 713kB
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) Filter: (((document)::text <> '0'::text) AND ((document)::text <> ''::text) AND ((document)::text <> '-'::text)) Rows Removed by Filter: 2
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) Buckets: 1024 Batches: 1 Memory Usage: 2kB
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) Buckets: 1024 Batches: 1 Memory Usage: 1kB
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) Buckets: 1024 Batches: 1 Memory Usage: 19kB
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) Buckets: 1024 Batches: 1 Memory Usage: 1kB
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) Buckets: 1024 Batches: 1 Memory Usage: 64kB
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) Buckets: 1024 Batches: 1 Memory Usage: 1kB
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) Filter: (id = 1) Rows Removed by Filter: 2
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) Index Cond: (nro_patronal = empresas_sucursales.nro_patronal) Heap Fetches: 49997
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) Recheck Cond: (npatronal = empresas_sucursales.nro_patronal) Filter: (SubPlan 1) Rows Removed by Filter: 12
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) Index Cond: (npatronal = empresas_sucursales.nro_patronal)
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) Sort Key: empleados_movimientos.fecha, empleados_movimientos.id Sort Method: top-N heapsort Memory: 25kB
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) One-Time Filter: (empleados.empresa_id = emp.id)
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) Index Cond: (empleado_id = empleados.id) Rows Removed by Index Recheck: 0
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) Recheck Cond: (empresa_id = emp.id) Filter: (SubPlan 3) Rows Removed by Filter: 15
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) Index Cond: (empresa_id = emp.id)
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) Sort Key: empleados_movimientos_1.fecha, empleados_movimientos_1.id Sort Method: top-N heapsort Memory: 25kB
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) Index Cond: (empleado_id = emplea.id) Rows Removed by Index Recheck: 0
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) Index Cond: (nro_patronal = empresas_sucursales.nro_patronal) Heap Fetches: 49997
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) Recheck Cond: (npatronal = empresas_sucursales.nro_patronal) Filter: (SubPlan 5) Rows Removed by Filter: 12
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) Index Cond: (npatronal = empresas_sucursales.nro_patronal)
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) Sort Key: empleados_movimientos_2.fecha, empleados_movimientos_2.id Sort Method: top-N heapsort Memory: 25kB
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) One-Time Filter: (empleados_1.empresa_id = emp.id)
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) Index Cond: (empleado_id = empleados_1.id) Rows Removed by Index Recheck: 0
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) Index Cond: (id = empleados_1.persona_id) Rows Removed by Index Recheck: 0 Filter: ((sexo)::text = 'M'::text) Rows Removed by Filter: 0
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) Index Cond: (nro_patronal = empresas_sucursales.nro_patronal) Heap Fetches: 49997
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) Recheck Cond: (npatronal = empresas_sucursales.nro_patronal) Filter: (SubPlan 7) Rows Removed by Filter: 12
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) Index Cond: (npatronal = empresas_sucursales.nro_patronal)
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) Sort Key: empleados_movimientos_3.fecha, empleados_movimientos_3.id Sort Method: top-N heapsort Memory: 25kB
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) One-Time Filter: (empleados_2.empresa_id = emp.id)
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) Index Cond: (empleado_id = empleados_2.id) Rows Removed by Index Recheck: 0
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) Index Cond: (id = empleados_2.persona_id) Rows Removed by Index Recheck: 0 Filter: ((sexo)::text = 'F'::text) Rows Removed by Filter: 1
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) Sort Key: cambio_situacion_empresa.fecha_creacion, cambio_situacion_empresa.id_cambio_situacion_empresa Sort Method: quicksort Memory: 25kB
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) Hash Cond: (situacion_emp.id_situacion = cambio_situacion_empresa.situacion_act)
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) Buckets: 1024 Batches: 1 Memory Usage: 1kB
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) Recheck Cond: (nro_patronal = empresas_sucursales.nro_patronal)
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) Index Cond: (nro_patronal = empresas_sucursales.nro_patronal)

Hash Left Join  (cost=3024.43..435692500.52 rows=49893 width=1489) (actual time=92.916..138854.621 rows=49997 loops=1)
  Hash Cond: (empresas_sucursales.type = empresas_sucursales_types.id)
  ->  Hash Left Join  (cost=3023.38..13446.55 rows=49893 width=1465) (actual time=92.448..936.723 rows=49997 loops=1)
        Hash Cond: (empresas_sucursales.id_activ_econ = actividad_econ.id_activ_econ)
        ->  Hash Left Join  (cost=2998.61..12735.77 rows=49893 width=1411) (actual time=91.504..823.943 rows=49997 loops=1)
              Hash Cond: (empresas_sucursales.distrito_id = distritos.id)
              ->  Hash Left Join  (cost=2997.21..12048.73 rows=49893 width=1379) (actual time=91.456..725.263 rows=49997 loops=1)
                    Hash Cond: (empresas_sucursales.city_id = city.id)
                    ->  Hash Left Join  (cost=2988.56..11356.55 rows=49893 width=1343) (actual time=91.094..622.407 rows=49997 loops=1)
                          Hash Cond: (emp.id_categoria_empresa = empresas_categorias.id_categoria_empresa)
                          ->  Hash Left Join  (cost=2987.47..11163.70 rows=49893 width=827) (actual time=91.059..542.265 rows=49997 loops=1)
                                Hash Cond: (emp.type = empresas_types.id)
                                ->  Hash Join  (cost=2985.79..10476.00 rows=49893 width=311) (actual time=90.981..446.678 rows=49997 loops=1)
                                      Hash Cond: (empresas_sucursales.empresa_id = emp.id)
                                      ->  Seq Scan on empresas_sucursales  (cost=0.00..2594.31 rows=49896 width=237) (actual time=0.038..68.339 rows=49999 loops=1)
                                            Filter: (type = 1)
                                            Rows Removed by Filter: 5625
                                      ->  Hash  (cost=1680.57..1680.57 rows=49858 width=82) (actual time=90.460..90.460 rows=49859 loops=1)
                                            Buckets: 1024  Batches: 8  Memory Usage: 713kB
                                            ->  Seq Scan on empresas emp  (cost=0.00..1680.57 rows=49858 width=82) (actual time=0.019..46.252 rows=49859 loops=1)
                                                  Filter: (((document)::text <> '0'::text) AND ((document)::text <> ''::text) AND ((document)::text <> '-'::text))
                                                  Rows Removed by Filter: 2
                                ->  Hash  (cost=1.30..1.30 rows=30 width=524) (actual time=0.058..0.058 rows=30 loops=1)
                                      Buckets: 1024  Batches: 1  Memory Usage: 2kB
                                      ->  Seq Scan on empresas_types  (cost=0.00..1.30 rows=30 width=524) (actual time=0.018..0.035 rows=30 loops=1)
                          ->  Hash  (cost=1.04..1.04 rows=4 width=520) (actual time=0.021..0.021 rows=4 loops=1)
                                Buckets: 1024  Batches: 1  Memory Usage: 1kB
                                ->  Seq Scan on empresas_categorias  (cost=0.00..1.04 rows=4 width=520) (actual time=0.014..0.016 rows=4 loops=1)
                    ->  Hash  (cost=5.51..5.51 rows=251 width=40) (actual time=0.346..0.346 rows=251 loops=1)
                          Buckets: 1024  Batches: 1  Memory Usage: 19kB
                          ->  Seq Scan on city  (cost=0.00..5.51 rows=251 width=40) (actual time=0.004..0.173 rows=251 loops=1)
              ->  Hash  (cost=1.18..1.18 rows=18 width=40) (actual time=0.037..0.037 rows=18 loops=1)
                    Buckets: 1024  Batches: 1  Memory Usage: 1kB
                    ->  Seq Scan on distritos  (cost=0.00..1.18 rows=18 width=40) (actual time=0.014..0.024 rows=18 loops=1)
        ->  Hash  (cost=16.01..16.01 rows=701 width=58) (actual time=0.926..0.926 rows=701 loops=1)
              Buckets: 1024  Batches: 1  Memory Usage: 64kB
              ->  Seq Scan on actividad_econ  (cost=0.00..16.01 rows=701 width=58) (actual time=0.004..0.450 rows=701 loops=1)
  ->  Hash  (cost=1.04..1.04 rows=1 width=40) (actual time=0.016..0.016 rows=1 loops=1)
        Buckets: 1024  Batches: 1  Memory Usage: 1kB
        ->  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)
              Filter: (id = 1)
              Rows Removed by Filter: 2
  SubPlan 2
    ->  Aggregate  (cost=1859.34..1859.35 rows=1 width=8) (actual time=0.877..0.877 rows=1 loops=49997)
          ->  Nested Loop  (cost=5.61..1859.19 rows=58 width=8) (actual time=0.128..0.867 rows=10 loops=49997)
                ->  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=49997)
                      Index Cond: (nro_patronal = empresas_sucursales.nro_patronal)
                      Heap Fetches: 49997
                ->  Bitmap Heap Scan on empleados  (cost=5.32..1850.31 rows=58 width=24) (actual time=0.110..0.837 rows=10 loops=49997)
                      Recheck Cond: (npatronal = empresas_sucursales.nro_patronal)
                      Filter: (SubPlan 1)
                      Rows Removed by Filter: 12
                      ->  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=49997)
                            Index Cond: (npatronal = empresas_sucursales.nro_patronal)
                      SubPlan 1
                        ->  Limit  (cost=12.06..12.06 rows=1 width=20) (actual time=0.029..0.029 rows=1 loops=1104207)
                              ->  Sort  (cost=12.06..12.06 rows=2 width=20) (actual time=0.026..0.026 rows=1 loops=1104207)
                                    Sort Key: empleados_movimientos.fecha, empleados_movimientos.id
                                    Sort Method: top-N heapsort  Memory: 25kB
                                    ->  Result  (cost=0.00..12.05 rows=2 width=20) (actual time=0.015..0.022 rows=2 loops=1104207)
                                          One-Time Filter: (empleados.empresa_id = emp.id)
                                          ->  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=1103945)
                                                Index Cond: (empleado_id = empleados.id)
                                                Rows Removed by Index Recheck: 0
  SubPlan 4
    ->  Aggregate  (cost=2210.20..2210.23 rows=1 width=16) (actual time=0.523..0.523 rows=1 loops=49997)
          ->  Bitmap Heap Scan on empleados emplea  (cost=5.50..2208.80 rows=70 width=16) (actual time=0.057..0.507 rows=12 loops=49997)
                Recheck Cond: (empresa_id = emp.id)
                Filter: (SubPlan 3)
                Rows Removed by Filter: 15
                ->  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=49997)
                      Index Cond: (empresa_id = emp.id)
                SubPlan 3
                  ->  Limit  (cost=12.06..12.06 rows=1 width=20) (actual time=0.014..0.014 rows=1 loops=1357314)
                        ->  Sort  (cost=12.06..12.06 rows=2 width=20) (actual time=0.012..0.012 rows=1 loops=1357314)
                              Sort Key: empleados_movimientos_1.fecha, empleados_movimientos_1.id
                              Sort Method: top-N heapsort  Memory: 25kB
                              ->  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=1357314)
                                    Index Cond: (empleado_id = emplea.id)
                                    Rows Removed by Index Recheck: 0
  SubPlan 6
    ->  Aggregate  (cost=2324.97..2324.98 rows=1 width=8) (actual time=0.756..0.757 rows=1 loops=49997)
          ->  Nested Loop  (cost=5.61..2324.88 rows=38 width=8) (actual time=0.101..0.749 rows=6 loops=49997)
                ->  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=49997)
                      Index Cond: (nro_patronal = empresas_sucursales.nro_patronal)
                      Heap Fetches: 49997
                ->  Nested Loop  (cost=5.32..2316.19 rows=38 width=16) (actual time=0.092..0.732 rows=6 loops=49997)
                      ->  Bitmap Heap Scan on empleados empleados_1  (cost=5.32..1850.31 rows=58 width=24) (actual time=0.045..0.447 rows=10 loops=49997)
                            Recheck Cond: (npatronal = empresas_sucursales.nro_patronal)
                            Filter: (SubPlan 5)
                            Rows Removed by Filter: 12
                            ->  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=49997)
                                  Index Cond: (npatronal = empresas_sucursales.nro_patronal)
                            SubPlan 5
                              ->  Limit  (cost=12.06..12.06 rows=1 width=20) (actual time=0.016..0.017 rows=1 loops=1104207)
                                    ->  Sort  (cost=12.06..12.06 rows=2 width=20) (actual time=0.014..0.014 rows=1 loops=1104207)
                                          Sort Key: empleados_movimientos_2.fecha, empleados_movimientos_2.id
                                          Sort Method: top-N heapsort  Memory: 25kB
                                          ->  Result  (cost=0.00..12.05 rows=2 width=20) (actual time=0.006..0.010 rows=2 loops=1104207)
                                                One-Time Filter: (empleados_1.empresa_id = emp.id)
                                                ->  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=1103945)
                                                      Index Cond: (empleado_id = empleados_1.id)
                                                      Rows Removed by Index Recheck: 0
                      ->  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=493920)
                            Index Cond: (id = empleados_1.persona_id)
                            Rows Removed by Index Recheck: 0
                            Filter: ((sexo)::text = 'M'::text)
                            Rows Removed by Filter: 0
  SubPlan 8
    ->  Aggregate  (cost=2324.75..2324.76 rows=1 width=8) (actual time=0.518..0.519 rows=1 loops=49997)
          ->  Nested Loop  (cost=5.61..2324.70 rows=20 width=8) (actual time=0.115..0.513 rows=3 loops=49997)
                ->  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=49997)
                      Index Cond: (nro_patronal = empresas_sucursales.nro_patronal)
                      Heap Fetches: 49997
                ->  Nested Loop  (cost=5.32..2316.19 rows=20 width=16) (actual time=0.107..0.501 rows=3 loops=49997)
                      ->  Bitmap Heap Scan on empleados empleados_2  (cost=5.32..1850.31 rows=58 width=24) (actual time=0.044..0.427 rows=10 loops=49997)
                            Recheck Cond: (npatronal = empresas_sucursales.nro_patronal)
                            Filter: (SubPlan 7)
                            Rows Removed by Filter: 12
                            ->  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=49997)
                                  Index Cond: (npatronal = empresas_sucursales.nro_patronal)
                            SubPlan 7
                              ->  Limit  (cost=12.06..12.06 rows=1 width=20) (actual time=0.016..0.016 rows=1 loops=1104207)
                                    ->  Sort  (cost=12.06..12.06 rows=2 width=20) (actual time=0.013..0.013 rows=1 loops=1104207)
                                          Sort Key: empleados_movimientos_3.fecha, empleados_movimientos_3.id
                                          Sort Method: top-N heapsort  Memory: 25kB
                                          ->  Result  (cost=0.00..12.05 rows=2 width=20) (actual time=0.006..0.009 rows=2 loops=1104207)
                                                One-Time Filter: (empleados_2.empresa_id = emp.id)
                                                ->  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=1103945)
                                                      Index Cond: (empleado_id = empleados_2.id)
                                                      Rows Removed by Index Recheck: 0
                      ->  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=493920)
                            Index Cond: (id = empleados_2.persona_id)
                            Rows Removed by Index Recheck: 0
                            Filter: ((sexo)::text = 'F'::text)
                            Rows Removed by Filter: 1
  SubPlan 9
    ->  Limit  (cost=12.92..12.93 rows=1 width=134) (actual time=0.065..0.066 rows=1 loops=49997)
          ->  Sort  (cost=12.92..12.93 rows=2 width=134) (actual time=0.062..0.062 rows=1 loops=49997)
                Sort Key: cambio_situacion_empresa.fecha_creacion, cambio_situacion_empresa.id_cambio_situacion_empresa
                Sort Method: quicksort  Memory: 25kB
                ->  Hash Join  (cost=11.79..12.91 rows=2 width=134) (actual time=0.048..0.051 rows=1 loops=49997)
                      Hash Cond: (situacion_emp.id_situacion = cambio_situacion_empresa.situacion_act)
                      ->  Seq Scan on situacion_emp  (cost=0.00..1.07 rows=7 width=122) (actual time=0.002..0.005 rows=7 loops=40466)
                      ->  Hash  (cost=11.76..11.76 rows=2 width=20) (actual time=0.036..0.036 rows=1 loops=49997)
                            Buckets: 1024  Batches: 1  Memory Usage: 1kB
                            ->  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=49997)
                                  Recheck Cond: (nro_patronal = empresas_sucursales.nro_patronal)
                                  ->  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=49997)
                                        Index Cond: (nro_patronal = empresas_sucursales.nro_patronal)
Total runtime: 138892.636 ms

Per node type stats

node type	count	sum of times	% of query
Aggregate	4	1,999.880 ms	1.4 %
Bitmap Heap Scan	5	21,780.215 ms	15.7 %
Bitmap Index Scan	5	3,099.814 ms	2.2 %
Hash	8	394.879 ms	0.3 %
Hash Join	2	835.504 ms	0.6 %
Hash Left Join	6	1,314.765 ms	0.9 %
Index Only Scan	3	899.946 ms	0.6 %
Index Scan	6	53,631.393 ms	38.6 %
Limit	5	12,852.479 ms	9.3 %
Nested Loop	5	5,675.120 ms	4.1 %
Result	3	15,465.972 ms	11.1 %
Seq Scan	9	317.633 ms	0.2 %
Sort	5	20,587.021 ms	14.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
actividad_econ	1	0.450 ms	0.0 %
Seq Scan	1	0.450 ms	100.0 %
cambio_situacion_empresa	1	899.946 ms	0.6 %
Bitmap Heap Scan	1	899.946 ms	100.0 %
city	1	0.173 ms	0.0 %
Seq Scan	1	0.173 ms	100.0 %
distritos	1	0.024 ms	0.0 %
Seq Scan	1	0.024 ms	100.0 %
empleados	4	20,880.269 ms	15.0 %
Bitmap Heap Scan	4	20,880.269 ms	100.0 %
empleados_movimientos	4	39,307.713 ms	28.3 %
Index Scan	4	39,307.713 ms	100.0 %
empresas	1	46.252 ms	0.0 %
Seq Scan	1	46.252 ms	100.0 %
empresas_categorias	1	0.016 ms	0.0 %
Seq Scan	1	0.016 ms	100.0 %
empresas_sucursales	4	968.285 ms	0.7 %
Index Only Scan	3	899.946 ms	92.9 %
Seq Scan	1	68.339 ms	7.1 %
empresas_sucursales_types	1	0.014 ms	0.0 %
Seq Scan	1	0.014 ms	100.0 %
empresas_types	1	0.035 ms	0.0 %
Seq Scan	1	0.035 ms	100.0 %
persons	2	14,323.680 ms	10.3 %
Index Scan	2	14,323.680 ms	100.0 %
situacion_emp	1	202.330 ms	0.1 %
Seq Scan	1	202.330 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CSgD

Color mode:

Visible columns:

Per node type stats

Per table stats