I'd like to try an exotic postgres SQL query but your question does not contain database specific detail (I mean, a JSONB column, containing a 'hash'? what does that mean?)

If requirements make it possible to use postgresql JSONB indexing it can be extremely fast.