Great! Yes this is the query to get the posts of a channel. I think this is perhaps a general DB performance degradation we are observing here.
Would you be able to run a VACUUM VERBOSE ANALYZE posts; and let us know if that improves things?
If that doesn’t improve, then would you be able to run a EXPLAIN ANALYZE <query> output of that query. I believe the slow query logs dump the query parameters as well.