try use the following index and if required increase index key size suggested in the posts
CREATE INDEX idx_conversations_of_user_inbox ON spots
(conv_id, (distinct (array (distinct (array ( msgr . user_id) for msgr in ( msg . msg_recipients ) end)) for msg in conv_messages end)))
WHERE ( type = “conversation”)