@PeterCxy upgrading everything. monitoring actually looked fine but running ANALYZE is still good practice, just like gentoo users recompiling everything...
@ghost My Mastodon instance also worked fine before ANALYZE because it does not really need that much of index scan to work well. However Matrix is an absolute beast and without index scans it just stalls completely.
@ghost Also upgrading PostgreSQL?