HashAggregate  (cost=184379.25..193041.35 rows=692968 width=15) (actual time=3458.736..3461.309 rows=1651 loops=1)
  Group Key: l.name, (c.created_at)::date
  Buffers: shared hit=211741
  ->  Hash Join  (cost=83363.68..179181.99 rows=692968 width=7) (actual time=1411.261..3363.212 rows=578665 loops=1)
        Hash Cond: (fi.locale_id = l.id)
        Buffers: shared hit=211741
        ->  Hash Join  (cost=83359.34..175584.29 rows=692968 width=12) (actual time=1397.444..3210.153 rows=578665 loops=1)
              Hash Cond: (fi.film_id = f.id)
              Buffers: shared hit=211736
              ->  Seq Scan on films_info fi  (cost=0.00..66192.40 rows=5094100 width=8) (actual time=0.015..816.283 rows=5086436 loops=1)
                    Buffers: shared hit=152514
              ->  Hash  (cost=79003.37..79003.37 rows=348477 width=12) (actual time=1396.087..1396.089 rows=378852 loops=1)
                    Buckets: 524288  Batches: 1  Memory Usage: 20373kB
                    Buffers: shared hit=59222
                    ->  Hash Join  (cost=44378.38..79003.37 rows=348477 width=12) (actual time=406.905..1313.815 rows=378852 loops=1)
                          Hash Cond: (f.content_id = c.id)
                          Buffers: shared hit=59222
                          ->  Seq Scan on films f  (cost=0.00..27900.52 rows=2561702 width=8) (actual time=0.018..380.226 rows=2563650 loops=1)
                                Buffers: shared hit=22835
                          ->  Hash  (cost=39500.04..39500.04 rows=390267 width=12) (actual time=405.583..405.584 rows=378852 loops=1)
                                Buckets: 524288  Batches: 1  Memory Usage: 20373kB
                                Buffers: shared hit=36387
                                ->  Seq Scan on content c  (cost=0.00..39500.04 rows=390267 width=12) (actual time=0.020..334.897 rows=378852 loops=1)
                                      Filter: ((content_type)::text = 'movie'::text)
                                      Rows Removed by Filter: 2490055
                                      Buffers: shared hit=36387
        ->  Hash  (cost=2.04..2.04 rows=184 width=7) (actual time=13.790..13.790 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.735..13.763 rows=184 loops=1)
                    Buffers: shared hit=2
Planning Time: 1.345 ms
JIT:
  Functions: 33
  Options: Inlining false, Optimization false, Expressions true, Deforming true
  Timing: Generation 1.885 ms, Inlining 0.000 ms, Optimization 0.632 ms, Emission 12.867 ms, Total 15.384 ms
Execution Time: 3525.058 ms