explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OJUc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 419.212 ↑ 1.0 1 1

Finalize Aggregate (cost=448,186.39..448,186.40 rows=1 width=64) (actual time=419.212..419.212 rows=1 loops=1)

2. 119.202 529.759 ↓ 1.2 6 1

Gather (cost=448,185.78..448,186.29 rows=5 width=64) (actual time=418.345..529.759 rows=6 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
3. 21.843 410.557 ↑ 1.0 1 6 / 6

Partial Aggregate (cost=447,185.78..447,185.79 rows=1 width=64) (actual time=410.557..410.557 rows=1 loops=6)

4. 4.065 388.714 ↑ 1.1 54,244 6 / 6

Append (cost=0.00..444,695.38 rows=62,260 width=24) (actual time=64.537..388.714 rows=54,244 loops=6)

5. 0.001 0.001 ↓ 0.0 0 6 / 6

Parallel Seq Scan on player_balance (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.001 rows=0 loops=6)

  • Filter: (player_id = '1833949'::text)
6. 375.758 384.648 ↑ 1.1 54,244 6 / 6

Parallel Bitmap Heap Scan on player_balance_31 (cost=7,036.97..444,695.38 rows=62,259 width=24) (actual time=64.536..384.648 rows=54,244 loops=6)

  • Recheck Cond: (player_id = '1833949'::text)
  • Rows Removed by Index Recheck: 316,618
  • Heap Blocks: exact=21,237 lossy=11,720
7. 8.890 8.890 ↓ 1.0 326,061 1 / 6

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

  • Index Cond: (player_id = '1833949'::text)
Planning time : 0.412 ms
Execution time : 529.922 ms