Sort  (cost=150311108.46..150311568.46 rows=184000 width=15) (actual time=16062.696..16062.699 rows=30 loops=1)
  Sort Key: ((d.d)::date) DESC, l.name
  Sort Method: quicksort  Memory: 26kB
  ->  Nested Loop  (cost=150289.04..150295018.26 rows=184000 width=15) (actual time=2930.269..16062.675 rows=30 loops=1)
        ->  Function Scan on generate_series d  (cost=0.01..10.01 rows=1000 width=8) (actual time=221.095..221.100 rows=6 loops=1)
        ->  HashAggregate  (cost=150289.03..150290.87 rows=184 width=11) (actual time=2640.257..2640.259 rows=5 loops=6)
              Group Key: l.name
              ->  Hash Join  (cost=48303.19..149134.08 rows=230989 width=3) (actual time=458.352..2569.657 rows=577440 loops=6)
                    Hash Cond: (fi.locale_id = l.id)
                    ->  Nested Loop  (cost=48298.85..148509.44 rows=230989 width=4) (actual time=458.340..2501.072 rows=577440 loops=6)
                          ->  Hash Join  (cost=48298.42..82923.42 rows=116159 width=4) (actual time=457.938..1357.069 rows=378607 loops=6)
                                Hash Cond: (f.content_id = c.id)
                                ->  Seq Scan on films f  (cost=0.00..27900.52 rows=2561702 width=8) (actual time=0.005..260.831 rows=2563650 loops=6)
                                ->  Hash  (cost=46672.30..46672.30 rows=130089 width=4) (actual time=457.603..457.603 rows=378607 loops=6)
                                      Buckets: 524288 (originally 131072)  Batches: 2 (originally 1)  Memory Usage: 12289kB
                                      ->  Seq Scan on content c  (cost=0.00..46672.30 rows=130089 width=4) (actual time=0.010..384.157 rows=378607 loops=6)
                                            Filter: ((created_at < d.d) AND ((content_type)::text = 'movie'::text))
                                            Rows Removed by Filter: 2490300
                          ->  Index Only Scan using films_info_film_id_locale_id_key on films_info fi  (cost=0.43..0.52 rows=4 width=8) (actual time=0.002..0.003 rows=2 loops=2271642)
                                Index Cond: (film_id = f.id)
                                Heap Fetches: 2980956
                    ->  Hash  (cost=2.04..2.04 rows=184 width=7) (actual time=0.056..0.056 rows=184 loops=1)
                          Buckets: 1024  Batches: 1  Memory Usage: 16kB
                          ->  Seq Scan on locales l  (cost=0.00..2.04 rows=184 width=7) (actual time=0.008..0.027 rows=184 loops=1)
Planning Time: 0.508 ms
JIT:
  Functions: 32
  Options: Inlining true, Optimization true, Expressions true, Deforming true
  Timing: Generation 2.057 ms, Inlining 14.092 ms, Optimization 130.243 ms, Emission 76.494 ms, Total 222.887 ms
Execution Time: 16065.301 ms