explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6yqe

Settings
# exclusive inclusive rows x rows loops node
1. 0.067 0.273 ↑ 1.0 1 1

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

2. 0.185 0.206 ↓ 1.5 254 1

Bitmap Heap Scan on words_games (cost=10.00..651.35 rows=175 width=16) (actual time=0.035..0.206 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.021 ↓ 0.0 0 1

BitmapOr (cost=10.00..10.00 rows=177 width=0) (actual time=0.021..0.021 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.010 0.010 ↓ 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.010 rows=167 loops=1)

  • Index Cond: (5 = player2)