
CREATE INDEX idx_messagerecipient_userrecipient_id_message_isread_message_id ON msg.messagerecipient USING btree (userrecipient_id, message_id, message_isread,Message_isNew) WHERE (COALESCE(message_isread,0)=0 AND Message_isNew=1 )
