Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
without limit offset
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.