QUERY PLAN
Limit (cost=130.44..130.47 rows=10 width=127)
-> Sort (cost=130.44..131.05 rows=243 width=127)
Sort Key: r.open_from DESC, r.created_at DESC
-> Hash Right Join (cost=50.71..125.19 rows=243 width=127)
Hash Cond: (rvr.rating_id = r.id)
-> Seq Scan on tbl_rating_voters rvr (cost=0.00..74.34 rows=10 width=9)
Filter: (user_id = 1000)
-> Hash (cost=47.68..47.68 rows=243 width=125)
-> Hash Right Join (cost=10.47..47.68 rows=243 width=125)
Hash Cond: (rc.rating_id = r.id)
-> Seq Scan on tbl_rating_candidates rc (cost=0.00..37.16 rows=18 width=4)
Filter: (user_id = 1000)
-> Hash (cost=7.43..7.43 rows=243 width=125)
-> Seq Scan on tbl_ratings r (cost=0.00..7.43 rows=243 width=125)