Seq Scan Additional Join

seq_scan_additional_join_plan.txt

                                                                                                       QUERY PLAN                                                                                                        
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Hash Join  (cost=266360.55..488077.22 rows=119262 width=28) (actual time=2194.811..7024.339 rows=118653 loops=1)
   Hash Cond: (keyword_data.id = keywords.keyword_data_id)
   Buffers: shared hit=15183 read=275712 dirtied=1 written=1, temp read=22010 written=21974
   ->  Seq Scan on keyword_data  (cost=0.00..134830.11 rows=6256211 width=12) (actual time=0.015..2070.005 rows=6284330 loops=1)
         Buffers: shared read=72268 dirtied=1 written=1
   ->  Hash  (cost=263988.41..263988.41 rows=122651 width=28) (actual time=2192.429..2192.429 rows=118653 loops=1)
         Buckets: 65536  Batches: 4  Memory Usage: 2278kB
         Buffers: shared hit=15183 read=203444, temp read=3212 written=3691
         ->  Hash Join  (cost=164128.36..263988.41 rows=122651 width=28) (actual time=1184.182..2144.762 rows=118653 loops=1)
               Hash Cond: (results.keyword_id = keywords.id)
               Buffers: shared hit=15183 read=203444, temp read=3212 written=3182
               ->  Append  (cost=0.00..93005.60 rows=122651 width=20) (actual time=49.334..829.157 rows=118653 loops=1)
                     Buffers: shared read=75412
                     ->  Seq Scan on results  (cost=0.00..0.00 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=1)
                           Filter: ((created_at >= '2017-10-25 00:00:00'::timestamp without time zone) AND (created_at <= '2017-11-19 23:59:59.999999'::timestamp without time zone) AND (account_id = 10026))
                     ->  Bitmap Heap Scan on _hyper_1_37_chunk  (cost=2137.22..93005.60 rows=122650 width=20) (actual time=49.330..784.878 rows=118653 loops=1)
                           Recheck Cond: ((account_id = 10026) AND (created_at >= '2017-10-25 00:00:00'::timestamp without time zone) AND (created_at <= '2017-11-19 23:59:59.999999'::timestamp without time zone))
                           Rows Removed by Index Recheck: 819290
                           Heap Blocks: exact=48168 lossy=26592
                           Buffers: shared read=75412
                           ->  Bitmap Index Scan on _hyper_1_37_chunk_account_id_created_at_idx  (cost=0.00..2106.56 rows=122650 width=0) (actual time=35.561..35.561 rows=130346 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-19 23:59:59.999999'::timestamp without time zone))
                                 Buffers: shared read=652
               ->  Hash  (cost=150852.05..150852.05 rows=763705 width=12) (actual time=1134.416..1134.416 rows=722081 loops=1)
                     Buckets: 131072  Batches: 16  Memory Usage: 2969kB
                     Buffers: shared hit=15183 read=128032, temp written=2626
                     ->  Seq Scan on keywords  (cost=0.00..150852.05 rows=763705 width=12) (actual time=0.017..859.281 rows=722081 loops=1)
                           Buffers: shared hit=15183 read=128032
 Planning time: 9.101 ms
 Execution time: 7044.488 ms