explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sJTm

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

CTE Scan on game_video_ids (cost=16,790.17..32,238.29 rows=772,406 width=32) (actual time=0.015..315.186 rows=770,062 loops=1)

  • Output: game_video_ids.youtube_video_id
  • Buffers: shared hit=579135
2.          

CTE game_video_ids

3. 142.014 142.014 ↑ 1.0 770,062 1

Index Only Scan using youtube_video_to_game_2_game_id_youtube_video_id_idx on matching.youtube_video_to_game_2 (cost=0.56..16,790.17 rows=772,406 width=12) (actual time=0.013..142.014 rows=770,062 loops=1)

  • Output: youtube_video_to_game_2.youtube_video_id
  • Index Cond: (youtube_video_to_game_2.game_id = 15033)
  • Heap Fetches: 0
  • Buffers: shared hit=579135
Planning time : 0.081 ms