#	exclusive	inclusive	rows x	rows	loops	node
1.	113.037	294.968	↓ 1.0	55,608	1	→ Hash Join (cost=2,660.31..6,246.37 rows=55,602 width=78) (actual time=112.555..294.968 rows=55,608 loops=1) Hash Cond: (empresas_sucursales.empresa_id = empresas.id)
2.	69.418	69.418	↓ 1.0	55,608	1	→ Seq Scan on empresas_sucursales (cost=0.00..2,474.02 rows=55,602 width=66) (actual time=0.017..69.418 rows=55,608 loops=1)
3.	46.592	112.513	↓ 1.0	49,844	1	→ Hash (cost=2,037.36..2,037.36 rows=49,836 width=20) (actual time=112.513..112.513 rows=49,844 loops=1) Buckets: 8192 Batches: 1 Memory Usage: 2341kB
4.	65.921	65.921	↓ 1.0	49,844	1	→ Seq Scan on empresas (cost=0.00..2,037.36 rows=49,836 width=20) (actual time=0.011..65.921 rows=49,844 loops=1)

Hash Join  (cost=2660.31..6246.37 rows=55602 width=78) (actual time=112.555..294.968 rows=55608 loops=1)
  Hash Cond: (empresas_sucursales.empresa_id = empresas.id)
  ->  Seq Scan on empresas_sucursales  (cost=0.00..2474.02 rows=55602 width=66) (actual time=0.017..69.418 rows=55608 loops=1)
  ->  Hash  (cost=2037.36..2037.36 rows=49836 width=20) (actual time=112.513..112.513 rows=49844 loops=1)
        Buckets: 8192  Batches: 1  Memory Usage: 2341kB
        ->  Seq Scan on empresas  (cost=0.00..2037.36 rows=49836 width=20) (actual time=0.011..65.921 rows=49844 loops=1)
Total runtime: 332.423 ms

Per node type stats

node type	count	sum of times	% of query
Hash	1	46.592 ms	15.8 %
Hash Join	1	113.037 ms	38.3 %
Seq Scan	2	135.339 ms	45.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
empresas	1	65.921 ms	22.3 %
Seq Scan	1	65.921 ms	100.0 %
empresas_sucursales	1	69.418 ms	23.5 %
Seq Scan	1	69.418 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DwxB

Color mode:

Visible columns:

Per node type stats

Per table stats