explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DwxB

Settings
# 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)