explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dQf1

Settings
# exclusive inclusive rows x rows loops node
1. 632.255 525,909.297 ↓ 2,312.5 770,062 1

Nested Loop Left Join (cost=57.20..3,307.82 rows=333 width=20) (actual time=128.254..525,909.297 rows=770,062 loops=1)

  • Output: vp.id, vp.published
  • Inner Unique: true
  • Buffers: shared hit=2646513 read=1232546 dirtied=35091
  • I/O Timings: read=511766.887
2. 155.515 1,634.882 ↓ 2,312.5 770,062 1

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

  • Output: vg.youtube_video_id
  • Buffers: shared hit=7 read=136270
  • I/O Timings: read=445.473
3. 0.033 0.033 ↑ 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.032..0.033 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 read=4
  • I/O Timings: read=0.015
4. 1,377.374 1,479.334 ↓ 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=127.752..1,479.334 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=7 read=136266
  • I/O Timings: read=445.458
5. 101.960 101.960 ↓ 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=101.960..101.960 rows=770,062 loops=1)

  • Index Cond: (g.id = vg.game_id)
  • Buffers: shared hit=2 read=8068
  • I/O Timings: read=26.126
6. 523,642.160 523,642.160 ↑ 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.680..0.680 rows=1 loops=770,062)

  • Output: vp.id, vp.published
  • Index Cond: (vg.youtube_video_id = vp.id)
  • Buffers: shared hit=2646506 read=1096276 dirtied=35091
  • I/O Timings: read=511321.413
Planning time : 2.943 ms