#Instance Details

kubectl -n <namespace> get postgresql <instance_name> -o yaml

# View PostgreSQL user password
kubectl -n <namespace> get secret <instance_name>.credentials.postgresql.acid.zalan.do -o yaml

# View connection endpoint
kubectl -n <namespace> get svc <instance_name>

# View Pod resource limits
kubectl -n <namespace> get pod <instance_name>-0 -o yaml | grep resources -A 5

# View storage configuration
kubectl -n <namespace> get pvc pgdata-<instance_name>-0 -o yaml

# View node affinity
kubectl -n <namespace> get postgresql <instance_name> -o yaml | grep affinity -A 10

# View tolerations
kubectl -n <namespace> get postgresql <instance_name> -o yaml | grep tolerations -A 5