explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y78u

Settings
# exclusive inclusive rows x rows loops node
1. 0.531 0.850 ↑ 1.0 3 1

HashAggregate (cost=32.42..32.45 rows=3 width=2) (actual time=0.849..0.850 rows=3 loops=1)

  • Group Key: type
2. 0.319 0.319 ↑ 1.0 1,290 1

Seq Scan on result (cost=0.00..29.14 rows=1,314 width=2) (actual time=0.008..0.319 rows=1,290 loops=1)

Planning time : 0.065 ms
Execution time : 0.881 ms