GroupAggregate  (cost=228702.40..244294.18 rows=692968 width=15) (actual time=3321.765..3458.410 rows=1651 loops=1)
  Group Key: l.name, ((c.created_at)::date)
  Buffers: shared hit=205824, temp read=15838 written=15840
  ->  Sort  (cost=228702.40..230434.82 rows=692968 width=7) (actual time=3319.804..3409.309 rows=578665 loops=1)
        Sort Key: l.name, ((c.created_at)::date)
        Sort Method: external merge  Disk: 10192kB
        Buffers: shared hit=205824, temp read=15838 written=15840
        ->  Hash Join  (cost=59612.88..159581.19 rows=692968 width=7) (actual time=1185.872..3132.727 rows=578665 loops=1)
              Hash Cond: (fi.locale_id = l.id)
              Buffers: shared hit=205824, temp read=14564 written=14564
              ->  Hash Join  (cost=59608.54..155983.49 rows=692968 width=12) (actual time=1172.079..2983.317 rows=578665 loops=1)
                    Hash Cond: (fi.film_id = f.id)
                    Buffers: shared hit=205822, temp read=14564 written=14564
                    ->  Seq Scan on films_info fi  (cost=0.00..66192.40 rows=5094100 width=8) (actual time=0.007..686.829 rows=5086436 loops=1)
                          Buffers: shared hit=152514
                    ->  Hash  (cost=55082.37..55082.37 rows=348477 width=12) (actual time=1170.700..1170.703 rows=378852 loops=1)
                          Buckets: 524288  Batches: 2  Memory Usage: 12234kB
                          Buffers: shared hit=53308, temp read=5121 written=5860
                          ->  Hash Join  (cost=18265.37..55082.37 rows=348477 width=12) (actual time=187.131..1099.840 rows=378852 loops=1)
                                Hash Cond: (f.content_id = c.id)
                                Buffers: shared hit=53308, temp read=5121 written=5121
                                ->  Seq Scan on films f  (cost=0.00..27900.52 rows=2561702 width=8) (actual time=0.011..325.667 rows=2563650 loops=1)
                                      Buffers: shared hit=22835
                                ->  Hash  (cost=13196.44..13196.44 rows=390267 width=12) (actual time=185.797..185.798 rows=378852 loops=1)
                                      Buckets: 524288  Batches: 2  Memory Usage: 12254kB
                                      Buffers: shared hit=30473, temp written=738
                                      ->  Bitmap Heap Scan on content c  (cost=4679.40..13196.44 rows=390267 width=12) (actual time=26.666..124.224 rows=378852 loops=1)
                                            Recheck Cond: ((content_type)::text = 'movie'::text)
                                            Heap Blocks: exact=29019
                                            Buffers: shared hit=30473
                                            ->  Bitmap Index Scan on content_type_created_at_idx  (cost=0.00..4581.83 rows=390267 width=0) (actual time=22.669..22.669 rows=378852 loops=1)
                                                  Index Cond: ((content_type)::text = 'movie'::text)
                                                  Buffers: shared hit=1454
              ->  Hash  (cost=2.04..2.04 rows=184 width=7) (actual time=13.783..13.784 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=13.740..13.758 rows=184 loops=1)
                          Buffers: shared hit=2
Planning Time: 0.421 ms
JIT:
  Functions: 32
  Options: Inlining false, Optimization false, Expressions true, Deforming true
  Timing: Generation 1.919 ms, Inlining 0.000 ms, Optimization 0.525 ms, Emission 13.007 ms, Total 15.451 ms
Execution Time: 3463.730 ms