explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0PsQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,377.826 ↑ 1.0 1 1

Limit (cost=0.00..1.49 rows=1 width=64) (actual time=1,377.825..1,377.826 rows=1 loops=1)

2. 300.104 1,377.823 ↑ 311,295.0 1 1

WindowAgg (cost=0.00..463,373.07 rows=311,295 width=64) (actual time=1,377.823..1,377.823 rows=1 loops=1)

3. 28.185 1,077.719 ↓ 1.0 325,461 1

Append (cost=0.00..447,808.32 rows=311,295 width=24) (actual time=73.857..1,077.719 rows=325,461 loops=1)

4. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on player_balance (cost=0.00..0.00 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (player_id = '1833949'::text)
5. 991.807 1,049.532 ↓ 1.0 325,461 1

Bitmap Heap Scan on player_balance_31 (cost=7,036.97..447,808.32 rows=311,294 width=24) (actual time=73.854..1,049.532 rows=325,461 loops=1)

  • Recheck Cond: (player_id = '1833949'::text)
  • Rows Removed by Index Recheck: 1,899,710
  • Heap Blocks: exact=56,485 lossy=34,032
6. 57.725 57.725 ↓ 1.0 326,061 1

Bitmap Index Scan on player_balance_31_player_id_idx (cost=0.00..6,959.14 rows=311,294 width=0) (actual time=57.725..57.725 rows=326,061 loops=1)

  • Index Cond: (player_id = '1833949'::text)
Planning time : 0.416 ms
Execution time : 1,381.245 ms