explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xu5A : Optimization for: plan #oIwT

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 218.687 ↓ 0.0 0 1

Limit (cost=0.44..37.61 rows=50 width=136) (actual time=218.687..218.687 rows=0 loops=1)

2. 42.969 218.685 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.44..22,158.02 rows=29,806 width=136) (actual time=218.685..218.685 rows=0 loops=1)

  • Filter: (COALESCE(mr."ratingsAdjusted", true) IS FALSE)
  • Rows Removed by Filter: 59649
3. 116.067 116.067 ↓ 1.0 59,649 1

Index Scan Backward using matches_dota2_matchendedtime_idx on dota2 m (cost=0.29..11,384.04 rows=59,611 width=135) (actual time=5.990..116.067 rows=59,649 loops=1)

  • Filter: (state = '4'::numeric)
  • Rows Removed by Filter: 7220
4. 59.649 59.649 ↓ 0.0 0 59,649

Index Scan using matchesratings_pkey on matchesratings mr (cost=0.15..0.17 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=59,649)

  • Index Cond: (m.id = id)