emnlvrz

                                                                                              QUERY PLAN                                                                                               
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Hash Join  (cost=55065.63..120421.32 rows=72750 width=16) (actual time=488.697..896.514 rows=72133 loops=1)
   Hash Cond: (results.keyword_id = keywords.id)
   Buffers: shared hit=26492 read=80492, temp read=2666 written=2636
   ->  Append  (cost=0.00..60833.38 rows=72750 width=16) (actual time=0.146..262.637 rows=72133 loops=1)
         Buffers: shared hit=26492 read=44417
         ->  Seq Scan on results  (cost=0.00..0.00 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)
               Filter: ((created_at >= '2017-10-25 00:00:00'::timestamp without time zone) AND (created_at <= '2017-11-10 23:59:59.99999