explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q6H8

Settings
# exclusive inclusive rows x rows loops node
1. 0.084 0.127 ↑ 1.7 7 1

HashAggregate (cost=15.460..15.580 rows=12 width=5) (actual time=0.125..0.127 rows=7 loops=1)

  • Group Key: november, bravo
2. 0.043 0.043 ↑ 1.0 312 1

Seq Scan on sierra (cost=0.000..13.120 rows=312 width=5) (actual time=0.002..0.043 rows=312 loops=1)