explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tGi9

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=153.73..153.75 rows=8 width=123) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=153.73..154.85 rows=448 width=123) (actual rows= loops=)

  • Sort Key: a.is_viewed, a.created_at
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=66.28..144.77 rows=448 width=123) (actual rows= loops=)

  • Hash Cond: (a.video_id = v.id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=53.58..125.91 rows=448 width=95) (actual rows= loops=)

  • Hash Cond: (a.job_id = j.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on applications a (cost=0.00..66.17 rows=448 width=24) (actual rows= loops=)

  • Filter: (user_id = 1)
6. 0.000 0.000 ↓ 0.0

Hash (cost=47.70..47.70 rows=470 width=75) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on jobs j (cost=0.00..47.70 rows=470 width=75) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=11.20..11.20 rows=120 width=36) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on videos v (cost=0.00..11.20 rows=120 width=36) (actual rows= loops=)