Idx Scan Plan

idx_scan_plan.txt

                                                                                              QUERY PLAN                                                                                               
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=0.55..196754.90 rows=72750 width=16) (actual time=0.087..545.345 rows=72133 loops=1)
   Buffers: shared hit=311301 read=48510
   ->  Append  (cost=0.12..60835.52 rows=72750 width=16) (actual time=0.049..272.686 rows=72133 loops=1)
         Buffers: shared hit=26493 read=44417
         ->  Index Scan using results_hyper_keyword_id_idx on results  (cost=0.12..2.15 rows=1 width=16) (actual time=0.003..0.003 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))
               Buffers: shared hit=1
         ->  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.045..264.629 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
   ->  Index Scan using keywords_pkey on keywords  (cost=0.42..1.86 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=72133)
         Index Cond: (id = results.keyword_id)
         Buffers: shared hit=284808 read=4093
 Planning time: 1.668 ms
 Execution time: 551.077 ms