explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s3tc : ayy lmao

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.067 0.278 ↓ 50.0 50 1

Nested Loop Left Join (cost=9.77..18.92 rows=1 width=2,050) (actual time=0.052..0.278 rows=50 loops=1)

  • Filter: (COALESCE(mr."ratingsAdjusted", false) IS FALSE)
2.          

CTE finished_matches

3. 0.015 0.104 ↑ 1.0 50 1

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

4. 0.089 0.089 ↑ 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.089 rows=50 loops=1)

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

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

  • Filter: (state = '4'::numeric)
6. 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)