explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1L2g

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 78.642 597.902 ↓ 1.0 228,000 1

GroupAggregate (cost=33,966.51..37,956.02 rows=227,972 width=41) (actual time=397.851..597.902 rows=228,000 loops=1)

  • Group Key: centrocodigo
2. 490.029 519.260 ↓ 1.0 228,000 1

Sort (cost=33,966.51..34,536.44 rows=227,972 width=41) (actual time=397.842..519.260 rows=228,000 loops=1)

  • Sort Key: centrocodigo
  • Sort Method: external merge Disk: 12968kB
3. 29.231 29.231 ↓ 1.0 228,000 1

Seq Scan on oportunidadcitas (cost=0.00..6,664.72 rows=227,972 width=41) (actual time=0.011..29.231 rows=228,000 loops=1)

Planning time : 0.158 ms
Execution time : 606.614 ms