explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7ipI

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 4.488 ↑ 1.0 623 1

Hash Join (cost=250.51..312.56 rows=631 width=26) (actual time=3.916..4.488 rows=623 loops=1)

2. 0.365 0.365 ↓ 1.0 638 1

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

3. 3.889 3.889 ↑ 1.0 623 1

Hash (cost=242.62..242.62 rows=631 width=8) (actual time=3.889..3.889 rows=623 loops=1)

4. 3.779 3.779 ↑ 1.0 623 1

HashAggregate (cost=236.31..242.62 rows=631 width=8) (actual time=3.687..3.779 rows=623 loops=1)

5. 3.501 3.501 ↓ 1.0 707 1

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

6. 0.161 0.161 ↓ 1.0 794 1

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

7. 3.094 3.094 ↓ 1.0 714 1

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

8. 2.964 2.964 ↓ 1.0 714 1

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

9. 1.397 1.397 ↓ 1.0 9,155 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.043..1.397 rows=9,155 loops=1)

Planning time : 2.145 ms
Execution time : 4.682 ms