explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B9O6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4.179 ↓ 3.0 15 1

Hash Anti Join (cost=243.34..311.75 rows=5 width=26) (actual time=3.725..4.179 rows=15 loops=1)

2. 0.360 0.360 ↓ 1.0 638 1

Seq Scan on films (cost=0.00..53.36 rows=636 width=26) (actual time=0.011..0.360 rows=638 loops=1)

3. 3.686 3.686 ↓ 1.0 707 1

Hash (cost=234.56..234.56 rows=703 width=8) (actual time=3.686..3.686 rows=707 loops=1)

4. 3.541 3.541 ↓ 1.0 707 1

Hash Join (cost=207.74..234.56 rows=703 width=8) (actual time=3.172..3.541 rows=707 loops=1)

5. 0.152 0.152 ↓ 1.0 794 1

Seq Scan on seasons (cost=0.00..16.92 rows=792 width=16) (actual time=0.005..0.152 rows=794 loops=1)

6. 3.149 3.149 ↓ 1.0 714 1

Hash (cost=198.95..198.95 rows=703 width=8) (actual time=3.149..3.149 rows=714 loops=1)

7. 2.996 2.996 ↓ 1.0 714 1

HashAggregate (cost=191.92..198.95 rows=703 width=8) (actual time=2.891..2.996 rows=714 loops=1)

8. 1.454 1.454 ↓ 1.0 9,142 1

Index Only Scan using index_season_items_on_season_id on season_items (cost=0.29..169.11 rows=9,122 width=8) (actual time=0.039..1.454 rows=9,142 loops=1)

Planning time : 1.946 ms
Execution time : 4.306 ms