Refactor: add ucsp indices; refactor some slowish queries #1142

Closed mipyykko closed 1 year ago