Optimize the DB select query JSON B type extract
You painted yourself into a corner by modeling this with jsonb. The whole large thing has to be read to extract the attribute.
The best I can think of is to break the desired value out of the large object into its own column:
ALTER TABLE mytab
   ADD results jsonb GENERATED ALWAYS AS (message -&gt; 'results') STORED;

This will work on recent PostgreSQL versions; for older versions you can use a trigger that does the same thing.
Then you only have to read the results column instead of the whole message.