#	exclusive	inclusive	rows x	rows	loops	node
1.	1,056.685	2,172.145	↓ 1.0	667,571	1	→ Hash Join (cost=3,274.44..76,262.03 rows=663,040 width=84) (actual time=114.836..2,172.145 rows=667,571 loops=1) Hash Cond: (empleado.nropatronal = empresas_sucursales.nro_patronal)
2.	1,000.668	1,000.668	↓ 1.0	667,572	1	→ Seq Scan on empleado (cost=0.00..58,897.99 rows=663,040 width=30) (actual time=0.022..1,000.668 rows=667,572 loops=1) Filter: (anho = 2017) Rows Removed by Filter: 1992747
3.	49.871	114.792	↓ 1.0	56,882	1	→ Hash (cost=2,563.64..2,563.64 rows=56,864 width=58) (actual time=114.792..114.792 rows=56,882 loops=1) Buckets: 8192 Batches: 1 Memory Usage: 5078kB
4.	64.921	64.921	↓ 1.0	56,882	1	→ Seq Scan on empresas_sucursales (cost=0.00..2,563.64 rows=56,864 width=58) (actual time=0.015..64.921 rows=56,882 loops=1)

Hash Join  (cost=3274.44..76262.03 rows=663040 width=84) (actual time=114.836..2172.145 rows=667571 loops=1)
  Hash Cond: (empleado.nropatronal = empresas_sucursales.nro_patronal)
  ->  Seq Scan on empleado  (cost=0.00..58897.99 rows=663040 width=30) (actual time=0.022..1000.668 rows=667572 loops=1)
        Filter: (anho = 2017)
        Rows Removed by Filter: 1992747
  ->  Hash  (cost=2563.64..2563.64 rows=56864 width=58) (actual time=114.792..114.792 rows=56882 loops=1)
        Buckets: 8192  Batches: 1  Memory Usage: 5078kB
        ->  Seq Scan on empresas_sucursales  (cost=0.00..2563.64 rows=56864 width=58) (actual time=0.015..64.921 rows=56882 loops=1)
Total runtime: 2634.547 ms

Per node type stats

node type	count	sum of times	% of query
Hash	1	49.871 ms	2.3 %
Hash Join	1	1,056.685 ms	48.6 %
Seq Scan	2	1,065.589 ms	49.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
empleado	1	1,000.668 ms	46.1 %
Seq Scan	1	1,000.668 ms	100.0 %
empresas_sucursales	1	64.921 ms	3.0 %
Seq Scan	1	64.921 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JGdS : Optimization for: plan #0lwx

Color mode:

Visible columns:

Optimization path:

Per node type stats

Per table stats