QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 HashAggregate  (cost=158075.65..166737.75 rows=692968 width=15) (actual time=3358.411..3361.035 rows=1709 loops=1)
   Group Key: l.name, (c.created_at)::date
   Buffers: shared hit=205827
   ->  Hash Join  (cost=57060.08..152878.39 rows=692968 width=7) (actual time=1287.568..3263.435 rows=578665 loops=1)
         Hash Cond: (fi.locale_id = l.id)
         Buffers: shared hit=205827
         ->  Hash Join  (cost=57055.74..149280.69 rows=692968 width=12) (actual time=1273.505..3115.672 rows=578665 loops=1)
               Hash Cond: (fi.film_id = f.id)
               Buffers: shared hit=205822
               ->  Seq Scan on films_info fi  (cost=0.00..66192.40 rows=5094100 width=8) (actual time=0.016..832.039 rows=5086436 loops=1)
                     Buffers: shared hit=152514
               ->  Hash  (cost=52699.77..52699.77 rows=348477 width=12) (actual time=1272.118..1272.121 rows=378852 loops=1)
                     Buckets: 524288  Batches: 1  Memory Usage: 20373kB
                     Buffers: shared hit=53308
                     ->  Hash Join  (cost=18074.77..52699.77 rows=348477 width=12) (actual time=264.242..1187.799 rows=378852 loops=1)
                           Hash Cond: (f.content_id = c.id)
                           Buffers: shared hit=53308
                           ->  Seq Scan on films f  (cost=0.00..27900.52 rows=2561702 width=8) (actual time=0.020..387.530 rows=2563650 loops=1)
                                 Buffers: shared hit=22835
                           ->  Hash  (cost=13196.44..13196.44 rows=390267 width=12) (actual time=262.908..262.909 rows=378852 loops=1)
                                 Buckets: 524288  Batches: 1  Memory Usage: 20373kB
                                 Buffers: shared hit=30473
                                 ->  Bitmap Heap Scan on content c  (cost=4679.40..13196.44 rows=390267 width=12) (actual time=29.335..192.180 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=25.572..25.572 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=14.036..14.036 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.981..14.009 rows=184 loops=1)
                     Buffers: shared hit=2
 Planning Time: 1.431 ms
 JIT:
   Functions: 33
   Options: Inlining false, Optimization false, Expressions true, Deforming true
   Timing: Generation 1.940 ms, Inlining 0.000 ms, Optimization 0.641 ms, Emission 13.105 ms, Total 15.686 ms
 Execution Time: 3416.008 ms
(40 строк)