This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |