Sort  (cost=164993057.90..164993557.90 rows=200000 width=39)
  Sort Key: ((d.d)::date) DESC, l.name
  ->  Nested Loop  (cost=164968.45..164975448.26 rows=200000 width=39)
        ->  Function Scan on generate_series d  (cost=0.01..10.01 rows=1000 width=8)
        ->  HashAggregate  (cost=164968.44..164970.94 rows=200 width=35)
              Group Key: l.name
              ->  HashAggregate  (cost=158616.24..161503.60 rows=230989 width=15)
                    Group Key: l.name, (c.created_at)::date
                    ->  Hash Join  (cost=55475.46..156883.82 rows=230989 width=7)
                          Hash Cond: (fi.locale_id = l.id)
                          ->  Nested Loop  (cost=55471.12..155681.70 rows=230989 width=12)
                                ->  Hash Join  (cost=55470.69..90095.68 rows=116159 width=12)
                                      Hash Cond: (f.content_id = c.id)
                                      ->  Seq Scan on films f  (cost=0.00..27900.52 rows=2561702 width=8)
                                      ->  Hash  (cost=53844.57..53844.57 rows=130089 width=12)
                                            ->  Seq Scan on content c  (cost=0.00..53844.57 rows=130089 width=12)
                                                  Filter: (((content_type)::text = 'movie'::text) AND ((created_at)::date < d.d))
                                ->  Index Only Scan using films_info_film_id_locale_id_key on films_info fi  (cost=0.43..0.52 rows=4 width=8)
                                      Index Cond: (film_id = f.id)
                          ->  Hash  (cost=2.04..2.04 rows=184 width=7)
                                ->  Seq Scan on locales l  (cost=0.00..2.04 rows=184 width=7)
JIT:
  Functions: 31
  Options: Inlining true, Optimization true, Expressions true, Deforming true