explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8npb

Settings
# exclusive inclusive rows x rows loops node
1. 5.061 71,663.840 ↓ 317.2 6,661 1

Unique (cost=172.25..172.35 rows=21 width=25) (actual time=71,654.654..71,663.840 rows=6,661 loops=1)

  • Output: v.channel_id
  • Buffers: shared hit=1468447 read=209602 dirtied=541
  • I/O Timings: read=69084.144
2. 94.569 71,658.779 ↓ 1,690.1 35,493 1

Sort (cost=172.25..172.30 rows=21 width=25) (actual time=71,654.651..71,658.779 rows=35,493 loops=1)

  • Output: v.channel_id
  • Sort Key: v.channel_id
  • Sort Method: quicksort Memory: 4309kB
  • Buffers: shared hit=1468447 read=209602 dirtied=541
  • I/O Timings: read=69084.144
3. 369.297 71,564.210 ↓ 1,690.1 35,493 1

Nested Loop (cost=0.98..171.78 rows=21 width=25) (actual time=6.987..71,564.210 rows=35,493 loops=1)

  • Output: v.channel_id
  • Buffers: shared hit=1468447 read=209602 dirtied=541
  • I/O Timings: read=69084.144
4. 89.719 349.209 ↓ 2,312.5 770,062 1

Nested Loop (cost=0.98..87.48 rows=333 width=12) (actual time=0.345..349.209 rows=770,062 loops=1)

  • Output: vg.youtube_video_id
  • Buffers: shared hit=579135 read=4
  • I/O Timings: read=0.315
5. 0.335 0.335 ↑ 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.334..0.335 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 = ANY ('{Fortnite}'::text[]))
  • Buffers: shared read=4
  • I/O Timings: read=0.315
6. 259.155 259.155 ↓ 293.4 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 vg (cost=0.56..58.60 rows=2,625 width=16) (actual time=0.009..259.155 rows=770,062 loops=1)

  • Output: vg.game_id, vg.youtube_video_id
  • Index Cond: (vg.game_id = g.id)
  • Heap Fetches: 0
  • Buffers: shared hit=579135
7. 70,845.704 70,845.704 ↓ 0.0 0 770,062

Index Scan using videos_y2019_q2_id_idx on youtube.videos_y2019_q2 v (cost=0.00..0.24 rows=1 width=37) (actual time=0.092..0.092 rows=0 loops=770,062)

  • Output: v.id, v.channel_id, v.published, v.is_deleted, v.view_count, v.comment_count, v.like_count, v.dislike_count, v.favorite_count, v.duration, v.dimension, v.definition, v.title, v.description, v.category_id, v.thumbnail_url, v.tags, v.topic_ids, v.topic_categories, v.last_synced, v.last_stats_synced
  • Index Cond: (v.id = vg.youtube_video_id)
  • Rows Removed by Index Recheck: 0
  • Filter: ((v.published > '2019-04-01 00:00:00+00'::timestamp with time zone) AND (v.published < '2019-05-01 00:00:00+00'::timestamp with time zone) AND (v.view_count > 1000))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=889312 read=209598 dirtied=541
  • I/O Timings: read=69083.829
Planning time : 13.343 ms