Since it’s a managed PG instance, you’ll want to check logs for that service.
(always look at the logs!)
You might find it tells you why this happened, for instance maybe it has a maximum connection lifetime configured and the restore is taking longer to complete.