Sort  (cost=150311108.46..150311568.46 rows=184000 width=15) (actual time=16178.953..16178.957 rows=30 loops=1)
  Sort Key: ((d.d)::date) DESC, l.name
  Sort Method: quicksort  Memory: 26kB
  Buffers: shared hit=12543819, temp read=29616 written=29616
  ->  Nested Loop  (cost=150289.04..150295018.26 rows=184000 width=15) (actual time=2996.365..16178.921 rows=30 loops=1)
        Buffers: shared hit=12543816, temp read=29616 written=29616
        ->  Function Scan on generate_series d  (cost=0.01..10.01 rows=1000 width=8) (actual time=232.997..233.002 rows=6 loops=1)
        ->  HashAggregate  (cost=150289.03..150290.87 rows=184 width=11) (actual time=2657.648..2657.650 rows=5 loops=6)
              Group Key: l.name
              Buffers: shared hit=12543816, temp read=29616 written=29616
              ->  Hash Join  (cost=48303.19..149134.08 rows=230989 width=3) (actual time=439.770..2583.906 rows=577440 loops=6)
                    Hash Cond: (fi.locale_id = l.id)
                    Buffers: shared hit=12543816, temp read=29616 written=29616
                    ->  Nested Loop  (cost=48298.85..148509.44 rows=230989 width=4) (actual time=439.757..2509.692 rows=577440 loops=6)
                          Buffers: shared hit=12543811, temp read=29616 written=29616
                          ->  Hash Join  (cost=48298.42..82923.42 rows=116159 width=4) (actual time=439.726..1352.564 rows=378607 loops=6)
                                Hash Cond: (f.content_id = c.id)
                                Buffers: shared hit=355332, temp read=29616 written=29616
                                ->  Seq Scan on films f  (cost=0.00..27900.52 rows=2561702 width=8) (actual time=0.005..271.727 rows=2563650 loops=6)
                                      Buffers: shared hit=137010
                                ->  Hash  (cost=46672.30..46672.30 rows=130089 width=4) (actual time=439.649..439.649 rows=378607 loops=6)
                                      Buckets: 524288 (originally 131072)  Batches: 2 (originally 1)  Memory Usage: 12289kB
                                      Buffers: shared hit=218322, temp written=3318
                                      ->  Seq Scan on content c  (cost=0.00..46672.30 rows=130089 width=4) (actual time=0.010..375.363 rows=378607 loops=6)
                                            Filter: ((created_at < d.d) AND ((content_type)::text = 'movie'::text))
                                            Rows Removed by Filter: 2490300
                                            Buffers: shared hit=218322
                          ->  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
                                Buffers: shared hit=12188479
                    ->  Hash  (cost=2.04..2.04 rows=184 width=7) (actual time=0.043..0.043 rows=184 loops=1)
                          Buckets: 1024  Batches: 1  Memory Usage: 16kB
                          Buffers: shared hit=2
                          ->  Seq Scan on locales l  (cost=0.00..2.04 rows=184 width=7) (actual time=0.009..0.024 rows=184 loops=1)
                                Buffers: shared hit=2
Planning Time: 4.200 ms
JIT:
  Functions: 32
  Options: Inlining true, Optimization true, Expressions true, Deforming true
  Timing: Generation 1.568 ms, Inlining 41.192 ms, Optimization 118.710 ms, Emission 72.786 ms, Total 234.256 ms
Execution Time: 16248.606 ms