explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X7T1 : Optimization for: plan #BsB1

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 113.758 337.764 ↑ 1.0 55,602 1

Hash Join (cost=2,660.31..6,246.37 rows=55,602 width=78) (actual time=138.776..337.764 rows=55,602 loops=1)

  • Hash Cond: (empresas_sucursales.empresa_id = empresas.id)
2. 85.316 85.316 ↑ 1.0 55,602 1

Seq Scan on empresas_sucursales (cost=0.00..2,474.02 rows=55,602 width=66) (actual time=0.040..85.316 rows=55,602 loops=1)

3. 55.167 138.690 ↓ 1.0 49,839 1

Hash (cost=2,037.36..2,037.36 rows=49,836 width=20) (actual time=138.690..138.690 rows=49,839 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 2340kB
4. 83.523 83.523 ↓ 1.0 49,839 1

Seq Scan on empresas (cost=0.00..2,037.36 rows=49,836 width=20) (actual time=0.042..83.523 rows=49,839 loops=1)