How long after payment is the subscription activated?

This depends on the payment method used. For card and PayPal payments, access is immediate. For bank transfers, the subscription becomes active once we receive the payment.