explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J83H : Optimization for: plan #HxT3

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 2.135 3.800 ↑ 1.0 17 1

HashAggregate (cost=1,447.35..1,447.52 rows=17 width=4) (actual time=3.799..3.800 rows=17 loops=1)

  • Group Key: code_12
2. 1.665 1.665 ↑ 1.0 19,388 1

Seq Scan on streets (cost=0.00..1,398.88 rows=19,388 width=4) (actual time=0.010..1.665 rows=19,388 loops=1)

Planning time : 0.069 ms
Execution time : 3.818 ms