explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xC54

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.047 ↓ 3.0 3 1

Nested Loop (cost=12.62..32.85 rows=1 width=806) (actual time=0.037..0.047 rows=3 loops=1)

  • Output: episodes.id, episodes.name, episodes.movie_id, videos.id, videos.host_id, videos.episode_id, videos.created_at, videos.error, videos.checked_at, hosts.id, hosts.name, hosts.priority
  • Inner Unique: true
2. 0.011 0.030 ↓ 3.0 3 1

Hash Join (cost=12.47..32.25 rows=1 width=734) (actual time=0.026..0.030 rows=3 loops=1)

  • Output: episodes.id, episodes.name, episodes.movie_id, videos.id, videos.host_id, videos.episode_id, videos.created_at, videos.error, videos.checked_at
  • Hash Cond: (episodes.id = videos.episode_id)
3. 0.011 0.011 ↓ 1.2 5 1

Seq Scan on public.episodes (cost=0.00..19.75 rows=4 width=76) (actual time=0.009..0.011 rows=5 loops=1)

  • Output: episodes.id, episodes.name, episodes.movie_id
  • Filter: (episodes.movie_id = 10001)
  • Rows Removed by Filter: 2
4. 0.003 0.008 ↑ 27.5 4 1

Hash (cost=11.10..11.10 rows=110 width=658) (actual time=0.008..0.008 rows=4 loops=1)

  • Output: videos.id, videos.host_id, videos.episode_id, videos.created_at, videos.error, videos.checked_at
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.005 0.005 ↑ 27.5 4 1

Seq Scan on public.videos (cost=0.00..11.10 rows=110 width=658) (actual time=0.003..0.005 rows=4 loops=1)

  • Output: videos.id, videos.host_id, videos.episode_id, videos.created_at, videos.error, videos.checked_at
6. 0.012 0.012 ↑ 1.0 1 3

Index Scan using host_pk on public.hosts (cost=0.15..0.60 rows=1 width=72) (actual time=0.004..0.004 rows=1 loops=3)

  • Output: hosts.id, hosts.name, hosts.priority
  • Index Cond: (hosts.id = videos.host_id)
Planning time : 0.373 ms
Execution time : 0.094 ms