explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9VY8

Settings
# exclusive inclusive rows x rows loops node
1. 111.314 258.131 ↓ 1.0 55,602 1

Hash Join (cost=2,660.73..5,260.69 rows=55,599 width=20) (actual time=96.380..258.131 rows=55,602 loops=1)

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

Index Only Scan using empresas_sucursales_id_empresa_id_idx on empresas_sucursales (cost=0.41..1,488.40 rows=55,599 width=8) (actual time=0.093..50.559 rows=55,602 loops=1)

  • Heap Fetches: 134
3. 44.733 96.258 ↓ 1.0 49,839 1

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

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

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