explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ewQq

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 22.251 ↑ 1.0 10 1

Limit (cost=0.42..2,981.22 rows=10 width=23) (actual time=7.112..22.251 rows=10 loops=1)

2. 4.878 22.247 ↑ 4.2 10 1

GroupAggregate (cost=0.42..12,519.78 rows=42 width=23) (actual time=7.110..22.247 rows=10 loops=1)

  • Group Key: analysis_neighborhood
3. 17.369 17.369 ↑ 3.6 31,332 1

Index Only Scan using neighborhood_date on crimes (cost=0.42..11,961.71 rows=111,531 width=15) (actual time=0.047..17.369 rows=31,332 loops=1)

  • Heap Fetches: 31332
Planning time : 0.293 ms
Execution time : 22.320 ms