Thread of 2 posts

Hey gotosocial admins and devs!

My #gotosocial instance got interrupted while duing database migrations and now struggles with slow queries probably due to missing indices. Is there a way to check the db for what is missing or to somehow get it into a working state again?

Alternatively would restoring the db from a dump help?

Please boost.

Thanks!

I have successfully run an ANALYZE run on the db and now it seems to work as fast as before. Thanks for your hints and answers!