explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M6cj

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.009 0.142 ↓ 17.0 17 1

Sort (cost=65.36..65.36 rows=1 width=57) (actual time=0.141..0.142 rows=17 loops=1)

  • Sort Key: c.created
  • Sort Method: quicksort Memory: 27kB
2. 0.003 0.133 ↓ 17.0 17 1

Nested Loop (cost=0.57..65.35 rows=1 width=57) (actual time=0.066..0.133 rows=17 loops=1)

3. 0.001 0.021 ↑ 1.0 1 1

Nested Loop (cost=0.57..16.63 rows=1 width=8) (actual time=0.020..0.021 rows=1 loops=1)

  • Join Filter: ((s.uid = g.player1) OR (s.uid = g.player2))
4. 0.010 0.010 ↑ 1.0 1 1

Index Scan using words_games_pkey on words_games g (cost=0.29..8.31 rows=1 width=12) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (gid = 48856)
5. 0.010 0.010 ↑ 1.0 1 1

Index Scan using words_social_pkey on words_social s (cost=0.29..8.30 rows=1 width=4) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((sid = '17880121030128875114'::text) AND (social = 8))
6. 0.109 0.109 ↑ 1.0 17 1

Seq Scan on words_chat c (cost=0.00..48.55 rows=17 width=61) (actual time=0.045..0.109 rows=17 loops=1)

  • Filter: (gid = 48856)
  • Rows Removed by Filter: 1628