explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xlkw : Optimization for: plan #1L2g

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 146.510 166.952 ↓ 1,140.0 228,000 1

HashAggregate (cost=4,737.52..4,739.52 rows=200 width=524) (actual time=118.245..166.952 rows=228,000 loops=1)

  • Group Key: centrocodigo
2. 20.442 20.442 ↓ 10.3 228,000 1

Seq Scan on oportunidadcitas (cost=0.00..4,627.35 rows=22,035 width=524) (actual time=0.010..20.442 rows=228,000 loops=1)

Planning time : 0.194 ms
Execution time : 175.490 ms