explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JGdS : Optimization for: plan #0lwx

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1,056.685 2,172.145 ↓ 1.0 667,571 1

Hash Join (cost=3,274.44..76,262.03 rows=663,040 width=84) (actual time=114.836..2,172.145 rows=667,571 loops=1)

  • Hash Cond: (empleado.nropatronal = empresas_sucursales.nro_patronal)
2. 1,000.668 1,000.668 ↓ 1.0 667,572 1

Seq Scan on empleado (cost=0.00..58,897.99 rows=663,040 width=30) (actual time=0.022..1,000.668 rows=667,572 loops=1)

  • Filter: (anho = 2017)
  • Rows Removed by Filter: 1992747
3. 49.871 114.792 ↓ 1.0 56,882 1

Hash (cost=2,563.64..2,563.64 rows=56,864 width=58) (actual time=114.792..114.792 rows=56,882 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 5078kB
4. 64.921 64.921 ↓ 1.0 56,882 1

Seq Scan on empresas_sucursales (cost=0.00..2,563.64 rows=56,864 width=58) (actual time=0.015..64.921 rows=56,882 loops=1)