Some queries that don't finish

PostgreSQL runs vacuum automatically in the background.

In normal usage, we never need to manually go and interfere on that.

However, imports, restoring backups and etc, can generate a lot of cruft in the database, and if the resources aren’t adequate it can generate garbage faster than the autovacuum can clean it out.