explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OIkm

Settings
# exclusive inclusive rows x rows loops node
1. 642.483 513,827.868 ↓ 2,312.5 770,062 1

Nested Loop Left Join (cost=57.20..3,307.81 rows=333 width=20) (actual time=95.300..513,827.868 rows=770,062 loops=1)

  • Output: vp.id, vp.published
  • Inner Unique: true
  • Buffers: shared hit=2686688 read=1192360 dirtied=288401
  • I/O Timings: read=494461.614
2. 150.362 1,094.155 ↓ 2,312.5 770,062 1

Nested Loop Left Join (cost=56.63..2,955.43 rows=333 width=12) (actual time=94.832..1,094.155 rows=770,062 loops=1)

  • Output: vg.youtube_video_id
  • Buffers: shared hit=73797 read=62480
  • I/O Timings: read=207.209
3. 0.013 0.013 ↑ 1.0 1 1

Index Scan using idx_topic_games_title on topic.games g (cost=0.41..2.63 rows=1 width=4) (actual time=0.012..0.013 rows=1 loops=1)

  • Output: g.id, g.title, g.alternative_titles, g.platforms, g.store_ids, g.categories, g.logo_url, g.description
  • Index Cond: (g.title = 'Fortnite'::text)
  • Buffers: shared hit=4
4. 873.342 943.780 ↓ 291.8 770,062 1

Bitmap Heap Scan on matching.youtube_video_to_game_2 vg (cost=56.21..2,926.41 rows=2,639 width=16) (actual time=94.817..943.780 rows=770,062 loops=1)

  • Output: vg.youtube_video_id, vg.game_id, vg.matching_score
  • Recheck Cond: (g.id = vg.game_id)
  • Heap Blocks: exact=128203
  • Buffers: shared hit=73793 read=62480
  • I/O Timings: read=207.209
5. 70.438 70.438 ↓ 291.8 770,062 1

Bitmap Index Scan on youtube_video_to_game_2_game_id_idx (cost=0.00..55.56 rows=2,639 width=0) (actual time=70.438..70.438 rows=770,062 loops=1)

  • Index Cond: (g.id = vg.game_id)
  • Buffers: shared hit=8070
6. 512,091.230 512,091.230 ↑ 1.0 1 770,062

Index Scan using video_published_pkey on youtube.video_published vp (cost=0.57..1.06 rows=1 width=20) (actual time=0.665..0.665 rows=1 loops=770,062)

  • Output: vp.id, vp.published
  • Index Cond: (vg.youtube_video_id = vp.id)
  • Buffers: shared hit=2612891 read=1129880 dirtied=288401
  • I/O Timings: read=494254.405
Planning time : 7.677 ms