Result (cost=70.60..70.62 rows=1 width=32)
InitPlan 3 (returns $2)
-> Aggregate (cost=16.65..16.66 rows=1 width=32)
InitPlan 1 (returns $0)
-> Aggregate (cost=8.30..8.31 rows=1 width=8)
-> Index Scan using idx_fe32fd77f675f31b on entry_vote (cost=0.28..8.30 rows=1 width=4)
Index Cond: (author_id = 71967)
Filter: ((user_id <> 71967) AND (choice = 1))
InitPlan 2 (returns $1)
-> Aggregate (cost=8.30..8.31 rows=1 width=8)
-> Index Scan using idx_fe32fd77f675f31b on entry_vote entry_vote_1 (cost=0.28..8.30 rows=1 width=4)
Index Cond: (author_id = 71967)
Filter: ((user_id <> 71967) AND (choice = '-1'::integer))
-> Result (cost=0.00..0.01 rows=1 width=0)
InitPlan 6 (returns $5)
-> Aggregate (cost=21.44..21.45 rows=1 width=32)
InitPlan 4 (returns $3)
-> Aggregate (cost=10.70..10.71 rows=1 width=8)
-> Bitmap Heap Scan on entry_comment_vote (cost=4.30..10.70 rows=2 width=4)
Recheck Cond: (author_id = 71967)
Filter: ((user_id <> 71967) AND (choice = 1))
-> Bitmap Index Scan on idx_9e561267f675f31b (cost=0.00..4.29 rows=2 width=0)
Index Cond: (author_id = 71967)
InitPlan 5 (returns $4)
-> Aggregate (cost=10.70..10.71 rows=1 width=8)
-> Bitmap Heap Scan on entry_comment_vote entry_comment_vote_1 (cost=4.30..10.70 rows=1 width=4)
Recheck Cond: (author_id = 71967)
Filter: ((user_id <> 71967) AND (choice = '-1'::integer))
-> Bitmap Index Scan on idx_9e561267f675f31b (cost=0.00..4.29 rows=2 width=0)
Index Cond: (author_id = 71967)
-> Result (cost=0.00..0.01 rows=1 width=0)
InitPlan 9 (returns $8)
-> Aggregate (cost=3.66..3.67 rows=1 width=32)
InitPlan 7 (returns $6)
-> Aggregate (cost=1.81..1.82 rows=1 width=8)
-> Seq Scan on post_vote (cost=0.00..1.81 rows=1 width=4)
Filter: ((user_id <> 71967) AND (author_id = 71967) AND (choice = 1))
InitPlan 8 (returns $7)
-> Aggregate (cost=1.81..1.82 rows=1 width=8)
-> Seq Scan on post_vote post_vote_1 (cost=0.00..1.81 rows=1 width=4)
Filter: ((user_id <> 71967) AND (author_id = 71967) AND (choice = '-1'::integer))
-> Result (cost=0.00..0.01 rows=1 width=0)
InitPlan 12 (returns $11)
-> Aggregate (cost=28.82..28.83 rows=1 width=32)
InitPlan 10 (returns $9)
-> Aggregate (cost=14.39..14.40 rows=1 width=8)
-> Bitmap Heap Scan on post_comment_vote (cost=4.21..14.39 rows=1 width=4)
Recheck Cond: (author_id = 71967)
Filter: ((user_id <> 71967) AND (choice = 1))
-> Bitmap Index Scan on idx_d71b5a5bf675f31b (cost=0.00..4.21 rows=7 width=0)
Index Cond: (author_id = 71967)
InitPlan 11 (returns $10)
-> Aggregate (cost=14.39..14.40 rows=1 width=8)
-> Bitmap Heap Scan on post_comment_vote post_comment_vote_1 (cost=4.21..14.39 rows=1 width=4)
Recheck Cond: (author_id = 71967)
Filter: ((user_id <> 71967) AND (choice = '-1'::integer))
-> Bitmap Index Scan on idx_d71b5a5bf675f31b (cost=0.00..4.21 rows=7 width=0)
Index Cond: (author_id = 71967)
-> Result (cost=0.00..0.01 rows=1 width=0)