We found the query that is causing CSP to timeout: "group by xyz" , the sorting was taking too long even with resultset just a handful.
adding the ID helps avoid timeout "ID like '%%%' group by xyz"