explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wZWg : EPIC MEMES

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.009 0.300 ↓ 50.0 50 1

Limit (cost=9.77..18.92 rows=1 width=2,050) (actual time=0.053..0.300 rows=50 loops=1)

2.          

CTE finished_matches

3. 0.016 0.107 ↑ 1.0 50 1

Limit (cost=0.29..9.62 rows=50 width=135) (actual time=0.033..0.107 rows=50 loops=1)

4. 0.091 0.091 ↑ 1,192.2 50 1

Index Scan Backward using matches_dota2_matchendedtime_idx on dota2 (cost=0.29..11,118.07 rows=59,611 width=135) (actual time=0.031..0.091 rows=50 loops=1)

  • Index Cond: ("matchEndedTime" IS NOT NULL)
5. 0.064 0.291 ↓ 50.0 50 1

Nested Loop Left Join (cost=0.15..9.30 rows=1 width=2,050) (actual time=0.052..0.291 rows=50 loops=1)

  • Filter: (COALESCE(mr."ratingsAdjusted", false) IS FALSE)
6. 0.177 0.177 ↓ 50.0 50 1

CTE Scan on finished_matches (cost=0.00..1.12 rows=1 width=2,041) (actual time=0.043..0.177 rows=50 loops=1)

  • Filter: (state = '4'::numeric)
7. 0.050 0.050 ↓ 0.0 0 50

Index Scan using matchesratings_pkey on matchesratings mr (cost=0.15..8.17 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=50)

  • Index Cond: (finished_matches.id = id)