seq scan

gistfile1.txt

                                                                                              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.999999'::timestamp without time zone) AND (account_id = 10026))
         ->  Index Scan using _hyper_1_37_chunk_account_id_created_at_idx on _hyper_1_37_chunk  (cost=0.43..60833.38 rows=72749 width=16) (actual time=0.134..252.769 rows=72133 loops=1)
               Index Cond: ((account_id = 10026) AND (created_at >= '2017-10-25 00:00:00'::timestamp without time zone) AND (created_at <= '2017-11-10 23:59:59.999999'::timestamp without time zone))
               Buffers: shared hit=26492 read=44417
   ->  Hash  (cost=43266.39..43266.39 rows=719139 width=8) (actual time=487.810..487.810 rows=718424 loops=1)
         Buckets: 131072  Batches: 16  Memory Usage: 2789kB
         Buffers: shared read=36075, temp written=2293
         ->  Seq Scan on keywords  (cost=0.00..43266.39 rows=719139 width=8) (actual time=0.021..281.812 rows=718424 loops=1)
               Buffers: shared read=36075
 Planning time: 2.641 ms
 Execution time: 900.485 ms