explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ft9d

Settings
# exclusive inclusive rows x rows loops node
1. 4,446.859 4,446.859 ↑ 1.0 770,062 1

CTE Scan on game_video_ids (cost=155,791.67..171,373.11 rows=779,072 width=32) (actual time=3,978.186..4,446.859 rows=770,062 loops=1)

  • Output: game_video_ids.youtube_video_id
  • Buffers: shared hit=128205 read=8068
  • I/O Timings: read=3850.442
2.          

CTE game_video_ids

3. 327.865 4,281.807 ↑ 1.0 770,062 1

Bitmap Heap Scan on matching.youtube_video_to_game_2 (cost=16,410.27..155,791.67 rows=779,072 width=12) (actual time=3,978.183..4,281.807 rows=770,062 loops=1)

  • Output: youtube_video_to_game_2.youtube_video_id
  • Recheck Cond: (youtube_video_to_game_2.game_id = 15033)
  • Heap Blocks: exact=128203
  • Buffers: shared hit=128205 read=8068
  • I/O Timings: read=3850.442
4. 3,953.942 3,953.942 ↑ 1.0 770,062 1

Bitmap Index Scan on youtube_video_to_game_2_game_id_idx (cost=0.00..16,215.50 rows=779,072 width=0) (actual time=3,953.942..3,953.942 rows=770,062 loops=1)

  • Index Cond: (youtube_video_to_game_2.game_id = 15033)
  • Buffers: shared hit=2 read=8068
  • I/O Timings: read=3850.442
Planning time : 0.074 ms