How to query a job by its serialized contents in postgres?

[JasterV]

I want to be able to fetch all the jobs whose content contains a certain value.

I thought that the job would be serialized as a jsonb in postgres, but all I see is an encoded string which unfortunately I don't know how to decode

Any idea?

Another option, given that this value I'm using is a unique ID that should be contained inside of the jobs payload, would it be possible to set the ID of the job with this unique ID generated on our side?

[JasterV]

Ok I've figured out that the job payload is being stored as a bytea type, that means I need to convert that into jsonb and then I can query it :)