explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4r1U : Optimization for: plan #BQnp

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 151.405 177.703 ↓ 1,140.0 228,000 1

HashAggregate (cost=4,713.88..4,715.88 rows=200 width=524) (actual time=130.172..177.703 rows=228,000 loops=1)

  • Group Key: centrocodigo
2. 26.298 26.298 ↓ 10.4 228,000 1

Seq Scan on oportunidadcitas (cost=0.00..4,604.25 rows=21,925 width=524) (actual time=0.014..26.298 rows=228,000 loops=1)

Planning time : 0.101 ms