without limit offset

gistfile1.txt

Nested Loop Left Join  (cost=6191.69..6584.42 rows=97 width=537) (actual time=542.848..720.503 rows=2092 loops=1)
  ->  Nested Loop Left Join  (cost=6191.41..6392.32 rows=97 width=225) (actual time=542.819..639.048 rows=2092 loops=1)
        ->  Sort  (cost=6190.83..6191.07 rows=97 width=48) (actual time=542.760..543.326 rows=2078 loops=1)
              Sort Key: post.scheduled_date DESC
              Sort Method: quicksort  Memory: 384kB
              ->  Nested Loop  (cost=2930.79..6187.63 rows=97 width=48) (actual time=443.701..521.780 rows=2078 loops=1)
                    ->  Hash Join  (cost=2930.50..6097.66 rows=238 width=52) (actual time=443.642..482.235 rows=2079 loops=1)
                          Hash Cond: (vote.post_id = post.id)
                          ->  Bitmap Heap Scan on vote  (cost=1701.53..4859.49 rows=3505 width=4) (actual time=158.607..172.574 rows=5127 loops=1)
                                Recheck Cond: (((user_id)::text = ANY ('{IBS7ftMAytR3HpMCtk3jzixnuIk1,78c4CKECYWSVt3RmOIgA0U6x7Z12,fjHvzaoyr2OvW2SoWQeB3w5tGQB2}'::text[])) AND (vote > 15))
                                Heap Blocks: exact=1239
                                ->  BitmapAnd  (cost=1701.53..1701.53 rows=3505 width=0) (actual time=158.365..158.365 rows=0 loops=1)
                                      ->  Bitmap Index Scan on index1  (cost=0.00..309.07 rows=21572 width=0) (actual time=29.235..29.235 rows=20659 loops=1)
                                            Index Cond: ((user_id)::text = ANY ('{IBS7ftMAytR3HpMCtk3jzixnuIk1,78c4CKECYWSVt3RmOIgA0U6x7Z12,fjHvzaoyr2OvW2SoWQeB3w5tGQB2}'::text[]))
                                      ->  Bitmap Index Scan on index4  (cost=0.00..1390.46 rows=132138 width=0) (actual time=120.605..120.605 rows=134028 loops=1)
                                            Index Cond: (vote > 15)
                          ->  Hash  (cost=1177.41..1177.41 rows=4125 width=48) (actual time=285.012..285.012 rows=16325 loops=1)
                                Buckets: 16384 (originally 8192)  Batches: 1 (originally 1)  Memory Usage: 1467kB
                                ->  Index Scan using index5 on post  (cost=26.48..1177.41 rows=4125 width=48) (actual time=0.234..206.100 rows=16325 loops=1)
                                      Index Cond: (scheduled_date <= '2019-06-19 00:00:00'::timestamp without time zone)
                                      Filter: ((parent_post_id IS NULL) AND (NOT (hashed SubPlan 1)))
                                      Rows Removed by Filter: 3089
                                      SubPlan 1
                                        ->  Seq Scan on blocked_user  (cost=0.00..26.18 rows=4 width=28) (actual time=0.069..0.195 rows=1 loops=1)
                                              Filter: (((user_id)::text = 'snaildragon'::text) OR ((user_id)::text = ANY ('{IBS7ftMAytR3HpMCtk3jzixnuIk1,78c4CKECYWSVt3RmOIgA0U6x7Z12,fjHvzaoyr2OvW2SoWQeB3w5tGQB2}'::text[])))
                                              Rows Removed by Filter: 671
                    ->  Index Only Scan using index6 on content_post content_post_1  (cost=0.29..0.37 rows=1 width=4) (actual time=0.018..0.019 rows=1 loops=2079)
                          Index Cond: (post_id = post.id)
                          Heap Fetches: 1924
        ->  Nested Loop  (cost=0.57..2.05 rows=1 width=177) (actual time=0.041..0.045 rows=1 loops=2078)
              ->  Index Scan using index6 on content_post content_post_2  (cost=0.29..1.71 rows=1 width=28) (actual time=0.022..0.026 rows=1 loops=2078)
                    Index Cond: (post.id = post_id)
              ->  Index Scan using content_pkey on content content_1  (cost=0.29..0.35 rows=1 width=149) (actual time=0.017..0.017 rows=1 loops=2092)
                    Index Cond: (id = content_post_2.content_id)
  ->  Index Scan using user_pkey on "user" user_1  (cost=0.28..1.98 rows=1 width=304) (actual time=0.036..0.036 rows=1 loops=2092)
        Index Cond: ((id)::text = (post.user_id)::text)
Planning Time: 8.584 ms
Execution Time: 721.113 ms