Sort  (cost=51.01..51.03 rows=10 width=65)
   Sort Key: broadcasts.publish_date
   ->  Nested Loop  (cost=27.49..50.84 rows=10 width=65)
         ->  Hash Join  (cost=27.34..48.68 rows=7 width=8)
               Hash Cond: (broadcasters.id = subscriptions.broadcaster_id)
               ->  Seq Scan on broadcasters  (cost=0.00..18.20 rows=820 width=4)
               ->  Hash  (cost=27.25..27.25 rows=7 width=4)
                     ->  Seq Scan on subscriptions  (cost=0.00..27.25 rows=7 width=4)
                           Filter: (phoji_user_id = 1846)
         ->  Index Scan using index_broadcasts_on_broadcaster_id on broadcasts  (cost=0.15..0.30 rows=1 width=65)
               Index Cond: (broadcaster_id = broadcasters.id)
               Filter: ((publish_date <= '2015-01-29 20:26:04.671564'::timestamp without time zone) OR (publish_date IS NULL))