Postgres has 100% CPU for large databases, Discourse 2.7.7

This query seems to come from Jobs::BadgeGrant.