explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BsB1

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 105.545 267.089 ↑ 1.0 55,602 1

Hash Join (cost=2,660.73..5,278.55 rows=55,602 width=20) (actual time=111.900..267.089 rows=55,602 loops=1)

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

Index Only Scan using empresas_sucursales_empresa_id_id_idx on empresas_sucursales (cost=0.41..1,506.20 rows=55,602 width=8) (actual time=0.041..49.712 rows=55,602 loops=1)

  • Heap Fetches: 134
3. 46.664 111.832 ↓ 1.0 49,839 1

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

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

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