explain.depesz.com

PostgreSQL's explain analyze made readable

Result: edbr

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

Hash Join (cost=188,828.43..423,088.44 rows=4,958,296 width=8) (actual rows= loops=)

  • Hash Cond: (movie_companies.movie_id = title.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on movie_companies (cost=0.00..84,441.96 rows=4,958,296 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=112,760.08..112,760.08 rows=4,636,508 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on title (cost=0.00..112,760.08 rows=4,636,508 width=8) (actual rows= loops=)