#	rows x	node
1.	↓ 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.0	→ Seq Scan on movie_companies (cost=0.00..84,441.96 rows=4,958,296 width=8) (actual rows= loops=)
3.	↓ 0.0	→ Hash (cost=112,760.08..112,760.08 rows=4,636,508 width=8) (actual rows= loops=)
4.	↓ 0.0	→ Seq Scan on title (cost=0.00..112,760.08 rows=4,636,508 width=8) (actual rows= loops=)

   Group Key: title.kind_id, movie_companies.company_type_id
    ->  Hash Join  (cost=188828.43..423088.44 rows=4958296 width=8)
          Hash Cond: (movie_companies.movie_id = title.id)
          ->  Seq Scan on movie_companies  (cost=0.00..84441.96 rows=4958296 width=8)
          ->  Hash  (cost=112760.08..112760.08 rows=4636508 width=8)
               ->  Seq Scan on title  (cost=0.00..112760.08 rows=4636508 width=8)

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.000 ms	0.0 %
Hash Join	1	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
movie_companies	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
title	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uhvs

Color mode:

Visible columns:

Per node type stats

Per table stats