Sort  (cost=111114880.71..111115340.71 rows=184000 width=15) (actual time=14460.441..14460.445 rows=30 loops=1)
  Sort Key: ((d.d)::date) DESC, l.name
  Sort Method: quicksort  Memory: 26kB
  Buffers: shared hit=12508305, temp read=29616 written=29616
  ->  Nested Loop  (cost=111092.81..111098790.51 rows=184000 width=15) (actual time=2514.490..14460.420 rows=30 loops=1)
        Buffers: shared hit=12508305, temp read=29616 written=29616
        ->  Function Scan on generate_series d  (cost=0.01..10.01 rows=1000 width=8) (actual time=204.819..204.824 rows=6 loops=1)
        ->  HashAggregate  (cost=111092.80..111094.64 rows=184 width=11) (actual time=2375.928..2375.929 rows=5 loops=6)
              Group Key: l.name
              Buffers: shared hit=12508305, temp read=29616 written=29616
              ->  Hash Join  (cost=9106.96..109937.86 rows=230989 width=3) (actual time=181.853..2300.864 rows=577440 loops=6)
                    Hash Cond: (fi.locale_id = l.id)
                    Buffers: shared hit=12508305, temp read=29616 written=29616
                    ->  Nested Loop  (cost=9102.62..109313.21 rows=230989 width=4) (actual time=181.844..2225.157 rows=577440 loops=6)
                          Buffers: shared hit=12508303, temp read=29616 written=29616
                          ->  Hash Join  (cost=9102.19..43727.19 rows=116159 width=4) (actual time=181.814..1090.856 rows=378607 loops=6)
                                Hash Cond: (f.content_id = c.id)
                                Buffers: shared hit=319824, temp read=29616 written=29616
                                ->  Seq Scan on films f  (cost=0.00..27900.52 rows=2561702 width=8) (actual time=0.005..267.913 rows=2563650 loops=6)
                                      Buffers: shared hit=137010
                                ->  Hash  (cost=7476.08..7476.08 rows=130089 width=4) (actual time=181.744..181.744 rows=378607 loops=6)
                                      Buckets: 524288 (originally 131072)  Batches: 2 (originally 1)  Memory Usage: 12289kB
                                      Buffers: shared hit=182814, temp written=3318
                                      ->  Bitmap Heap Scan on content c  (cost=1886.04..7476.08 rows=130089 width=4) (actual time=47.126..126.969 rows=378607 loops=6)
                                            Recheck Cond: (((content_type)::text = 'movie'::text) AND (created_at < d.d))
                                            Heap Blocks: exact=174096
                                            Buffers: shared hit=182814
                                            ->  Bitmap Index Scan on content_type_created_at_idx  (cost=0.00..1853.52 rows=130089 width=0) (actual time=43.413..43.413 rows=378607 loops=6)
                                                  Index Cond: (((content_type)::text = 'movie'::text) AND (created_at < d.d))
                                                  Buffers: shared hit=8718
                          ->  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.038..0.038 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.007..0.019 rows=184 loops=1)
                                Buffers: shared hit=2
Planning Time: 0.550 ms
JIT:
  Functions: 33
  Options: Inlining true, Optimization true, Expressions true, Deforming true
  Timing: Generation 1.814 ms, Inlining 11.773 ms, Optimization 120.423 ms, Emission 72.331 ms, Total 206.342 ms
Execution Time: 14462.367 ms