explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oTU1

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 110.372 ↑ 2.8 5 1

Subquery Scan on tt (cost=14,069.15..14,070.41 rows=14 width=23) (actual time=110.351..110.372 rows=5 loops=1)

  • Filter: (tt.ranking <= 5)
  • Rows Removed by Filter: 37
2. 0.021 110.367 ↑ 1.0 42 1

WindowAgg (cost=14,069.15..14,069.89 rows=42 width=31) (actual time=110.349..110.367 rows=42 loops=1)

3. 0.020 110.346 ↑ 1.0 42 1

Sort (cost=14,069.15..14,069.26 rows=42 width=23) (actual time=110.344..110.346 rows=42 loops=1)

  • Sort Key: t.cnt DESC
  • Sort Method: quicksort Memory: 28kB
4. 0.005 110.326 ↑ 1.0 42 1

Subquery Scan on t (cost=14,067.18..14,068.02 rows=42 width=23) (actual time=110.317..110.326 rows=42 loops=1)

5. 22.496 110.321 ↑ 1.0 42 1

HashAggregate (cost=14,067.18..14,067.60 rows=42 width=23) (actual time=110.316..110.321 rows=42 loops=1)

  • Group Key: crimes.analysis_neighborhood, count(*) OVER (?)
6. 41.638 87.825 ↓ 1.0 105,956 1

WindowAgg (cost=0.42..13,537.78 rows=105,880 width=23) (actual time=8.236..87.825 rows=105,956 loops=1)

7. 46.187 46.187 ↓ 1.0 105,956 1

Index Only Scan using neighborhood_date on crimes (cost=0.42..11,949.58 rows=105,880 width=15) (actual time=0.048..46.187 rows=105,956 loops=1)

  • Index Cond: (analysis_neighborhood IS NOT NULL)
  • Heap Fetches: 105956
Planning time : 0.431 ms
Execution time : 110.505 ms