There are some queries that seem like they could be improved by utilizing indexes in the database. These are all provided by a user.
A query like this can take up to or more than 20 seconds
The fix has been tested by the customer to be working. For regression tests, some smoke testing around creating and viewing posts in channels, scrolling up to view old posts should suffice.