explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qTUU

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.043 ↓ 17.0 17 1

Sort (cost=43.84..43.85 rows=1 width=57) (actual time=0.042..0.043 rows=17 loops=1)

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

Nested Loop (cost=0.85..43.83 rows=1 width=57) (actual time=0.028..0.035 rows=17 loops=1)

3. 0.002 0.016 ↑ 1.0 1 1

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

  • Join Filter: ((s.uid = g.player1) OR (s.uid = g.player2))
4. 0.005 0.005 ↑ 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.005..0.005 rows=1 loops=1)

  • Index Cond: (gid = 48856)
5. 0.009 0.009 ↑ 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.009..0.009 rows=1 loops=1)

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

Index Scan using words_chat_gid_idx on words_chat c (cost=0.28..27.03 rows=17 width=61) (actual time=0.012..0.017 rows=17 loops=1)

  • Index Cond: (gid = 48856)