I've been running a restore job on 38m row table for over 24 hours that doesn't seem to want to come to an end. When I check pg_stat_activity it tells me that the restore job is still running, and the query column shows valid insert queries slotting data into the database.
However, when I run a count(*) on the table, I've been getting the same number just shy of 38m for the last 15 hours.
I don't think the issue is a hardware one, as previously a restore of this table took just 3 hours (it had around 25m rows at that stage).
Has anyone else experienced anything similar?
Also, is there any way to determine the number of rows in a .backup file? Perhaps, then I can know if it has captured all of the data.
Or is the only way to be sure to ignore the backup and run a complete insert all of the data again?