"Unique  (cost=8419738.53..8442329.47 rows=1462381 width=46) (actual time=778183.637..778754.779 rows=38399 loops=1)"
"  ->  Sort  (cost=8419738.53..8425386.26 rows=2259094 width=46) (actual time=778183.636..778556.458 rows=1248982 loops=1)"
"        Sort Key: movies.movieid, movies.title, movies.mvyear"
"        Sort Method: external merge  Disk: 53704kB"
"        ->  Hash Join  (cost=653015.57..8042329.51 rows=2259094 width=46) (actual time=599182.051..776878.241 rows=1248982 loops=1)"
"              Hash Cond: (actormovie.movieid = movies.movieid)"
"              ->  Hash Join  (cost=592952.99..7920701.39 rows=2259094 width=8) (actual time=444667.407..770776.935 rows=1248982 loops=1)"
"                    Hash Cond: (generomovie.genero_id = genero.genero_id)"
"                    Join Filter: ((lower((actor.name)::text) ~~ ANY ('{"zuidinga, fran%"}'::text[])) OR (lower((personagem.as_character)::text) ~~ ANY ('{[tony%}'::text[])) OR (lower((genero.descricao)::text) = 'romance'::text))"
"                    Rows Removed by Join Filter: 19327392"
"                    ->  Hash Join  (cost=592951.34..6576421.25 rows=51210609 width=45) (actual time=67904.631..740244.185 rows=20576374 loops=1)"
"                          Hash Cond: (actormovie.characterid = personagem.characterid)"
"                          ->  Hash Join  (cost=74600.93..3670603.31 rows=51210609 width=32) (actual time=990.216..638042.161 rows=20576374 loops=1)"
"                                Hash Cond: (actormovie.actor_id = actor.actor_id)"
"                                ->  Merge Join  (cost=1663.18..2217237.43 rows=51210609 width=20) (actual time=0.026..540246.985 rows=20576374 loops=1)"
"                                      Merge Cond: (generomovie.movieid = actormovie.movieid)"
"                                      ->  Index Scan using generomovie_movieid_idx on generomovie  (cost=0.42..37262.94 rows=853027 width=8) (actual time=0.013..35384.674 rows=853027 loops=1)"
"                                      ->  Materialize  (cost=0.56..1483914.09 rows=29692304 width=12) (actual time=0.012..498024.007 rows=38111561 loops=1)"
"                                            ->  Index Scan using actormovie_movieid_idx on actormovie  (cost=0.56..1409683.33 rows=29692304 width=12) (actual time=0.008..494059.192 rows=29692392 loops=1)"
"                                ->  Hash  (cost=34889.89..34889.89 rows=2072389 width=20) (actual time=788.186..788.186 rows=2072389 loops=1)"
"                                      Buckets: 65536  Batches: 64  Memory Usage: 2178kB"
"                                      ->  Seq Scan on actor  (cost=0.00..34889.89 rows=2072389 width=20) (actual time=0.014..294.780 rows=2072389 loops=1)"
"                          ->  Hash  (cost=245782.96..245782.96 rows=14846196 width=21) (actual time=39616.240..39616.240 rows=14846196 loops=1)"
"                                Buckets: 65536  Batches: 256  Memory Usage: 3561kB"
"                                ->  Seq Scan on personagem  (cost=0.00..245782.96 rows=14846196 width=21) (actual time=0.006..33891.856 rows=14846196 loops=1)"
"                    ->  Hash  (cost=1.29..1.29 rows=29 width=222) (actual time=16.625..16.625 rows=29 loops=1)"
"                          Buckets: 1024  Batches: 1  Memory Usage: 10kB"
"                          ->  Seq Scan on genero  (cost=0.00..1.29 rows=29 width=222) (actual time=16.605..16.608 rows=29 loops=1)"
"              ->  Hash  (cost=28929.81..28929.81 rows=1462381 width=46) (actual time=2122.111..2122.111 rows=1462381 loops=1)"
"                    Buckets: 65536  Batches: 64  Memory Usage: 2298kB"
"                    ->  Seq Scan on movies  (cost=0.00..28929.81 rows=1462381 width=46) (actual time=9.222..1727.341 rows=1462381 loops=1)"
"Planning time: 204.132 ms"
"Execution time: 778794.119 ms"