explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 62m1

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

Aggregate (cost=231.93..231.94 rows=1 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=115.10..230.68 rows=500 width=4) (actual rows= loops=)

  • Merge Cond: (f1.film_id = ((f2.film_id + 1)))
3. 0.000 0.000 ↓ 0.0

Index Only Scan using film_pkey on film f1 (cost=0.28..93.35 rows=1,000 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=114.83..117.33 rows=1,000 width=4) (actual rows= loops=)

  • Sort Key: ((f2.film_id + 1))
5. 0.000 0.000 ↓ 0.0

Seq Scan on film f2 (cost=0.00..65.00 rows=1,000 width=4) (actual rows= loops=)