explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BQnp

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 148.472 173.357 ↓ 1,140.0 228,000 1

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

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

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

Planning time : 0.099 ms