pg_restore is slow after creating index "public.activities_visibility_index"

I've moved to another server before and the restore process was fast.

Today I want to restore from an archive file that is less than 200MB:

sudo -Hu postgres pg_restore -d pleroma -v -1 /var/lib/postgresql/pleroma.pgdump

At first, everything worked fine, but after the creation of index "public.activities_visibility_index", hours passed and no new messages appeared.

I don't understand what pg_restore is doing, and from the log file it looks like it's restoring the activities table, but it's stuck.

Edited Dec 24, 2022 by debula