Pasted

 Aggregate  (cost=12424.43..12424.44 rows=1 width=32)
   ->  Nested Loop  (cost=9.06..12424.43 rows=1 width=17)
         ->  Nested Loop  (cost=8.63..12423.97 rows=1 width=21)
               ->  Nested Loop  (cost=8.20..12418.45 rows=12 width=25)
                     Join Filter: (t.id = ci.movie_id)
                     ->  Nested Loop  (cost=7.64..12412.40 rows=3 width=29)
                           Join Filter: (t.kind_id = kt.id)
                           ->  Seq Scan on kind_type kt  (cost=0.00..1.09 rows=1 width=4)
                                 Filter: ((kind)::text = 'movie'::text)
                           ->  Nested Loop  (cost=7.64..12411.05 rows=21 width=33)
                                 ->  Nested Loop  (cost=7.21..12399.83 rows=23 width=8)
                                       Join Filter: (cc.status_id = cct2.id)
                                       ->  Seq Scan on comp_cast_type cct2  (cost=0.00..1.05 rows=1 width=4)
                                             Filter: ((kind)::text ~~ '%complete%'::text)
                                       ->  Nested Loop  (cost=7.21..12397.63 rows=92 width=12)
                                             Join Filter: (cc.subject_id = cct1.id)
                                             ->  Seq Scan on comp_cast_type cct1  (cost=0.00..1.05 rows=1 width=4)
                                                   Filter: ((kind)::text = 'cast'::text)
                                             ->  Nested Loop  (cost=7.21..12392.00 rows=366 width=16)
                                                   ->  Nested Loop  (cost=6.79..12263.49 rows=270 width=4)
                                                         ->  Seq Scan on keyword k  (cost=0.00..3632.40 rows=8 width=4)
                                                               Filter: ((keyword)::text = ANY ('{superhero,sequel,second-part,marvel-comics,based-on-comic,tv-special,fight,violence}'::text[]))
                                                         ->  Bitmap Heap Scan on movie_keyword mk  (cost=6.79..1075.85 rows=304 width=8)
                                                               Recheck Cond: (keyword_id = k.id)
                                                               ->  Bitmap Index Scan on keyword_id_movie_keyword  (cost=0.00..6.71 rows=304 width=0)
                                                                     Index Cond: (keyword_id = k.id)
                                                   ->  Index Scan using movie_id_complete_cast on complete_cast cc  (cost=0.42..0.46 rows=2 width=12)
                                                         Index Cond: (movie_id = mk.movie_id)
                                 ->  Index Scan using title_pkey on title t  (cost=0.43..0.49 rows=1 width=25)
                                       Index Cond: (id = mk.movie_id)
                                       Filter: (production_year > 1950)
                     ->  Index Scan using movie_id_cast_info on cast_info ci  (cost=0.56..1.54 rows=38 width=12)
                           Index Cond: (movie_id = mk.movie_id)
               ->  Index Scan using char_name_pkey on char_name chn  (cost=0.43..0.46 rows=1 width=4)
                     Index Cond: (id = ci.person_role_id)
                     Filter: (((name)::text !~~ '%Sherlock%'::text) AND (((name)::text ~~ '%Tony%Stark%'::text) OR ((name)::text ~~ '%Iron%Man%'::text)))
         ->  Index Only Scan using name_pkey on name n  (cost=0.43..0.45 rows=1 width=4)
               Index Cond: (id = ci.person_id)