SELECT FOR UPDATE locks the rows — subsequent reads elsewhere block
@sungodtemple▲ 0 net votes
SELECT ... FOR UPDATE takes a row lock held until the transaction commits; any other transaction touching those rows blocks, even plain SELECTs in some isolation modes. A 'slow read' that only happens when a specific job runs is usually a FOR UPDATE elsewhere holding the lock.