explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RWwb

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 0.249 ↑ 1.0 1 1

Aggregate (cost=657.91..657.93 rows=1 width=12) (actual time=0.249..0.249 rows=1 loops=1)

2. 0.180 0.200 ↓ 1.5 254 1

Bitmap Heap Scan on words_games (cost=10.00..651.35 rows=175 width=16) (actual time=0.033..0.200 rows=254 loops=1)

  • Recheck Cond: ((5 = player1) OR (5 = player2))
  • Filter: (finished IS NOT NULL)
  • Rows Removed by Filter: 6
  • Heap Blocks: exact=165
3. 0.000 0.020 ↓ 0.0 0 1

BitmapOr (cost=10.00..10.00 rows=177 width=0) (actual time=0.020..0.020 rows=0 loops=1)

4. 0.011 0.011 ↓ 7.8 93 1

Bitmap Index Scan on words_games_player1_coalesce_idx (cost=0.00..4.38 rows=12 width=0) (actual time=0.011..0.011 rows=93 loops=1)

  • Index Cond: (5 = player1)
5. 0.009 0.009 ↓ 1.0 167 1

Bitmap Index Scan on words_games_player2_coalesce_idx (cost=0.00..5.53 rows=165 width=0) (actual time=0.009..0.009 rows=167 loops=1)

  • Index Cond: (5 = player2)